Hello
I'm having an issue importing data into ACCPAC 5.4A SP3. I'm working with code created by someone else and I'm not too sure what the layout of the CSV file is supposed to be. The file seems okay but when I try and import it I get the following error:
Invoice total amount [910.02] does not match payment schedule total [910.01]. Correct the payment amounts in the payment schedule or the item detail lines.
The file looks as follows:
RECTYPE,CNTBTCH,CNTITEM,IDCUST,IDINVC,SPECINST,ORDRNBR,CUSTPO,INVCDESC,IDACCTSET,DATEINVC,DATEASOF,TERMCODE,CODETAXGRP,CODETAX1,BASETAX1,AMTTXBL,AMTTAXTOT,AMTINVCTOT,AMTPYMSCHD,AMTNETTOT,DATERATE,AMTDUE,AMTDSCBASE,SRCEAPPL
RECTYPE,CNTBTCH,CNTITEM,CNTLINE,IDITEM,TEXTDESC,UNITMEAS,QTYINVC,AMTCOST,AMTPRIC,AMTEXTN,AMTCOGS,TOTTAX,BASETAX1,TAXSTTS1,RATETAX1,COMMENT,SWPRTSTMT,,,,,,,
RECTYPE,CNTBTCH,CNTITEM,CNTPAYM,DATEDUE,AMTDUE,DATEDISC,AMTDISC,,,,,,,,,,,,,,,,,
RECTYPE,CNTBTCH,CNTITEM,OPTFIELD,VALUE,TYPE,LENGTH,DECIMALS,ALLOWNULL,VALIDATE,VALINDEX,VALIFTEXT,VALIFMONEY,VALIFNUM,VALIFLONG,VALIFBOOL,VALIFDATE,VALIFTIME,FDESC,VDESC,,,,,
RECTYPE,CNTBTCH,CNTITEM,CNTLINE,OPTFIELD,VALUE,TYPE,LENGTH,DECIMALS,ALLOWNULL,VALIDATE,VALINDEX,VALIFTEXT,VALIFMONEY,VALIFNUM,VALIFLONG,VALIFBOOL,VALIFDATE,VALIFTIME,FDESC,VDESC,,,,
1,1,1,D0019,***NEW***,LABOUR CHARGES,,,W/END 17/08/2008,1,20080817,20080817,COD,VAT,VAT,798.26,798.26,111.75,798.26,910.01,910.01,20080817,910.01,910.01,AR
2,1,1,20,PP_HRS,TEMP POSITION: 2500,HRS,40.5,0,19.71,798.26,0,111.75,798.26,2,14,MKJEA HW - Normal Hours,1,,,,,,,
3,1,1,1,20080817,910.01,,0,,,,,,,,,,,,,,,,,
The file seems to have the right detail and balance amounts but it looks to me like ACCPAC does it's own calculations.
I'm not an ACCPAC guru by any means and I won't pretend to understand the import file format.
Any assistance will be greatly appreciated.
Cheers
Rob
South Africa
I'm having an issue importing data into ACCPAC 5.4A SP3. I'm working with code created by someone else and I'm not too sure what the layout of the CSV file is supposed to be. The file seems okay but when I try and import it I get the following error:
Invoice total amount [910.02] does not match payment schedule total [910.01]. Correct the payment amounts in the payment schedule or the item detail lines.
The file looks as follows:
RECTYPE,CNTBTCH,CNTITEM,IDCUST,IDINVC,SPECINST,ORDRNBR,CUSTPO,INVCDESC,IDACCTSET,DATEINVC,DATEASOF,TERMCODE,CODETAXGRP,CODETAX1,BASETAX1,AMTTXBL,AMTTAXTOT,AMTINVCTOT,AMTPYMSCHD,AMTNETTOT,DATERATE,AMTDUE,AMTDSCBASE,SRCEAPPL
RECTYPE,CNTBTCH,CNTITEM,CNTLINE,IDITEM,TEXTDESC,UNITMEAS,QTYINVC,AMTCOST,AMTPRIC,AMTEXTN,AMTCOGS,TOTTAX,BASETAX1,TAXSTTS1,RATETAX1,COMMENT,SWPRTSTMT,,,,,,,
RECTYPE,CNTBTCH,CNTITEM,CNTPAYM,DATEDUE,AMTDUE,DATEDISC,AMTDISC,,,,,,,,,,,,,,,,,
RECTYPE,CNTBTCH,CNTITEM,OPTFIELD,VALUE,TYPE,LENGTH,DECIMALS,ALLOWNULL,VALIDATE,VALINDEX,VALIFTEXT,VALIFMONEY,VALIFNUM,VALIFLONG,VALIFBOOL,VALIFDATE,VALIFTIME,FDESC,VDESC,,,,,
RECTYPE,CNTBTCH,CNTITEM,CNTLINE,OPTFIELD,VALUE,TYPE,LENGTH,DECIMALS,ALLOWNULL,VALIDATE,VALINDEX,VALIFTEXT,VALIFMONEY,VALIFNUM,VALIFLONG,VALIFBOOL,VALIFDATE,VALIFTIME,FDESC,VDESC,,,,
1,1,1,D0019,***NEW***,LABOUR CHARGES,,,W/END 17/08/2008,1,20080817,20080817,COD,VAT,VAT,798.26,798.26,111.75,798.26,910.01,910.01,20080817,910.01,910.01,AR
2,1,1,20,PP_HRS,TEMP POSITION: 2500,HRS,40.5,0,19.71,798.26,0,111.75,798.26,2,14,MKJEA HW - Normal Hours,1,,,,,,,
3,1,1,1,20080817,910.01,,0,,,,,,,,,,,,,,,,,
The file seems to have the right detail and balance amounts but it looks to me like ACCPAC does it's own calculations.
I'm not an ACCPAC guru by any means and I won't pretend to understand the import file format.
Any assistance will be greatly appreciated.
Cheers
Rob
South Africa