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:
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:
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:
Here we can filter Multi-Bins starting with "XX" or a list of starting codes "XX,XX,XX"
For example this would give:
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 |