Import XML Button

The Import XML button can be used to load journal entry information from a XML file.  This option is typically used to load Journal Entry Information from an excel spreadsheet, - using an XML Schema, so that it can be posted to the General Ledger.

To import a journal entry from an XML file, you should.

•      Set the accounting year, period and post date in the Journal Entry program to the correct values for the entry you are importing.

•      Press the Import XML Button.  This action will cause the system to display a windows file selection object, which you may use to select the XML file to be imported.  The windows file selection object will default to the cove\xmlin directory and a file extension of .xml

•      As the XML file is loaded into the Journal Entry program, the system will ck the information in the XML file to make sure it is valid.

•      If any of the journal entry lines being imported have both debit and credit values, the values will be cleared.

•      If any of the accounts are not set up in the current accounting period – or if any of the accounts are not valid, the system will warn you which lines are not valid, and why, and it will display a message that the line should be deleted and re-entered manually.

•      Once the XML information has been loaded into the Journal Entry Program, the debit and credit totals for the JE are displayed.  At this point, you may modify the information that is displayed in the program (add or delete lines, change line amounts, etc), or you may add comments and/or image records to the transaction.  Note that you may also import comment lines for the journal entry lines being imported – as shown in the below xml file format example.  You may edit the comments for each line whether they are automatically loaded from the XML file or not.

•      Once the information in the Journal Entry is complete, and the JE is in balance, you may save and post the entry using the Save key or button.

XML File Format:

The following is an example of a two line je in xml format

<ROOT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >

  <ROW>

          <DPT>1</DPT>

          <ACCT>730</ACCT>

          <SUB>0</SUB>

          <PROJECT>Proj1</PROJECT>

          <DEBIT>111.11</DEBIT>

       <COMMENT>This is a line comment 1</COMMENT>

  </ROW>

  <ROW>

          <DPT>1</DPT>

          <ACCT>735</ACCT>

          <SUB>0</SUB>

          <PROJECT>Proj2</PROJECT>

          <CREDIT>111.22</CREDIT>

       <COMMENT>This is a line comment 2</COMMENT>

  </ROW>

</ROOT>

More:

Load JE Button