gibsonsnet
IS-IT--Management
I am trying to get Vendor balances up to a specific date. Is there an easy way to do this. I have access to all of the files.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AP Balance up to specific date Macola 6.0
- Thread starter gibsonsnet
- Start date
- Status
Are you serious, Macola 6.0 as in the DOS version?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"What version of URGENT!!! are you using?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"What version of URGENT!!! are you using?
WOW I have forgotten more that I remember about version 6. I am going to make a couple of assumptions.
1 the files are btrieve
2 you have the ddf files
3 the A/P open purge has not been run
4 you have the skills to write the report
If these are true there is a table named apopnfil or apopnfil_sql. This table contains a record for every A/P transaction, vouchers, payments and credit memos. There is a transaction date for each record., depending on how you did credit memos there should be an apply to record that will link the records together. You may have to deal with the beginning balance issue. That depends on how the data was originally entered.
This should get you started.
Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.
If the only tool you can use is a hammer then all your problems look like nails.
1 the files are btrieve
2 you have the ddf files
3 the A/P open purge has not been run
4 you have the skills to write the report
If these are true there is a table named apopnfil or apopnfil_sql. This table contains a record for every A/P transaction, vouchers, payments and credit memos. There is a transaction date for each record., depending on how you did credit memos there should be an apply to record that will link the records together. You may have to deal with the beginning balance issue. That depends on how the data was originally entered.
This should get you started.
Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.
If the only tool you can use is a hammer then all your problems look like nails.
- Status