How to rebuild the Dynamics GP UPR00900 table

Just spent 4 hours trying to figure out the formula for the UPR00900.SUTAWAGS column, then had a casual conversation with a CPA at lunchtime, and he just spit out "wages minus sheltered deductions". And I just did a facepalm. Query here: 

http://dyndeveloper.com/DynColumn.aspx?TableName=UPR00900 

In order to reconcile, follow the path below. This will rebuild the table. Be sure to check the 'reconcile' check box. Understand that the SUTAWAGS field will rebuild based on the SUTASTAT field in UPR30300. I had to repopulate this field correctly to get the SUTAWAGS to rebuild correctly.

 

 

 


RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences