Running the Aged Unbilled Stock Receipts

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 purchase orders for stock that you have received but for which you have not been billed.

You can manage the unbilled receipts using the P/O Reconciliation Queue to view purchase orders by vendor. You can sort the queue to only display unbilled stock receipts.

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

To run the Aged Unbilled Stock Receipts Report:

1. From the A/P > Reports menu, select Aged Unbilled Stock Receipts to display the Aged Unbilled Stock Receipts Report window.

2. 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 in the report.

3. 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..

4. In the Home Branches field, enter the branch, branches, or territories for which you want to run the report. You are only able to report on home branches to which you are authorized.

The system includes every vendor that has one of the designated branches identified as its home branch in the report. To include all vendors who a home branch assigned, leave the Home Branches field set to All.

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.

5. In the Include blank home branch field, indicate whether to include those vendors that do not have home branch assignment. You are only able to report on home branches to which you are authorized.

Note: If you run separate reports for different branches or territories, select Yes for only one of the reports. Otherwise, you include the same vendors in multiple reports. If you entered All in the Home Branches field, select Yes.

6. In the Buy Branches field, enter the branch, branches, or territories for which you want to include in the report. You are only able to report on home branches to which you are authorized.

Note: Typically, a company runs the report for all buying branches. However, if you have branches that represent separate companies and those branches run their own statements, enter the branch or territory name.

7. In the Detail/Summary field, enter one of the following to determine the level of detail to include In the report:

8. 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.

9. Summary - Displays one line of aging totals for each vendor, followed by a grand total for all vendors.

8. In the Sort By field, select how you want the contents of the report sorted.

9. In the Include Freight Vendors area, select Yes to include freight vendors in the report.

If you select Yes, the report displays aged amounts for freight vendors as it does material vendors.

10. In the Credits (Include/Exclude/Only) field, indicate whether or not to include credit information on the report:

11. In the Vendor Level field, enter one of the following to determine which type of vendor to include in the report:

12. Pay-To - Includes only pay-to vendors in the report. Pay-to vendors are vendors to whom you pay your bills.

13. Ship-From - Includes only ship-to vendors in the report. Ship-from vendors are vendors from whom your products ship.

12. Set options, if needed, and generate report.

What the Report Shows

The Aged Unbilled Stock Receipts Report shows the following information:

See Also:

Refining the Scope of Report Results

A/P Reports Overview