International Consignment Warehouse Sales Transactions

Data receipt

 Data files are pushed to IPS Jackson Finance by the International Consignment Warehouse partner for sales transactions in the previous calendar month.

Timing > Data is pushed between the 1^st and 7^th business day of the subsequent month depending on the partner.

Exceptions

• GBS data files are pulled from the partner portal. Data files are available in the 1^st day of the subsequent month.
• PGC transactions date range runs from the 28^th day for the previous month to the 27^th day of the current month. The data file is pushed on or around the 28^th day of the current month for posting during the current month.

Data submission

The intake gatekeeper will drop the files to VendorLink via a submission page in the Consignment Warehouse application.

VendorLink is configured with mapping specifications needed to transform the partners data into the standard format required by the Ingram systems.

The data is validated and made visible in the Consignment Warehouse application.  Transactions for IPS invalid EANS are tagging as invalid and held for user action.

Timing > Files may be submitted to the Consignment Warehouse application at the discretion of the intake gatekeeper.  All partner files should be submitted by the 10^th business day of the subsequent month.

Exception

• PGC data files must be submitted during the current month.

Validate and Release Sales Transactions

 Sales transactions from data loaded are visible to the Consignment Warehouse application user showing a state of “unreleased”.  The application also shows column totals for validation.

Once validation is complete, the user will “release” the data to flow for distribution.  The transactions are identified in chunks by partner and month.

Note that the Consignment Warehouse application user is the same person as the Intake Gatekeeper.

Timing > Sales transaction are released at the discretion of the user.  The sales transactions should be released by the 10^th business day of the subsequent month.

Exceptions

• PGC sales transactions must be released during the current month.

Publication

 Released sales transactions and inventory information for all partners are published for downstream distribution on the same day. 

Timing > The Consignment Warehouse application user will Publication of all released sales transactions and inventory reconciliations by the 12^th business day of the month.

Exception

• PGC sales transactions are published separately during the current month.

Downstream Distribution

 Once published, sales transactions will flow to the ODS data repository making the transactions available to iQ reporting, publisher feeds, and client statements.

Exception

• Sales transactions for the following partners do not flow to client statements.
  • Wiley - UK
  • Amazon Advantage - UK
  • Footprint – Australia
  • MHM – Japan
  • APD – Singapore