web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Clear an invoice with O/S payments

    The most common cause of something like this is when you have another payment application batch that addressed the invoice but that batch has not been released or suspended during the release.  Open the payment application screen and use F3 to open the PV list for batches and scroll down looking for a batch with a H, B or S status.  you could also run the batch register report looking for such a status but you should increase the beginning/ending period range to cover more than the current posting period since the batch might be from another (past or future) period.

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

    There were no open batches that I saw. I'm going to investigate some more.

  • Community Member Profile Picture
    Community Member 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

  • Community Member Profile Picture
    Community Member 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 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 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 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 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 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 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:

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans