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
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
I know this happened a while back for you, but do you recall how it got resolved? I'm having the same issue at the moment.
The problem has been fixed and the invoice was Posted. Thank you everyone for all your help.
Try viewing the records in PJINVDET and PJINVHDR to start and then into AR as Rick suggested.
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.
Still have not fixed this problem and the invoice remains un-posted. Please help.
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.
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?
Never mind its in the Flexible billings tab.
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.
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.
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,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156