RE: 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?
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.