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) / How to get purchase or...
Microsoft Dynamics AX (Archived)

How to get purchase order prepayment amount and remaining amount for a vendor in a report - AX 2012 R2

(0) ShareShare
ReportReport
Posted on by Rana Anees 1,813

Hii,

We are using Prepayments functionality for some Purchase Orders to pay advance to vendors. 

There is no any report that shows list of POs with prepayments and remaining balances along with vendors.

Please guide what tables, queries are involved where i can get data?  Do it need some customization?

Looking for your experience reply. 

Thanks,


 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    This former post suggestion may help

    community.dynamics.com/.../522787

    You may want to consider a different approach to prepayments,( which have some limitations e.g. no report, not part of aging etc.) To recap:

    There is both a prepayment payment  and a prepayment invoice.

    A prepayment payment is a deposit to the vendor, for which no invoice was yet received from the vendor. This payment is like any other payment , and you see it in the settlement forms to settle against an invoice, when you eventually receive the invoice.  So that is a simpler approach you can consider.

    The prepayment invoice generated from a purchase order, and is used to create an advanced invoice, against which the vendor requires the deposit, against which you will make a payment.  

    If using prepayment combined with print management then also check this post www.axsolution.com

    In DMO365 ( is it now DFMO365?) there is enhanced visibility of prepayment invoicing activity.

    The Open prepayments list page is added to provide a snapshot of the status of

    prepayment invoicing activity. This page provide information about purchase orders that have:

    - remaining prepayment values to be invoiced

    - the  invoiced values that need to be paid,

    - paid invoice values that need to be applied to standard invoices.

    There are additional, enhancements for the automatic application of paid prepayment invoices to standard invoice.

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    Hii,

    Still struggling on Vendor Prepayment on Purchase Orders report.

    How I can get Prepayment transactions on POs for a vendor?

    What tables involved so that to write query / join?

    How to know PO prepayment is open or closed and final settlement  etc?

    How to get PO total invoice amount and remaining in prepayment case?

    Please guide.

    Thanks,

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

    Hi Rana Anees,

    In D365fO there is an open prepayments form available (AP-common-open prepayments). Try to get access to a demo box and see how this has been fixed in the latest version. You can probably reuse much of the code to make a modification in your AX2012 system.

    Best regards,

    Ludwig

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    Hii Ludwig Reinhard,

    Its very good suggestion but I dont have access to demo D365fo. Please help us to share the code and form if you have access or some one else.

    Best Regards,

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Rana Anees,

    Are you working for a customer or a MS Partner?

    If you are working for a partner you should be able to deploy a local demo version. Otherwise, you can get a free access to a D365fo trial version (trials.dynamics.com/operations)

    Please try those options first. If you can't get it work, please let us know.

    Many thanks and best regards,

    Ludwig

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    Hii,

    How to get in x++ or query of

    Vendors -> List of Purchase Orders -> All Invoices on a Purchase Order | Prepayments -> Invoice Settled / Unsettled

    How we can get above results in a job and what tables should be joined.

    Thanks,

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