To exclude accounts from an A/R Aging Report:Businesses often borrow money against their accounts receivables. Someone from the company goes to the bank with a report of what the company’s accounts receivable balance is and asks to borrow against that balance. If the company receives a loan, they may be required to produce reports to show exactly what their accounts receivable balance is, sometimes on a daily basis, because their borrowing power can change day to day. A bank considers a certain amount of accounts receivable as uncollectable because it has been delinquent for too long.
This topic includes two methods to exclude delinquent accounts from an A/R Aging Report. The first three steps are the same for both methods.
To exclude accounts from an A/R Aging Report:
Create a record for a fictitious branch in Customer Maintenance, using the following information:
In the Name field, enter a significant but fictitious name such as Branch 99.
On the left side of the screen, only populate the Zip, Sort By, and Index fields.
On the right side of the screen, flag the Bill To, Job or Ship To, and Branch fields.
Create a record for the fictitious branch in Branch Maintenance, using the following information:
In the Branch/ID New field, enter the same number as you did in step one, such as 99.
In the Short Desc field, enter any applicable description.
In the Entity ID field, enter Branch 99.
Leave the Default Price Class field blank.
Display the Customer Maintenance record for each delinquent customer that you want to exclude from your A/R Aging report. Use the following steps for each customer:
From the Files menu, select Customer to display the Customer Maintenance screen.
In the Customer/New field, type the name of the customer to exclude.
Use the Branch hot key to display the Accessible Branches screen.
In the Home Branch field, enter 99.
Press Esc to exit the screen and save the information.
Proceed to Method One or Method Two, depending on your needs.
Display your own User Maintenance record.
Use the Branches hot key to display the Accessible Branches screen.
In the Auth field, enter S.
Run the A/R Aging Report with All entered in the Home Branches field.
This includes all the branches to which the user has access. The report displays “All Branches” but does not, in fact, include the customers with “uncollectable” accounts who have Branch 99 assigned as their home branch, because Branch 99 was not accessible to the user running the report.
Create a territory in Territory Maintenance, with the name of “Corp” for Corporate, for example, that includes all branches except Branch 99.
You must have access to all the branches to be included in the territory. If you do not have access, when you try to include an inaccessible branch in the territory, the following message displays: Not authorized for all branches in territory.
Run the A/R Aging Report, and select Corp, or whatever name you created in Territory Maintenance in step one, in the Home Branches field. This includes on the report all customers in all branches except Branch 99.
You must have access to all the branches in the territory named “Corp”. If you do not have access, when you try to run the report, the following message displays: Not authorized for all branches in territory.
The report says “Corporate” territory, but Branch 99 customers are not included in the aging report.
See Also: