Tracking ORIGINAL order qty in sales order processing

[SSG]

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?

 

[ame]

I would set the Ledger flag to yes on your Order Activity rules to capture
the sales Ledger based on order entry... that way when you first enter the
order.. .you would have the quantity entered based on the customer's
requirements (as long as someone doesn't have a keying mistake). thanks,
Bobby








_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

 

[SSG]

Thanks for the reply Bobby,
Can I ask, what would you do if the customer changed the order quantity 3 times before despatch and you wanted to capture the last ledger entry for that line item before it was split into lot numbers?

 

[ame]

Tougher question... how would do you commit to the lots? Manually or through
batch committments?






Can I ask, what would you do if the customer changed the order quantity 3
times before despatch and you wanted to capture the last ledger entry for
that line item before it was split into lot numbers?


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus

 

[SSG]

The lot committment is done manually through bar code scanning.

 

[kalpathysundaram]

Jde does not provide revision tracking in Sales Order Processing. You may
try the following work around.

1. Create a different order type and enter your original customer order in
this. Generate the Sales order from this.

2. If you are not using order types 'SQ' or 'SB', you can use this for
entering the Customer Sales order.

But to compare what is originally ordered and what is actually shipped, you
may have to create your own report.

----- Original Message -----
From: "SSG" <[email protected]>
To: <[email protected]>
Sent: Wednesday, March 05, 2003 11:19 AM
Subject: Tracking ORIGINAL order qty in sales order processing


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?
list/forum.



OWN STAND ALONE PC WITH WINDOWS 98