Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Strange Reversal Entry of Posted Inv. in G/L

Posted on by 95

So we have a case and raising a ticket to Microsoft CSP also did not help. I am here if fellow community members can help me with this.

So we have a posted purchase invoice, which once we go to find entries and check its GL Entries, it has reversal posted as well. The date shows reversal was posted same time as posting.

Below is screenshot;

pastedimage1677820781668v1.png

This is abnormal behavior and we can't figure out why this happened.

Note1: We have posted many such invoices with this Vendor and never had this issue. This specific one behaved like this.

Note2: There is no customization done which reverses a posted invoice right after its posted.

Note3: The Correct and Cancel button on our Posted Purchase Invoice asks us to pass a credit memo manually so there is no chance the user clicked on any of those 2 buttons right after they posted it.

  • Valentin Castravet Profile Picture
    Valentin Castravet 24,691 Super User 2024 Season 2 on at
    RE: Strange Reversal Entry of Posted Inv. in G/L

    okay so it looks like your posted purchase invoice contains an item. An invoice for an item would create 4 entries like that. Except the 4 entries would each go to a separate GL account.

    One idea - the Gen. Prod. Posting Group tied to the item, in the General Posting Setup Page has the Direct Cost Applied Account as 14100 and the Purchases Account as 24100. Can you please confirm if this is true?

    The Vendor Posting Group has GL Account 24100, and the Inventory Posting Group is 14100. If that was the case then that would create your 4 entries which makes it looks like the invoice was reversed.

  • Mesam Profile Picture
    Mesam 95 on at
    RE: Strange Reversal Entry of Posted Inv. in G/L

    Hello Valentin,

    Thanks a ton for responding!

    - 4 line's SystemCreatedAt field are all at same date, same time.

    - Doc. type field in blank for the last two lines. However, I noticed something maybe that can point to something?

    The reversed line once I inspected it shows the Description field as "Direct Cost FZC-V0419 on 01/01/23" can this info help us?

    - When I paste the GL Entry number in GL/Registers there is no result. However I do see it in the filter my 2 lines;

    ictic.png

    - All our Payment Methods do not have a Balancing Account.

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,691 Super User 2024 Season 2 on at
    RE: Strange Reversal Entry of Posted Inv. in G/L

    A few questions:

    -if you open the Page Inspection Pane and look at all 4 lines at the SystemCreatedAt field, were they all posted at the same time? I'm trying to see if the 4 lines were posted at the same time, or subsequently as its possible to post multiple transactions with the same date and document no.

    -what about the Document Type field, 2 of the lines should have document Type Invoice, what about the remaining 2?

    -if you go to the G/L Register Page and find the register for these entries, are all 4 part of the same register meaning they were posted at the same time?

    -what is the payment method code of the invoice? Does it have a Bal. Account No. populated? If you have this field populated with your G/L Account 14100 that would create the automatic reversal entries that you have 

    pastedimage1677822551126v1.png

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans