Finance | Project Operations, Human Resources, ...

PO number is not matching in Invoice journal report of Account Payable

(0) Share

Report

Posted on by Laraib

131

I want to show PO Number in Invoice Journal Grid which i used to see in transaction's general tab in the field of Reason comment which is coming from REASONTABLEREF table vi VENDTRANS table.

I have made new data source in VENDINVOICEJOUR form with vend table somehow it is showing PO number but it is not matching with transaction's general tab reason comment. Can you please guide for the solutions pictures are given below

I want this Reason Comment field data in Invoice Journal Grid

Invoice_Journal_02

Invoice_Journal_01

All responses (2)

Answers (0)

Laraib 131 on at

Like (0)

Report

RE: PO number is not matching in Invoice journal report of Account Payable

First of all I would like to thank you for your guidance secondly in my case POs are not combined in single invoice and thirdly I have resolve this issue by creating another data source of REASONTABLEREF table
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: PO number is not matching in Invoice journal report of Account Payable

Hi,

Do you always receive a single invoice for a PO or do your vendor invoice multiple POs in a single invoice?

In the latter case, that is, if POs are combined in a single invoice you won't be able to extract the data in the form you shared.

Best regards,

Ludwig