Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
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 18,383 Super User 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 18,383 Super User 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 18,383 Super User 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'

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans