Tax Code Report not showing correct sales amnt

[leishad]

Macola SQL Progression 7.6.400b
Setup for tax schedules

I have a sales invoice with a sales amnt of 314.72 The tax code report only shows 100.00 in the sales amnt field (in this case it is a non taxable client so taxable amount is correct at $0 and there is non-taxable freight which also shows properly).
In order to narrow down my search I checked for past invoices with the same cus_no, tax_sched, item_no to see if this was 'normal', however past invoices (within a few days) behaved as expected.
In my mind I have eliminated the above fields from further consideration as sources of the problem -- does anyone have any idea what else might cause this issue?

 

[dgillz]

Are each of the line items taxable? Are all the line items on the order actually in the item master or do you have service codes or non-items on the order?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[leishad]

All items are taxable and in item master. I can look at 2 different invoices that are alike in item_no, cus_no, tax_sched and they do not both behave in this manner as far as the tax code report is concerned.

 

[leishad]

I have looked into the sytaxhst table and just did a search on $0 sale amounts and see that there are many times over history that this occurs (when the sale amount is not $0). When setting up tax codes/schedules are there conditions that would account for this? I CAN think of reasons to do it I just need to know the logical conditions that account for it.

 

[dgillz]

This is pretty strange. Can you recreate this at will?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[leishad]

That will be my next approach --- when I determine the cause(positive thinking) I will post results here.

 

[leishad]

While I continue to work on this I realize that I failed to mention that the tax schedule is made up of 4 tax codes, 3 of which show the proper sale amount for the invoice and only 1 that does not.

 

[dgillz]

I have tried to recreate this but I can't.

Please confirm that the individual tax codes that make up this tax schedule are on file and they have the tax method set to P-percentage of sales/purchase amount.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[leishad]

Well, as would not be surprising I found multiple sources of the problem -- and then learned a few additional things along the way.

1) One of the tax codes was not listed in the master tax schedule.
2) Several items did not have a tax schedule associated with them (which led to the discovery that setting a default value in the tax schedule box does nothing and setting a value in the value list will display the number but won't save it unless you actually tab thru the field, this can only be discovered by looking in the underlying table because the screen will always display the number from the value list even though it won't save it.)
3) Several customers did not have their taxable flag checked. (When using tax schedules it is the schedule that determines the tax so even though the customer is non-taxable you must still check the taxable box in order for the program to reference your tax schedule. This is not very intuitive so often there is operator error. I have resolved this by setting the taxable flag to default to yes, I then hid it and replaced the exempt_no field (which is disabled when the tax flag is yes) with a user_def_fld. I think that should do it.)