APDISSCN Accounts Payable Distribution History Report
AP Distribution History Report
Application Overview
The AP Distribution History Report shows, in GL account number order, all items that have been purchased on a particular account.
Run Instructions
Select the Distribution History Report from the pull-down A/P Reports window and select Print and then Distribution History Report. The following screen will then be displayed:
The following options are available:
- After pressing the RETURN key, enter the data requested on the screen
To exit press the ESC or F10 key when the cursor is positioned for entry of the first field on the screen
To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.
Entry Field Descriptions
Name | Type and Description |
1. Starting G/L Account | An account in the standard account number format.
Pressing the F7 key will allow you to search for the account by number or pressing the F8 key will allow you to search for the account by description.
Press Enter to print All accounts.
The default is blank. |
2. Ending G/L Account | An account in the standard account number format.
Pressing the F7 key will allow you to search for the account by number or pressing the F8 key will allow you to search for the account by description.
This field is skipped if all accounts are selected.
The default is the Starting G/L Account number. |
3. Starting Item No | 15 alphanumeric characters.
Enter the starting item number for the range of items to appear on the report.
Press the F7 key to search by item number or press the F8 key to search by item description. Defaults to All items. |
4. Ending Item No | 15 alphanumeric characters.
Enter the ending item number for the range of items to appear on the report. This field is skipped if all items are selected.
Press the F7 key to search by item number or press the F8 key to search by item description. Defaults to the starting item number. |
5. Starting Voucher Date | Enter a date in the standard date format.
Enter the starting voucher date you want to appear on the report. Leave this field blank to select all dates.
This field defaults to blank. |
6. Ending Voucher Date | Enter a date in the standard date format.
Enter the ending voucher date you want to appear on the report. This field will be skipped if all dates are selected.
This field defaults to the starting voucher date. |
AP Distribution History Report Screen:
AP Inventory Value Report
Application Overview
This is essentially an Inventory Stock Status/Valuation Report from the A/P point of view. This information can be especially valuable if you use the standard cost method for inventory valuation. For example, your auditor may want to compare the value difference between the item standard cost and the actual cost paid in A/P. This report will show the latest receiving to make up the current inventory and the associated A/P vouchers and checks. Variance between A/P and standard cost will be printed for each item; subtotal and grand total level should give the auditor sufficient information to determine if the book inventory valuation is acceptable.
Run Instructions
Select the Distribution History Report from the pull-down A/P Reports window and select Print and then A/P Inventory Value Report. The following screen will then be displayed:
The following options are available:
- After pressing the RETURN key, enter the data requested on the screen
Entry Field Descriptions
Name | Type and Description |
1. Use What Qty | 1 alphanumeric character; C = Current Qty, F = Freeze Qty, S = Specific Date Qty.
If the Current or Freeze quantity is used, the appropriate date will appear tot he right. If the Specific date option is selected, it will prompt you for the date.
The default is C. |
2. Starting Item No | 15 alphanumeric characters.
Enter the starting item number for the range of items to appear on the report.
Press the F7 key to search by item number or press the F8 key to search by item description. Defaults to All items. |
3. Ending Item No | 15 alphanumeric characters.
Enter the ending item number for the range of items to appear on the report. This field is skipped if all items are selected.
Press the F7 key to search by item number or press the F8 key to search by item description. Defaults to the starting item number. |
4. Starting Product Category | 3 alphanumeric characters.
Enter the starting product category for the range to print. Press the F7 key to search by product category.
Defaults to All product categories. |
5. Ending Product Category | 3 alphanumeric characters.
Enter the ending product category for the range to print. Press the F7 key to search by product category. This field is skipped if all product categories are selected.
Defaults to the starting product category. |
6. Material Cost Type | 1 alphanumeric character.
Enter the material cost type code for the report to print. Press the F7 key to search by material cost type. Leave this field blank to select All product categories.
Defaults to blank. |
7. Buyer/Analyst | 2 alphanumeric characters.
Enter the buyer code for the report to print. Press the F7 key to search by buyer code. Leave this field blank to select All buyers.
Defaults to blank. |
8. Include Obsolete Item ? | Y, N or O.
If Y, obsolete items will appear on the report. If N, obsolete item will not appear on the report. If O, only obsolete items will appear on the report.
The default is Y. |
9. Minimum Variance % | 6 numeric digits with 2 decimal places (9,999.99).
This is the minimum variance an item must have before it will appear on this report. Leave blank to print All.
This field defaults to blank. |
10. Minimum Variance Value | 10 numeric digits with 2 decimal places (99,999,999.99).
This is the minimum variance value an item must have before it will appear on this report. Leave blank to print All.
This field defaults to blank. |
11. Minimum Inventory Value | 10 numeric digits with 2 decimal places (99,999,999.99).
This is the minimum inventory value an item must have before it will appear on this report. Leave blank to print All.
This field defaults to blank. |
12. Printing Sequence | 1 alphanumeric character; I = Item, C = Category, M = Material Type and B = Buyer.
Select the print sequence you would like the report to print.
The default is I. |
13. Print Detail Level | 1 alphanumeric character; D = Detail and I = Item Summary.
Select the detail level you would like the report to print.
The default is D. |
14. Print Variance % | 1 alphanumeric character; I = At Item Level and G = At Grand Total Level.
Select the level you would like the print variance percentage to print on the report.
The default is G. |
15. Show Mostly Mfg Mfg Items? | 1 alphanumeric character; N = No, Y = Yes and P = Yes & Show PO & Prod Details Only.
The default is P. |
16. Show Mostly Purch Mfg Item | 1 alphanumeric character; N = No, Y = Yes and P = Yes & Show PO & Prod Details Only.
The default is P. |
17. Show Purchase Items? | 1 alphanumeric character; N = No, Y = Yes and P = Yes & Show PO & Prod Details Only.
The default is P. |
Related Articles
AP11S1 Accounts Payable Check History Report
Check History Report Application Overview The Check History Report accesses the A/P Open Item File for check information. The A/P Open Item File contains information since the last purge date (date for which the Purge A/P Open Item File was last ...AP1400 Accounts Payable Job Distribution Report
Job Distribution Report Application Overview Distributions are posted to the Job Distribution Report and are printed. This report is a particular project or activity for which expenses are being tracked. When an invoice is entered into the Accounts ...AP0000 Accounts Payable Overview
Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a ...AP1500 Accounts Payable Job Analysis Report
Job Analysis Report Application Overview A Job Analysis Report can give you the capability to trade expenses that are being billed. When an invoice is entered into the Accounts Payable package, the invoice amount can be distributed among the ...AP13S1 Accounts Payable Vendor History Report
Vendor History Report Application Overview The Vendor History Report can be used to find information on paid vendor invoices if they were paid since the cut‑off date of the last purge of the A/P Open Item File. This report is printed from the A/P ...