Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Invoice posting in AR

Posted on by 470

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posting in AR

    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.

  • krausero Profile Picture
    krausero 470 on at
    RE: Invoice posting in AR

    The problem has been fixed and the invoice was Posted. Thank you everyone for all your help.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posting in AR

    Try viewing the records in PJINVDET and PJINVHDR to start and then into AR as Rick suggested.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posting in AR

    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.

  • krausero Profile Picture
    krausero 470 on at
    RE: Invoice posting in AR

    Still have not fixed this problem and the invoice remains un-posted. Please help.

  • krausero Profile Picture
    krausero 470 on at
    RE: Invoice posting in AR

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posting in AR

    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?

  • krausero Profile Picture
    krausero 470 on at
    RE: Invoice posting in AR

    Never mind its in the Flexible billings tab.

  • krausero Profile Picture
    krausero 470 on at
    RE: Invoice posting in AR

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posting in AR

    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.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans