Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Updating Tax Schedule ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Updating Tax Schedule ID with Tax Details - Mass Update

(0) ShareShare
ReportReport
Posted on by Kristie McNulty 977
We have nearly 40K tax details which need to be associated to one of two tax schedule IDs in our GP 18.5 environment.  All of the tax details are created.  Both of the tax schedule IDs are created.  Is it okay for me to update the TX00102 by inserting the tax detail IDs so they are associated to their corresponding tax schedule ID using SQL?  If yes, are there any post insert steps (e.g., check links) I should perform?
Categories:
Microsoft Dynamics GP
  • Kristie McNulty Profile Picture
    Kristie McNulty 977 on at
    Updating Tax Schedule ID with Tax Details - Mass Update
    Hi Sandipdjadhav,
     
    Unfortunately, the window's ability to develop a usable MACRO does not appear to be an option because I cannot select a specific tax detail ID, but rather, the MACRO records the line I selected for the insert step, as shown here in the script created in the .mac file:
    # Key 1: 
      MoveTo line 7 browsewin 'Tax_Detail_Scroll' 
      MoveTo field 'Insert Button' 
      ClickHit field 'Insert Button' 
    # Key 1: 
      MoveTo line 13 browsewin 'Tax_Detail_Scroll' 
      MoveTo field 'Insert Button' 
      ClickHit field 'Insert Button' 
    # Key 1: 
      MoveTo line 16 browsewin 'Tax_Detail_Scroll' 
      MoveTo field 'Insert Button' 
      ClickHit field 'Insert Button'
     
    I will try and extract out the data and number the rows and see if I can construct the MACRO in that manner, because SQL updates is not my first choice, for obvious reasons.  Thanks for taking the time to review and post to my question.
  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Updating Tax Schedule ID with Tax Details - Mass Update
    Hello Kristie,
    Can you try Macro with word mail merge? It will be easy and will follow all validation when it done from GP screen.
     
    Let me know how it goes.

    Thanks much
    Sandip

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans