Charge item on a Sales Document

Question Status

Suggested Answer
Raga1 asked a question on 6 Feb 2018 11:50 PM

Hi

I tried to do a "item charge assignment " an expense (from Purchase invoice) to a Posted sales invoice via "get sales shipment lines", so the expense impacts the profitability of the sale . However nothing seem to be happening  to the profit after i do that unless i charge item to "get receipt line" ( that is on the stock item that  we bought and sold via this sales invoice).

How can i allocate a cost (eg freight) to a posted sales document?

Also, what purpose  and impact does the charge item on sales doc do anyway? ie charge item on "get sales shipment lines"??

thanks

Reply
Hannes Holst responded on 7 Feb 2018 3:23 AM

Hi,

Raga1

How can i allocate a cost (eg freight) to a posted sales document?

In "Item Charge Assignment", open "Get Sales Shipment Lines" and select the Sales Shipment.

Then "Suggest Item Charge Assignment.." or allocate manually. Then post the Purchase Invoice.
You will see the costs in the "Value Entries" of the Item Ledger Entry (filter by Document No. of Sales Shipment).

Raga1

Also, what purpose  and impact does the charge item on sales doc do anyway? ie charge item on "get sales shipment lines"??

On the Sales Document itself will be no impact. You will be able to see the costs in the Value Entries of the Item Ledger Entry. The Value Entries are used for automatic costs calculations etc.

Reply
Suggested Answer
Alexander Ermakov responded on 7 Feb 2018 3:22 PM

How to: Assign Item Charges to Sales Documents (msdn.microsoft.com/.../hh168603(v=nav.90).aspx ).

Note that in Value Entry the cost amount would appear in Cost Amount (Non-Invtbl.) field.

Reply
Suggested Answer
Robertas Rackauskas responded on 12 Feb 2018 5:49 AM

Hi,

when applying the item charge to the purchase receipts, system will put the cost as a part of item cost, and when selling such item - all cost will go to the COGS. However this can be used for incoming transport cost, not outgoing ones.

If you put the cost on the sales shipment (as in your case to assign outgoing shipment costs), system cannot record these as a cost (as the item is already shipped), so it will record it as non-inventory cost (different field in the ILE), and post to gl as per setup (which can vary).

Robertas

Reply
Suggested Answer
Raga1 responded on 12 Feb 2018 8:43 PM

Great thanks Hannes. looks like no impact on sales document ledger entries, unless i allocate to the respective purchase document

Reply
Suggested Answer
Raga1 responded on 12 Feb 2018 8:46 PM

Thanks Robertas.

Looks like  i need to charge item to  the respective purchase item receipt  to roll the cost to the posted sales document to have any impact on the posted sales document  cost and statistics

Reply
Suggested Answer
Alexander Ermakov responded on 7 Feb 2018 3:22 PM

How to: Assign Item Charges to Sales Documents (msdn.microsoft.com/.../hh168603(v=nav.90).aspx ).

Note that in Value Entry the cost amount would appear in Cost Amount (Non-Invtbl.) field.

Reply
Suggested Answer
Robertas Rackauskas responded on 12 Feb 2018 5:49 AM

Hi,

when applying the item charge to the purchase receipts, system will put the cost as a part of item cost, and when selling such item - all cost will go to the COGS. However this can be used for incoming transport cost, not outgoing ones.

If you put the cost on the sales shipment (as in your case to assign outgoing shipment costs), system cannot record these as a cost (as the item is already shipped), so it will record it as non-inventory cost (different field in the ILE), and post to gl as per setup (which can vary).

Robertas

Reply
Suggested Answer
Raga1 responded on 12 Feb 2018 8:43 PM

Great thanks Hannes. looks like no impact on sales document ledger entries, unless i allocate to the respective purchase document

Reply
Suggested Answer
Raga1 responded on 12 Feb 2018 8:46 PM

Thanks Robertas.

Looks like  i need to charge item to  the respective purchase item receipt  to roll the cost to the posted sales document to have any impact on the posted sales document  cost and statistics

Reply