Wednesday, April 13, 2011

Lesson Learned- Importing Tax Details

Last week, a client asked if they needed to manually set up 100 tax details in Dynamics GP.  We are in the testing phase, so I knew it wasn't a matter of setting these up once...but twice if we did it manually (for the live database and for the test database, which couldn't be restored at that point due to other dependencies and testing).  So I did what I shouldn't have done.  I said, "Sure, we can do a quick table import".  Now, to be clear, the issue is not using table import.  It is that I used the work "quick".  (For those of you not familiar with table import, Mariano Gomez has a great blog post on the subject.)

So I took a "quick" look and imported the tax info to the Sales/Purchases Tax Master (TX00201).  When importing to this table (first lesson learned), first set up a record manually so you can see the proper settings for all fields (there are many that are not obvious and need to have the correct defaults set in the import).  Well, that was quick.  One table, check links (Microsoft Dynamics GP, Maintenance, Checklinks, Company), done.

Well, not so quick.  When users entered transactions using the tax details, all went fine.  But when they tried to post (even though there were no errors on the edit list), the posting journal would return "detail" errors and the batch would be sent to batch recovery.  And when we tried to manually delete the tax details through GP, we would get "record locked" errors.  Ugh.  Ugh.  Ugh.

Hunting.  And berating myself for not being more measured about it.  And then I found the Sales/Purchases Tax Summary Master (TX00202).  Ah-ha.  For every record saved in the TX00201, a record is also created in the TX00202.  So I needed two table imports, not one.  The TX00202 is a rather simple table storing historical summary information.  Easy to populate, but again, check an entry that has been made directly in GP to determine how to correctly populate the fields with defaults in the TX00202 table.

Good luck, hope a few of you can learn from my mistake!

Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional. She is a supervising consultant with BKD Technologies, providing training, support, and project management services to new and existing Microsoft Dynamics customers.


McNulty said...

Running the Company Check Links option for Sales/Purchases Tax Master achieves the goal of having the TX00202 table updated with the results found in TX00201 table

Christina Phillips said...

Thanks! Great quick way to accomplish the same thing :)

Mark Polino said...

Thank you Christina and McNulty. This saved my bacon today.


Christina Phillips said...

Happy to save your bacon any day, Mark!

TLCinNM said...

This is very helpful! I am about to embark on this exact scenario. Thank you for the great post!!

Tammy Chavez