GL Accountants Export Designer

Navigator > Setup > General Ledger > Accountants Export Designer

Typically, accounting systems require different formats for importing transactions with a file comprising a single header record, multiple body records (representing the transactions) and possibly a final single footer record. Not all systems require a header or footer record. Many formats cannot accept commas in fields, avoid using commas and quote marks in fields to be exported.

You can create an export definition for exporting GL transactions to different accounting formats. The definition consists of sections of MaxBasic code that prints out the appropriately formatted file, the definition can be used to create an output file from Navigator > Tasks > General Ledger > Export to Accountants System.

Generally, the code is made up of Print statements that print the information to the file in the format required by the accounting system. When an accountant's system changes its import file format, adjust the code to output a file in the new format.


Code Sections
Header tab			Use to output a header and pre-initialise variables to be used in the body or footer code.
Body tab			Use to output the details for each transaction.
Footer tab			Use to output a footer (typically for totals).
Code Editor
Objects available include:
Account			Fields from the GL Account record.
Branch			Fields from the Branch record. (Accredo Saturn Only)
Company			Contains details of the Company name and address.
Department			Fields from the Department record. (Accredo Saturn Only)
Document			Fields from the export to accountants system window.
Transaction			Fields from the GL transaction record.
User			Fields from the current User.
Buttons
	Check Code `(Alt+C)`	View the code to check all the code sections compile correctly, without exporting.
	Set/Clear Breakpoint `(Alt+B)`	Set a code breakpoint on the current line. Click again to toggle to clear the breakpoint. You can also click to the right of a line to set or clear a breakpoint. Hover the mouse over a breakpoint, then right-click to make a breakpoint unavailable, or access the Breakpoint Properties. If a condition has been set for a breakpoint, it will be shown when you hover over the breakpoint.
	Load... `(Alt+L)`	Load previously saved definitions.
	Save... `(Ctrl+S)`	Save the definition for use in Export to Accountants System. If you modify one of the supplied definitions, save it under a new name so that it is not overwritten next time you install an Accredo update.