Difference between revisions of "Information Systems:Auditors"
| Line 26: | Line 26: | ||
We want an Excel file of warehouse, item number, description, item account group, class, brand, quantity, unit cost, and extended cost. Use [[Auditors - Inventory|Item Transaction Detail in InfoNet]] to get this. This file will have more information that the auditors require, so you can remove some lines and columns. |
We want an Excel file of warehouse, item number, description, item account group, class, brand, quantity, unit cost, and extended cost. Use [[Auditors - Inventory|Item Transaction Detail in InfoNet]] to get this. This file will have more information that the auditors require, so you can remove some lines and columns. |
||
| + | |||
| + | ===Sales Order Shipping (First and Last of Year== |
||
| + | |||
| + | We want an Excel file of pick list, sales order, invoice number, date, and time, Use * [[Auditors - Sales Order Shipping|Item Transaction Detail in InfoNet]] to get this. This file will have more information that the auditors require, so you can remove some lines and columns. |
||
| + | |||
| − | * [[Auditors - Sales Order Shipping|Sales Order Shipping (Last and First)]] |
||
* [[Auditors - Expenses|Expenses]] |
* [[Auditors - Expenses|Expenses]] |
||
* [[Auditors - Purchase Order Receiving|Purchase Order Receiving (Last and First)]] |
* [[Auditors - Purchase Order Receiving|Purchase Order Receiving (Last and First)]] |
||
Revision as of 13:40, 28 January 2016
New Process
The old queries have been replaced with InfoNet programs that allow more flexibility, and that Finance can do themselves - maybe even the auditors can.
Accounts Receivable
We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end. Use Summarize A/R From Transactions in InfoNet to get this. This file will have more information that the auditors require, so you can remove some lines and columns.
Sort by 'Original Amount' and delete any lines with a zero balance.
As only one summary level was requested, columns for the second and third levels can be deleted (C, D, E, and F).
The columns for 'transactions', 'remaining amount', 'banner', 'area', and address can be deleted.
Accounts Payable
We want an Excel file of vendor number, name, account type, balance, and preliminary invoices. Use Summarize A/P From Transactions in InfoNet to get this. This file will have more information that the auditors require, so you can remove some lines and columns.
Sort by 'Original Amount' and delete any lines with a zero balance.
As only one summary level was requested, columns for the second and third levels can be deleted (C, D, E, and F).
The columns for 'transactions', 'remaining amount', 'banner', 'area', and address can be deleted.
Inventory
We want an Excel file of warehouse, item number, description, item account group, class, brand, quantity, unit cost, and extended cost. Use Item Transaction Detail in InfoNet to get this. This file will have more information that the auditors require, so you can remove some lines and columns.
=Sales Order Shipping (First and Last of Year
We want an Excel file of pick list, sales order, invoice number, date, and time, Use * Item Transaction Detail in InfoNet to get this. This file will have more information that the auditors require, so you can remove some lines and columns.
- Expenses
- Purchase Order Receiving (Last and First)
- Sales Comparison
- Trial Balance
- Financial Reports (Report Writer)