Hi, This is our Business Flow on some of our products;
Customer Places Order for Item (our items is not stocked as prices are highly volatile and subject to daily changes, set as Made To Order)
Sales order Generates a PO to the Vendor
Sales order also Generates Delivery for the customer (will not be ready until PO items are received)
PO is checked and confirmed at the end of the day for next day delivery
PO confirmation then generates Inventory receipt for the goods
PO goods are received along with the current market prices
At this point, we need to be able to update the product cost & Sales Prices (ideally in the product, that will then feed through to the invoices for the sales orders that had already been processed with old or zero prices)
At the moment, we have to edit each invoice separately, so if one product is spread across 100 customers, we have to edit 100 invoices manually, for one product price change!, lots of manual input required.
Is their a simple way around this?
Ideally we would like to edit the product prices in the product record, before we run the invoices and for the invoice run to use the new product price not the price that was in the Sales Order, but only on these particular products.
Thanks