Forum Discussion
Dividing quantities by inserting rows
I am currently facing a challenge on one of my excel report which is basically used for formatting Sales order lines in order to upload on ERP (Baan).
Basically, I get data for the 'x' part for 10000 qty (multiple lines of different parts). but as per minimum order quantity( for e.g. 1500, I supposed to split them into 1500 x 6 lines and one line of 1000. likewise, there is a huge row I need to split and update. Then loading SO lines in ERP. I tried a lot using automation with it but I am not able to identify the right logic. Could anybody help me with the right logic that i can use to make automation?
Basically, I get data for the 'x' part for 10000 qty (multiple lines of different parts). but as per minimum order quantity( for e.g. 1500, I supposed to split them into 1500 x 6 lines and one line of 1000. likewise, there is a huge row I need to split and update. Then loading SO lines in ERP. I tried a lot using automation with it but I am not able to identify the right logic. Could anybody help me with the right logic that i can use to make automation?
6 Replies
Is this what you want?
Ramiz_Assaf Hi ,
Its not a shipment, Its a sales order creation template for upload in ERP.
Please find attached example for your reference.
Basically I have given qty ordered in PO by customer and accordingly we need to split them in ERP by lines for SO.
