AP Distribution History Report

Application Overview

The AP Distribution History Report shows, in GL account number order, all items, which 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:

A/P Distribution History Report Entry Screen

The following options are available:

* After pressing 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.

Screens

A/P Distribution History Report

Run Date: Jan 8, 2008 - 10:48am Electronics - RSS(96) Page 1

D I S T R I B U T I O N H I S T O R Y A N A L Y S I S

Ranges: G/L Account: 04230-00000-00000 Thru 04230-00000-00000

For All Item

For All Date

G/L Account No Item No Dist_Amount Vou_Date QTY Uom Po# Vendor_No Vendor_Name

04230-00000-00000 120 0.01 01/01/03 10.000 EA 00016200 000100 Computer Electronics Center

Sub-Total Item: 120 $0.01

202 0.00 01/24/03 100.000 EA 00014000 000100 Computer Electronics Center

65.00 10/07/04 50.000 EA 00018100 000100 Computer Electronics Center

Sub-Total Item: 202 $65.00

CLOCK 1.00-06/21/02 10.000 EA 00011400 000200 CompuPart Computer Services

Sub-Total Item: CLOCK $1.00-

DISPLAY 90.00 03/24/06 1.000 EA 00022100 000100 Computer Electronics Center

Sub-Total Item: DISPLAY $90.00

FLC1 9.00-09/18/00 20.000 EA 00007100 000100 Computer Electronics Center

Sub-Total Item: FLC1 $9.00-

FLC2 18.00-09/18/00 30.000 EA 00007100 000100 Computer Electronics Center

Sub-Total Item: FLC2 $18.00-

FLC3 21.00-09/18/00 30.000 EA 00007100 000100 Computer Electronics Center

Sub-Total Item: FLC3 $21.00-

FLC4 54.00-09/18/00 30.000 EA 00007100 000100 Computer Electronics Center

Sub-Total Item: FLC4 $54.00-

Sub-Total Acct: 04230-00000-000 Amt: $52.01

Grand Total Amt: $52.01

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:

A/P Inventory Value Report Entry Screen

The following options are available:

* After pressing 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.

Screens

A/P Inventory Value Report

Run Date: Jan 8, 2008 - 4:03pm Electronics - RSS(96) Page 1

A / P I N V E N T O R Y V A L U E D E T A I L R E P O R T

Inventory Qty As of 01/08/08 Include Obsolete Items

Printed In Item Number Sequence Show Mfg Mfg Item PO & Prod Dtl Only

From Item 101 Thru 202 Show Mfg Purch Items Purch Detl Only

For All Categories Show Purchase Items Purch Detl Only

Material Cost Type: All

Buyer Code : All

Minimum Variance % All

Minimum Variance Value All Positive Variance Means Favorable

Minimum Inventory Value All Negative Variance Means Un-Favorable

Item No/Desc Avg-Cost Quantity Invt-Value Cat M By

PO/Doc-# Ln# Inv/Rcvd Inv-No Check# Quantity Recv-Cst Rcv-Ext-Cst Std-PPV AP-Cst AP-Ext-Cst Purch-PPV Total-PPV

101 11.4371 963.00 11,013.93 1 1

Testing

Balance 963.00 11.43 11,013.93 11,013.93 .00 .00

Item 101 Ttl 11,013.93 11,013.93 11,013.93 .00 .00

------------------------------------------------------------------------------------------------------------------------------------

123 .0000 42.00 .00 FG 1

rachel test

Balance 42.00 .00 .00 .00 .00 .00

Item 123 Ttl .00 .00 .00 .00 .00

------------------------------------------------------------------------------------------------------------------------------------

202 9.9263 2064.00 20,487.88 C 1

Box 1 TTTTTTTTTTTTTTTTTTTTTTTN

Balance 2,064.00 9.92 20,487.88 20,487.88 .00 .00

Item 202 Ttl 20,487.88 20,487.88 20,487.88 .00 .00

------------------------------------------------------------------------------------------------------------------------------------

Grand Total 31,501.81 31,501.81 31,501.81 .00 .00

Variance% 0.00% 0.00%

Rounded .00 .00

Total No. Of Item Checked 3