The AGRIS 19.3.0 release has added:

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

Want to reduce time and effort to understand how revenues and expenses are trending month-to-month using the format from your financial form?

There is a new standard Financial Form report that shows 14 amount columns (report #2 below). 

There is also a new standard Financial Form Excel report that shows the 14 amount columns (report #5 below). 

Image Removed

Here is the report Range Selection Criteria screen:

Image Removed

The Financial Form Code at the bottom of the screen allows you to choose any one of your Income Statement Financial Forms.

The magnifying glass search icon will display the list of your existing forms and allow you to select the appropriate one.

You can filter the report by Detail Code, Profit Center and G/L Location.

The "Date Range For All Columns" defaults to 13 months before the current Ledger Period. 

By default:

• Column 1 Date through Column 13 Date represent the months through the current Ledger Period and 13 months prior.  
• Column 14 is a column that shows the total for the months in the current year-to-date period.

The sample below shows:

• Fiscal year that began March 1, 2015.
• Current reporting month is December 2015.
• Amount columns for 13 months' of activity.
• Column 14 amount that represents the year-to-date total for March through December 2015.
• The title of your Financial Form will display on the heading line at the top of the first column (where the image below says "Account Description"). 

Image Removed

NOTE: 

...

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.

JOURNAL ENTRY IMPORT FILE (Page 1 of 2)

== Journal Entry Record =======================================================

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 with
Image Added

Journal Entry Import Validation

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

1. Next journal period must exist.
2. Next journal period must belong to the same journal location as the manual journal posting period.
3. Next journal period must be active.

Failed validation will prevent posting the manual journal and display "K" error code with message "NEXT JOURNAL PERIOD NOT FOUND (OR NOT ACTIVE)".

Sample Import Report with Validation Errors
Image Added