I need to update the standard costset periodically. Can I update only specific parts of the costset but not the entire standard costset with this tool?
Here is how you can update only specific parts of the costset:
1. Create a SIM Cost set in 30.1, for example S1SET
2. Use 30.13.5 Loader to download standard cost set to the spreadsheet
3. Delete any items that you do not want to update in the standard costset.
4. In the Loader header, change costset from “Standard” to S1SET and upload to QAD.
5. Use 30.3 to copy S1SET to QAD when necessary. Only the selected items will be updated.
Please try in the TEST system first.
We are often asked whether we have a Data Loader to update the Standard Cost Set, like 1.4.9 or 1.4.15. We have SIM Costset Data Loader 30.13.5 which is capable of updating the Standard Costset through a simulated costset. Finance users are familiar with this practice. The reason we do not allow the upload into the standard costset is that the system will automatically re-evaluate inventory. This can create a problem if done carelessly as Accounting would have to deal with those inventory variances. The standard costset update is usually done at the month end or when minimum to no inventory activity is happening in QAD. Using 30.15.5 Loader and adding one more step 30.3 is additional control point that avoids the creation of a massive problem in QAD.
If this option does not work for you and you understand the potential risk, we can build a Data Loader which will be capable of updating Standard costset directly. Contact us and confirm that this is the intent.
Join our mailing list to stay informed about our webinars