Formats

Exports listed in this activity generate and transfer data to an external accounting package. This activity allows the Systems Administrator to maintain settings such as the default export path, or layout of data within the export. Additionally, these Export Formats display as list options, when the Multi Unit Manager initiates the export, using the Release/Lock GL Data and Release/Lock Purchasing Data, activities.

This activity is available on the Smart Client ONLY.

Configurable Accounting Formats

How to Apply an Export Mask

In the details of an export, an Export Mask can be applied to any of the columns. To set up a mask, the following elements may be used:

Masking element	Description
0	Digit, required. This element will accept any single digit between 0 and 9.
9	Digit or space, optional.
#	Digit or space, optional. If this position is blank in the mask, it will be rendered as a space. Plus (+) and minus (-) signs are allowed. .
L	Letter, required. Restricts input to the ASCII letters a-z and A-Z.
?	Letter, optional. Restricts input to the ASCII letters a-z and A-Z.
&	Character, required. If the AsciiOnly property is set to true, this element behaves like the "L" element.
C	Character, optional. Any non-control character. If the AsciiOnly property is set to true, this element behaves like the "?" element.
A	Alphanumeric, optional. If the AsciiOnly property is set to true, the only characters it will accept are the ASCII letters a-z and A-Z.
a	Alphanumeric, optional. If the AsciiOnly property is set to true, the only characters it will accept are the ASCII letters a-z and A-Z.
.	Decimal placeholder.
,	Thousands placeholder.
:	Time separator. / Date separator.
$	Currency symbol.
<	Shift down. Converts all characters that follow to lowercase.
>	Shift up. Converts all characters that follow to uppercase.
\|	Disable a previous shift up or shift down.
\ (backslash)	Escape. Escapes a mask character, turning it into a literal. "\" is the escape sequence for a backslash.
All other characters	Literals. All non-mask elements will appear as themselves. Literals always occupy a static position in the mask at run time, and cannot be moved or deleted by the user.
<<>>	To mask negative account value. Example: <<#,##0.00;#,##0.00; >> Please note that a space character needs to be placed before the closing >>.
;	The ';' character is used to separate sections for positive, negative, and zero numbers in the format string

Maintain Configurable Accounting Export

Formats define what data to include in the export. For GL Exports, the format must be created in the Accounting Formats activity, prior to establishing the layout for the accounts in this activity.

Go to Formats
Type the name in the 'NAME' column
Select the type of separator in the 'SEPARATOR' column
Type the name in the 'FILE NAME' column
1. PAR OPS accepts the following tokens to be used as part of the file name:
  1. date: This will use Document Date, not today's date
  2. mmddyy: Current date in format MMddyy
  3. today: Current date in format yyyyMMdd
  4. ucustom1...ucustom5: Corresponds to Custom1 through Custom5 columns
  5. unit: Unit number
  6. yymmdd: Current date in format yyMMdd
Select Per Export to export data in one file or Per Accounting Date to generate one file per accounting date from the 'EXECUTE BEFORE' and 'EXECUTE AFTER' columns
1. During the export, PAR OPS can generate a secondary file.
Define whether this is the Primary or Secondary export file in the 'METHOD' and 'SECONDARY METHOD' columns
Select Suppress
Expand format details to define the account layout within the export
1. Before: Displays header information for the export.
2. Details: Defines the mapping for the body of the export.
3. After: Displays footer information for the export.
Click Save

Forecast Setup

Import Data