web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Amount Paid against th...
Microsoft Dynamics AX (Archived)

Amount Paid against the Invoiced Amount for Corresponding Purchase Order in AX 2012

(0) ShareShare
ReportReport
Posted on by Muneeb 895

Hi,

I am using AX 2012 R2 CU7.

I am working on SSRS report in which displays all the Purchase Orders and displaying corresponding Amount Invoiced. Upto this no issues.

I am trying to add a column called "Amount Paid" against the Invoiced Amount for the corresponding Purchase Order. Now Payment to the Vendor can be done simply for that PO OR even by clubbing multiple POs and single payment. Moreover partial payment to few POs, etc.

My query is, how can I map like What Amount is paid to the Vendor for the Invoiced Amount of the corresponding Purchase Order even if it is Partial payment to the Invoiced Amount for that corresponding Purchase Order in case if the single Payment was done by clubbing multiple POs.

Report format is as below: (Report will display all the Purchase Orders along with the required details)

Detail_5F00_1.jpg

Thanks in advance.

Sincerely,

Muneeb

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Muneeb,

    Probably have a look at the payment history form available from the vendor master record to get an idea how this can be realized.

    Hope this helps,

    Ludwig

  • Muneeb Profile Picture
    Muneeb 895 on at

    Hi Ludwig,

    Thank you for your response.

    But there too the issue is same. I am unable to get track like what amount was paid against which Purchase Order Invoice as the Payment to vendor can be done based on Voucher which is in turn attached to single OR many Purchase Order Invoices that too might be full or partial.

    I want to track like what Amount was paid to the Vendor Against which Purchase Order Invoices?

    Thanks in advance.

    Sincerely,

    Muneeb

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Muneeb,

    The information you are looking for can be retrieved through a couple of tables. Probably start with the vendsettlement table first to identify what has been paid for what open position. From there you have a relationship to the vendtrans table from where you can get additional information on the invoices/POs. Might not be an Information that can be retrieved easily.

    Best regards,

    Ludwig

  • Muneeb Profile Picture
    Muneeb 895 on at

    Hi Ludwig,

    Ok. Understood. I will figure this out.

    Thank you so much for your help.

    Sincerely,

    Muneeb

  • Muneeb Profile Picture
    Muneeb 895 on at

    Hi,

    I was looking into it.

    As per my small research I doubt if we can get this information as everywhere like in relevant tables and forms, I am only able to get only the Amount Paid to the Vendor against the Purchase Order Invoice Voucher AND NOT Amount Paid against the individual Invoiced Purchase Orders.

    Now this Voucher could in tern have many POs involved or single PO that too it might be full or partial payment.

    Would appreciate for some thought.

    Sincerely,

    Muneeb

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Muneeb,

    I guess the only way to get this clearly separated is if a single invoice is posted for each purchase order. As soon as summarized invoices are received and posted and if you have partial / downpayments for a couple of invoices you will probably not be able to get this information without an enormous effort.

    I believe what might be required is a process change resulting in a relationship 1 PO = 1 invoice = 1 payment. If there is another number than one in this 'equation' things can really get complex for your reporting request. I would not say that it is impossible to get this information but I am not sure if the effort required to realize this kind of reporting justifies the additional benefit/information that one can get at the end of the day.

    Probably try comming back to your colleagues and ask why they Need this kind of information and what they would be willing to 'spent' on time and effort to get it automatically included in a report compared to retrieving those information manually through the standard AX forms.

    Hope this helps,

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans