So I turned my sight to the account determination. Few Condition types didn't have the Account Key assigned to it and that seemed like a possible culprit. To validate that we found the G/L Accounts missing for those combinations. But if you remember the Revenue Account Determination procedure, there is an option / combination of just Chart of Accounts as well as Sales Org. combination. So that too can't be the possible issue. We compared the successfully processed documents from the table VBRP for the same document type and Acc. Assignment combination. We noticed that there was a change in the Pricing Procedure. Which means - for the combination of Sales Area, Customer Pricing Procedure and Doc PP, the Pricing Procedure determined were different. How could it be possible? Then we looked at the date of creation. The failed documents' Sales Orders were created 3 years ago and at that time there would have been a different Pricing Procedure assigned to.
Now there is no way that we can post these invoices automatically. So creating a manual Ledger Posting was the only way and we did the same. The Invoice's document status was set to 'complete' or 'posted' manually by an ABAP programme.
The moral of the story: Never just look at the text book solutions alone. If so, we would have got stuck in that Revenue Account Determination Rule itself. However if there was any G/L accounts assigned for any of the combinations, the system would have posted it to accounts. So getting stuck there wouldn't be a deviation from the text book perspective. But when it comes to the real time situations, we must look beyond the text books...
Today we had an account determination issue that made the day interesting... The problem was that the invoice document was not posted to accounts because of the 'Account Determination Error'. When there is an Account Determination Error, the first place to look at is the 'Account Assignment' field in the Customer and Material Masters, whether anything had been changed? Because if a smooth working system suddenly stops working the first casualty could be the master Data. When I checked that there was no change in the Customer Master. However there was a change in the Material Master Data that it was set for deletion. I was tempted to buy that reason but I realised that the efforts to post to Accounts was done much ahead of the deletion flag indication being set. However that was also a learning point - when you can't process an article that was marked for deletion in Sales Order itself, there is no way that the article came via Sales Order.
Maheshwaran
Maheshwaran is a Mechanical Engineer turned Sales Engineer who had found his passion / calling in IT - ERP. With a solid experience of 2 implementation and support projects in his stint with SAP since 2007, he turned to teaching for sharing the knowledge gained over a period of time. He had trained in SAP Training academy as well in virtual classes. These series of posts are sharing the knowledge on advanced topics which were not taught in the standard SAP Certification academy.
Latest from Maheshwaran
Leave a comment
Make sure you enter the (*) required information where indicated. HTML code is not allowed.