Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

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

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 

  • Suggested answer
    David Bader Profile Picture
    David Bader 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
    Ludwig Reinhard 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
    Harry S 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
    Ramit Paul 22,300 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
    Ludwig Reinhard 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
    Ramit Paul 22,300 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
    Harry S 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
    Ramit Paul 22,300 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
    Harry S 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans