Many QAD environments involve some level of integration with other systems as part of the implementation. At a recent Food and Beverage client, this involved several interfaces to the General Ledger. Some examples of this external data are Employee T & E data, UPS Invoices, Employee Benefit information, Payroll data and Procurement Card data. At this client, we developed an interface that was very flexible but still creates a standard process that could be used for all interface data. The functions developed include the following:• A GL Cross reference module to map source data to the QAD chart of accounts.• An Import Module that processes the source data file into a custom interface table, cross references the GL accounts and validates the data.• A maintenance program that allows manipulation of the interface data, clearing of errors and reprocessing of error data.• Error Reporting.• A Journal Entry CIM Load program to create GL transactions from the interface data.A custom import map that is used by the...

I was recently involved in a client project to upgrade to QAD eB2.1. Part of this upgrade was the integration to two separate business units into a single database with one domain. One business unit was a “Corporate” entity which was the primary supplier to the other “Retail” business unit. One of the challenges in this integration was that while a single domain adds the convenience sharing part numbers, it also lends itself to exposing other data. Item costs were one of the pieces of data that could not be shared. The securing of this data was handled through a combination of Menu Security, Site Security, Entity Security, and customization. An analysis of QAD menus that would be used by each business unit was done and they were divided into the following categories:• Programs that were only used at Corporate.• Programs that already used Site or Entity Security.• Programs that used Site or Entity in the selection criteria but did not invoke Security.• Programs that do not include Site or Entity in the selection...

What is the Definition of Named Users vs Concurrent Users?