The following SQL queries are available to run in management studio or serve as a basis in Info Maker for Portals or Crystal Reports.

Accounts Payable

• Vendors with Wrong Payable G/L Number
• Discounts Posted to Accounts Payable G/L Account in Error
• A/P G/L posting used in A/P Voucher Line
• Vouchers with Terms G/L equal to A/P
• Voucher A/P Account Number Wrong

Inventory Receipts Clearing

• Reversed Voucher Listing
• Manual Vouchers using IRC general ledger number
• Review of Non Auto Posted Journals

Accounts Receivable

• Customers with Wrong General Ledger Number
• Invoices with Wrong G/L for A/R account
• Customer Credit Query

General Ledger

• Chart of Accounts
• Journal Entry Reversal by Import

Inventory

• Inventory Item(s) with wrong asset G/L Account
• OCI Item with wrong asset G/L account
• Item with Qty on Hand - no moving average cost
• Items with Open Quantities and Unallocated
• Inventory Adjustment Reversal by Import

Price Service

• Price Service price fields for update

Sales Tax

• Unassigned Tax Group to shipto
• Unassigned Tax Group to Item
• Unassigned Tax Group to Freight Code
• Unassigned Tax Group to Location

System

• P21 Users Logged On

Stritar  >>> Jeff >>> Career >>> Epicor >>> Tools >>> AC  >>>  Query                                Updated: January 14, 2016