Sage 50 Currency Import/Update

Releated Topics.

Sage 50 : Extract Currency Record Features

To extract Currency data simply press Extract button, on the PostTrans Toolbar, this will allow you to extract Currency data from Sage 50. You can also add filtering criteria in row 2. See more about filtering

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.

Currency