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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Prepayment invoice resettlement is not reducing the balance from the final invoice

(0) ShareShare
ReportReport
Posted on by 35

Hi 

Prepayment invoice resettlement is not reducing the balance from the final invoice. Here is the scenario:

1. Create a PO for $4600.

2. Create prepayment of 20%. Confirm the PO.

3. Create a Prepayment invoice for $920.

4. Make a payment journal for $920 and settle against prepayment invoice.

5. Create a final Invoice for the PO. Apply prepayment invoice for the final invoice. 

6. The balance shown in the Final PO invoice is $3680. $3680 is reflected in the vendor transaction form as balance against the invoice. 

Here is the issue:

1. In the closed settlement form. Unapply/Reverse the Prepayment settled against the payment. 

2. The vendor transaction form now shows all the transactions as open. The Final invoice now shows $4600 as balance. 

3. Go to Settle open transaction form and select the prepayment invoice ($920) and payment voucher ($920).

4. Go to vendor transaction form. The final invoice now shows the complete $4600 as balance and there are no OPEN transactions to settle this entry to reflect the original $3680 as balance. 

Prepayment-settlement-issue.png

Please advice how to resolve this.

Thanks

Harsha 

I have the same question (0)
  • Harry S Profile Picture
    35 on at

    Also, from the screenshot voucher EBN-156179 is a system generated entry and it does not appear in the 'Settle open transactions form'

  • Suggested answer
    Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at

    Hi,

    Can you check if this is similar to this issue?

    fix.lcs.dynamics.com/.../Details

  • Harry S Profile Picture
    35 on at

    Hi Ramit

    Looks similar, How can I check the details of that case.

    Thanks

    Harsha

  • Suggested answer
    Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at

    If this is same then it is fixed in 10.0.14 as DCR.

    However, I recommend to create a product ticket to  know more about your issue.

    If this is same, they will link with this LCS BUG.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Ramit,

    Wait a second.

    You shared a hotfix for D365FO but this is the AX forum and the screenprint above seems to be taken from an AX2012 environment.

    I don't think that this hotfix can be the right one.

    Best regards,

    Ludwig

  • Suggested answer
    Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at

    Dear Ludwig,

    I see your point, yes, my bad.

    This fix is in D365 FO only.

    Apologies for this, we can investigate this.

  • Harry S Profile Picture
    35 on at

    It appears to be due to the old version of Ax 2012. However, i havent found any solution for this yet.

    Thanks

    Harsha

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Harsha,

    Have you tried contacting the MS support about this issue?

    Best regards,

    Ludwig

  • Suggested answer
    David Bader Profile Picture
    on at

    Hi Harry,

    If the workaround from D365 F&O of creating the settlement after prepayment and invoice journal will be posted, I do recommend to enter a support ticket. The team can determine if the DCR was requested for AX 2012.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans