happy new year team....running into an issue where...
# general
j
happy new year team....running into an issue where we're using discount codes on sales orders/invoices to push through internal transactions as marketing expenses in the general ledger...unfortunately this is generating the below GL transaction which is overstating revenue and overstating expense....how do we adjust the transaction (Celigo is our connector) so the item fulfillment posts to the correct marketing expense GL code and the revenue side is $0. These are coming from inventory items that can be sold to customers as well. see screenshots below
r
Hi John. Passing this on to the team at Celigo. What endpoint are you integrating with?
j
My apologies Rico...I misspoke...the above integration is a completed via an in house built in system that is integrated with NS via API and suitlets
in this case they used a discount code at 100% to drive the transaction between sales & marketing expense
when in reality it should have posted as an item fulfillment going to a marketing expense GL account (no impact on sales)
k
is the item in question set up with the revenue account? if that is the cаse then the account needs to change..
j
For these types of transactions..I’m looking to have the item fulfillment for the item post to a marketing expense account rather than a COGS account and i would like the revenue amount to be $0
k
is that an inventory item? it should be a non-inventory item then
j
they are inventory items being sold to customers
but in this case marketing is requesting the units to use for Brand Ambaassadors, etc
to update the item fulfillment GL does that require the use of a script?