Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

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

Posted on by 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

  • Laraib Profile Picture
    Laraib 131 on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans