DS Solutions, Inc.

Modified MRP250 (Releasable Orders Report) to “blow through” all phantom levels, consider inventory in all nettable warehouses for the facility being processed and provide an option to only print shortages.
Modified INV300 (Material Status Inquiry) to display the User ID when viewing transaction history.
Developed new program to automatically close shop orders based on user defined tolerances defined by warehouse.
Developed user defined routine for assigning the manufacturing lot number in SFC650 (Shop Floor Posting).
Developed custom forms using EZ/Print for customer order acknowledgement, pick list, packing list, bill of lading, customer invoice, purchasing receiver ticket, purchase order, vendor schedule and accounts payable check.
Integrated 3rd party, web based purchasing software with BPCS. This involved:

developing integration between the NT server and the AS/400;
creating an AS/400 scheduler to monitor for new receipt transactions;
performing multiple edits against the new receipt transactions;
generating error listings and audit trails;
providing an on-line inquiry for correcting errors;
processing the new receipt transactions through BPCS PUR550 (Purchase Receipts) in batch mode.

developing integration between the NT server and the AS/400;
creating an AS/400 scheduler to monitor for new EDI transactions;
creating an “un-wrapper” to process the flat file from the NT server and populate the appropriate ECM files;
creating a “wrapper” to create a flat file for the NT server from the appropriate ECM files;
loading demand information into the BPCS material requirements file;
converting inbound ship schedules (862) into inbound purchase orders (850) and then creating BPCS customer orders;
generating error listings and audit trails;
creating numerous reports for analyzing the data and measuring performance.

DS Solutions, Inc.