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

 



Feedback and Knowledge Base