E-WMS

WMS Bartender integration: mandatory fields and samples for all processes

Pick-IT

Introduction

BarTender is a bar code label design and printing solution by Seagull Scientific. BarTender can be used as stand-alone application to create bar code labels, but E-WMS also offers integration with BarTender. This allows you to automatically print bar code labels in specific steps of the E-WMS process, like Receipts or Sales Order Fulfillment. E-WMS supports two ways of integration with BarTender.

Please see this document for the requirements for using BarTender with E-WMS.

To use this BarTender integration, you will need to create SQL views. This document describes the mandatory fields for these views and provides sample views and labels.

Description

You will need SQL views to set up the BarTender integration in E-WMS. This view is used by E-WMS (to check for records and fields) and must be used in the BarTender lay-out itself when using the BarTender 'client' method. The view name must also be entered in the E-WMS label configuration in menu System, E-WMS, Labels.

The sample views and labels referred to, can be obtained from this link.

Document BarTender - configuring a BarTender lay-out for your own environment shows how to update server, database and printer in existing BarTender layouts.

Main process	Process step	Mandatory fields in view	Base tables	View + label name

Receipts	Send to scanner	PurchaseOrderNumber Warehouse CSPickITTransactionGUID	Orsrg, Orkrg	eWMSReceiptsSend
	Read back	PurchaseOrderNumber CSPickITTransactionGUID	Orsrg, Orkrg csPickitOrsrg	eWMSReceiptsReadback
	Validate	PurchaseOrderNumber Warehouse CSPickITTransactionGUID	Orsrg, Orkrg csPickitOrsrg	eWMSReceiptsValidate
	Process	PurchaseOrderNumber Warehouse CSPickITTransactionGUID	Orsrg, Orkrg csPickitOrsrg	eWMSReceiptsProcess

Sales Order Fulfillment	Send to scanner	SalesOrderNumber Warehouse csPickitTransactionGuid	Orsrg, Orkrg	eWMSFulfillmentSend
	Read back	SalesOrderNumber csPickitTransactionGuid	Orsrg, Orkrg csPickitOrsrg	eWMSFulfillmentReadback
	Validate	SalesOrderNumber Warehouse csPickitTransactionGuid	Orsrg, Orkrg csPickitOrsrg	eWMSFulfillmentValidate
	Process	Warehouse csPickitTransactionGuid	Orsrg, Orkrg csPickitOrsrg	eWMSFulfillmentProcess

Transfers	Read back	TransferID WarehouseFrom	csPickitTransfers csPickitTransferLines csPickitTransferSB	eWMSTransfersReadback
	Validate	TransferID	csPickitTransfers csPickitTransferLines csPickitTransferSB	eWMSTransfersValidate
	Process	PickitStatus TransferID	csPickitTransfers csPickitTransferLines csPickitTransferSB	eWMSTransfersProcess

Inventory/Counts	Send to scanner	several (see view)	csPickitCounts csPickitCountsSB	eWMSCountsSend
	Read back	several (see view)	csPickitCounts csPickitCountsSB	eWMSCountsReadback
	Compare	several (see view)	csPickitCounts csPickitCountsSB	eWMSCountsCompare
	Process	several (see view)	csPickitCounts csPickitCountsSB	eWMSCountsProcess

Stock Transactions	Read back	PickITStatus CountRangeID	csPickitCounts csPickitCountsSB	eWMSStocktransReadback
	Validate	PickITStatus CountRangeID	csPickitCounts csPickitCountsSB	eWMSStockTransValidate
	Process	PickITStatus CountRangeID	csPickitCounts csPickitCountsSB	eWMSStockTransProcess

Sales Entry	Read back	SalesOrderNumber	Orsrg, Orkrg	eMobileSalesReadback

Purchase Entry	Read back	PurchaseOrdernumber	Orsrg, Orkrg	eWMSPurchaseEntryReadback

Replenishment	Send to scanner	WarehouseFrom WarehouseTo Itemcode TransferID	csPickitTransfers csPickitTransferLines csPickitTransferSB	eWMSReplenishmentSend
	Read back	TransferID	csPickitTransfers csPickitTransferLines csPickitTransferSB	eWMSReplenishmentReadback
	Validate	WarehouseFrom WarehouseTo TransferID	csPickitTransfers csPickitTransferLines csPickitTransferSB	eWMSReplenishmentValidate
	Process	WarehouseFrom WarehouseTo TransferID	csPickitTransfers csPickitTransferLines csPickitTransferSB	eWMSReplenishmentProcess

Production Issues	Send to scanner	ProductionOrderNumber Warehouse	csPickitGbkmut Gbkmut	eWMSProdIssuesSend
	Read back	ProductionOrderNumber Warehouse	csPickitGbkmut csPickitGbkmutEx Gbkmut	eWMSProdIssuesReadback
	Validate	ProductionOrderNumber Warehouse	csPickitGbkmut csPickitGbkmutEx Gbkmut	eWMSProdIssuesValidate
	Process	ProductionOrderNumber Warehouse	csPickitGbkmut csPickitGbkmutEx Gbkmut	eWMSProdIssuesProcess

Production Receipts	Read back	ProductionOrderNumber	csPickitGbkmut csPickitGbkmutEx Gbkmut	eWMSProdReceiptsReadback
	Validate	ProductionOrderNumber	csPickitGbkmut csPickitGbkmutEx Gbkmut	eWMSProdReceiptsValidate
	Process	ProductionOrderNumber	csPickitGbkmut csPickitGbkmutEx Gbkmut	eWMSProdReceiptsProcess

Autopack	Shipment	ShipmentSSCC DeliveryDebtor TransactionGUID	csPickitLabelprinting	eWMSAutopackShipment
	Pallet (SSCC)	ShipmentSSCC DeliveryDebtor TransactionGUID	csPickitLabelprinting csPickitOrsrg	eWMSAutopackPallet
	Box (inner SSCC)	ShipmentSSCC DeliveryDebtor TransactionGUID	csPickitLabelprinting csPickitOrsrg	eWMSAutopackBox

SSCC label printing from hand terminal (generated SSCC)	Shipment	ShipmentSSCC DeliveryDebtor TransactionGUID SSCCNumber	csPickitLabelprinting	eWMSHTShipment
	Pallet (SSCC)	ShipmentSSCC DeliveryDebtor TransactionGUID SSCCNumber	csPickitLabelprinting	eWMSHTPallet
	Box (inner SSCC)	ShipmentSSCC DeliveryDebtor TransactionGUID SSCCNumber	csPickitLabelprinting	eWMSHTBox

SKU Label printing from hand terminal	SKU - Handheld: outer (pallet)	TransactionGUID	csPickitSKUmaster	eWMSKUouter
	SKU - Handheld: inner (box)	TransactionGUID	csPickitSKUmaster	eWMSKUinner

Serial/Batch Generation from hand terminal	S/B hand terminal: batch item	TransactionGUID	csPickitLabelPrinting, ItemNumbers	eWMS_SB_Batch
	S/B hand terminal: serial nr item	TransactionGUID	csPickitLabelPrinting, ItemNumbers	eWMS_SB_Serial

WMS Bartender integration: mandatory fields and samples for all processes

Introduction

Description

Related documents