GL Journal Import

Import General Ledger journal entry totals.

PrismCore Import_GL_Journal Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

ASCII Delimited Format

XML Definition

The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data.  All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_gl_jrn_imports>

       <trn_gl_jrn_import

              entry_number="JT-00000576"

              tran_code_id="1"

              create_date="07/16/2007"

              post_date=""

              store_id="9"

              gl_period="4"

              gl_year="2005"

              credit_amount="5.4300"

              debit_amount="5.4300"

              reference="Reference for JT-00000576"

              reverse_entry=""

              b_reversable="0"

       />

</trn_gl_jrn_imports>

 PRISM Format for GL Journal Import

Not defined at this time, call R&D if needed.

GL Journal Detail Import

Imports General Ledger journal entry details. 

PrismCore Import_Gl_Journal Detail Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

ASCII Delimited Format

XML Definition

<?xml version="1.0"?>

<trn_gl_jrnd_imports>

       <trn_gl_jrnd_import

              entry_number="JT-00000576"

              tran_code_id="1"

              gl_account="60880"

              gl_description="MISCELLANEOUS EXPENSE"

              line_number = "3741"

              debit_amount="5.4300"

              credit_amount=".0000"

              store_id="9"

       />

       <trn_gl_jrnd_import

              entry_number="JT-00000576"

              tran_code_id="1"

              gl_account="60770"

              gl_description="INVOICE CREDIT"

              line_number = "3742"

debit_amount=".0000"

              credit_amount="5.4300"

              store_id="9"

       />

</trn_gl_jrnd_imports>

PRISM Format for GL Journal Detail Import

Not defined at this time, call Support if needed.

GL Journal Export

Exports General Ledger journal entry totals.

PrismCore Export_GL_Journal Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Note: The export files for GL Journal Export and GL Journal Detail Export will only be created when running the “Export GL” module in the PrismCore Admin program.

ASCII Delimited Format

XML Definition

The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data.  All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_gl_jrn_exports>

       <trn_gl_jrn_export

              entry_number="JT-00000576"

              tran_code_id="1"

              store_id="9"

              create_date="07/16/2007"

              post_date=""

              gl_period="4"

              gl_year="2005"

              debit_amount="5.4300"

              credit_amount="5.4300"

              reference="Reference for JT-00000576"

              reverse_entry=""

              b_reversable="0"

       />

</trn_gl_jrn_exports>

PRISM Format for GL Journal Export

• All Dates are in MM/DD/YY format - (03/05/95).

• All amounts have an embedded decimal points but no leading zeros - (     10.23).

• All fields have a tilde (~) between them and end in a CR/LF.

GL Journal Detail Export

Exports General Ledger journal entry details.

PrismCore Export_GL_Journal_Detail Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Note: The export files for GL Journal Export and GL Journal Detail Export will only be created when running the “Export GL” module in the PrismCore Admin program.

ASCII Delimited Format

XML Definition

The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data.  All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_gl_jrnd_exports>

       <trn_gl_jrnd_export

              entry_number="JT-00000576"

              line_number="3660"

              tran_code_id="1"

              store_id="9"

              gl_account="60880"

              gl_description="MISCELLANEOUS EXPENSE"

              debit_amount="5.4300"

              credit_amount=".0000"

       />

       <trn_gl_jrnd_export

              entry_number="JT-00000576"

              line_number="3661"

              tran_code_id="1"

              store_id="9"

              gl_account="60770"

              gl_description="INVOICE CREDIT"

              debit_amount=".0000"

              credit_amount="5.4300"

       />

</trn_gl_jrnd_exports>

PRISM Format for GL Journal(GLDIST) Detail Export

• All Dates are in MM/DD/YY format - (03/05/95).

• All amounts have an embedded decimal points but no leading zeros - (     10.23).

• All fields have a tilde (~) between them and end in a CR/LF.