We need someone to create a way to import orders into Microsoft Dynamics GP 10 from Excel or CSV file. We already have the ability to do this through integration manager BUT the challenge is that line items must be in GP in the same order as Excel or CSV.
So for example, if the Excel has the line items
The sales order/invoice must go into GP with the line items in the same order, A, B, C, D. At this moment our integration manager can import the items but in a different order. We have tried to solve this in integration manager but not able to.
It should be a simple thing if anybody knows the solution to it.