We are currently receiving all drop-ship purchase ...
# inventoryl
Livio
08/04/2020, 2:56 PMWe are currently receiving all drop-ship purchase orders into our main warehouse location and using those serial numbers to fufill our dropship orders. Since its a dropship there is no need to receive serial numbers but the reason we are doing that is because thats what we use to calculate real profitability on our invoices.
Is there a way to use PO rate as the cost of good on the invoice, because if we dont receive those serial numbers, estimated gross profit is always 100%
k
KevinJ of Kansas
08/04/2020, 2:57 PMNo native solutions for this.
KevinJ of Kansas
08/04/2020, 2:57 PMthat said - you should be able to get to Sales Order profitability by joining to the fulfillments for the COGS lines and the Invoice for the revenue lines
KevinJ of Kansas
08/04/2020, 2:58 PMJust an extra step is required.
KevinJ of Kansas
08/04/2020, 2:58 PMMight have to throw an additional field on the fulfillment to be able to get the right join.
KevinJ of Kansas
08/04/2020, 2:58 PMSince it'll be "created from" the PO instead of the SO most likely
l
Livio
08/04/2020, 3:00 PMnetsuite calculates commissions based on invoices
will our commission plans be able to calculate correctly based on sales order profitability
Livio
08/04/2020, 3:01 PMcause current estimated gross profit on invoices is 100% and i dont think we have the ability to change that
k
KevinJ of Kansas
08/04/2020, 3:24 PMYou'd need a script to backfill the ASA for commissions with my approach.
KevinJ of Kansas
08/04/2020, 3:25 PMKinda looks like you're stuck with your current approach - also I'm curious how with your current approach you are getting an estimated cost.
4 Views