SSG
Active Member
I have always had a problem with trying to report on the original order quantity on a sales order. When a line is ship confirmed, the lines are split into the lot numbers and the original ordered qty field is changed to the qty of the lot number. We have tried using the Sales Ledger, but when quantities are changed before the order is shipped, it's difficult to pick up the last transaction. (our orders get changed alot before shipment and writes a ledger record for each change). Our manager's have a requirement to track what the customer ordered versus what was delivered.... any tips?