Running the Aged Unbilled Stock Receipts Report

Run an Aged Unbilled Stock Receipts Report to obtain a picture of what to expect in accounts payable based on receipts for which you have not yet received invoices. This report also creates an aged listing of the P/Os for stock that has been received but for which you have not been billed.

For a description of the report, see What the Report Shows at the end of the topic.

To run an Aged Unbilled Stock Receipts Report:

From the A/P > Reports menu, select Aged Unbilled Stock Receipts to display the Aged Unbilled Stock Receipts Report screen.
In the Data Through field, enter a date to determine which unbilled stock receipts to include in the report. Only receipts dated up to and including this date are included.

The current date is the default date for this field.

In the Age as of field, enter the date used to determine the aging of the receipts.

The default date is the date entered in the Data Through field.

In the Home Branches field, enter the branch or territory for which you want to run the report. Enter All to run the report for all branches.

Every vendor who has one of the designated branches identified as its home branch will be included in the report. To include all vendors who have been assigned a home branch, leave the Home Branches field set to All.

While typically a company runs the report for all home branches or territories, however, when branches represent separate companies and those branches run their own statements, enter the branch or territory name.

In the Include Blank Home Br (Y/N) field, indicate whether to include in the report those vendors that have no Home Branch assignment.

If you specified All in the Home Branches field, enter Y in this field.
If you run separate reports for different branches or territories, enter Y in this field for only one of the reports. Otherwise, you include the same vendors in multiple reports.

In the Buy Branches field, enter the branch or territory for which you want to report. Enter All to report on all branches and territories.

Typically, a company runs the report for all buying branches, however, when branches represent separate companies and those branches run their own statements, enter the branch or territory name.

In the Detail/Summary field, press F10 and select one of the following to determine the level of detail to include on the report.

Summary – Displays one line of aging totals for each vendor, followed by a grand total for all vendors.
Detail – Displays all stock receipts and invoices for each vendor, followed by the aging totals for that vendor, and then by a grand total for all vendors.

In the Sort By field, press F10 and select one of the following to determine how to sort the report:

Home Branch – Sorts by home branches.
Buy Branch – Sorts by buy branches.
Vendor – Sorts by vendor accounts.

In the Include Freight Vendors (Y/N) field, enter one of the following to indicate whether to include freight vendors in the report:
Y – Includes freight vendors.
N – Does not include freight vendors.
Note: If you enter Y, the report displays aged amounts for freight vendors as it does for material vendors.

In the Credits (Inc/Exc/Only) field, press F10 and select one of the following to determine whether or not to include credit information on the report:

Include – Includes credits on the report and displays them as negative values.
Exclude – Excludes all credits from the report.
Only – Includes only credits on the report.

In the Vendor Level field, enter one of the following to determine which type of vendor to include in the report:
Pay-To – Includes only pay-to vendors in the report. Pay-to vendors are vendors to whom you pay your bills.
Ship-To – Includes only ship-to vendors in the report. Ship-from vendors are vendors from whom your products ship.

Use the Slct key to display the Additional Selection Input screen, where you can enter additional criteria, for example, to select orders associated with a particular batch number.
Set options, if needed, and generate the report.

What the Report Shows

The Aged Unbilled Stock Receipts Report shows the following information:

Column	Description
Home Branches	Which home branches are included in the report.
Buy Branches	Which buy branches are included in the report.
Freight Vendors	Indicates whether or not you included freight vendors in the report.
Vendor Name	The name of the vendor.
Rec Date	The date the stock was received.
PO/Rec#	The purchase order number associated with the received stock.
Future	Those unbilled payables that are due before the due date of the current fiscal month.
Current	Those unbilled payables that are due within the current fiscal month.
31-60	Those unbilled payables that are between 31 and 60 days due.
61-90	Those unbilled payables that are between 61 and 90 days due.
91-120	Those unbilled payables that are between 91 and 120 days due.
Over 120	Those unbilled payables that are over 120 days due.
Total	The total of all amounts in all of the columns.