Applying discount to PO after adding to inventory
We have ran in to a bit of an issue with discounting our PO's after they have already been received.
At the moment, many of our vendors send invoices with final prices and discounts after we have already received shipments and added the product to our inventory.
We have not been able to figure out a way to apply a discount to the landed cost of the items received after the fact, unless you manually go through every single product and variant and individually re-enter the cost price for everything. The problem with this is that it is incredibly time consuming and costly when you have to do this for a purchase order that comes in the shape and size of 14 shipping pallets of product in a fedex semi truck...
If anyone has a recommendation for a work-around to this situation to save a considerable amount of time, it would be greatly appreciated. I'm not sure if there is a way to download the .csv for the PO and then calculate in bulk in excel and then re-upload to do a landed cost adjustment or something like that... Or if there is a better way.
Any help is greatly appreciated!