Home > Reports > Screen Shots/Explanations > Access Interface Report

Access Interface Report

What Is It?

The Access Interface takes the raw data from within the system, for example dept sales, stock movements, goods receipts and so on, and exports them into csv files suitable for entry into the Access third party system. See Access Interface Report Format for more information.

Commands

Client - REQUESTREPORTEOD.EXE ACCESSINTERFACE

Server - REPORTEOD.EXE

What Are The Report Parameters?

Location

Transactions will be extracted for the selected location. If this is a group, all locations within the group will be extracted.

Update Data As Processed 

When you run the report, it will show all data since the last time the data was extracted. If this flag is checked on, it tells the system that the data has been definitely extracted. Next time the report is run, it will use this as the starting point to get the next set of data. You might run the report once with this option checked off so you can check the data, then you would run it again with the option checked on to finalise the data.

From Date/To Date

The report keeps track of internal counters to ensure it gets all data since the last extract. This is the most efficient means of ensuring all data is extracted properly. However, if you want to run the report for a previous date range for auditing purposes, you have to use these options. If you leave these dates empty, the report runs in its normal mode, that is it uses the internal counters to determine the new data. If you enter the dates it ignores the counters and uses the dates to extract the data.

Note: Because the selection criteria used for data extraction are different, there is a very slight possibility that different results may occur. This is highly unlikely but you should be aware the possibility exists.

Paper Requirements

This report prints on A4 paper in Landscape mode.

Sample Report

Figure: Example Access Interface Report

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)