View source for Import G/L Transactions

This option imports G/L transactions into a Keystone G/L Batch where it can be editited and posted.  Optionally Job Cost fields can also be imported.


== Standard Import Format ==

:'''GLAccount''' <String 20>
:'''TrxDate''' < mm/dd/yy>
:'''RefNo''' This is ignored
:'''CheckNo''' <0 or check number>
:'''TrxAmount''' <numeric>
:'''SourceCode''' <String 2>
:'''Description1''' <String 35>
:'''Description2''' <String 35>
:'''Job ID'''  <String 20 - Optional - Requires Budget Category and Tranaction Type>
:'''Budget Category'''
:'''Transaction Type'''
:'''Asset''' <Optional when Job fields are used>

==Sample File==
<PRE>
"G/L ACCOUNT","TRANS DATE","REF NO.","CHECK NO.","TRANS AMT","SOURCE CODE","DESCRIPTION","DESCRIPTION2","JOB ID","BUD CAT","TRX TYPE","ASSET"
"718.00","11/29/02",0,0,-137.5,"PR","401K DED"
"718.00","11/29/02",0,0,34.38,"PR","CO 401K"
"647.00","11/29/02",0,0,-400.25,"PR","MEDICAL"
"645.00","11/29/02",0,0,-102.3,"PR","FICA"
"645.00","11/29/02",0,0,71.99,"PR","KSsutaEX"
"645.00","11/29/02",0,0,9.6,"PR","FUTA EXP"
"645.00","11/29/02",0,0,102.3,"PR","CFICA EX"
"639.00","11/29/02",0,0,1737.5,"PR","GROSS PY"
"220.00","11/29/02",0,0,-71.99,"PR","KSsutaWH"
"220.00","11/29/02",0,0,-9.6,"PR","FUTA W/H"
"215.00","11/29/02",0,0,-46.74,"PR","KS TAX"
"212.00","11/29/02",0,0,-94.72,"PR","FED TAX"
"212.00","11/29/02",0,0,-102.3,"PR","CFICA PB"
"110.00","11/29/02",0,0,-955.99,"PR","NET PAY"
</PRE>

Sample with Job Cost:
<PRE>
"822.10","11/29/02",0,0,1400,"TIRES","Trk 22","T22","MAINT","PARTS"
"822.10","11/29/02",0,0,1400,"TIRES","Trk 22","T16","MAINT","PARTS","3MT168"
</PRE>