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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor prepayment
Microsoft Dynamics AX (Archived)

Vendor prepayment

(0) ShareShare
ReportReport
Posted on by imran ul haq 3,984

Hi All

I am using the vendor prepayment functionality, and at the time of invoicing (Last Invoice) the PO user forget to apply the prepayment and the status of the PO become invoice and the prepayment entry was not passed and the amount is hanging in the PO prepayment form. In order to correct the entry i can pass the GL entry which can update the vendor balance and the vendor advance ledgers but the prepayment amount will always be hanging for that PO.

So how can i make the correction that will affect the GL entries and also the prepayment amount will also be removed from the prepayment form.

please advise.

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor prepayment

    Hello Imran,

    What I was referring to in through the link above was a forthcoming enhancement that is in the development pipeline of Microsoft.

    On the site above it says

    For project purchase orders, prepayments must be processed to release payment to vendors. These prepayment invoices are now available in the project estimation and recognition process for fixed-price Projects

    I thought that this was what your are looking for but it seems not.

    Anyway, keep an eye on D365 roadmap because some of the features might be downgraded to AX 2012 environments.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 3,984 on at
    RE: Vendor prepayment

    Hi Ludwig,

    Can you please elaborate it more what you want to say.

    Prepayment functionality i am using for the PO whether they are generic or pertaining to project and i believe it is working fine as per the accounting process.

    thanks

    Imran

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor prepayment

    Hi Imran,

    I don't think that the PO prepayment functionality is relalted to your project because just recently a new feature that provides this link for fix-price projects became available. Please see the following link: roadmap.dynamics.com and search for prepayment.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 3,984 on at
    RE: Vendor prepayment

    Hi Ludwig,

    Further reference to my initial post, can you please suggest me if the PO is pertaining to the project how shall i fix.

    I test with the above steps all the goes correct except one extra entry posted in the project (posted transaction) by the advance amount against the category selected on the PO.

    Please advise.

    thanks in advance.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor prepayment

    Hello Imran,

    I have not used this way of processing prepayments in a live environment. If it works for you, perfect. I would suggest that you do some tests - especially in regards to tax issues and prepayments - and if it works fine for you, just use the described procedure that you found.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 3,984 on at
    RE: Vendor prepayment

    Thanks Ludwig for the solution and sorry for late reply.

    I tried the above procedure you said but here i believe we can have the problem as we are going to add the new line item in the PO with the pending advance amount, which will increase the total of the PO.

    Also which searching over the internet i found something:

    pre.jpg

    Simply go the vendor master form select Invoice tab, and click on Apply, System will open the the list of the PO with there prepayment attached, select the prepayment amount and click on "apply prepayment". System will pass the addition entry of reversing the prepayment in the existing PO invoice:

    Debit: Vendor account

    Credit: Advance 

    What do  you suggest.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor prepayment

    Hi Imran,

    Please try the following:

    (1) in the procuement & sourcing module parameters ensure that the parameter "safety level of invoiced orders in the update section is set to "None"

    (2) Setup a dummy procurement category or a dummy service item that is setup with a ledger posting that uses the same account as your prepayment transaction

    (3) Add an additional line to your invoice purchase order where you setup a new line with the newly created dummy procurement category/item

    (4) Ensure that you enter the same amount in (3) that you prepayed.

    (5) Confirm the PO

    (6) Generate the final invoice for your new line with the dummy item/procurement cateogry and apply the prepayment

    (7) check that your voucher offsets all accounts

    Please test the steps in a demo environment first.

    Hhpe 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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans