Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Overview 

GL Journal allows users to enter manual or adjust journal entries in the system. In Vienna Advantage, currently system posts the transaction in all the accounting schemas those are linked with posting organization and have common Chart of account. New option is brought for the user to select accounting schemas manually to post the transaction. 

GL Journal Form 

This form will enter the data on "GL Journal" window. This form is consist of two form "GL Journal View" and "GL Journal Entry". 

This form allow user to save, complete, post and reverse GL Journal. 

 

GL Journal View 

This form is used to view "GL Journal" record. Also user can complete and posting "GL Journal".  

...

  1. This is parameter to filter data on middle grid. Record will be sort in descending order on account date. 

  2. This grid will show "GL Journal" record, data on this grid will be coming from "GL Journal" window. 

    • Drafted document will show in white color 

    • Completed document will show in light blue color 

    • Posted document will show in grey color 

  3. Add New button will allow user to create new "GL Record" and this will open "GL Journal Entry" form. 

  4. Refresh button will refresh form data. 

  5. Complete button will complete drafted record. User can also allow to complete multiple record same time. 

  6. Post button will allow to post completed record. User can also post to multiple record same time. 

  7. Edit button will open "GL Journal Entry" form. This button will be editable if record is not completed. 

  8. Zoom button will open record on "GL Journal" window. 

  9. This section will show "GL Journal"  header data, this is read only section. 

  10. This section will show ledger GL line if document is not posted. After posting this grid will show it's posting. 

 

GL Journal Entry 

This form is used to create GL Journal, Line, Line Dimension and Assign Accounting Schema. Also user can complete, reverse, edit and post "GL Journal" record. This form is divided in four section 

...

  1. Element Type" fetch data from "Account Schema Element" tab of "Accounting Schema" window. System will check accounting schema that is selected on GL Journal header. List will show record which are active and not having "Type" select as "Account". 

  2. "Delete all dimension" button will delete all created line dimension, from "Line Dimension" tab. 

  3. "Delete" only selected line dimension, from "Line Dimension" tab. 

  4. "Add" this will allow user to create multiple record against one "GL Journal Line". After save, "Description" and"Type" of GL journal line will update. 

 

Assign Accounting Schema  

Data from this section will save on "Assign Accounting Schema" tab of "GL Journal" window. Data on this grid only show if system has more than one accounting schema. Also accounting schema has same COA bind and document organization should have defined under "Assigned Organization" tab of "Accounting Schema" window.  

...

"Print" button will allow user to take print of the document 

Enhancement 1 

  1. In this update we are introducing "Line Dimension" import option via excel on "GL Journal" form. 

  2. On Journal View Form (Journal) new search parameter introduce "Account Date From" and "Account Date From". 

  3. When user use "New" button on "GL Journal Entry" form, system will not change "Account Date" and "Document Date" for next GL record. When user  use "New" button on "Journal View Form (Journal)" system date will set system date in "Account Date" and "Document Date". 

  4. On Selection of accounting schema on "GL Journal Form", if other accounting schema will having same chart of account, those accounting schema will be auto selected. 

  5. Bug Fixes and improvement.  

Excel Import on Line Dimension 

Excel import option is allowing user to import multiple record against single ledger code. Excel will be having two columns. 

...

View file
nameSample Line Dimension Import.xlsx

 

Enhancement 2 

  1. On "GL Journal View" form validation set on "Document Type" parameter, only GL Journal document type will show. Earlier GL Journal Batch document type were showing. 

  2. On "GL Journal View" form, while complete and post process will show confirmation message. 

  3. Document Status column added in GL Journal tile on "GL Journal View" form. 

  4. On "GL Journal Entry" form introduced "Document Type" field  and hide "GL Type" field. 

  5. On "GL Journal Entry" form rename "Journal No" to "Document No". 

...

If excel has multiple sheet and you are importing same on GL journal form (account or line dimension), system will pick data from first sheet (sheet name in alphabetic order). 

 

Enhancement 3 

  1. "Select all" option introduced on "GL Journal View" form. This will select a record of the first page only, reset of records will select once the user scrolls down. 

...