One moment please...
 
E-WMS   
 

Troubleshooting ICL: Control Center selections

 

Introduction

This document lists the basic selections that are done when starting the ICL control centers, to help explain why transactions cannot be exported in a specific situation.

 

Description

This document contains following sections:

Sales database:

Purchase database:

Central database:

 

ICL Export Orders (sales database)

Menu: Order/To be processed/ICL Sales admin/export sales orders.

For used SQL query, see document 19.673.914 - selection for 'export sales orders'

 

Basic selection for showing orders to be exported:

  • SO line warehouse is an ICL warehouse
  • SO approved (orkrg.fiattering)
  • SO line item is 'sales' or 'text' item (orsrg.ar_soort=T or V) and not a phantom item (items.type<>P)
  • Planned fulfillment or return (gbkmut.transtype=B and gbkmut.transsubtype=B or H)
  • Gbkmut budget line (B) validations: gbkmut.freefield1=V, gbkmut.blockitem=0,  gbkmut.checked=1 (SO approved)
  • SO line delivery date less or equal to Control Center delivery date selection
  • SO order date less or equal Control Center order date selection
  • SO line warehouse not blocked
  • SO line ICL status  (orsrg.CSPickITCWStatusSalesDB) = NULL or 1  (1 means "to send")
  • SO status (orkrg.status) = V
  • SO is type 'sales' (orkrg.ord_soort=V)
  • SO is not completed (orkrg.afgehandld=0)
  • SO line not fulfilled (orsrg.uitgifte=0)


Additional checks after starting export of specific order:

  • SO line delivery date < ICL warehouse date filter (magaz.CSPickITCWExportFilterDate; make sure this date setting is in the future, for instance 31-12-2299)
  • target warehouse in central is not blank (magaz.CSPickITCWWarehouseInCWDB <> '')
  • number of days between 'today' and SO line delivery date does not exceed ICL warehouse day filter (magaz.CSPickITCWExportFilterDays, set this setting to '999')
  • item type is sales, text or discontinued (V,T,N)
  • SO line ICL status  (orsrg.CSPickITCWStatusSalesDB) = NULL,1,2 or 3

ICL process orders ('sales' database)

Menu: Order/To be processed/ICL Sales admin/Process sales orders.

For used SQL query: see doc 21.793.418 - selection for 'Process orders' in sales database

 

Basic selection to show list of orders which can be processed:

  • warehouse: as selected in Control Center
  • warehouse not blocked
  • transactions are Gbkmut fulfillments or returns
  • planned delivery date (Gbkmut.afldat) matches (or is before) selected date in control center
  • status of sales order is correct (Gbkmut checked=1 and blockitem=0, can be repaired with Globe Diagnose/Logistics)
  • order confirmation printed, or not required
  • order authorized, or authorization not required
  • ICL status of orderline is correct (orsrg.csPickitStatus = 5)
  • orkrg.status = V   (free)
  • order not fulfilled or completed yet in sales database (orkrg.afgehandld = 0)
  • order line not fulfilled yet (orsrg.uitgifte = 0)
  • item is a standard item (items.type<>'P')
  • quantity ordered <> 0  (orsrg.esr_aantal <> 0)
  • order is or right type (sales order, orkrg.ord_soort = V, P, N or I)
  • order debtor has right status (not blocked, not status E or B)
  • invoice debtor has right status (not blocked, not status E or B)

Other checks done after pressing Process in Control Center:

  • warehouse <> TRAN

 

ICL export orders (purchase database)

Menu: Purchase/To be processed/ICL Purchase admin/Export purchase orders.

For used SQL query, see document 19.585.178 - selection for 'export purchase orders'


Basic selection for showing PO's to be exported:

  • warehouse is not a ICL (order/order) warehouse
  • supplier in PO is an ICL supplier
  • PO order date >= ICL supplier 'start date' (supplier ICL settings)
  • item is not a phantom item
  • warehouse is not blocked
  • PO line ICL status (orsrg.CSPickITCWStatusSalesDB) is NULL or '1'
  • PO is approved or does not need approval
  • PO is 'processed' (printed final)
  • PO status (orkrg.status) = 'V' (free, 'old' functionality ?)


Checked later, while exporting selected PO:

  • PO does not have status 'completed' (orkrg.afgehandld = 0)
  • Order is of type 'B' (standard PO)
  • item is a 'sales' item (not an 'internal' item)
  • item is linked to the ICL supplier (main supplier)
  • no receipts yet on line level (orsrg.uitgifte = 0)
  • item is of type V, T or N (sales, text or inactive)
  • PO line ICL status (orsrg.CSPickITCWStatusSalesDB) is NULL or 1 or 2 or 3
 

ICL Purchase 'process receipts'

Menu: Purchase/To be processed/ICL Purchase admin/Process purchase orders.

Basic selection to show PO's to be processed:

  • PO line planned fulfillment date matches fulfillment date selection in control center
  • Item is not of type 'Phantom' or 'Contract'
  • Warehouse in PO header is not blocked
  • PO is of type 'B' (orkrg.ord_soort)
  • PO is printed 'finally'
  • PO does not have status 'ready'
  • PO does not have result_type = 'rejected'
  • PO line status (orsrg.csPickitState) = 5
 

ICL export changes ('central' database)

Menu: order/To be processed/ICL Central Admin/Export changes

For SQL query used, see doc 19.674.143 - selection for 'Export changes'

Basic selection to show SO's to export changes for:

  • not a phantom item
  • invoice debtor is an ICL debtor
  • order type is sales order
  • originating from sales database (orkrg.CSPickITCWSysGUIDSalesDB <> NULL)
  • order line 'changed' status is NULL or G: ISNULL(orsrg.CSPickITCWStatusCWDB, 'G') = 'G'  (G means 'modified')
  • order date and delivery date selection meet the Control Center criteria

Additional selection while starting export of specific changes:

  • item type (orsrg.ar_soort) is V,T,I,N 
  • order line status: orsrg.CSPickITCWStatusCWDB is NULL, W or G
 

ICL Export delivery notes ('central' database)

Menu: Order/To be processed/ICL Central Admin/Export delivery notes

SQL statement: see doc 19.674.298 - selection for Export Fulfillment

Basic selection to show delivery notes to be exported:

  • invoice debtor is an ICL debtor
  • item is not a phantom item
  • gbkmut.CSPickITCWDeliveryNoteCWDB was filled during the fulfillment process (standard SDK 'hook' when CW active)
  • gbkmut.CSPickITCWOrsrgIDCWDB was filled during the fulfillment process (standard SDK 'hook' when CW active)
  • order originates from sales database (orkrg.CSPickITCWSysGUIDSalesDB <> NULL)
  • order is a sales order (orkrg.ord_soort=V)
  • order line 'changed' status is NULL, G or W (orsrg.CSPickITCWStatusCWDB)
  • order dates meet selected dates in Control Center

 

ICL EXPORT INVOICES ('central' database)

Menu: Order/To be processed/ICL Central Admin/Export Invoices

SQL statement: see doc 19.674.335 - selection for 'Export Invoices'

Basic selection used to show sales invoices to be exported:

  • invoice line is based on order line
  • invoice debtor is an ICL debtor
  • order line status is 'fulfilled' (orsrg.CSPickITCWStatusCWDB=D)
  • order is standard sales order (orkrg.ord_soort=V)
  • order originates from sales database (orkrg.CSPickITCWSysGUIDSalesDB <> NULL)
  • invoice was not exported before (when 'send again' is off) (frhkrg.CSPickITCWStatusCWDB is NULL)
  • invoice date meets Control Center selection

 

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: temporary  Document ID: 19.584.979
 Assortment: E-WMS  Date: 21-07-2011
 Release:  Attachment:
 Disclaimer