Use the AR Sales Register to:
Print an invoice register of all invoices.
Update invoices to the open receivables file, customer file, salesperson/territory file, sales tax file and GL journal file.
Update the sales analysis holding file according to the sales information.
Invoice register information includes the following:
Summary - invoice number, invoice date, terms code, salesperson/territory, department, customer number and name, merchandise amount, discount amount, cost amount, tax amount, freight amount, and total amount of invoice.
Detail - summary information plus line number, item, description, taxable flag, cost and price for each item on the invoice.
During the AR Sales Register update, FACTS updates the bank transaction system only for invoices with cash type terms codes (C,1-4) that have the cash GL# set to "BANK". Any non-cash terms codes or cash terms codes that are set up with a specific cash GL number will update GL and will not update the bank balance or transfer over to the bank reconciliation system.
Cash terms codes are indicated by a $ to the right of the terms code. Customers over their credit limit are indicated by an asterisk (*) to the right of the invoice total. Subtotals are printed for cash and for Accounts Receivable. The register totals include the total number of invoices on the register and their average invoice amount. All deleted (deleted before printing) and voided (deleted after printing) documents appear on the register to provide a complete audit trail of all invoice numbers. Depending on the setting for the flag in the AR sales posting to GL record, you can obtain a general ledger distribution printout.
Access this program by choosing Accounts Receivable-->Invoice Processing-->Sales Register.
1. Enter the sales register date. Press Enter to default to the system date. This displays the date and the current AR and GL periods. The period the sales register posts to in SA is the same as the period that it posts to in GL and is based on the register date that you enter here.
2. Enter the branch number to print. The entry must be valid in the system. Press F1 to default to ALL.
3. Select the scope of the information that should print. The choices are Summary and Detail information. The program defaults to S-Summary.
4. Indicate whether this is the correct date and GL period for the Sales Register to post.
The system builds the GL distribution while it prints the Sales Register. The parameters established in the AR Sales to GL Posting F/M program and AR GL posting tables affect how the system builds the distribution.
Check register. OK to print GL distribution? After printing the Sales Register, verify the printout. If you need to make a correction, select Cancel to exit the program. You can rerun the register after you make the correction. If everything is correct, enter OK to continue. The program prints the GL distribution. Verify the accuracy of the GL distribution, and when you are ready, proceed with the update.
If you are not printing the GL distribution, the system displays this message:
Check register. OK to update?
After printing the Sales Register, verify the printout. If there is a correction to be made, select Cancel to exit the program. After the correction is made, the register can be rerun. If everything is correct, select OK to continue. The program will not print a GL distribution, it skips the following field and proceeds with the update.
Check GL distribution. OK to update? After printing the distribution, verify the printout. If everything is correct, select OK to continue. The program proceeds with the update. If there is a correction to be made, select Cancel to exit the program. After the correction is made, the entire register process begins again. The program runs the register first, then prints the GL distribution, and then updates if you tell it to do so.
How to print and update the Sales Register
Viewing reports on screen (using the viewer)