Views Reply Votes
Irfan Jamal
Irfan
 7
can we automate the application of cash (820) against an invoice?
105
2
00
Posted: Jul 24, 2019   
Votes
Shivakumar Patil
Shivakumar
 45
Replied 

have you checked this feature "Processing Incoming Bank Files".

There are many ways to handle the EE functions in lieu of CIM methodology.

1. use QAD API's to load the financial data

2. use Qxtend

3. write programs using QAD tables and update the data - risky but can be used for medium complexity menus.

4. build interface to convert external files to excel integration format and manually load in QAD using execl integartion menus.

if you need more information email me patil.shivkumar@gmail.com

00
Replied: Jul 25, 2019
Votes
Irfan Jamal
Irfan
 7
Replied 

Our files are not from the bank. We actually receive 820s directly from customers, and the files contain details of which invoice they are paying, item quantities, price and extension. 

As a developer, I need to find more resources on how we can automate the process of loading and matching these payments, including handling prepayments/deductions.

The manual process our A/R team currently uses is Customer Payment Create (27.6.4.1). There is quite a bit of matching going on, so I need to understand how we can automate this.

If someone can point me in the direction of any documents/guides/tutorials on how to automate using either the API or some other method, it would be appreciated.

THANKS

00
Replied: Aug 21, 2019
Forums
All
Forum Help
Help Using Forums