CDEX Check Stub Transfer to Revenue - CDX220

This program creates Gross Sales Ledger (GSL) and Batch Master items for data received from the CDEX Check Stub Exchange service. You can also use it to print a report related to the transfer to Gross Sales, WITHOUT creating any Gross Sales items.

When you process this program in 'T'ransfer mode, the program first checks for a Revenue Cash Clearing account, as set up for this company in Revenue A/R System Setup (RAR295). If one is defined and valid, then all Revenue Batches created here require posting (using REV171). Thereafter, it determines the correct Excalibur Purchaser Property Master (PPM) item to use for a CDEX Transaction. Each PPM product has a Cash Basis flag, either 'Y' or 'N' (or null).

After the program extracts the CDEX Product Code from the incoming file, it translates to the Excalibur Product Master file item as follows:

It translates directly using the GE.PRODUCT.CODES file, which has exactly one Excalibur product assigned as the standard translation. If the translated product is not on the PPM item, then the search continues.
If step (a) fails, then the program inspects the GE.COMPANY.CODES item for an exception product for this purchaser. If the CDEX product code exists as an exception, the program takes its associated Excalibur product code and searches the PPM item for that product.
The search through the list of exception products continues until an acceptable product is found or the list is exhausted. The search is top-down; that is, as soon as the program finds a usable product, the search stops. If an exception product is used, (and if its cash basis flag is 'Y'), then the program prints a warning message, "USED EXCEPTION PRODUCT xx".

If you are using Cash Clearing and the product has a Cash Basis flag of 'Y', then CDX220 creates a normal GSL. If you are using Cash Clearing but the product's Cash Basis flag is NOT 'Y', then the GSL created is a shell item (with status 'DE') that is deleted by REV171 after you post the batch.

If you are not using Cash Clearing and the product has a Cash Basis flag of 'Y', then CDX220 creates a normal GSL. If you are not using Cash Clearing and the product's Cash Basis flag is NOT 'Y', then the program ignores the data and prints a report of the items ignored.

The program prints two kinds of messages. This can be useful for finding and correcting any data deficiencies before you perform the transfer. Error messages, those prefixed with "*ERR*", outline problems which MUST be corrected before you process the program in 'T'ransfer mode. After you make data corrections in Revenue, rerun this program in 'E'rror mode and proofread the results. Warning messages outline potential problems which should be verified before proceeding with the Revenue Gross Sales Distribution (REV180). If the calculated amount due is less than five percent, or 15 cents of the amount received, then the calculated amount is made equal to the amount received.

If you run this process in 'T'ransfer mode and there are line items with *ERR* messages, then the program does not create GSLs for those line items. You must either enter the GSLs manually via Gross Sales Data Entry (REV170) or correct the component batch total in Revenue Batch Control Maintenance(REV172). The program flags the untransferred line items as errors and you cannot reprocess them.

In 'T'ransfer mode, the program prints an asterisk on a detail line that represents data transferred to Revenue. For each check transferred, the program prints the Revenue batch ID. The program totals the check detail, and also prints totals for items transferred and not transferred. This assists you in balancing cash.

This program applies the inflation factor on the product for all Purchaser Property Master items. When an inflation factor is used, this program prints an "I" in the column immediately after the product code.

You should print and verify the CDX215 (Transmitted Records Analysis) report prior to actually transferring this data to Revenue.

The process creates one GSL record for GE.CHECK.TRANSACTIONS with the same purchaser, property, sale date, and product. If transmitted data have the same purchaser, property, sale date, product, AND the same gross volume, gross severance tax, net value, then they are treated as continuations of one GSL item. That is, no break occurs.

You can modify any Gross Sales item created with this process in REV171 (Gross Sales Data Entry Function Processor). However, modifications should not be necessary if you checked the data transmission and it is error free.