Currency Extract Template
This PostTrans function allows the user to easily extract Sage 50 Currency data.
The cell A1 has a tag “Sage50currency” 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.
Currency Required fields
To Extract Sage 50 Currency Data, the following Tags/Fields must be specified:
Sage50currency, CrErrorDesc, CrCode, CrName
Cell A1 must equal Sage50currency
CrCode is used to detect end of spreadsheet. PostTrans will stop Importing/Amending, from row 4 on-wards, when this field is empty.
Restrictions
Extract only
Tags for Currency Records
The following PostTrans tags can be used to extract/import Currency Records into Sage 50 .
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 |
|
Important Fields: |
||
|
Sage50currency |
Text Req |
Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row |
|
CrCRC |
Text Req |
Contains CRC number to help PostTrans detect changes in current row. |
|
CrCode |
Text 8 EOF Req Read |
Currency Code |
|
CrName |
Text 60 Req Read |
Currency Name |
|
CrSymbol |
Text 3 Read |
Currency Symbol |
|
CrEMUFlag |
Yes/No Read |
EMU Member |
|
CrExchangeRate |
Double Read |
Exchange Rate |
|
CrLocked |
Yes/No Read |
Locked |
|
CrMajorUnit |
Text 20 Read |
Major Currency Unit |
|
CrMinorUnit |
Text 20 Read |
Minor Currency Unit |
Req = Field is required EOF = End of file, Stop when no more values
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.