DDE and Salestaxcode

[saruch]

I am trying to automate entering invoices into 2002. I can get the salestaxcode to be entered but I cannot get it to compute the tax. Also I am trying to find out if an invoice number is already used but cannot figure out how to do it.

Thank you.

[SBTBILL]

You titled your post DDE and Salestax. That sounds like you are doing the invoices outside Peachtree. Where are you doing them? Access, EXCEL, VFP? I believe that you have to things in a specific order to make it work.

I've mainly used DDE for reports but am thinking of trying to do a bit more. The manual says you do not have to be a programmer. I am and I don't see it as easy.

Bill Couture
sbtbill@aol.com

[saruch]

I do create the invoices from outside peachtree. I have a custom access application that tracks projects and then enters the information into peachtree. The only thing that is not taking is the sales tax. The code gets entered in, but the tax does not calculate.

Shawn

[SBTBILL]

OK, here is a thought maybe it is the order the data is entered in? Also, maybe the sales tax has to be sepertely posted. This is going to the sales order Journal?

Bill Couture

[saruch]

According to the Peachtree DDE manual I am entering it in the right order. The salestax code gets into the invoice but it doesn't get calculate.

Shawn

[dringstrom]

In my experience, you have to calculate the sales tax outside of Peachtree. DDE works well for extracting transacations and other data from Peachtree, but it can be a frustrating means to enter transactions. I abandoned poking transactions over a long while back...I now alway create .CSV files that the user imports. It's a little more work for the user, but it works consistently every single time. Of course, you'd have to calculate the sales tax this way, also.