Finance | Project Operations, Human Resources, ...

Duplicate rows error due to multiple purchase order lines with same ITEM NR

(0) Share

Report

Posted on by S. D.

Users add different lines for the same item with a different quantity. When the delivery file (XML) from the supplier comes through to d365 via data management, this will cause an error due to duplicate rows. In theory this should happen without any problems in d365. Does anyone know how I can solve this technically in d365 without telling the users one by one that they can just adjust the quantity on the purchase order line?

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi S.D,

You can simply put a validation on PO lines not to allow same product twice.

OR

You can put a validation while import XML delivery file if 02 products exist with different quantities, sum up the Qty. and then validate. Please keep in mind, vendor can also do partial delivery as well.

Was this reply helpful? Yes No
S. D. 23 on at

Like (0)

Report

Hi Junaid,

Thanks for your reply! Can you tell me in steps how I can do those validations? Still learning :)

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi S. D.,

Have you used a line number in the data entity to specify which exact line has been received? When you communicate with electronic messages, you can provide the item ID, to the vendor, but also the line number. The combination will be unique per order.

Was this reply helpful? Yes No
S. D. 23 on at

Like (0)

Report

Hi André,

Yes, the vendor gets the PO line number, Item number, PO number and quantity. However it goed in error when importing the file to d365 due to the fact that multiple lines contain the same item nr. In theory it’s not allowed to go in error. I like the idea of putting a validation when import XML delivery file, it sums up the qty’s. However I have no idea where or how to do this as I’m only a beginner.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi S. D. ,

Can you explain how exactly you import the files and what you mean with it sums up the quantities?

Was this reply helpful? Yes No
S. D. 23 on at

Like (0)

Report

Hi André,

So the vendor sends the delivery slip to us and this will be translated from SAP to d365 (=idoc) in logicapps. For every delivery slip an XML file will be send to d365 with the PO-lines of the PO. It is in this last step that the error occurs.

If the XML file contains two lines for the same item number with in the first line a qty of 2 and in the second line a qty of 3. It will be an option to validate the import if the accumulated quantity corresponds to how much has been ordered in total for that item in that PO. However I have no clue where to start to fix this.

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Do you have some customizations in this process? Are you using the standard data entities or did you develop something yourself? If you use the standard data entities, which entity/entities are you using?

Was this reply helpful? Yes No