Brief background:
We are moving from pricing procedure TAXUS to TAXUSJ, non-jurisdiction to jurisdiction method for calculating sales tax. We have run into a few issues on the SD side when creating credit memos or reversing documents that were originally created in pre-jursidction system. Had to update a couple of fields in a couple of tables with tax jursidiction code info...
Now for the RE-FX side of the house...
Now, the issue occurs when we try to reverse (rerapprv) an invoice that was created pre-jurisdiction. The error is that there is a field, somewhere, that requires a tax jurisdiction code, but it is blank because it was built before we turned on jurisdiction. What I believe is happening is that it is using the invoice record, finding the txjcd field empty and therefore erroring out. What I donu2019t know is just where that record might be found. I really hate updating existing records, but I think this is the only way to get around those documents that are going to cross the threshold so to speak.
I have tried adding jurisdiction codes (txjcd) to the bseg and bset tables for the document as well as the viradocitem table. No luck so far. What did occur is that the error changed to need tax jurisdiction code to the condition type AR1 is not valid for the tax code (Old pricing procedure used AR1 where the new on uses JR1 for state level tax).
Has anyone else run into issues like this? Has anyone moved from non-jurisdiction to jurisdiction pricing? Seems to me there is a config item or something else I'm mayble overlooking?
Any help or ideas is greatly appreciated!
Thanks
Laurie McGinley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.