Accounts Payable APDISSCN Help - Elliott Business Software



AP Distribution History Report

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                                                                                    

 



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile