|
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. +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
