Nominal Extract/Amend/Import Template
This PostTrans function allows the user to easily extract, amend, and import Sage 200 Nominal data.
The cell A1 has a tag “Sage200nom” to designate the type of import. It uses a series of tags, placed in row 1, to identify the data to be processed.
These tags, listed in table below, can be easily added to a spreadsheet using the Tags button. See Training for an explanation of this.
Nominal Required fields
To Import/Extract/Amend Exchequer Enterprise Nominal Data, the following Tags/Fields must be specified:
Sage200nom, NoErrorDesc, NoCode, NoName
Cell A1 must equal Sage200nom
NoCode is used to detect end of spreadsheet. PostTrans will stop Importing/Amending, from row 4 on-wards, when this field is empty.
You can edit Nominal Records, such as the bedget figures, but not add new ones.