Hi,

Here is the screenshot of the job and the first 10 rows of the source data.

Thanks,
Aditya

JE Line Creation Date,JE Batch Name,Entity,Account,Dept,SubDept,Batch Status,Je Line Num,Entered Dr,Entered Cr,JE Line Description,Vend Nm/Inv Batch No/Line Type Ref 1,Invoice_Id - Ref 2,Invoice Dist No/PO/Req Hdr ID - Ref 3,PO Num/Req Num/Check Num - Ref 4,Invoice Num/Req Hdr Desc - Ref 5,Je Category Name,Je Source Name,User Name,Batch Default Period Name,JE Header Posted Date,Je Header Je Source,Gl Header Description,Actual Flag,Header Period Name,Net Change,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,Attribute7,Attribute8,Attribute9,No1,Reference 6,Reference 7,Reference 8,Reference 9,Reference 10,Line Type Code,Full Name
10/2/2007 16:41,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788202: A 2588265,15,10100,0,0,P,2,1234,0,Lockbox Acct#747480044 9/24/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788202:,A,9/7/2008,1234,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:41,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788202: A 2588265,15,10100,0,0,P,1,4321,0,Lockbox Acct#747480044 9/7/07 to 9/21/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788202:,A,9/7/2008,4321,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/9/2007 10:32,MCW-093007-Reclass Cash Balance Spreadsheet 10863912: A 2604782,15,10100,0,0,P,1,0,2345678,Reclass Cash Balance,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/9/2007 12:30,Spreadsheet,Journal Import 10863912:,A,9/7/2008,2345678,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/4/2007 14:15,MCW-093007-To relieve AmEx and Discover R Spreadsheet 10817592: A 2596659,15,10200,0,0,P,3,5678,0,Account -0051 from 9/20/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/4/2007 16:30,Spreadsheet,Journal Import 10817592:,A,9/7/2008,5678,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/4/2007 14:15,MCW-093007-To relieve AmEx and Discover R Spreadsheet 10817592: A 2596659,15,10200,0,0,P,1,3456,0,Account -0085 from 9/21/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/4/2007 16:30,Spreadsheet,Journal Import 10817592:,A,9/7/2008,3456,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:41,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788202: A 2588265,15,10200,0,0,P,3,0,1234567,Cash Receipts from 9/24/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788202:,A,9/7/2008,1234567,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:43,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788231: A 2588283,15,10200,0,0,P,1,1234567,0,Cash Receipts from 9/24/07 to 9/28/07 Orig. post to wrong acct.,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788231:,A,9/7/2008,1234567,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:45,MCW-093007-JE #2 C Card Acct Recv Spreadsheet 10788251: A 2588295,15,10200,0,0,P,1,1234567,0,Cash received from 9/24/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788251:,A,9/7/2008,1234567,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:45,MCW-093007-JE #2 C Card Acct Recv Spreadsheet 10788251: A 2588295,15,10200,0,0,P,2,3456789,0,Cash received from 9/4/07 to 9/21/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788251:,A,9/7/2008,3456789,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/9/2007 13:06,MCW-093007-JE #3 C Card Disbursement Spreadsheet 10866403: A 2605291,15,10200,0,0,P,1,0,654321,Exhb Payments WE 09/23/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/9/2007 13:12,Spreadsheet,Journal Import 10866403:,A,9/7/2008,654321,,,,,,,,,,,,,,,,,"Wolf, Michelle"

Last edited by aaddiitt (2008-05-06 20:55:51)