Skip to Content
0
Jun 22, 2020 at 07:41 AM

Is there a way to automatically reduce line item prices during supplier invoice processing?

249 Views

Currently we put the estimated freight costs in the condition records on the PO line items. During invoice creation, the freight costs are automatically populated in the invoice. However, sometimes the supplier invoice is less than the PO line items. In that case, we need to manually decrease the invoice line items cost so it matches the actual cost from the supplier. That's a manually intensive activity. Is there an easier way of doing this? Here's an example

Supplier invoice amount: 15$

Freight PO line 10: 10$

Freight PO line 20: 10$

Balance: (10+10) - 15 = 5$

In this case, I have to manually reduce a line item cost by 5$ so that the line item cost matches the actual invoice cost of 15$.