PostTrans XL Visual Importer: Edit Picked Qty and other Transaction Line Fields
This is only available in the Professional version of PostTrans
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 | |
|
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 |
|
|
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. To update POSTED thDueDate the Transaction Type must be one of: dtSIN, dtSCR, dtSJI, dtSJC, dtSRI, dtSRF, dtPIN, dtPCR, dtPJI, dtPJC, dtPPI, dtPRF |
|
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 |