Dynamics Community Forum Thread Details

Field value update from F&O to Invoice Capture App getting error

Hi Team,

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.