Generating the Point of Sale Download File (GGPD)
Purpose: You can use the P.O.S. Download file to transfer invoice information for store replenishment orders to the GERS P.O.S. system.
The P.O.S. Download file can be produced in two ways:
• enter a date and select F9 on the Generate GERS P.O.S. Download File Screen (fast path = GGPD).
• run the periodic function Generate GPD POS Download. In order to set up this periodic function, use the function name GGPDDN and the program name OER1091. See Work with Periodic Functions Screen.
When you select to generate the P.O.S. Download file, the system:
• includes invoice information for orders that contain the salesman number defined in the Salesrep Number to Use in P.O.S. Download File (F82), system control value only.
• selects CWDirect invoices:
• that contain an Invoice ship to date that is less than or equal to the entered date, and
• that contain an Invoice processed date in the Invoice Header file that is blank
• writes individual records to the P.O.S. Download file. If records already exist in this file, the system adds the new records to the existing file.
• updates the Invoice posted date with the date the P.O.S. Download file was generated. In order for the system to update this date, the Update Invoice File with System Date During Billing (D51) system control value must be set to N.
In this topic:
• Generate GERS P.O.S. Download File Screen
• P.O.S. Download File (IXGPOS)
Generate GERS P.O.S. Download File Screen
How to display this screen: Enter GGPD in the Fast path field at the top of any menu or select Generate GPD P.O.S. Download from a menu.
OER1087 ENTER Generate GERS P.O.S. Download file 9/28/98 9:36:41 The KL Mail Order Company
Date: 92898
F3=Exit F9=Submit F12=Cancel |
Field |
Description |
The date the system uses to write invoice information to the GERS P.O.S. Download file. The system selects invoices that are less than or equal to the date you enter. Numeric, 6 positions (MMDDYY format); required. |
GERS Field Name |
GERS Attributes |
CWDirect Attributes |
Field Description |
Company |
Alphanumeric, 3 positions |
Numeric, 3 positions |
The CWDirect company code where the P.O.S. Download file was generated. This is a key field. |
Invoice Number |
Alphanumeric, 20 positions |
Numeric, 7 positions |
The invoice number associated with the store replenishment order. This is a key field. |
Record Type |
Alphanumeric, 1 position |
Alphanumeric, 1 position |
Indicates whether this record includes invoice header or invoice detail information. Valid values are: H = Invoice header information. D = Invoice Detail information. This is a key field. |
Sequence # |
Numeric, 3 positions |
Numeric, 3 positions |
The sequence number for the invoice detail record, starting with 1. The system displays a sequence number of 0 for invoice header records. This is a key field. |
VE CD |
Alphanumeric, 6 positions |
Alphanumeric, 6 positions |
01 displays for invoice header records. |
Fact CD |
Alphanumeric, 6 positions |
Alphanumeric, 6 positions |
01 displays for invoice header records. |
Employee Initials |
Alphanumeric, 8 positions |
Alphanumeric, 8 positions |
01 displays for invoice header records. |
Hold Payment |
Alphanumeric, 1 position |
Alphanumeric, 1 position |
N displays for invoice header records. This field displays blank for invoice detail records. |
Priority |
Numeric, 1 position |
Numeric, 1 position |
9 displays for invoice header records. 0 displays for invoice detail records. |
Invoice date |
Numeric, 7 positions (CYYMMDD format) |
Numeric, 7 positions (CYYMMDD format) |
The date the invoice was created in CWDirect. This date is pulled from the CWDirect Invoice Ship To file. The invoice date only displays for invoice header records. 0 displays for invoice detail records. |
Discount Amount |
Numeric, 13 positions with a 2-place decimal |
Numeric, 13 positions with a 2-place decimal |
0 displays for invoice header and invoice detail records. |
Inv Merchandise Code |
Alphanumeric, 3 positions |
Alphanumeric, 3 positions |
MER displays for invoice header records. This field displays blank for invoice detail records. |
Prepay Invoice |
Alphanumeric, 1 position |
Alphanumeric, 1 position |
N displays for invoice header records. This field displays blank for invoice detail records. |
Paid in Full |
Alphanumeric, 1 position |
Alphanumeric, 1 position |
N displays for invoice header records. This field displays blank for invoice detail records. |
Invoice Amount |
Numeric, 13 positions with a 2-place decimal |
Numeric, 13 positions with a 2-place decimal |
The total amount for this invoice. The total invoice amount is pulled from the Invoice Ship To file. The invoice amount only displays for invoice header records. 0 displays for invoice detail records. |
Invoice 1099 |
Alphanumeric, 1 position |
Alphanumeric, 1 position |
N displays for invoice header records. This field displays blank for invoice detail records. |
Enter Date |
Numeric, 9 positions (DDDMMYYYY format) |
Numeric, 9 positions (DDDMMYYYY format) |
GERS populates this field. |
Due Date |
Numeric, 9 positions (DDDMMYYYY format) |
Numeric, 9 positions (DDDMMYYYY format) |
GERS populates this field. |
Item/SKU |
Alphanumeric, 12 positions |
Alphanumeric, 12 positions |
The first 5 positions of the item number and the first 4 positions of the SKU + 01 displays for invoice detail records. This field displays blank for invoice header records. |
Item Cost |
Numeric, 10 positions with a 2-place decimal |
Numeric, 10 positions with a 2-place decimal |
The average cost for the item displays for invoice detail records. The system performs the following calculation to determine the cost: cost (from the Invoice Detail file) / number of units = item cost. This field displays blank for invoice header records. |
PO Number |
Numeric, 5 positions |
Numeric, 5 positions |
The first 5 positions of the purchase order number defined for the store replenishment order displays for invoice header records. This field displays blank for invoice detail records. |
| General Ledger Download Audit Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Generating the GERS Item Download File (GGID) |
SO02_10 CWDirect 18.0.x 2018 OTN