Record type 1 is what is controlling whether the batch is saved or not.

If the record looks like  1|GJNLA|10052007|| it does not have a batch name and description and will not go to the Imported batches folder, but will post directly to GL and create a trace report with the 10/05/2007 posting date.

If the record looks like   1|GJNLA|10052007|JPM|J1 it will go to the Imported batches folder, but will post to the business date the user is on when they post it, not the date that was in this header record.

To bring items in seperately, the file would look similar to this:

DIV=95
1|GJNLA|10052007||
2|A0100002010
3|Holiday Inns & Suites|JPMORGAN|||176.85-||
4|A0100006110|Holiday Inns & Suites1|JPMORGAN1|||176.85
1|GJNLA|10102007||
2|A0100002010
3|Walmart|JPMORGAN|||54.93-|||
4|A0100006110|Walmart|JPMORGAN|||54.93
1|GJNLA|10152007||
2|A0100002010
3|Barnes & Noble|JPMORGAN|||21.95-|||
4|A0100006110|Barnes & Noble|JPMORGAN|||21.95
1|GJNLA|10202007||
2|A0100002010
3|Duffy's Lawncare|JPMORGAN|||1026.00-|||
4|A0100006110|Duffy's Lawncare|JPMORGAN|||1026.00

Note there are 4 records with a type 1 on them, each with different dates. This will generate 4 seperate trace reports, each posting on the date indicated on the type 1 record.

To bring in records with several items on 1 date, and others on a 2nd date, the same file would look like this:

DIV=95
1|GJNLA|10052007||
2|A0100002010
3|Holiday Inns & Suites|JPMORGAN|||176.85-||
4|A0100006110|Holiday Inns & Suites1|JPMORGAN1|||176.85
2|A0100002010
3|Walmart|JPMORGAN|||54.93-|||
4|A0100006110|Walmart|JPMORGAN|||54.93
2|A0100002010
3|Barnes & Noble|JPMORGAN|||21.95-|||
4|A0100006110|Barnes & Noble|JPMORGAN|||21.95
1|GJNLA|10202007||
2|A0100002010
3|Duffy's Lawncare|JPMORGAN|||1026.00-|||
4|A0100006110|Duffy's Lawncare|JPMORGAN|||1026.00

Note there are 2 records with a type 1 on them, each with different dates. This will generate 2 seperate trace reports, with each record posting on the date indicated on the type 1 record that is above record types 2,3 and 4.

If the GL entries are imported into the Imported Batch folder, the Saved date shows blank. Whatever business date the user is on when they select a batch to post, is what will be used.

If we were able to change some of the behavior of the imported journal folder, to put in the date that is in the type 1 record, when the user tried to post the entries, it would ask  for every single one if it should post on the current date or the one that was in the batch already.  The date functionality is not a problem when imports do not have multiple dates, as the user can just pick whatever date they want to post by using that business date.

Everything works as needed as long as the user does not save the entries, but allows them to post directly into the GL.  Any prior editing needed would be done through the import file itself. If there is a critical error, such as an entry is out of balance, it will not pass the error checking that is performed on all imports.

 

Additional note:

This method of bringing in multiple dates in one import file does not work in Accounts Payable. Each module has it's own rules of how the entries can be brought into the system.