Is your QAD system set up for automatic pricing in QAD? Do you use best pricing and list/discount pricing in QAD? If so, do you have a quick, efficient and reliable way to enter and update price lists in QAD?
If your answer to that last question is no, then this webinar is for you. Learn how you can efficiently maintain price lists in QAD with our Data Loaders for Customer (1.10.1.1) and Supplier (1.10.2.1) Price Lists, which allow you to quickly, accurately, securely—and with very little effort—maintain, review and analyze sales and purchasing price lists in QAD.
• Get real-time access to QAD data and price list details – in easy to use Excel spreadsheet
• Manage new prices or price lists, expire old ones, copy existing price lists in convenient Excel spreadsheets
• Upload your changes and additions directly and safely into your QAD system with a click of button—without IT involvement!
• Increase your productivity, reduce errors, and contribute significantly to your bottom line
• Get the flexibility you need to react quickly to market fluctuations
Do 32 Soft Price List Data Loaders work for QAD20012EE? In QAD20012EE expiry dates are mandatory.
Yes, 32 Soft Price List Data Loaders work for QAD20012EE. They behave according to QAD restrictions. In QAD versions where expiry date can be left blank, the Loaders will also allow you to leave it blank. In QAD versions where expiry date is mandatory, the Loaders’ validation logic will report an error if you leave expiry date blank (undefined).
If a new price change is in decimals, do the Price List Loaders upload the new price to that level of decimals?
Price List Data Loaders support the same format for the price list field as in QAD, which is 5 decimals. The price is downloaded and uploaded back in the same format as the corresponding QAD price field, but display format in Excel can me modified to show less decimals.
Is there any special set-up required for 32 Soft Price List Data Loaders?
Each 32 Soft Data Loader consist of an Excel template that can be stored on your PC, network or cloud drive; backend PROGRESS code installed on the QAD database or application server: and Java listening service (one per QAD database) which is common for all 32 Soft Data Loaders.
Backend code needs to be compiled against the QAD database and the Java listening service must be configured and started. Both these steps are simple and very straightforward.
In the Excel template (by clicking on the Setup->Maintain button), you will simply need to specify the IP address and port for the Java service before users can start using the Loader.
There is no other setup required in QAD for the Price List Data Loaders.
I have a version of the 1.10.2.1 Price List Data Loader that shows a price as 1:$4.90. I assume it means one unit at $4.90.
1.10.2.1 Price List Data Loader allows you to create up to four levels of quantity-break pricing. For example, you will see formats such as 0:$5.00 | 10:$4.90 | 20:$4.80 | 40:$4.70 for price list structures in QAD. This means the price will be $5.00 if quantity ordered is less than 10; $4.90 if quantity ordered is 10-19; $4.80 if quantity ordered is 20-39 and $4.70 if quantity ordered is 40 or more. In your example, the price list type is P and price is $4.90 if quantity is 1 or more. The quantity-break pricing logic is defined in QAD. The Price List Data Loaders use this specific format to accommodate QAD logic.
Join our mailing list to stay informed about our webinars
