Hi,
Currently I’m having the need of updating data daily to inventory_part_planning view. And I was recommended to use INSERT_OR_UPDATE procedure for this. How can I selectively update just for some fields, e.g safety stock, order point? Much appreciated if someone has a user guideline for this type of procedure.
Best answer by Eranga Jayatissa
Hi,
As I understood, you want to update the existing records connected to inventory_part_planning view.
There is procedure called Modify_Order_Point_Parameters in Inventory_Part_Planning_API. I hope you can use this procedure to update the order point parameters which you mentioned.
Or else you can use Modify___ Procedure inside Inventory_Part_Planning_API since you are going to update the existing records. You can pass the updated values through an attribute string to this method.
Hope this information will help you.
Best Regards,
Eranga
+6Hi,
As I understood, you want to update the existing records connected to inventory_part_planning view.
There is procedure called Modify_Order_Point_Parameters in Inventory_Part_Planning_API. I hope you can use this procedure to update the order point parameters which you mentioned.
Or else you can use Modify___ Procedure inside Inventory_Part_Planning_API since you are going to update the existing records. You can pass the updated values through an attribute string to this method.
Hope this information will help you.
Best Regards,
Eranga
Thank you for your help
I guess it is also good if I set up the File mapping like below. Pos 10-50 as the order in the csv file, and 0 for the rest of columns, which we dont want to update.
/Hazel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
