Whether you are deeply enmeshed in juggling scheduled shipments or just considering the move from discrete orders to customer schedules, you know one thing: keeping on top of your customer scheduled orders is an all-important part of your supply chain and production process. It is vital for the happiness of your customer!
We’ll show you, through three company case studies, the hands-down simplest, easiest, and most cost-efficient way to maintain and manage shipment schedules sent by your customers. Find out how to achieve greater visibility of current and historic customer orders, track and de-activate schedules for discontinued items, and pinpoint—and promptly react to—changes in customer demand!
Whether you process orders electronically through EDI, Qxtend, or QAD Supplier Portal or process them manually into QAD, you’ll want to join us and Bob Bailey, Business Analyst from Carlex to find out how you can manage, maintain and analyze your customer schedules like a champ!
How can you tell that you haven’t previously received an item?
Items that are new will have an extension assigned to the Release ID number as they come in. All previously received items will have a number assigned without an extension. You can also often see the difference in the Start Date. There are some other ways you can know, as well, dependent on your configuration.
Can you show on the spreadsheet the Prior CUM Required and Prior CUM Shipped columns?
CUM ordered usually comes from the customer. CUM Shipped fills in from Receipts and would show the total number shipped of that item.
Can you also download planning and required schedules with this Data Loader?
Yes, you can download Planned and Req uired schedules the same way as you download Ship schedules.
Does Bob’s company use CUM based or REQ based orders with the non-EDI customers?
We use CUM based.
What is the difference between the Import and Download buttons?
The Download button will retrieve data from QAD. The Import button is used to import data from a source other than QAD.
Regarding CUM Ordered, why is that not an editable field?
CUM ordered is what has been ordered prior to this date. The quantities in the dated fields can be expressed as cumulated or non-cumulated. In this demo, it is expressed as non-cumulated.
Making sure I understand active/inactive – entering an End Date that is earlier than today will set a line to Inactive, but zeroing out the quantities does not set it to Inactive, is that correct? And, if a new release comes in from that customer, that line should not reappear if there are no new required quantities coming in, correct?
Active is identified based on the same logic as QAD so whatever is the latest status is assigned to the cell.
And, yes, if a new release comes in from that customer, the old release for that item will disappear.
How does Bob load the prior CUM from his customers?
Generally every time they send a new release, it starts at a zero base. We have an agreement with this customer to operate in this way.
With non-EDI orders, you often have to adjust the CUM Ordered because the customer does not give you their receipts. Can this field be editable?
Yes, that can be done and we will work with you to accomplish that and other configurations you might need.
For the data downloaded from QAD, what or where is the field “Cumulative” set?
CUM originates in Sales Order. When you define the sales order you define how that will be expressed.
Join our mailing list to stay informed about our webinars