Menu

Currency

Releated Topics.

Training on Static Data

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

Related Topics...

Training on Static Data    

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.