Adaco: Invoice Log Report – Fourth & HotSchedules Customer Success Portal

Invoice Log

This report provides a list of applied invoice information.

To run the Invoice Log report, go to Report Center > Accounting Reports > Invoice Log
To open the report criteria screen, double-click Invoice Log or select the report and click Run Report, as per Fig.1

Fig.1 - Invoice Log report

Report Criteria

Enter report criteria to get desired results, as per Fig.2

Fig.2 - Report Criteria for the Invoice Log report

Fields	Description
Invoice Type	Select the Invoice type as defined under Property > Setup > Accounting > Payment Methods if applicable. A/P [default]
Report Selection	Invoice Log - will generate a report of all invoices that have not been exported to accounts payable. [default] Exported Log - will generate a report of all invoices that have been exported to accounts payable
Report Options	All Vendors - generates the report for all vendors and provides a per vendor monetary total [default] All Vendors, Remittance Detail - generates the report for all vendors with vendor monetary totals and includes the account totals charged per vendor Selected PO's - allows selecting of individual purchase orders per the date range entered Selected Accounts - allows selecting of individual accounts that meet the report criteria
Date Range Option	Receiving Date - displays order with a received date within the date range entered. You will need to fill on the From and Through dates [default] Date Range by Period - when selected will open the Period field and allow choosing of a reporting period as defined under Property > Setup > Accounting > Fiscal Calendar Invoice Applied Date Range - when selected will open the Date From and Through fields allowing entry of the invoice date range Exported Dates - Used with the Report Selection: Exported Invoice Log to allow entering an exported date range
Get Orders button	Used along with the Report Option: Selected PO, to populate the grid with orders that meet the criteria entered.

Report Results

When the Invoice Log report is generated, the result should look similar to Fig.3

User-added image

Fig.3 - Invoice Log report results

Please Note: Manually entered invoices will appear on the Invoice Log Report.
For manually entered invoices, "P.O. No" and "Received By" fileds will be blank. The "P.O. Amt" field will contain "0.0000".

Fields	Description
From and Through	Displays the From and Through dates the report was generated for.
P.O. No	The purchase order number.
Invoice No.	The invoice number.
Invoice DT.	The invoice date entered when applying the invoice.
P.O. Amt	The purchase order total.
Invoice Amt	The invoice amount applied.
A/P Vendor No	The accounts payable vendor cross reference number as defined under Property>Vendor menu [If applicable].
Final Approved	Displays the full name of the user that Final approved the order as defined under Property>User Center.
Received By	Displays the full name of the user that received the purchase order as defines under Property>User Center.
GL Outlet	Displays the general ledger outlet as defines under Property>Setup>Location>Outlet>General Ledger Outlet field. [If Applicable]
GL Account	The general ledger account as defined under Property>Setup>Location>Outlet>General Ledger Account field. [If Applicable]
A/P Acct No	The accounts payable cross reference number as defined under Property>Setup>Accounting>Accounts>Accounts Payable Cross Reference. [If applicable]
Inv. Dist. Amount	The monetary invoiced total on the corresponding purchase order.
Vendor	The vendor number and name.
Vendor Total	The total amount invoiced per each vendor.
Grand Total	The amount invoiced for all order on the report. Calculation: GRAND TOTAL = VENDOR "A" TOTAL + VENDOR "B" TOTAL...etc.
Accounts Grand Total Recap	Account - The Adaco account number. Account Name - The Adaco account name. Total - The account total.
Accounts Grand Total	The accounts grand total. Calculation: ACCOUNTS GRAND TOTAL = ACCOUNT "A" TOTAL + ACCOUNT "B" TOTAL... etc.

Related articles