Field descriptions on export file 1

[CSdjohnson]

Anyone know where I can get free information on field relationships in the accpac 5.0 export/import csv file? I am writing an export from a rental package my company developed to be imported into accpac. I have a csv file generated by accpac but can not find any information on what all the columns are used for in accpac.
Accpac is calculating taxes for my customer but certain line items I am exporting should not be taxed. I am trying to find out what flags I need to set to let accpac know not to calculate tax for these lines. I set the amttxbl to zero for lines i don't want tax to be charged for but accpacc still calculates tax for them when I import it.
I would be grateful for any insight

 

[jayconverse]

Assuming you're talking about A/R, try setting ARIBH.SWMANTX (Do Not Calc. Tax) to 1.

Jay Converse
IT Director
Systemlink, Inc.

 

[CSdjohnson]

This looks to be a field in the header. If I flag it won't that cause accpac to not calculate tax for all line items? Is there a per line flag?

P.S. it is AR that I am trying to import into.

Thanks for input!!

 

[jayconverse]

Yes, that's in the header. For the details only, try using the SWMANLTX field. "1" should mean "Do not calculate", but the documentation I have isn't clear, it says "Reserved" for that field.

Jay Converse
IT Director
Systemlink, Inc.

 

[CSdjohnson]

I was confused at first, but looking over my posts I see that I said accpac 5.0. I am actually trying to do this for accpac 5.1. Sorry for the confusion. I do not see the SWMANLTX in the 5.1 export file. Is it called something different?

Thank you for all the help so far.

 

[jayconverse]

Nope, it's there in all versions from 5.0 and forward.

Jay Converse
IT Director
Systemlink, Inc.

 

[CSdjohnson]

This is the export file that I am creating from the rental package. I want to tax everything but the BC PROVINCIAL SALES TAX which should give me a tax base of 37780.00. When I import into accpac it gets a tax base of a little over 39000. Do I need to send over BASETAX1 also?

RECTYPE CNTBTCH CNTITEM IDCUST IDINVC TEXTTRX DATEINVC FISCYR FISCPER TERMCODE DATEDUE CODETAXGRP
RECTYPE CNTBTCH CNTITEM CNTLINE TEXTDESC AMTEXTN TAXSTTS1 IDACCTREV AMTTXBL SWTAXINCL1
RECTYPE CNTBTCH CNTITEM CNTPAYM DATEDUE AMTDUE
1 1 1 1100 7011072 1 20060119 2006 1 N30 20060218 ALTA
2 1 1 20 BC PROVINCIAL SALES TAX 1925 2 3350-010 0 1
2 1 1 40 12' X 56' WELLSITE TRAILER 8580 2 4005-070 8580 0
2 1 1 60 GEO LAB 5940 2 4009-070 5940 0
2 1 1 80 ENG/ENG WELLSITE 9460 2 4010-070 9460 0
2 1 1 100 ENG/ENG WELLSITE 9460 2 4010-070 9460 0
2 1 1 120 FLOC TANK 3740 2 4055-070 3740 0
2 1 1 140 TANK SERVICE & CLEANING 350 2 4390-070 350 0
2 1 1 160 ENVIRO LEVY 250 2 4425-070 250 0
3 1 1 1 20060218 42349.6

 

[jayconverse]

Wait a minute... You're importing the tax amount, too? That tells me you want nothing taxed.

Jay Converse
IT Director
Systemlink, Inc.

 

[CSdjohnson]

I'm not sure I am following. If I want accpac to calculate tax on everything but the the 1925 which columns should I include/remove?

I thank you for the input.

-Daniel

 

[CSdjohnson]

Hey Joe,

Thanks for all the help. I found an object model for accpac 5.1. Now it makes a lot more sense to me.

-Daniel