AP Invoice Payment Means formatted search query

[mantse]

Dear Expert,

I want a query that will copy the Payment means Docnum to the AP invoice header so I can use it for a report.

Regards

[Kuldeep]

Hello Justice,

Hope you're doing well!

You can always link the payment table with Invoice for the reporting purpose. The invoice number is captured under VPM2 field name is DocEntry.

In case of your requirement with capturing the payment number on invoice using FMS, please use the below query:

Select DocNum from VPM2 where DocEntry = $[$8.0.NUMBER]

Please note that this FMS would be executable after you have added the Invoice as such until then there no payment created in the system.

Hope this would be helpful.

Best Regards,

Kuldeep