Unbilled Receiving Report
The Unbilled Receiving Report is used to show all Receivings from Vendors that do not have an Invoice against them.
Fig.1 - Running the Unbilled Receiving Report
Report Criteria
Fig.2 - Report Criteria for the Unbilled Receiving Report
Report Results
When the Unbilled Receivings Report is run, it should look similar to Fig.3 and Fig.4.
Fig.3 - Unbilled Receiving Report
Fig.4 - Unbilled Receiving Report Summary
Unbilled Receiving Report Summary (Fig.4)
On the last page of the report is a summary of accounts and vendor payment days.
The Unbilled Receiving Report is used to show all Receivings from Vendors that do not have an Invoice against them.
- To run this report, go to Report Center > Accounting Reports > Unbilled Receiving Report
- To open the report criteria screen, double-click Unbilled Receiving Report or select the report and then Run Report, as per Fig.1
Fig.1 - Running the Unbilled Receiving Report
Report Criteria
- Enter report criteria below to get desired results, as per Fig. 2
Fig.2 - Report Criteria for the Unbilled Receiving Report
| Fields | Description |
| Payment Type | Automatically Defaulted to "Unbilled" and cannot be changed. |
| Group By |
By Vendor: generates the report alphabetically by Vendor name. By Invoice Type: generates the report by Invoice Type. Note: Only Unbilled Invoices will show. By Outlet: generates the report alphabetically by Outlet name. |
| Date Range Options |
Without Dates: Runs the report for all unbilled receivings on the solution. Select Start and Ending Dates: Allows a Start and End date to be entered into the corresponding boxes for Receiving date. Date Range by Period: Allows the report to be run for all receivings with a receiving date within the financial period. |
| Period | Allows the user to run the report for all receivings with a date within an individual financial period. |
| From Date / To Date | Allows the user to run the report for all receivings within a certain time frame. |
| Include Outlet Names | When ticked, the report has an extra column showing the outlet that posted the receiving. |
| Include PO Comments | When ticked, any comments added to each individual Purchase Order will show underneath the Invoice type on the PO line. |
| Hide Zero Value Items | When ticked, any invoice with 0 monetary value is not included in the report. |
Report Results
When the Unbilled Receivings Report is run, it should look similar to Fig.3 and Fig.4.
Fig.3 - Unbilled Receiving Report
Fig.4 - Unbilled Receiving Report Summary
| Fields | Description |
| Document Map | Allows the user to look at report for individual vendors or consolidated. |
| Invoice Type | Type of Invoice - Will be Unbilled. Note: If Include PO comments included is ticked, comments will display underneath. |
| PO Number | Number of the PO against the Receiving. |
| Delivery Date | Delivery date added on creation of the PO. |
| Receiving Date | Date PO was received on the solution. |
| Receiving No | Receiving number assigned to the PO by the solution upon receiving. |
| PO Amount | Monetary amount of Receiving Note: This may differ from original Purchase Order Amount if value/quantity is different to what was ordered. |
| Outlet Name |
Note: Only shows if Include Outlet Names is ticked. |
| Account Reference | Accounting code for the associated account the products received will be costed to. If multiple accounts within one receiving, each account will show on a separate row. |
Unbilled Receiving Report Summary (Fig.4)
On the last page of the report is a summary of accounts and vendor payment days.
| Fields | Description |
| AP Account | The account cross reference configured for the AP Interface. |
| Account Number | The solution-assigned account number. |
| Account | The Account name configured in Property > Setup > Accounting > Accounts. |
| Amount | The total amount of all unbilled receivings for each individual account |
| Account Total | The total amount of all unbilled receivings for all accounts within the property |
Comments
0 comments
Please sign in to leave a comment.