When processing invoices in PO you can have an additional cost against the purchase order\receipt invoice - this works great on a singular level. EG One freight charge per invoice.
However if you are an imported and your deal with a freight forwarder or a clearing house etc, they quite often consolidate their billing onto one invoice. There is no practical way to take this one invoice in PO and apply the additional cost to multiple purchase orders down to the items that were receipted so that you end up with an accurate unit cost per item.
An acceptable scenario would be to have
PO Receipt 1
Item 123 - QTY 2 Unit Cost 10 Extended Cost 20
PO Receipt 2
Item 456 Qty 3 Unit Cost 20 Extended Cost 60
PO Receipt 3
Item 789 Qty 4 Unit Cost 15 Extended Cost 60
Each of these has their own singular invoice from different vendors.
Have Invoice ABC as an additional cost that can be applied to multiple receipts. As an easy example we will use the logic that they are going to apply the cost to each item on a qty basis. Additional Cost invoice from ABC Co is 250 so. Total of 9 Items == 250/9 = 27.77 additional cost per item.
Update the unit cost for each item to
Receipt 1
Update unit cost to 37.77 - total cost to 75.54
Receipt 2
Update unit cost to 47.77 - total cost to 143.31
Receipt 3
Update unit cost to 42.77 - total cost to 171.08
Total Vendor Invoice Value 140 + Addition Cost of 250 = updated receipt cost of 390
This example does not quite add up with rounding it is 5 or 6 cents out but all of the business logic is there.
by: Kerry J. | over a year ago | Operations Management
Comments
This is already standard functionality. Please go read http://support.accpac.com/WEBFORUMS/ASPNETFORUMS/ShowPost.aspx?PostID=77690 for an explanation.