Welcome, Guest
Username: Password: Remember me

TOPIC: AR Customers Statements / input from Excel

AR Customers Statements / input from Excel #755

  • dborn
  • dborn's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
I'm hoping to automate faxing of customer statements.

First of all, I haven't been able to come up with a query that will tell me the customers that have invoices past due. If someone has any thoughts on that I'd appreciate it.

Since I'm struggling with a query, I'm playing with using the Aging Analysis crystal report and exporting the data to Excel. I would like to use the Excel file as input to EventManager in order to drive the customer statements.

Has anyone used Excel as input to EventManager. I'm not having any luck and the KnowledgeSync manual does not seem to have any information on imput from Excel.
The administrator has disabled public write access.

AR Customers Statements / input from Excel #1058

  • dcarolan
  • dcarolan's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
As a consultant, I know how to create a Crystal report that will replace the aging analysis and or AR customer statement and then streamline within Event Manager. These two reports regarding Aging cannot just be put into Event Manager as they are dependent upon the screen in ES, so they need to be recreated in Crystal. However, I have had extensive experience in doing that for customers.

You should be able to contact your regional office for expertise, or you can inquire to contact me on a consulting basis.

You should know that faxing is more difficult to setup than using email subscriptions. Hope that helps.

Best regards,
Dianne Carolan
Application Specialist
Event Manager and Crystal
dianne.carolan@exactsoftware.com
The administrator has disabled public write access.

AR Customers Statements / input from Excel #1433

  • be05x5
  • be05x5's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 123
  • Thank you received: 2
  • Karma: 0
dborn wrote:
First of all, I haven't been able to come up with a query that will tell me the customers that have invoices past due. If someone has any thoughts on that I'd appreciate it.

What is your ERP system? Progression, ES???
The administrator has disabled public write access.
Time to create page: 0.035 seconds
Powered by Kunena Forum  Protected by R Antispam