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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Lockbox Processing Unapplied Payment

(1) ShareShare
ReportReport
Posted on by 1,295

We are testing the import of a cash receipts file from our bank into the lockbox processing module. In 2 cases, there is no invoice to apply the cash to. I want to be able to just apply the cash to the customer. How can I do this?

Does it have to do with the setting you select for the Lockbox Apply Method?  I would think the setting would be "None".  However, there are only 2 in the batch that should be open, unapplied payments.  The rest need to be applied to an invoice.

How can we account for payments that we want applied to the customer's account but not to a document?

Thanks!

Nancy

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    25,195 on at

    When you automatically apply payments to invoices via lock box it does it's best to match them.   It then allows the user to review and correct the matches.  Remaining unmatched payments are typically posted in as Unapplied Payments.

    Believe it or not, some of the largest banks prepare the lockbox files to send you by hand keying the data into Excel.  Strange but True.  I have seen documents that were issued as INV000001001 sent back in lock boxes as 1001, which will not match, of course.

    If you are having these kinds of issues with mismatches, talk to your rep at your bank and let them know the full prefix (INV0000) is needed!

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans