PostTrans XL Importer: Edit Picked Qty and other Transaction Line Fields


PostTrans:: Features; Training; System Settings; Prices; Download/Update History; How to Install/Upgrade; Examples Included; Common Support Q/A; Extra functions and code


Functionality:: Import Transactions; Transaction Description; Import Cust/Suppliers; Import Stock; Import Price Matrix; Import Bill of Materials; Import Bank Rec; Import General Ledger; Import Jobs; Import Alternate Code DB; Import Multi-Buy; Import Contact & Roles; Inter-Company Trans; Import Matched Payments; Edit Transactions; POR Cheapest Supplier; Stock Take Multi-Bins; Remote Code Lookup XLA; LIVE Code Lookup XLA; In-Cell Searching; Edit Stock/BOM Item


Latest News:: Sign-up for Newsletter; Follow us on Facebook; Follow us on Twitter

: Bookmark page; Send to a Friend; Print this page


Experts in:: Importation; Exchequer; Bespoke Solutions for Exchequer

PostTrans XL Visual Importer: Edit Picked Qty and other Transaction Line Fields

This is only available in the Professional version of PostTrans

Uses

Pick Items in daybook
Add extra lines to transaction
Amend Works orders
Update prices in daybook
Update user defined fields
Adding notes to Transaction in daybook or posted
Add/Update links to external documents on transactions
Amend curtain fileds on posted transactions

Demonstration Video:

Easily Edit Transactions and lines

The "Update Lines.xls" Example shows this in action. more information on PostTrans examples

Features:

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, and if posted then the Red fields listed in the table below. + 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

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.

Edit Transaction Line fields available for update:

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
THOutStandingOrderVal	Double	Outstanding Order Value for whole transaction
TLOutStandingOrderVal	Double	Outstanding Order Value for line
THFollowWebLink	Double	Adds a Hyperlink to allow user to follow first Web Link
THFollowLink	Double	Adds a Hyperlink to allow user to follow first linked document
THLastGenNote	Double	Show the Last note in general notes, use "System Setting - Other - Display X Notes lines" to limit the number of lines.
THLastDateNote	Double	Show the Last note in dated notes, use "System Setting - Other - Display X Notes lines" to limit the number of lines.
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
TLDiscount	Double	Discount. Use 'Discount as %' under 'Trans Switches' in system setting
TLCostPrice	Money
TLCostCentre	Text
TLDepartment	Text
TLUser1	Text	Posted transaction can be updated
TLUser2	Text	Posted transaction can be updated
TLUser3	Text	Posted transaction can be updated
TLUser4	Text	Posted transaction can be updated
THUser5-10	Text	Line user field 5-10 (V6.9+)
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 Posted transaction can be updated
Update Header fields:		The following was added to V6 onwards...
THYourRef	Text	Update header values
THAltRef	Text
THUserField1	Text	Posted transaction can be updated
THUserField2	Text	Posted transaction can be updated
THUserField3	Text	Posted transaction can be updated
THUserField4	Text	Posted transaction can be updated
THUserFiled5-10	Text	Header user field 5-10 (V6.9+)
THTagNo	Integer	Posted transaction can be updated
THJobCode	Text
THAnalysisCode	Text
THNoLabels	Integer
THTransDate	Date
THDueDate	Date	This overrides any value set by TLLineDate on the Header. To update POSTED thDueDate the Transaction Type must be one of: dtSIN, dtSCR, dtSJI, dtSJC, dtSRI, dtSRF, dtPIN, dtPCR, dtPJI, dtPJC, dtPPI, dtPRF Posted transaction can be updated
THDelAddress1-5	Text
THDelCountryCode	Text
Links		The following tags should be used in pairs. You must specify the PATH and Name If on a series of lines, for same transaction, then PostTrans will look at first line
THLinkDocName_Overwrite	Text	Delete All and add Linked docs with Name
THLinkDocPath_Overwrite	Text	Delete All and add Linked docs with Path to doc
THLinkDocName_Add	Text	Add Linked docs with Name
THLinkDocPath_Add	Text	Add Linked docs with Path to doc
THWebDocName_Overwrite	Text	Delete All and add Linked docs with Name
THWebDocPath_Overwrite	Text	Delete All and add Linked docs with Path to doc
THWebDocName_Add	Text	Add Linked docs with Name
THWebDocPath_Add	Text	Add Linked docs with Path to doc
Notes
THDatedNotes_Add	Text	Add a Dated Note. User is set in system settings "Trans Header Cells 3", "User" under "Transaction Header Dated Notes"
THGeneralNotes_Add	Text	Add a General Note
Special
JBContact	Text	If transaction relates to Job then return/edit Job Contact
JBManager	Text	If transaction relates to Job then return/edit Job Manager
JBUser1-10	Text	If transaction relates to Job then return/edit Job User1-10
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.

Exchequer Software Plug-ins

Call an expert