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;
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.
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.
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;
- All our Payment Methods do not have a Balancing Account.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156