Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. KB 915100 - All the cash receipt transactions are not imported in when duplicate check numbers exist using Lockbox Processing in Microsoft Dynamics GP

KB 915100 - All the cash receipt transactions are not imported in when duplicate check numbers exist using Lockbox Processing in Microsoft Dynamics GP

View products that this article applies to.

Symptoms

When you import cash receipt transactions using Lockbox Processing in Microsoft Dynamics GP, only the first check is imported in where this check number is duplicated in the import file. It will skip the succeeding records for the duplicate check number and these transactions are not listed on the exception report, so the user does not receive any messages that indicate that the transactions were not imported.

↑ Back to the top

Cause

This problem occurs because duplicate check numbers exist in the imported transactions.

↑ Back to the top

Workaround

To work around this problem, you must add another field to the Lockbox import file to make the record unique, such as Customer ID or Customer Name.  To do this, follow these steps: 
  1. Open the lockbox file by clicking on Cards, point to Sales and click on Lockbox .
  2. Bring up the Lockbox ID you are using.
  3. In the lockbox mapping, add Customer Name or Customer ID to the Header row.
  4. Click Save.
  5. Ask the bank to include either the Customer ID or the Customer Name to the lockbox file they generate. Make sure you mapped the field in the Lockbox file to the same spaces in the line that the bank added it to the lockbox file.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: kbnosurvey, kbtshoot, kbmbspartner, kbmbsmigrate, kbprb, kb

↑ Back to the top

Article Info
Article ID : 915100
Revision : 2
Created on : 2/9/2018
Published on : 2/9/2018
Exists online : False
Views : 277