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 :
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)
  • Suggested answer
    David Bader Profile Picture
    on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

    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.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

    Hello Harsha,

    Have you tried contacting the MS support about this issue?

    Best regards,

    Ludwig

  • Harry S Profile Picture
    35 on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

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

    Thanks

    Harsha

  • Suggested answer
    Ramit Paul Profile Picture
    22,778 Most Valuable Professional on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

    Dear Ludwig,

    I see your point, yes, my bad.

    This fix is in D365 FO only.

    Apologies for this, we can investigate this.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

    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,778 Most Valuable Professional on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

    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.

  • Harry S Profile Picture
    35 on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

    Hi Ramit

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

    Thanks

    Harsha

  • Suggested answer
    Ramit Paul Profile Picture
    22,778 Most Valuable Professional on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

    Hi,

    Can you check if this is similar to this issue?

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

  • Harry S Profile Picture
    35 on at
    RE: Prepayment invoice resettlement is not reducing the balance from the final invoice

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

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans