Notifications
Announcements
No record found.
I am trying to post an invoice in AR but it is saying: Invoice number 013643 Rejected, invoice header and detail amounts are out of balance by xxxxx. Please help.
*This post is locked for comments
First we need to define at what point are you getting this message? Many users use the term "post" when they actually mean they are entering a batch. In SL, post is a process done by GL. So, are you getting this message during data entry, when trying to save the document, when trying to release the batch or when running the GL post transaction process?
Its at the end of the process. I am in Invoice and Adjustment Posting under the processes tab. It's (BI.REG.00) for reference.
Sorry, I may not be the best person to answer you as I am not that familiar with BI. Your original post said AR so I assumed that was the module you were in.
I have found that AR documents can have issues similar issues to this if the GL account specified has been frozen. If the screen populated the GL account from a default setting and not that account is frozen, you can get such an issue. However, I have also seen times when an extra transaction level record through some unusual data entry steps.
You might try abandoning that entry and starting over again but do check to make sure the GL accounts are valid.
Wait I am in the AR module. The Invoice and Adjustment Posting is under the Process tab in the AR module. The error is the result of an unbalanced invoice somehow. It has already been printed so I can not change it.
Never mind its in the Flexible billings tab.
Hi,
This doesn't sound like an error message I am familiar with. Are you in the AR invoice screen or in OM.
What is the message number?
It's not an error message but rather just a message that is stating. "Invoice number 013643 Rejected, invoice header and detail amounts are out of balance by xxxxx". I am in the invoice adjustment and posting tab under flex billings.
Still have not fixed this problem and the invoice remains un-posted. Please help.
I still may not be the best person to help since you are no clarifying you are in flex billing. However, I am going to assume that it is trying to create or has created an AR invoice document. Do you have a corresponding AR invoice batch for this? If so, I can probably assist if you have some knowledge in running SQL queries and have access to the SQL Management Studio tool. We need to run a query on ARDoc for that invoice number (reference number) and a query on the ARTran for that same reference number and look at the ARDoc OrigDocAmt and the sum of the debits in ARTran for that same reference number. Plus, we need to look at the Acct and Sub fields in each ARTran record to makes sure they are valid. It sure sounds like you either have a missing ARTran item or an extra ARTran item or the ARDoc OrigDocAmt is incorrect.
Try viewing the records in PJINVDET and PJINVHDR to start and then into AR as Rick suggested.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
