Re: De-Allocating Inventory

The fastest way might be to write and run a simple SQL  that adjusts the 
proper fields on OEP55 and then run the standard reconciliation jobs to get 
the stockroom file (INP60) in synch.

The SQL would be created to select those allocated orders having a delivery 
date greater than the real cutoff date that you wish to use. To ensure that 
no pick documents have been created be sure that the Quantity Allocated plus 
the Quantity Outstanding equal the Quantity Ordered, then change the Quantity 
Allocated to zero and make the Quantity Outstanding equal to the Quantity 
Ordered. Next, run the standard Allocation Reconciliation job in the update 
mode to get the INP60 Quantity Allocated values in synch with the order 
lines. Finally, run the standard Back Orders to Lines reconciliation (the 
update version) to get the INP60 Back Orders values in synch with the order 
lines.

Ray Hearl
Infotech Strategies


In a message dated Sat, 30 Dec 2000  8:54:12 PM Eastern Standard Time, 
jlang@GenFast.com writes:

<< Hello,

I hope that someone in the group is able to help us solve a major Stock
Allocation problem. It seems that one of our Warehouse Managers found it
necessary to change the Allocation Time Fence (3/OEM) on the Depot Profile
record (OEP90). When he changed it back, he fat fingered the keyboard and
entered 97 days, rather than the normal 7 days. This error was not caught
until after someone ran a Batch Allocation (10/OER) for that warehouse.

We do a great deal of EDI, and had thousands of orders in the system that
we were not ready to allocate. Subsequent customer requirements would have
surely amended, or perhaps cancelled the majority of these orders.
Additionally, this has created a nightmare for our material planners as
they try to anticipate our purchasing requirements for the next quarter.

I have scoured the System 21 documentation in a failed attempt to locate a
method for Batch De-allocation of inventory. Has anyone else experienced
this kind of problem? If so, what was your solution? If you wrote an
automated solution, are you in a position to share it?

TIA,

Jeff

Jeff Lang
IS Manager
General Fasteners Company
12999 Fairlane Rd.
Livonia, MI  48150
Ph. 734-524-5093
Fax. 734-524-5098
email jlang@genfast.com

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---
 >>


+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---