Home › Forums › Knowledge Base › Legacy Applications › Accounts Receivable Reporting Module
- This topic has 0 replies, 1 voice, and was last updated 19 years ago by
Rob.
-
AuthorPosts
-
April 14, 2006 at 12:09 pm #1487
Rob
MemberAccounts Receivable Reporting Module
A module designed to go along with the CD.MOD styling package. Customer Debit/Accounts Receivable. Will provide an activity report for a selected range of dates.
[color=red:3kc2z861][u:3kc2z861][b:3kc2z861]Download A_R[/b:3kc2z861][/u:3kc2z861][/color:3kc2z861][/url:3kc2z861]SYNTAX: A_R {/POSTCREDIT} {/POSTDEBIT} {/?}
* /POSTCREDIT – Will post a credit transaction to a customer’s file.
* /POSTDEBIT – Will post a debit transaction to a customer’s file.
* /? – Will display help information.Notes:
1. Requires SHARE
2. Requires subdirectories CHECKS, DATA, REPORTS and A_R
3. Version 1.xx A_R for TouchNET, Version 2.xx A_R for TouchPRO.
4. Reads the Manager report options for:
* Printer port
* Lines per page
* Eject page
* Extra lines of textInstructions for use:
1. Place the A_R.EXE and A_R.RES files in the TOOLS directory.
2. Create a shell to post debit transactions with the following values:
Command Line: A_R /POSTDEBIT
Lowest variable: 6
Highest variable: 34
Preserve screen: ON
Store variables: ON
Swap to XMS/EMS: ON
3. Create a shell to post credit transactions with the following values.
Command Line: A_R /POSTCREDITTechnical Information
Steps A_R performs upon execution:
1. Checks for existence of SHARE.
2. Checks for required subdirectories. (see below for names)
3. Reads GLOBAL.DAT for TOUCHNET version information.
4. Performs one of the command line switches or main program.Maximum values:
Customers: 12,000
A/R Transactions: 3000 (per account)
Dates: 730Requirements:
1. The following must be subdirectories of the application:
A_R, DATA, CHECKS, REPORTS
2. Share must be running.
3. Proper version of TouchNET or TouchPRO.
4. DOS version 6.22
5. 386 processor with 4mg RAMFile Formats:
Name: ########.#AR (where ########.# is equal to a customer account #)
Purpose: Permanent storage of all customer debit/credit transactions.
Location: A_R subdirectory of application
Type: Binary
Size: Variable dependent on number of records
Record size: 15Code 1 – byte BYTE
Data1 4 – bytes LONG
Data2 2 – bytes INTEGER
Amount 1 – 4 bytes LONG
Amount 2 – 4 bytes LONGCODE DESCRIPTION DATA 1 DATA 1 AMOUNT 1 AMOUNT 2
1
Debit Transaction Date Check # Amount Running Balance
2 Credit Transaction Date Blank Amount Running BalanceName: DATES.AR
Purpose: To provide the report module with a list of dates when Customer transactions took place.
Location: A_R subdirectory of application.
Type: Binary
Size: Variable dependent on number of records
Record size: 4Date 4 bytes LONG
Printing:
All printing is done respecting the report options defined in TOUCHNET’s MANAGER program. The specific report options used in A_R are:
* Printer port
* Page length
* Eject page
* Condensed print codes
* Regular print codes
* Extra textReports
All Accounts Activity Report:
1. Select a begining and ending date to run the report for.
2. Select Print or View.This report will show detailed activity, starting balances and ending balances for all accounts in the customer database for the range of dates selected. The report will only include accounts that have either activity recorded for the date range or an ending balance for the date range. (The activity must have been collected using this program.) The report will also include the total debit amount at the end of the report.
NOTE: This value is not necessarily the current amount outstanding.
This report uses the following files:
* DATACustomer.DAT
* DATACusAcnt.DAT
* DATACusName.DAT
* Various A_R########.#AR files (where ########.# = Customer Account#)One Accounts Activity Report:
1. Select a customer to generate the report for.
2. Select a beginning and ending date to run the report for.
3. Select Print or View.This report will show detailed activity, starting balances and ending balances for the account selected for the range of dates selected. The report will only include accounts that have either activity recorded for the date range or an ending balance for the date range. (The activity must have been collected using this program.)
This report uses the following files:
* DATACustomer.DAT
* DATACusAcnt.DAT
* DATACusName.DAT
* Various A_R########.#AR files (where ########.# = Customer Account#)Current Status Report:
1. Select Print or View.
This report will show the current status of all accounts in the customer database with a non-zero balance. A positive balance will indicate a credit amount and a negative balance will indicate a debit amount. The report will compute the total debits and credits and show a total amount outstanding.
This report uses the following files:
* DATACustomer.DAT
* DATACusAcnt.DAT
* DATACusName.DATRevisions
01/12/96 version 1!01
1. Fixed bug relating to respecting the Eject Page option from the Manager.CFG file. (Report Options defined by Touchnet MANAGER) Updated the doc file with more information.
02/21/96 version 1!02
1. Fixed bug relating to reports. Previously would only report accounts that had activity.
2. Added activity report for one selected account.
3. Added current status report.
4. Added on line help.
5. Changed method of collect transaction dates. Previously A_R would create an empty file with a name corresponding to a date, now it stores the dates when transactions took place in one file.
6. Updated this document with more information.05/02/96 version 1.03
1. Changed the screen i/o used to select a date. Replaced the select a date dialog that you used to choose Print or View on along with selecting a date to just a date selector and presented a Report Output Menu after report is generated.
2. Release version.08/08/96 Version 2.00
1. Version 5.xx compatible
08/28/96 Version 2.01
1. Fixed bug related storing transaction date in Dates.AR file. Was using PB INSTR function, switched to Darrin’s MyINSTR function.
03/10/97 Version 6.00
1. Only change was version dependency.
07/29/98 Version 6.01
1. Added support for virtual HASP (standalone)
12/08/98 Version 6.02
1. Y2K compliant.
03/30/99 Version 6.03
1. Will now allow selection of the newest 730 files instead of the oldest.
-
AuthorPosts
- You must be logged in to reply to this topic.