Just because the customer receives a value from your 3rd party system does not make it correct.  We have seen many cases where other systems calculate incorrect tax amounts but we do understand that what the customer receives and what was paid for and what must be used.

I think that it would be best to take this discussion offline.  We can post the solution once we have one.

Please submit your details to support@aaatex.com

Please include
1. Your QB version, Year, Country, etc.
2. The file that you are importing with the error
3. A screen images of the QB transaction with the incorrect tax amount.
4. The config settings file (i.e. TransImporter.ini) in our working folder.

The 'more correct' one is the 3rd party one as it is the invoice values that the customer receives.  We are importing the invoice with its reference number into quickbooks for accounting purposes and tax purposes.  We can't really tolerate the difference as it defeats the purpose of the import for our accounts guy to manually check each invoice after the fact.  My ideal solution is to have quickbooks take the tax value from the import file.  Alternatively, we need to find a way to automate comparing the two values so we don't have to manually check each invoice.

Each month we get approximately 3/100 transactions with this error.  We expect this part of our business to grow so the number of this transactions will increase over time.  I believe it's due to the number of decimal places quickbooks uses for its tax calculation in comparison to the number of decimal places our 3rd party supplier uses.

There is nothing in the TransImporter to accumate the tracking #s on each line and append them to the memo field or even to use multiple columns to be concatenated as is done in the memo field. If that is how you have it.

We could customize the program to do so but you would have to discuss that with sales@aaatex.com.

Hi

On the Additional Settings - Trans Types tab (Bld 1.1.95 is about 2 years old and the tab might have changed a bit) there are radio buttons and check boxes for which transaction type you need to import i.e. Invoice, Bill, etc.  You would need to make the appropriate settings.

I am not familar with the the message 'only set up to import on the AP module' in the TransImporter.  Perhaps there was a different message???

Currently our team is using Transporter Bld 1.1.95 Pro for our AP Module and have had no problem importing from excel.  We are now trying to set up our AR side for importing but are getting a message that says we are only set up to import on the AP module.  What do we need to do to be able to import for AR?

Thanks!

Question:
 Hi, we have purchased transimporter Basic version. We currently have a 3rd party do some of our billing and we need to import their transactions into quickbooks. I have most of this working well, but the 3rd party company sometimes calculates the tax on a transaction to be 1 cent less than quickbooks.

Response:
Taxes can be complex in QB

The only way to get the taxes to appear correctly at the bottom of the transaction in QB is by letting QB calculate it. (Just the way that QB works). In other programs and in other files taxes can be entered via a line item.  It would not be on the bottom of the transaction but in the body as a line item.   It is not clear that this would work for you.

Which would you consider to be 'more correct' the QB tax calculation or the 3rd party file?

How many of these do you get?

Can you accept the 1 cent difference?

How many of these would there be?
A Limit of 10 would suffice, but a strategy for over 10 cartons would be invaluable.
Would the tracking #s be tied to a product or item?
No, the cartons contain assorted items.
Does the customer see the sales transactions (i.e. Invoice or sales receipt, etc.)?
Yes.(The Invoice)
Can the tracking # be put on the item line?
No, multiple Unique Items are packed into a single carton.

 
 
 
 

Some Questions:

How many of these would there be?
Would the tracking #s be tied to a product or item?
Does the customer see the sales transactions (i.e. Invoice or sales receipt, etc.)?
Can the tracking # be put on the item line?

How can I Import multiple UPS Tracking Numbers, per invoice record,  into Quickbooks via flat file? Has anyone had experience in performing this task?

Another customer called with the same problem.

It appears that for some reason the signing certificate was bad.

We rebuilt the update (without any changes) and uploaded it to our web site.

This did work on the customer who called.

Please try
1.  In QB Admin Single user mode,  menu Edit, Preferences, Integrated Applicatations
REMOVE AaaTeXShoppingCartIntegrator
2.  Download and run the update
www.AaaTeX.com/downloads/AaaTeXShoppingCartIntegratorUpdate.exe
3.  Start the Integrator (Still in QB Admin mode) since you will have to re-authorize the program.

Sorry for the inconvience.  Not sure what happened. It may have been a file transmission upload problem.  Just don't know.