x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 45 subscribers
  • Views 3227 views
  • Users 0 members are here
Browse Forums
Announcements
68
topics
93
replies
Customization and Integration
262
topics
822
replies
Financials, Projects, and Administration
382
topics
843
replies
General Discussion
327
topics
836
replies
Installation and Technical Issues
335
topics
1k
replies
Manufacturing, Distribution, and Applications
341
topics
696
replies
Reporting and Analytics
124
topics
482
replies
B. Popp

Import A/R transactions into Sage 500 ERP

SOLVED
Posted By

I'm a new user to Sage and am not in the IT field.

My goal is to create an import file (.CSV or excel) containing each invoice number, payment amount, account info, etc to credit each invoice paid by an ACH remittance (money was already deposited into our bank, just need to get it to the invoice in Sage). 

Currently, we have to load each account, put in the total ACH deposit, find each individual invoice being paid and check the box, and then post it to our batch.  The amount of invoices per each ACH can be anywhere from 50-400 and this is becoming extremely tedious.

I've researched online but I'm seeing differing ways of how to do this.  Is it as simple as setting up a .CSV or excel file and importing it each day into MAS and it will automatically credit the invoices specified on the sheet or is there more to it?

Any assistance would be greatly appreciated.  Thank you!

-Brittany

  • 0

    Sage supplies an API to import cash receipts.  However I am not aware of an easy to use front end for it.  I thought it might be in data migrator but I didn't see it when I looked.  I would contact your reseller for more info.  If they don't know then I'd contact RKL or E2B Tech for help with it.  I bet one of them has a customization that is close to what you want.  

  • 0 in reply to JohnHanrahan

    Yes we have Extended API for this in the form of SQL Stored Procedures as well as Web Services. Feel free to reach out to Russ Griffith at [email protected] or me.

  • 0 in reply to jnoll
    verified answer

    As John notes, Sage provides an API for this and the entity type to import this into within the Data Import Manager module is called Pending Customer Payments.  (Note:  This has only been available for the last couple of versions of Sage 500 ERP.  If you are running an older version it will not be available to you unless you upgrade.)

    If you are running an older version or if you determine the out of the box solution isn't a solution after all, I would be happy to discuss it further with you.

  • 0 in reply to RussG

    Thank you Russ!  Once I can get into test mode I'm going to try out data import manager with the provided Pending Customer Payments sheet and see how it goes.  I was attempting to find a manual but I wasn't able to locate one.  We have verison 7.5 so we should be able to use the cash receipts upgrade in A/R.  I'm going to shoot you an email and if you happen to have any procedures or helpful tips on how to make this a smooth process I'd appreciate it!  Thanks again!

  • 0 in reply to jnoll

    Thank you John!  I'll start this process and see how it goes.  Appreciate the help!

*Community Hub is the new name for Sage City