Sample format for an import acceptable with Accpac

[hushman]

hi Guys

can anyone help me with the sample csv GL import format to import into accpac .

 

[ajwonder]

Hi hushman,

The easiest will be to export from the sample database. That will give you the exact file you require, together with relevant data.

 

[Jay Converse]

RECTYPE","BATCHID","BTCHENTRY","SRCELEDGER","SRCETYPE","JRNLDESC","DATEENTRY"
"RECTYPE","BATCHNBR","JOURNALID","TRANSNBR","ACCTID","TRANSAMT","TRANSDESC","TRANSREF","COMMENT"
"RECTYPE","BATCHNBR","JOURNALID","TRANSNBR","OPTFIELD","VALUE"
"1","1","1","GL","JE","mybatch",20160620
"2","1","1","1","11120",-48.3,"Description","Reference","Comment"
"2","1","1","1","11120",1048.3,"Description","Reference","Comment"
"2","1","1","1","11120",-1000,"Description","Reference","Comment"