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.

 



Accounts Payable

  1. AP0000 Accounts Payable Overview
  2. What Is The Difference Between Payment Date and Check Date during Print AP Check?
  3. How to Purge AP Distribution to GL Report
  4. DYO (Design Your Own) AP Laser Check Design
  5. How Can I Get a List of New Vendors Set Up Since a Certain Date?
  6. Why Doesn't the System Print the Bottom Stub on My Design-Your-Own AP Laser Check?
  7. System Period Control Does Not Apply to Recurring Transactions
  8. AP Check History Report That Includes Voided Check
  9. ERROR 035 on AP TEMP CHK File
  10. Feature - Voucher Criteria On Vendor Account Summary
  11. Feature - Voucher Reference on A/P Distribution to G/L Report
  12. Feature - A/P Simple Trx Processing
  13. AP01S4 Accounts Payable Vendor Audit Trail Report
  14. AP05S1 Accounts Payable A/P Open Item Report
  15. AP07S1 Accounts Payable Cash Requirements Report
  16. AP08S1 Accounts Payable Pre-Check Writing Report
  17. AP08S2 Accounts Payable Post A/P Checks
  18. AP08S4 Accounts Payable Void Checks After Posting
  19. AP10S1 Accounts Payable Check Reconciliation Report
  20. AP11S1 Accounts Payable Check History Report
  21. AP13S1 Accounts Payable Vendor History Report
  22. AP22S1 Accounts Payable Purge AP Open Item File
  23. AP0200 Accounts Payable Post AP Transactions
  24. AP0301 Accounts Payable Recurring Voucher Processing
  25. AP0302 Accounts Payable Post Recurring AP Transactions
  26. AP0400M Accounts Payable Vendor Account Inquiry
  27. AP0601 Accounts Payable Open Item Adjustment
  28. AP0800 Accounts Payable Payment Preparation
  29. AP0900 Accounts Payable AP Distribution to GL Report
  30. AP1001 Accounts Payable Check Reconciliation
  31. AP1200 Accounts Payable Vendor Analysis Report
  32. AP1400 Accounts Payable Job Distribution Report
  33. AP1500 Accounts Payable Job Analysis Report
  34. AP1600 Accounts Payable A/P Setup
  35. AP1701 Accounts Payable A/P Account File Maintenance
  36. AP1801 Accounts Payable FOB Code File Maintenance
  37. AP1901 Accounts Payable Ship Via Code File Maintenance
  38. AP2001 Accounts Payable Job Code File Maintenance
  39. AP2100 Accounts Payable Print/Create 1099 Forms
  40. AP2300 Accounts Payable Clear Vendor YTD Accumulators
  41. APDISSCN Accounts Payable Distribution History Report
  42. APINVIMS Accounts Payable Invoice Import Utility
  43. AP0100 Accounts Payable Vendor File Maintenance
  44. AP0202 Accounts Payable Transaction Processing
  45. FULLPAY Accounts Payable Reset Fully Paid Status
  46. Feature - Default Value For Create Variance Prompt
  47. Feature - Assign Next Manual Check Number in Computer Check Printing
  48. Feature - Added First Bank Export Format to Checks History Export
  49. I Forgot to Clear the AP Vendor Paid Accumulators at Year End
  50. What If I Do Not Run AP Manual Check Register?
  51. Feature - Add Ability to Include or Exclude by Vendor Type for AP Checks
  52. How to Find a Voided AP Check in Check History Report
  53. What Are the Impacts of Purging Accounts Payable Old Inactive Vendors?
  54. Feature - AP Check History CSV Creation
  55. AP Laser Check Layout
  56. How to Apply AP Credit to Voucher When Credit Is Greater Than Voucher Amount
  57. Feature - Add Amigo Support to Additional Transactional Files

Feedback and Knowledge Base