The following PostTrans tags can be used to import Project Adjustments and O/P Bal Transactions into Sage 200
.
See Online Training for Static templates for a full explanation of tags, and how PostTrans reads them to define the Extract/Import template.
Tag Name
|
Data Type
|
Description
|
companyCode
|
Text 30 Head Chg XML
|
Overide Company Code
|
mappings
|
Memo Head Chg XML
|
Overide Conversions List
|
Req = Field is required EOF = End of file, Stop when no more values Chg = Change forces a new transaction
XML = Un-attended PostTrans XML API for Sage 200
Head A header tag can be used in header section, before row 30, of the transaction template. Or in the rows data of data, below row 30, of the template like a traditional CSV importer.
With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE
Where ^ denotes a In Cell Code Search, delete ^ at end of tag, to turn off code search
All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.