Generating Syndication Invoices (MSYN)

Purpose: Use the Generate Syndication Invoices program to extract all JC Penney and Spiegel invoices from the CWDirect Invoice file and create separate JC Penney and Spiegel Invoice files.

The system checks the Source Cross Reference file to determine which orders are associated with JC Penney and Spiegel, based on the source code on the order. Only Invoice records with a JC Penney or Spiegel source code (identified by a P or S in the Syn field in the Source Cross Reference file) are extracted by this program.

In this topic:

• Generate Syndicate Invoices Screen

• Creating the JC Penney Invoice File

• Creating the Spiegel Invoice File

For more information:

• Overview of the JC Penney Interface

• Overview of the Spiegel Interface

Generate Syndicate Invoices Screen

How to display this screen: Enter MSYN in the Fast Path field at the top of any menu or select the Generate Syndication Invoices option from a menu.

See Creating the JC Penney Invoice File and Creating the Spiegel Invoice File.

PTR0017 ENTER Generate Syndication Invoices 1/04/95 9:11:08 CommercialWare A batch job will be submitted to create syndication invoice records for JC Penney and Spiegel. Only orders invoiced since the last extraction will be selected. Press Enter to submit job. F3=Exit F12=Cancel

Creating the JC Penney Invoice File

Results: When you complete the Generate Syndicate Invoices Screen:

• a consolidated invoice (consisting of 1,000 invoices) is created and sent to JC Penney

• Order Cross Reference records are created to identify the CWDirect order number and associated JC Penney order number. The system assigns the next sequential (5-digit) order number, based on the current value in the Last# field in for the Order Cross Reference counter in the Number Assignment file.

• Invoice Cross Reference records are created to identify the CWDirect invoice number and associated JC Penney invoice number. The system assigns the next sequential invoice number, based on the current value in the Last# field for the Invoice Cross Reference counter in the Number Assignment file.

• an open item Accounts Receivable record is created for each JC Penney invoice, using JC Penney as the bill-to account. A user-supplied program loads the debit General Ledger account number from the Pay Type record to the open item record; it is against this account number that payment will be posted.

Creating the Spiegel Invoice File

Results: When you complete the Generate Syndicate Invoices Screen:

• Petals will send the invoice file or a report to Spiegel

• the invoice file is sorted by pay type (including Spiegel, cash, credit card, and other pay types)

• Order Cross Reference records are created to identify the CWDirect order number and associated Spiegel order number. The system assigns the next sequential (5-digit) order number, based on the current value in the Last# field in for the Order Cross Reference counter in the Number Assignment file.

• Invoice Cross Reference records are created to identify the CWDirect invoice number and associated Spiegel invoice number. The system assigns the next sequential invoice number, based on the current value in the Last# field for the Invoice Cross Reference counter in the Number Assignment file.

• an open item Accounts Receivable record is created for each Spiegel invoice, using Spiegel as the bill-to account. A user-supplied program loads the debit General Ledger account number from the Pay Type record to the open item record; it is against this account number that payment will be posted. The open item record will be the amount that Spiegel owes Petals (minus the commission %). Open item records are created only for orders that were purchased with a Spiegel charge card.