Company Info

Sage 100 Contractor 1-3 Journal Transactions

Overview:

Import Journal Transactions directly into Sage 100 Contractor. Simply download your journal transactions into Excel, review and apply journal transaction information and import directly into Sage 100 Contractor 1-3 Journal Transactions.

Are you tired of manually keying in Journal Transactions one by one into Sage 100 Contractor? Would you rather download your journal transactions, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 1-3 Journal Transactions data entry form.

Key Features:

Import Template Download:

Import File Layout:

COL1RequiredGLJE(File Type Code)
COL2RequiredH(Header Record)
COL3RequiredString (20)123_abcJournal Number
COL4Requireddate2018-01-05Journal Accounting Date
COL5RequiredString (50)Test Journal EntryJournal Description
COL6RequiredNumeric1=Open; 2=ClearedJournal Status
COL7**String (20)Purch Order No
COL8**Numeric0=Adjust;1=Check;2=DepBank Category
COL9**NumericVendor Recnum
COL10String (50)payee1
COL11String (50)payee2
COL12String (50)addrs1
COL13String (50)addrs2
COL14String (50)ctynme
COL15String (2)state_
COL16String (10)zipcde
COL17String (50)usrdf1
COL18String (50)usrdf2
COL19TextNotes


Detail Layout
COL1RequiredGLJE(File Type Code)
COL2RequiredD(Detail Record)
COL3RequiredString (20)Journal Number
COL4Required **NumericLedger Acct Recnum
COL5**NumericSub Account Recnum
COL6String (50)Line Description
COL7NumericDebit Amount
COL8NumericCredit Amount
COL9String (50)User Defined 1
COL10String (20)Direct Exp *Workorder No
COL11**NumericDirect Exp *Job No
COL12**NumericDirect Exp *Phase No
COL13String (50)Direct Exp *Description
COL14**NumericDirect Exp *Cost Code
COL15**NumericDirect Exp *1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9Cost Type
COL16TextDirect Exp *Notes
COL17**NumericEquip Exp **Equip No
COL18String (50)Equip Exp **Description
COL19**NumericEquip Exp **Cost Code
COL20**NumericEquip Exp **1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9Cost Type
COL21TextEquip Exp **Notes

Direct Exp* - Required if the lgract (Col 4) is assigned to [13 - Direct Expense] account type
Equip Exp** - Required if the lgract (Col 4) is assigned to [14 - Equip/Shop Expense] account type

File Example:
GLJE,H,123,2018-01-05,"Test, Journal Entry ",1,,,,,,,,,,,,,,,
GLJE,D,123,1,2001,,500.00,,,,,,,,,,,,,,
GLJE,D,123,2,5001,,,250.00,,,2017504,"test line",,2030.000,2,,,,,,
GLJE,D,123,2,5601,,,250.00,,,,,,,,,1,test,2030.000,1,

REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite