Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Invoice Not on Custome...
Finance | Project Operations, Human Resources, ...
Suggested answer

Invoice Not on Customer Account

(1) ShareShare
ReportReport
Posted on by Jim Walker 194

We are on Dynamics SL 2011 FP1 (I know, upgrading this year!).  We use the Service Dispatch Module and do our invoicing through that module.  To create a batch of invoices, we use Service Call Invoice to select the invoices we want in the batch and then "Keep" them.  The batch had 74 invoices in it and 66 of them are on the respective customers account, but 6 of them are not on the accounts.  I don't see anything in ARDoc or ARTran that is different for the ones that did not hit the customer account vs the ones that did, other than the ones that did, still have a DocBal.  Not sure where to go from here.  Any help would be appreciated.

Jim 

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Invoice Not on Customer Account

    Dear JetReno

    Open doc must be true and there must be docbal and curydocbal , docamt , origdocamt  on the records.

    You can try updating those fields to see if they appear on the customers records.

    Best Regards,

    Jana

  • JetReno Profile Picture
    JetReno 22 on at
    RE: Invoice Not on Customer Account

    Yes ARDoc and ARTran records exist.  However, in ARDoc, all the records have "OpenDoc" = 0, but for this one, OpenDoc = 1.  In addition, the invoice amount is in Stmtbal, DocBal, etc. whereas the other documents in the batch have no balance.  

    Where we are not seeing it is on the customers account.  AR>Customer Maintenance>Customer Activity.  There should be an invoice, but it is not there.  

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Invoice Not on Customer Account

    Dear Jim,

    Is the custid on the doc and tran, you probably would be better off creating a case in support so they can look at the documents/trans , Can you pull them (the invoices) up in the Invoice and Memo  screen?

    Best Regards,

    Jana

  • JetReno Profile Picture
    JetReno 22 on at
    RE: Invoice Not on Customer Account

    Yes.  For example, in ARDoc, there are 74 documents.  All lines show Rlsed = 1 and almost all other data looks similar on all the lines.  However, two lines still have numbers in DocBal, CuryDocBal, CuryStmtBal and the LineCntr fields are 0 whereas all the rest of the documents have a 1 in that column.  All documents are in ARTran as well, with nothing looking odd. 

     

    So, the problem is that the invoices are not on the two customers accounts.  They have paid, but we have nothing to apply the payment to. 

     

    Let me know if I can provide any other information. 

    Thank you,

     

    Jim

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Invoice Not on Customer Account

    Dear Jim,

    So you are saying that the ARdoc/trans exist? Where are you not seeing the data?

    Best Regards,

    Jana MacDonald

  • thumphrey Profile Picture
    thumphrey 5 on at
    RE: Invoice Not on Customer Account

    This happened to me as well so I hope someone responds with a solution. I can reprint the invoice and see it in the customer history but not in the customer maintenance activity.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans