Versions Compared

Key

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

The AGRIS 19.3.0 release has added:

G/L Journal Entry Import - Automatically reverse manual journal in next period (AGS-7528) 

Benefit:

Reduce time and effort to reverse month-end journal entries for accruals.

Implementation:  

Journal Entry Import Layout

AGRIS System Support > Maintenance > File Layouts for Imports > LDG > Journal Entries

Journal Entry import file now supports Manual / Next Reverse journal type, Type "0".  Type "0" journal import will generate a Manual Journal Entry, Type "1", in the specified ledger period and will automatically generate a reversing journal, Type "6", in the next ledger period.  This single import journal replaces creating separate import file entries for both the manual and next period reversing entry.

...

FieldDescriptionPositionLengthTypeComments
NJournal Entry Type1001C

0 = Manual/Next Reverse (New)
1 = Manual
2 = Repeat
3 = System
4 = Current Reverse
5 = Prior Reverse
6 = Next Reverse
7 = System Reverse
8 = Standard Entry
9 = Compressed

G/L Journal Entry Import Report

Successfully posted reversing entry for Manual / Next Reverse import journal is printed immediately after posting the origin manual journal.  The origin manual journal is identified by the Type Entry Description "MAN-NXT/RV".  The report continues to identify the reversing journal Type Entry as "NXT/RV".

Sample G/L Journal Entry Import Report

...

:


Image Modified

Journal Entry Import Validation

In addition to the current data validation rules, Manual / Next Reverse import entries must pass the following rules.

...

Sample Import Report with Validation Errors:


Image Modified