ComTek Accounts

Where Are we?

Full list of Exchequer Add-ons

Interactive Remote Support

Pay us by Credit Card

Remote Ordering Via PDA

Reps taking customer orders

IRIS Enterprise CRM Links

Master Link for Goldmine

Master Link for ACT

Prices, Download

Common Support Q/A

Enhanced TeleSales

Enhanced TeleSales

PostTrans, XL Importation

About PostTrans

Import Transactions

Stock take Batch/Multi-Bins

Import Customer/Suppliers

Import Stock

Import Price Matrix

Import Bill of Materials

Import Bank Rec

Import General Ledger

Import Price Matrix

Import Alternate Code DB

Order from Cheapest Supplier

Edit Line/Header in daybook

Enhanced Reordering

Prices, Installation, Download

Licensing, System Setup, Lookups

Common Support Q/A, Examples

XML importation

About PostTransXML

Data warehouse MS Access/SQL

Reporting in MS Access/MS SQL

Other IRIS Enterprise Enhancements

Notes Plug-in for Popup Alerts

Statement Filter

Order from cheapest Supplier

Auto Maintain Price Matrix

Distribution route planning

Pick all on a WOR

Prioritised bespoke picking list

Hide Stock Descriptions

VAT report by Cost Centres

Produce Stock control

Stock Consignment module

Training

Fixing OLE Referances

Other Software

Online Backup Software

Postcode Address Lookup

UltraVNC Single Click

IRIS Enterprise - Edit Picked Qty and other Transaction Line Fields

Update Transaction line

This PostTrans functionality allows a template to be created which will update Transaction header and line fields which are sitting in the daybook.

In the above example, which is included in the installation, the sheet will update three lines on SOR000853. The Picked Qty will be updated for each stock code specified. This matches the lines based on StockCode by default. Turn on "Setup>>Other>>Match by LineNo" to match by line number.

Restrictions

Transactions must be in daybook and the lines must be updated with sensible values.

Tag Name	Data Type Length	Description
Required (Prof version):
LinePosted	Yes/No	Returns 'POSTED' if Trans line has been posted and will be ignored if 'POSTED' (required)
ErrorDesc	Text	Description of error posted back if record unsuccessfully posted
THOurRef	Text	Transaction to update
TLStockCode	Text	Line to update, identified by Stockcode or LineNo. Turn on "Setup>>Other>>Match by LineNo" to match by line number. ONLY required if updating lines
Fields updated:
TLDescription	Text 55	Line 1 description
TLQty	Integer
TLQtyPicked	Integer
TLQtyBuilt	Integer
TLQtyUnderOver	Integer
TLQtyPickedWO	Integer
TLNetValue	Money
TLCostPrice	Money
TLCostCentre	Text
TLDepartment	Text
TLUser1	Text
TLUser2	Text
TLUser3	Text
TLUser4	Text
TLJobCode	Text
TLAnalysis	Text
TLMultiLocation	Text
TLLineDate	Date	Line Date (V6 Onwards) On a SOR or POR the header Due Date will be edited to the oldest line date as in IRIS Enterprise
Update Header fields:		The following was added to V6 onwards...
THYourRef	Text	Update header values
THAltRef	Text
THUserField1	Text
THUserField2	Text
THUserField3	Text
THUserField4	Text
THTagNo	Integer
THJobCode	Text
THAnalysisCode	Text
THNoLabels	Integer
THTransDate	Date
THDueDate	Date	This overrides any value set by TLLineDate on the Header

PostTrans: PostTrans for IRIS Enterprise Prices

Import PostTrans for IRIS Enterprise Transactions, PostTrans for IRIS Enterprise Customer/Suppliers, PostTrans for IRIS Enterprise Stock, PostTrans for IRIS Enterprise BOM (Bill of Materials) (, PostTrans for IRIS Enterprise Price Matrix, PostTrans for IRIS Enterprise Alternate Code DB, PostTrans for IRIS Enterprise Job, PostTrans for IRIS Enterprise Job Analysis, PostTrans for IRIS Enterprise Job Rates, PostTrans for IRIS Enterprise Employee, PostTrans for IRIS Enterprise Order from cheapest supplier, PostTrans for IRIS Enterprise Enhanced Reorder, PostTrans for IRIS Enterprise Serial/Batch and Multi-Bins, PostTrans for IRIS Enterprise Examples included

[ More about Exchequer Software ] [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: February 05, 2008