Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Clear an invoice with ...
Microsoft Dynamics SL (Archived)

Clear an invoice with O/S payments

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Before I totally lose my mind....I want to apply the outstanding payments to this invoice. When I go to PA and the customer, there are no open invoices showing. However when I do an invoice inquiry the 'open' invoice shows as unpaid. I went back to Project/ Flexible Billings/ Construction Billing Entry and all invoices seem to have been released. Could this one be 'stuck' somewhere?

IN

001290

Net 30

9/20/2013

0.00

0.00

0.00

0.00

21,113.91

21,113.91

PA

2135

9/10/2013

0.00

0.00

0.00

0.00

-2,218.98

-2,218.98

PA

2197

10/2/2013

0.00

0.00

0.00

0.00

-18,894.93

-18,894.93

Customer Total

0.00

0.00

0.00

0.00

0.00

 0.00

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    No, that is a warning and not a reason for your issue.  The purpose of the warning is to tell you that this particular customer appears to have a collections issue.

    I am quite sure that we can resolve your issue if we can get the appropriate queries run.  I have a tool that allows me to connect to your computer or, in this case, your SQL Server box and I am willing to work with you and your IT person to run the appropriate queries to figure this out.  I will do that at no charge to you provided that we can limit the time to 15 minutes.  We should be able to do that if you provide the customer id and reference number of the invoice in question.  I do not normally provide my services at no charge but this issue seems to be spinning it wheels quite a bit and it seems like this may be the best solution.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    Thanks Rick.

    I find myself indiscriminately mixing Management Reporter with Management Studio.  Quite different.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    Yes Rick -

    You are correct in assuming I am inexperienced in SQL queries.

    Out of curiosity as to what messages, if any, might pop up, I tried to do a debit memo for the amount. I received a message that the 'Customer's oldest open invoice is older than the allowable number of days.'

    Could this be part of the issue and if so can I change the allowable number of days?

    Screenshot of error:

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    Minor correction to Elaine's post.  The query tool that is part of SQL Server is called SQL Server Management Studio and not Management Reporter.  Management Reporter is the new financial reporting tool that replaces FRx.

    The Dynamics SL client that is installed on a workstation does not include SQL Server Management Studio.  As Elaine said, it will be found on the SQL Server box.  There is a no-charge SQL Server Management Studio Express that you could install on your workstation in order to run queries.  However, based on your response, I will hazard a guess that you do not have any knowledge of SQL Server queries and this tool can do damage to the database in the hands of someone who is not SQL Server trained so this may not be the best route for you.

    If you do not have an IT type that can run queries for you then we may have to attack this issue in a different manner.  Those of us that know how to create SQL queries tend to utilize that tool because it is the fastest way to resolve many issues.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    I'll see if I can get through to him to give me access. He knows zip about accounting so wouldn't know what to look for.

    Thanks!! : )

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    The official name is Management Reporter which is part of the SQL server group.  It is installed on the File server and may/may not be installed on the workstation.

    Your IT group would be familiar if available.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    Auto Apply Payments is not flagged.

    Not to sound really dumb but I must not be able to access query? I don't see it anywhere.

    I'm in 'Initialize Mode' - does that matter?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    In Customer Maintenance,  do you have the flag set for AutoApply Payments under the Other Options tab?

    In Query, run this against the app dbase.

    Select siteid, refnbr,* from artran where custid  = 'xxx' and drcr = 'u'

    This would be the record that creates the aradjust when the batch is released.

    Most of the time you can delete the record if not involved with a small balance writeoff.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    The payments are showing but no invoice to apply them to. I'm beginning to think that payments were accidentally applied from another job to the invoice(s) for this job before I started here. There are some other jobs with open invoice amounts that I need to check.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Clear an invoice with O/S payments

    If you have access to SQL queries, run the following query:

    select * from ardoc where custid = 'xxxxxx' and refnbr = 'yyyyyy'

    xxxxxx is the cusid and yyyyyy is the reference number

    Look at the fields applamt and appbatnbr.  If they are not blank then they tell you what payment application batch has applied itself to this invoice.

    You can also run the following query to see if there is any non-released applied amounts:

    select * from artran where custid = 'xxxxxx' and siteid = 'yyyyyy' and rlsed = 0

    If something is found, look at the batnbr field

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