cash receipts import

• 06-30-2008 11:32 AM

  Gloria Gillespie Joined on 06-30-2008 Posts 2	cash receipts import Reply Contact I am looking for a module that will allow us to import the cash receipts from a customer file (*.txt, etc.) so we can post automatically by looking up the document number.  We have a high-volume transaction scenario that would greatly benefit being able to import the cash receipt data.  Thanks for any help.
  	Tags: Dynamics GP, solution finder

• 06-30-2008 12:23 PM

  In reply to

  Dan Sionov Joined on 06-30-2008 Posts 2	Re: cash receipts import Reply Contact The Lock Box feature in Dynamics GP will be able to do this for you.  It's typically used when a bank collects your cash receipts and sends you a text file.  You would then import this text file and automatically apply to the open invoices.
  	Tags: Dynamics GP, Great Plains

• 06-30-2008 12:52 PM

  In reply to

  Gloria Gillespie Joined on 06-30-2008 Posts 2	Re: cash receipts import Reply Contact We are not using a traditional lockbox.  The deposits are being made via EFT.  We get a separate remittance advice directly from our customer.  Could that file be imported in this lockbox feature?  Thanks for your help!

• 06-30-2008 7:24 PM

  In reply to

  Dan Sionov Joined on 06-30-2008 Posts 2	Re: cash receipts import Reply Contact  That should still be OK.  It's just expecting a text file.  It will let you configure the field mapping to be able to import the file.

• 07-01-2008 3:14 PM

  In reply to

  callen Joined on 06-26-2008 Posts 26	Re: cash receipts import Reply Contact There is a module called EFT for Receivables Management. If you have GP Professional, you can buy it if you don't own it. If you have GP Advanced Management, you already own it. If you have GP Standard or Business Essentials, your best bet is to use Integration Manager or perhaps the lockbox module. I haven't used the latter item so I can't comment on it.