DE-A SQL Query/Export (Java Version)

 

Purpose of Program

Use this program to exract all or selective records and fields from data files to a disk file in CSV format.

General Program Operation

If you are familiar with SQL Queries and the Evo file and field names, you can simply compose a query and click Execute to run it.  The results will be displayed with an option to save to CSV file.

 

If you are not familiar with SQL, click Query Wizard.  You will first be prompted to select the file(s) you want to access.  Select the files and click Next.  For each file in the dropdown list, you will be presented with a list of fields within the file to select.  Select the desired fields for each file.  When finished with all the files, click Next.  You will then be able to link the files by a common field.  For example, if you selected the BKAPPO (Purchase Order Header) and BKAPPOL (Purchase Order Lines) files, they would be linked by the Purchase Order Number field.  if the field used to link is not one of the selected field, click Show All in the upper right corner to have all fields in the files displayed.  Finally, click Next and enter any desired filters.  Again, you can click Show All if you want to filter on a field not included in the result set.

 

Click Finish and you will be returned to the main screen with the Query constructed for you.  Click Execute.  The results will be displayed with an option to save to CSV file.   You can also save the Query for future use.

 

Click Default Queries to see a a list of predefined queries for reconciliation between inventory and GL and between the PO-i-F report and GL in the PO/RNI account.  The preset queries are:

 

GLPOINV - Identifies GL Transactions to the PO/RNI account from PO Invoicing (AP-C) that do not have corresponding line items in the PO Receiver file.

GLPORECPT - Identifies GL Transactions to the PO/RNI account from PO Receiving (PO-C) that do not have corresponding line items in the PO Receiver file.

Inv_Txn_no_GL -  Find Inventory Transaction entries with no corresponding GL entries

INVGL - Find GL Transaction entries to a specified inventory account with no corresponding Inventory Transaction

INVGLACCT - Find Inventory Transactions with associated GL Transactions not posting to the correct account based on item class and Location

Inventory_Non_Asset - Identify tangible inventory items posting to a GL Account that is not an Asset account

Non_Inventory_Asset - Identify non-tangible inventory items posting to an Asset GL Account