Difference between revisions of "Remittance Configuration - Accounts Document"

From Catalyst
Jump to: navigation, search
(Updated from revision control)
(Updated from revision control)
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
The Platinum System allows the layout of Remittance Advices to be configured to print the details you require. This is done using a system of "tokens" which represent the items you wish to print, and their positions on the Document.
 
The Platinum System allows the layout of Remittance Advices to be configured to print the details you require. This is done using a system of "tokens" which represent the items you wish to print, and their positions on the Document.
 
== Layout Data File Names ==
 
== Layout Data File Names ==
−
The default layout files are stored in the {{FilePath|sxco1\docs}} folder, (or {{FilePath|sxco2}}, {{FilePath|sxco3}}, etc).
+
The layout files are stored in the {{FilePath|SXCo1\Docs}} folder, (or {{FilePath|SXCo2}}, {{FilePath|SXCo3}}, etc).
  
 
=== Remittance ===
 
=== Remittance ===
Line 171: Line 171:
  
 
|- valign="baseline"
 
|- valign="baseline"
−
| '''~27'''
+
| '''~28'''
 
| '''Heading Line 2'''
 
| '''Heading Line 2'''
 
{{Warning|iconsize=small|text=
 
{{Warning|iconsize=small|text=
Line 178: Line 178:
  
 
|- valign="baseline"
 
|- valign="baseline"
−
| '''~27'''
+
| '''~29'''
−
| '''Heading Line 3'''
+
| '''Footing Line 1'''
 
{{Warning|iconsize=small|text=
 
{{Warning|iconsize=small|text=
 
This token must be on a line of its own.
 
This token must be on a line of its own.
Line 185: Line 185:
  
 
|- valign="baseline"
 
|- valign="baseline"
−
| '''~27'''
+
| '''~30'''
−
| '''Heading Line 4'''
+
| '''Footing Line 2'''
 
{{Warning|iconsize=small|text=
 
{{Warning|iconsize=small|text=
 
This token must be on a line of its own.
 
This token must be on a line of its own.
Line 192: Line 192:
  
 
|- valign="baseline"
 
|- valign="baseline"
−
| '''~27'''
+
| '''~31'''
−
| '''Heading Line 5'''
+
| '''Footing Line 3'''
 
{{Warning|iconsize=small|text=
 
{{Warning|iconsize=small|text=
 
This token must be on a line of its own.
 
This token must be on a line of its own.
Line 310: Line 310:
  
 
|- valign="baseline"
 
|- valign="baseline"
−
| '''~601''',n
+
| '''~601''',n,m
 
| <div style="float:right; margin-left:1em; font-style:italic;">(8 characters)</div>'''Document Number'''
 
| <div style="float:right; margin-left:1em; font-style:italic;">(8 characters)</div>'''Document Number'''
 +
;m = 0
 +
:Document number.
 +
;m = 1
 +
:<div style="float:right; margin-left:1em; font-style:italic;">(30 characters)</div>Document reference.
 
|- valign="baseline"
 
|- valign="baseline"
 
| '''~602''',n
 
| '''~602''',n
Line 548: Line 552:
  
 
{{Example|text=
 
{{Example|text=
−
Some examples using {{DataValue|~29,1}} amount taxed at tax rate 1.
+
Some examples using {{DataValue|~29,1}} amount taxed at first tax rate. Note that {{DataValue|~29}} may not represent an amount in all document formats. This is just an example.
  
 
;~29,1
 
;~29,1
Line 586: Line 590:
 
:Use exchange rate as at the transaction date for all currency conversions.
 
:Use exchange rate as at the transaction date for all currency conversions.
 
|}
 
|}
−
==== Currency Tokens ====
+
==== Country/Currency Tokens ====
−
There is a group of tokens that may be used in headers and footers to print details about the currency set up for the account associated with the document.
+
There is a group of tokens that may be used in headers and footers to print details about the country and currency set up for the account associated with the document.
  
 
{| cellspacing="5" width="95%" valign="baseline"
 
{| cellspacing="5" width="95%" valign="baseline"
Line 594: Line 598:
 
!|
 
!|
  
 +
|- valign="baseline"
 +
| '''~292''',n
 +
| <div style="float:right; margin-left:1em; font-style:italic;">(3 characters)</div>'''Country code/description for the document.'''
 +
If the account in use has a specific country associated with it this will be used, otherwise the system default country will be output.
 +
;n = 0
 +
:Output the country code.
 +
;n = 1
 +
:<div style="float:right; margin-left:1em; font-style:italic;">(30 characters)</div>Output the country description.
 
|- valign="baseline"
 
|- valign="baseline"
 
| '''~293'''
 
| '''~293'''

Latest revision as of 05:30, 28 October 2021

The Platinum System allows the layout of Remittance Advices to be configured to print the details you require. This is done using a system of "tokens" which represent the items you wish to print, and their positions on the Document.

Layout Data File Names

The layout files are stored in the 'SXCo1\Docs' folder, (or 'SXCo2', 'SXCo3', etc).

Remittance

'FAXREMI'
Remittance pre-set up for Faxing
'WINREMI'
Remittance pre-set up for Windows Printing, on Plain Paper
'MULREMI'
Multi-part Remittance
'SINREMI'
Single Part Remittance

Token File Names

These are copied down into the main data directory when they are needed for the first time by Platinum, and from that point the layouts are as follows:

'SXLD043.EPL'
Remittance Advice

Layout Tokens

Tokens are indicated by the character '~' followed by a number (the token identifier).

These identifiers may be up to 3 digits in length in the range 1 to 999. Tokens each have specific uses, which are listed below.

Parameters

Some tokens may also be given parameters. The number of parameters vary for each token. To specify a token with parameters the token must be followed by a comma then parameter. Each parameter is similarly divided from the next by a comma (no terminating comma is required).

Document Areas

For the purposes of configuration, the remittance layouts are divided into 3 main areas: "Headings", "Body" & "Footings".

Area Tokens

~100 Configuration Section Start
~199 Configuration Section End
~200 Heading Block (First Page) Start
~299 Heading Block (First Page) End
~300 Heading Block (Continuation) Start
~399 Heading Block (Continuation) End
~400 Footing Block (Continuation) Start
~499 Footing Block (Continuation) End
~500 Footing Block (Last Page) Start
~599 Footing Block (Last Page) End
~600 Body Block Start
~699 Body Block End

Tokens

General Tokens

These can appear in either Headers or Footers.

~1
(30 characters)
Account Address Line 1
~2
(30 characters)
Account Address Line 2
~3
(30 characters)
Account Address Line 3
~4
(30 characters)
Account Address Line 4
~5
(30 characters)
Account Address Line 5
~6
(30 characters)
Company Name
~7,n Telephone Number
n = 0
(15 characters)
Telephone Number.
n = 1
(20 characters)
Mobile Number.
~8
(15 characters)
Fax Number
~9
(12 characters)
Account Balance
~10
(12 characters)
Credit Limit
~11
(5 characters)
Discount Percentage
~12
(3 characters)
Settlement Period
~13
(6 characters)
Customer Code
~14
(10 characters)
Today's Date
~15
(30 characters)
Notes 1
~16
(30 characters)
Notes 2
~17
(7 characters)
Month Selected
~18
(60 characters)
Message Of the Day Line 1
~19
(60 characters)
Message Of the Day Line 2
~20
(40 characters)
Company Name 1
~21
(40 characters)
Company Name 2
~22
(50 characters)
Company Address Line 1
~23
(50 characters)
Company Address Line 2
~24
(50 characters)
Company Address Line 3
~25
(50 characters)
Company Address Line 4
~26
(50 characters)
Company Address Line 5
~27 Heading Line 1
This token must be on a line of its own.
~28 Heading Line 2
This token must be on a line of its own.
~29 Footing Line 1
This token must be on a line of its own.
~30 Footing Line 2
This token must be on a line of its own.
~31 Footing Line 3
This token must be on a line of its own.
~32
(10 characters)
Account Reference
~33
(6 characters)
Account Group
~234
(30 characters)
Account V.A.T. Registration Number

Configuration Tokens

These affect the overall layout of the Invoice, and should be grouped together at the head of the layout file.

Document Configuration

~110,n Document Type
n = 0
One line per document number.
n = 1
Full document detail.
~111,n Line Skip
n = 0
No Line Skip.
n = 1
Line Skip between Items.
~112,n Heading Block
n => 1
The line to start printing.
~113,n,m Body Block
n
The line to start printing.
m
Depth (Number of lines to print).
~114,n Footing Block
n
The line to start printing.
~115,n Form Length
n
Number of Lines per Page.
~116
(6 characters)
Payment Indicator Start
~118 Enhance Payment Lines
(Multi Line Format Only)
~198 Currency conversion configuration
  • See Currency Conversions at the end of this article for more details.

Payment Amount Word Configuration

~119
(10 characters)
Pounds
~120
(10 characters)
Pence
~121 Do not Print Pence
~122 Print "Only" in place of Zero pence
~123 Suppress "And"

Body Block

General Information

'~6nn,1,2,3' where '~6nn' represents an item, described below, which you wish to be printed in the remittance body.

All have up to three parameters :-

Parm 1 - 'n'
Column position, from 1 to 132. You may omit this parameter if you place the token in the column in which it is supposed to print.
Parm 2 - 'm'
When this parameter is set to 1 then this column will be totalled. (Only available on some columns).
Parm 3 - 'l'
When this parameter is set to 1 then this token in the case of a zero figure this will print '0.00' instead of spaces.
  • A maximum of 20 tokens may be placed across the body line.
  • If required a token may appear more than once per line.
~601,n,m
(8 characters)
Document Number
m = 0
Document number.
m = 1
(30 characters)
Document reference.
~602,n
(10 characters)
Document Type
~603,n
(10 characters)
Document Date
~604,n
(10 characters)
Payment Amount
(Single Line Format Only)
~605,n
(10 characters)
Payment Indicator
(Multi Line Format Only)
~606,n
(10 characters)
Balance before Payment
(Single Line Format Only)
~607,n
(15 characters)
Document Comment
~608,n
(10 characters)
Amount if Debit
~609,n
(10 characters)
Amount if Credit
~610,n
(10 characters)
Amount Signed
~611,n
(10 characters)
Document Balance
This will print on the last document item only.
~613,n
(10 characters)
Rolling Balance
This will print on the last document item only.
~614,n
(3 characters)
Invoice Age in Days
This will print on the last document item only.
~615,n
(10 characters)
Original Amount
(Single Line Format Only)
~616,n
(10 characters)
Previous Payment or Allocation for this document
(Single Line Format Only)
~617,n
(10 characters)
Total Held for Document
This will print on the last document item only.
~618,n
(10 characters)
Document Balance - Held
This will print on the last document item only.
~619,n
(10 characters)
Discount Amount
(Single Line Format Only)

Totals Block

General Information

'~5nn,1,2,3' where '~5nn' represents an item, described below, which you wish to be printed in the remittance totals.

All have up to three parameters :-

Parm 1 - 'n'
See individual token for explanation.
Parm 2 - 'm'
See individual token for explanation.
Parm 3 - 'l'
When this parameter is set to 1 then this token in the case of a zero figure this will print '0.00' instead of spaces.
~510
(10 characters)
Total of Periods Payments
~511,n Discounts
n = 0
Total Amount before Discount
n = 1
Total Discount applied
~512,n,m
(10 characters)
Total of Periods Payment in Words Line 1
n = 1
Word format for pence
n = 2
Fraction format for pence
n = 3
Numeric format for pence
m
Width of text in characters (from 30 to 60)
~513,n,m
(10 characters)
Total of Periods Payment in Words Line 2
n = 1
Word format for pence
n = 2
Fraction format for pence
n = 3
Numeric format for pence
m
Width of text in characters (from 30 to 60)
~514
(10 characters)
Total Amount
~517 Blank Line If Period Payment is 0.00
~521
(10 characters)
First digit of Pounds as a Word
~522
(10 characters)
Second digit (10's) of Pounds as a Word
~523
(10 characters)
Third digit (100's) of Pounds as a Word
~524
(10 characters)
Fourth digit (1,000's) of Pounds as a Word
~525
(10 characters)
Fifth digit (10,000's) of Pounds as a Word
~526
(10 characters)
Sixth digit (100,000's) of Pounds as a Word
~527
(10 characters)
Seventh digit (1,000,000's) of Pounds as a Word
~528
(10 characters)
Eighth digit (10,000,000's) of Pounds as a Word
~529
(10 characters)
First digit of Pence as a Word
~529
(10 characters)
Second digit of Pence as a Word

Print Style Tokens

The following print style codes must have 3 spaces after them as these codes always 6 characters wide.

~79
(6 characters)
Expand
~80
(6 characters)
Unexpand
~81
(6 characters)
Compact
~82
(6 characters)
Uncompact
~83
(6 characters)
Double Strike On
~84
(6 characters)
Double Strike Off
~86
(6 characters)
Paper Forward
~87
(6 characters)
Paper Backward
~88,n
(up to 32 characters)
Insert print style

This print style code doesn't need any spaces after it as it will the width of the print code to insert.

n = 1 -> 999
Corresponds to the print code ID in the "Print Code Amendments".

Currency Conversions

Platinum "Elite" systems only. "Solo" systems will need to be upgraded to "Elite", contact your Platinum dealer or our sales team on (0116) 230 1500 or by using our website sales contact page for your upgrade path.

All tokens that return a currency amount may now be modified to convert that amount into a different currency before printing. This is done by using a currency modifier after the token number but before any parameters. This modifier begins with a special symbol and may optionally be followed by a number and/or a three character currency code.

To get the relevant currency symbol to print on a document, the symbols '$' and '#' (hash symbol, but may have been misprinted as a pound sign) are used immediately after the token that you wish the currency conversion to take place. Using the '#' will suppress the printing of the currency symbol. This can be useful when printers don't have relevant symbols for some currencies.

Unless the relevant currency required is set up against the base rate in Currency Maintenance, no conversion will take place. Also, the customer needs to be correctly flagged for the appropriate Country.

The number part of the modifier may be used to specify the maximum number of characters to print. Some currencies may involve quite large amounts and this number can be used to make sure there is enough room to print them. The three character currency code specifies which currency to convert the amount to. This may be omitted, in which case the currency specified for the account associated with the remittance being printed will be used, if there is one.

Some examples using '~29,1' amount taxed at first tax rate. Note that '~29' may not represent an amount in all document formats. This is just an example.
~29,1
no conversion
'*100.00' - (where * is your usual currency symbol).
~29$,1
convert to the account currency (if there is one)
'1005.18F' - (e.g. French Francs.)
~29$12,1
convert to account currency and print to a width of 12
'1005.18F'
~29$USD,1
convert to currency USD (US Dollar)
'$234.02'
~29$USD(02),1
convert to currency USD (US Dollar) and target to whole dollar units if within 2 cents. This feature is useful if you want to display values with the cents/pennies rounded away. For example if displaying in dollars then the number in brackets represents the maximum number of cents over or under a dollar within which the conversion will target to a whole dollar. For 02 within the brackets then $1.98, $1.99, $2.00, $2.01, $2.02 will all display as $2.00.
'$234.00'
~29#12USD,1
same, but suppress the symbol and print to a width of 12
'234.56'

Currency Configuration

There is an optional Currency Conversion configuration token which when used should be placed in the Configuration block. This token may have a currency modifier applied to it which will then be used by default throughout the document, although it can be overridden by modifiers applied to individual tokens.

~198x,n x = Default currency modifier (optional)
n = 0
Use exchange rate as at the user date for all currency conversions.
n = 1
Use exchange rate as at the transaction date for all currency conversions.

Country/Currency Tokens

There is a group of tokens that may be used in headers and footers to print details about the country and currency set up for the account associated with the document.

~292,n
(3 characters)
Country code/description for the document.

If the account in use has a specific country associated with it this will be used, otherwise the system default country will be output.

n = 0
Output the country code.
n = 1
(30 characters)
Output the country description.
~293
(12 characters)
Exchange rate from base currency to account currency
~294
(15 characters)
Sub-units of the currency set for this account
~295
(15 characters)
Units of the currency set for this account
~296
(30 characters)
Name of the currency set for this account
~297
(3 characters)
Code of the currency set for this account
~298 Skip block until next ~298

Should be used in pairs on a line. Everything between them is blanked out if there is no currency set for this account


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
Layout, Token, Format, Document, Setup, Config, Configuration, Remittance Advice
Tags

SL11

Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=Remittance_Configuration_-_Accounts_Document&oldid=43174"