Whenever we upload the invoice as attachment it will get all the details from the attachment including purchase number by the invoice capture App. But we will get some invoice attachments with purchase order starts with 'D'(Which is nothing but IBuy number) for only those starting with 'D' we need to go to D365 F&O purchase orders table and filter the IBuy number field using the number which we got in Invoice capture that starts with "D" in purchase order field and get the original Purchase order field value in the same filtered record in F&O and update the purchase order value in Invoice capture App purchase order field and IBuy in IBuy no field in the same APP.
For the above, as suggested by Microsoft, I created a power automate flow to get the exact purchase order number from F&O and updated in staging invoice header table after the invoice is captured but it still shows the error in captured invoice saying, "Purchase order D1437592 from vendor VEN-US1-006963 cannot be found in legal entity PHX". It still taking the invoice Purchase order starts with D. Without manual intervention how we can remove this error during the capture process because I'm fully automating this using power automate.
I don't know the details of the F&O invoicing App (yet) but I was curious as to why are you updating the staging table? I would expect you to update the invoice header. How is your update triggered? Perhaps this update should happen at a different moment in the process. Has anybody looked into why the invoicing App is not matching correctly?
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
13
Share
Report
All responses (
Answers (
