Search results for query: *

yes, it is the aribd table. Thanks for the info.

Anyone know what the acceptable values of the TAXSTTS1 in the accpac 5.1 import file are and what they indicate to accpac when importing?

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

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

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...

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.

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!!

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...

This is a little late, but I had a similar problem when I installed Mandrake. I have two hard disks, one with windows and one with linux and when I booted it would go right to windows with out asking me which OS to load. It turned out that I had to change the boot sequence in the bios to boot...

I have two sound cards. one on my motherboard and one in a PCI slot. I am running mandrake 9.2 Both cards are detected but the system is using the one on the motherboard and I want to use the one that I have in the PCI slot. How do I tell linux which sound card I want to use? Do I have to...

that works great with access, but not so good with sql server. any ideas on how to do it with sql server?

i have a database with a column called custnum of type char. if i have the following customer numbers in the database: 1 2 3 4 5 6 7 8 9 10 then it is stored like this in the table: 1 10 2 3 4 5 6 7 8 9 i am trying to get the highest custnum so far so that when a user is adding a new customer...

i have a table with a string column called custnum. the customer number can be alphanumeric. if i have customer numbers 1,2,3,4,5,6,7,8,9,10 and i run the following query: select max(custnum) as newnum from dbo_customers where type_cd = "C" and isnumeric(custnum); then i get a data...

I have two excel spreadsheets and there are three columns that I need to have match in both sheets. I have columns for sec salesman, sec custname, sec custloc for an invoice number. some of the rows are filled in and some are blank. on a second sheet I have the same thing, but the information...