I have this scenario (without warehousing and VAT):-
Create a PO with 2 items, A and B. Unit cost for Item A is 10.00 and Item B is 15.00. Quantity for Item A is 10 units and Item B is 10 units.
Still in PO, assumed receive full quantity and post receipt only.
When received vendor invoice, there is changes to the unit cost for Item A . Instead of 10.00, the new cost is 12.00.
Next, I create an invoice and use the Get Receipt Lines to select the above posted receipt lines. I post the invoice with new cost (Item A = 12.00 and Item B = 15.00).
Upon receiving the transporter invoice (different vendor), the user create an invoice for item charges (transport) with Direct Unit Cost Excl. SST = 150.00. In the Item Charge Assginment window, I select Get Receipt Lines and select the correct receipt lines.
Next, in the Suggest Item Charge Assignment, I selected Amount . When the system populates the amount, its uses the Item Charge Base Amount. In this case for Item A, the amount is 100.00 (total cost for Item A upon receipt).
My question is how to get the system to populates the item charge amount based on the new cost posted in the invoice instead of the cost posted in the receipt? (Other from manual calculation)
If customization requires, where to make the changes? When posting the purchaser invoice or when populating the Item Charge?
Thank you very much.
Have a nice day.