How do you efficiently allocate landed costs from a summary bill to multiple Item Receipts?

If you have a Bill for freight charges that is related to multiple shipments for a given period, how can you efficiently allocate to multiple Item Receipts as Landed Costs?

According to what I read in the Purchasing/Receiving document, one Bill can only be attached to one Item Receipt as a Source transaction in the Item Receipt’s Landed Cost subtab. If the bill was just associated with one shipment then I can just attach it to the relevant Item Receipt but if it’s for multiple shipments, I will have to just manually input the related landed cost per Item receipt. But does that mean that if I have hundreds of Item Receipts related to that one landed cost bill, I would have to edit them ONE BY ONE? or is there a much easier way to do this?

Rookie Asked on September 12, 2019 in Inventory.
Add Comment
1 Answer(s)

Without doing much investigation on the configuration part, I would say the solution is through scripting. Considering there’s a piece of data by line expense in the bill that allows a script to identify which item receipt it matches to, then it’s a matter of taking the amount from the line and setting it as landed cost in the item receipt.

Rookie Answered on September 13, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.