19
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?
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?
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.
Hi S. D. ,
Can you explain how exactly you import the files and what you mean with it sums up the quantities?
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.
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.
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.
#1
André Arnaud de Cal...
291,861
Super User 2024 Season 2
#2
Martin Dráb
230,540
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
