This PostTrans functionality allows a template to be created which will update Transaction header and line fields which are sitting in the daybook. + Payment ref on SCR SRI

In the above example, which is included in the installation, the sheet will update lines on transactions. In this case three transaction. The Picked Qty will be updated for each stock code specified. This matches the lines based on THOurRef, which is the format OurRef_LineNo.

"System Settings >> Other >> Update Lines", Tag updated Transaction, allows transactions to be Tagged when updated. Thus POR/SOR can be picked, then processed, to Delivery/Invoice, in Exchequer using tag filter. Enter "DAY" to use today's day number.

Transaction Header fields (those beginning with TH) must be updated in the first line of the transaction block. In this example rows 3, 5 and 7

Lines can be added to end of transaction but THOurRef must be the transaction ref (with no Lines numbers), as shown in row 10 on the above example.

Restrictions

When posting MUST be in THOurRef order

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, as of V6.1.12 this has line number appended to specify specific line to update. Format OurRef_LineNo.
Used for Lookup, not updateable:
THAccountCode	Text
THAccountName	Text
TLQtyOutstanding	Double
TLQtyWrittenOff	Double
TLQtyDelivered	Double
Fields updated:
TLStockCode	Text
TLDescription	Text 55	Line 1 description. Multiple lines CANNOT be updated
TLQty	Double
TLQtyPicked	Double
TLQtyBuilt	Double
TLQtyUnderOver	Double
TLQtyPickedWO	Double
TLQtyMultiplier	Double
TLNetValue	Money
TLCostPrice	Money
TLCostCentre	Text
TLDepartment	Text
TLUser1	Text
TLUser2	Text
TLUser3	Text
TLUser4	Text
TLJobCode	Text
TLAnalysis	Text
TLMultiLocation	Text
TLGLCode	Integer	GL code on line
TLLineDate	Date	Line Date (V6 Onwards) On a SOR or POR the header Due Date will be edited to the oldest line date
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
THDelAddress1-5	Text
Special
TLPaymentRef	Text	When used PostTrans will allow the update of PayRef on SCR/SRI. But all other update fields will be ignored, thus when used will only update PayRef on SCR/SRI. The lookup window will query SCR/SRI's. V6.1.30 onwards

PostTrans: PostTrans for IRIS Enterprise Prices

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

Last modified: November 17, 2009