Vision integration
1. Users enter job costing info into Vision.
2. Vision would provide an export that the output matches with our "Time America" paycard import layout (to be used in Payroll...Process paycards, Batch Payroll.
3. Once the payroll is posted. Users would use our product to export the gl entries into Vision either as journal entry transations and/or as cash disbursement transations.
Import layout for Vision's journal entry transactions:
Reference Number (from GL parameters screen)
Batch Date (from Preferences screen)
Master Description (from GL parameters screen)
Post Type (from GL parameters screen)
WBS1 (from GL parameters screen)
? unused ?
GL account number
debit amt
credit amt
Category name
sample:
ref,031108 ,mas,P,wbs1,,Bank Fees,,1514.92,Canada pension plan
Import layout for Vision's cash disbursement transactions:
Bank Code (from GL parameters screen)
Batch Date (from Preferences screen)
Payee (from GL parameters screen)
? unused ?
WBS1 (from GL parameters screen)
? unused ?
GL account number
debit amt
credit amt
Category name
sample:
Corporate,031108 ,ABCD,,wbs1,,Bank Fees,,1514.92,Canada pension plan
Both files are created as csv files, detail lines only (no header or trailer records are required).