Postcode Programming API  PostTrans XL Visual Importer: Stock Take in Exchequer Enterprise


This is only available in the Professional version of PostTrans

This PostTrans spreadsheet allows the user to easily perform a complex Stock take in Exchequer Enterprise.   It uses a series of tags, placed in row 1, to identify the data to be Amended by the Stock take.   These tags can be easily added to a spreadsheet using the [Design] button, on the PostTrans Toolbar.  The data is read from row 3 onwards, which allows you to put user descriptions in row 2.  More Information on Design and Tags.

  Demonstration Videos:


 
 
   Normal Stock Take
 
 

 
 
   Stock Take Multi-Bins
 
 

The "Stock Take" and "Bins Serial Batch" Example shows this in action.  more information on PostTrans examples


PostTrans XL Visual Importer: Stock Take Features:


Stock Data from Exchequer Enterprise to update Stock Take

To extract Stock data press [Update Lookups], on the PostTrans Toolbar, this will allow you to add criteria to the lookup:

Exchequer Enterprise Stock Take

Here we are going to stock take all stock in location "AAA".  We then press [Clear and Lookup Values] button to populate the spreadsheet with data Exchequer Enterprise Stock records.   

Post Trans will then allow additional criteria, used to filter Serial/Batch or Multi-Bins records:

Exchequer Enterprise Serail/Bin/Batch import

Here we can filter Multi-Bins starting with "XX" or a list of starting codes "XX,XX,XX" 

For example this would give:

Exchequer Enterprise Multi-Bins

Additional stock Serial/Batch and Multi-Bins items can be added to the sheet manually.

When the Free Stock figure has been adjusted the [Post Trans] button is pressed, which posts an stock adjustment to correct stock figure.

Stock Take Required fields

To Import/Extract/Amend Exchequer Enterprise Stock Data, the following Tags/Fields must be specified:

STKTakePosted

Cell A1 must equal

STStockCode is used to detect end of spreadsheet.  PostTrans will stop Importing/Amending, from row 3 onwards, when this field is empty.

Restrictions

Please note : It is up to the user to format Bin codes into correct format before posting into

Users should only edit the "STKTakeActualQty" column

Stock Take Adding Serial/Batch/Bins

Extra lines can be added to the spreadsheet to add Serial/Batch/Bins codes to stock, but the user must:

  • make sure the "STKTakeQtyFree" column is zero, since PostTrans is posting anything with a difference in stock qty
  • The "STStockCode" and "STLocationCode" is filled in
  • Fill in appropriate column for Serial/Batch/Bin number

Alternate Stock Code Database fields available for update:


The following Tags are used to identify the corresponding fields in Exchequer Enterprise.  Use the [Design] button (or Ctrl+Shift+D), on the PostTrans Toolbar, to access these tags.   Click here for more Information on Designing templates.

Tag Name

Data Type Length

Description

Required  (Prof version):

   

STKTakePosted

Yes/No

Returns 'POSTED' if Trans line has been posted and will be ignored if 'POSTED' (required)

SBPosted

Text

Used to track status of Serial/Bins/Batch Posting

ErrorDesc

Text

Description of error posted back if record unsuccessfully posted  (required)

STKTakeActualQty

Double

User enters Actual stock Bin Qty here, system then posts difference

Change this figure to adjust stock qty to Actual

STKTakeSystemQty

Double

Will write the Stock Take Bin Qty to this cell

STStockCode

Text 16

Stock identifier code (required)

STLocationCode

Text 3

Relates to Location record

STTakeType

Text 35

Stock Type Serial,Batch,Multi-Bin,Normal

STLastCostPrice

Double

The last cost price of Stock Item (Allowed to update from V6.1.22)

Information:    

STAltStockCode

Text 16

Optional code for stock searching

STParentStockCode

Text 16

Code of parent on tree (required)

STStockType

Text 1

G =Group,P =Product,D =Description,M =Bill of Materials,X =Discontinued (required)

STStockValType

Text 1

R =Serial/Batch,V=Serial/Batch Avg,C =Last Cost,L =LIFO,F =FIFO,S =Standard,A =Average (required)

STDesc1

Text 35

Stock description (required)

STDesc2

Text 35

Stock description 2

STDesc3

Text 35

Stock description 3

STDesc4

Text 35

Stock description 4

STDesc5

Text 35

Stock description 5

STDesc6

Text 35

Stock description 6

STQtyMin

Double

 

STQtyMax

Double

 

STDescStockingUnitQty

Text 10

Descriptive Stocking Unit Qty

STDescPurchaseQty

Text 10

Descriptive Purchase Unit Qty

STCostPriceCurrency

Byte

0-29,1=Sterling

STDepartment

Text 3

 

STCostCentre

Text 3

 

STSalesGLCode

Long Integer

Sales Nominal code (required)

STCostOfSalesGLCode

Long Integer

Cost of Sales Nominal code (required)

STBinLocation

Text 8

Location of Bin if multi-Location turned on

STSupplierCode

Text 6

Master supplier Ref.

STPORCurrency

Byte

POR Currency, 0-29,1=Sterling

STPORCostPrice

Double

POR Cost Price

STBarCode

Text 20

 

STReOderCostCentre

Text 3

 

STReOrderDepartment

Text 3

 

STUser1

Text 20

User defined field 1

STUser2

Text 20

User defined field 2

STUser3

Text 30

User defined field 3

STUser4

Text 30

User defined field 4

STLastUsed

Date

 

STWebPrevCat

Text 20

 

STSSDCountry

Text 5

Intrastat value fill in if turned on

Serial/Batch/Multi-Bin (Prof version):

 

 

SBBinCodeList

Text List

Serial

BinSellByDateList

Date List

Date list, comma delimited.   Updated only on new records

BinPickPriorityList

Text List

Picking Priority list, comma delimited.   Updated only on new records

BinTagNoList

Text List

Tag no of item list, comma delimited.   Updated only on new records

BinUOM

Text 10

Unit of measure text of all bins.   Updated only on new records

BinAutoPickMode

Integer

Default 0,Lock Bin 1, Quarantine Bin 2, Tag no 3, of all bins.   Updated only on new records

BinCapacityList

Double List

Capacity of Bin List, if not specified = 0.   Updated only on new records

Line Serial/Batch (Prof version):

 

 

SBSellByDate

Date

Sell by date of all Serial/Batch entries.   Updated only on new records

SBBinNo

Text 10

Bin number on Serial/Batch record.   Updated only on new records