Importing Schedules with EDI eCommerce
All EDI documents are imported using the same EDI eCommerce Document Import (35.1) function. Based on control data in the EDI file, the system determines the type of document being imported, maps the data to match the appropriate system database tables and fields, and calls the appropriate gateway program to load the document into the system.
See User Guide: QAD EDI eCommerce.
When adding a schedule, the system:
• Verifies that the trading partner exists in the system.
• Verifies that your site code matches that on the release.
• Cross-references item numbers to your internal item numbers.
• Checks and opens the order record and line number.
• Determines if quantities are discrete or cumulative based on information in the imported EDI file.
• Checks that cumulative quantities appear in ascending order.
• Deletes this specific release if it already exists in the system.
• Sets the effective end date of the prior release.
• Adds any comments and the detail schedule data.
• Creates requirement detail records if they are received. If authorization numbers are received, verifies that they are unique based on the AUTHNBR Unique Days setting in the schedule.
• Updates the cumulative requirements.
• Updates last receipt information from attached ASNs.
• Updates the fabrication and raw material authorizations.
• Creates a new schedule release, incrementing the release ID.
If the schedule import would override a required ship schedule with unshipped requirements, the transaction is not completed and an error displays.