Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Payment Reference through vendor invoice

(0) ShareShare
ReportReport
Posted on by 151

Hi AXians,

I have a very specific requirement.

User want to mention some reference when posting vendor invoice through PO. This reference need to be added in column Payment Reference in General Journal Account Entry when the invoice gets posted.

By this way, Finance dept can group transactions by this payment reference number from GL transactions and make more better reports when analysing account payable main account. 

If I can get the x++ class that is creating voucher when posting vendor invoice, i hope i can specify parmPaymReference() there to achieve this requirement. Can some one help me with the class or any other better solutions.

Thanks 

  • Lukas Nimberger Profile Picture
    5 on at
    RE: Payment Reference through vendor invoice

    Hello Ludwig,

    generally speaking, it would be great if we had a reference automatically handed over from invoice number to the payment reference.

    Is there any possibility to do so?

    Thank you,

    Lukas

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Payment Reference through vendor invoice

    Hello Mohammed,

    Have you been able to make some progress here and is there any other information/help that you need from the community?

    Would be great if you could keep us updated.

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    Vamsi Pranith Profile Picture
    682 on at
    RE: Payment Reference through vendor invoice

    There is something called as Invoice description that you can use. Would that not suffice your needs?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Payment Reference through vendor invoice

    Hello Mohammed,

    If you use the standard reason codes for that purpose then you have the advantage that you can build financial (management reporter) reports on top of them, which is not the case with your customization.

    I would recommend having a look at the reason codes as an alternative first.

    Best regards,

    Ludwig

  • Mohammed Jabir OM Profile Picture
    151 on at
    RE: Payment Reference through vendor invoice

    Yes.

    As a part of customization. I want to the possiblity of capturing some tags and then during posting yhe vendor invoice, i need that tag to be filled in paym reference column

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Payment Reference through vendor invoice

    Hello Mohammed,

    The tags that you mentioned are they part of a customization?

    If this is the case then you won't be able to grab that information in standard reports without making a corresponding adjustment in those reports.

    Best regards,

    Ludwig

  • Mohammed Jabir OM Profile Picture
    151 on at
    RE: Payment Reference through vendor invoice

    Hi..

    If I elloborate my requirement.

    This is my requirement for making report. For all the purchase order vendor invoices. We have created mutliple tags like NormalPO, ReturnPO, NonStockPO, AssetPO, ExpensePO, CorrectionPO, SpecialPO

    then when user make vendor invoice, they will select one of them. Later if I can get them in PaymReference, i can make direct Financial reports. I selected paym reference, bcoz the column is not being used by default during vendor invoice posting. Also it is one of available columns in GeneralJournalAccountEntry.

  • Gao Lu Wang Profile Picture
    180 on at
    RE: Payment Reference through vendor invoice

    If the information is in purchase order line, you need pass the information step by step.

    If the information is in vendor,you can do it directly.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Payment Reference through vendor invoice

    Hi Mohammed,

    Where do you get the information from that you want to fill into the payment reference field?

    Is this something that you need to code or is this an information that is part of the invoice?

    Best regards,

    Ludwig

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,110 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans