David Musgrave MVP, GPUG All Star, Community Legend
Forum Replies Created
-
The State Tax Summary report prints data from the uprCrossCompanyEmpMstrTemp3 temporary table only.
Without studying the source code that populates the temporary table I cannot confirm which tables that data comes from and I don’t know anything about US Payroll and how it works (other than it stores Employee data in the Employee Master table).
I would still suggest looking at data from the SQL level and seeing if you have values in the decimal places which are not shown on the reports (or Smartlist).
David
-
I would say that you have additional digits in some of your data that are not being shown on the report.
If you have data with non-zero numbers on the 3rd, 4th or 5th decimal place, they will not show on a report that is formatted to 2 decimal places but will be included in the total.
I would recommend checking the data at the SQL level or modifying the report to show all 5 decimal places so you can confirm.
Regards
David
-
Hi Howard
Also have a look at this article I wrote about creating views for extender data. These views can then be joined with other tables/views to create a new view and then added as a smartlist based on a SQL View.
https://winthropdc.wordpress.com/2009/02/05/creating-sql-views-of-extender-data/
Good luck
David
-
Hi Thomas
First of all, posting in summary is a legacy feature which goes back to the days when hard disk space was expensive. I would never recommend that nowadays as it makes it very difficult to reconcile GL to subsidiary modules such as RM/SOP and PM/POP.
History data for the PM module should be found in the PM_Paid_Transaction_HIST (PM30200) table and PM_Distribution_HIST (PM30600) table.
History data for the POP module should be found in the POP_ReceiptHist (POP30300) table and the POP_ReceiptLineHist (POP30310) table along with the POP_DistributionHist (POP30390).
Finally, The Table Finder is a tool in SmartList Builder and not available to all installs. In the same way GP Power Tools Resource Information and Resource Finder windows are only available from the Tools menu if the product is installed.
Hope this helps
David
-
Hi Raul
Creating a Service Procedure for use with SBA requires Dexterity. The DLL component is created automatically via the DAG.exe tool.
The security is handled by a Windows Active Directory account for logging in which is tied to a SQL account. Access to the particular Service Procedure is handled by the application level security.
Another option for you is to use GP Power Tools. The Developer Tools module has the ability to create custom Service Procedures which can be called externally or from within GP (via Dexterity, VSTools or GPPT). GPPT can also create custom URL Drill Backs and custom Report Writer (RW) functions.
We also have our Batch Posting Service Toolkit tool which can post batches via Web Service or direct calls.
If you need to get into more specifics, let me know as they are some tricks you will need to know to get SBA working for your own Dexterity products.
Kind regards
David
-
I would check with Integrity.
APR could be Advanced Pay Roll or something like that.
Also look at this Benefits Presentation
https://www.winthropdc.com/ftp/pub/GPPowerTools_Benefits.ppsx
You can easily fix your GP Power Tools deficiency.
Regards
David
-
You have a customization installed which will also need to be updated for the Year End update.
The trigger that is failing starts with APR, look at your installed products in the Dynamics.set and identify which product is named or written by APR.
If you have GP Power Tools, you can use the Resource Information window in Procedure mode and enter the trigger script’s name and it will identify which product the script is from.
Once you know the product, please contact the developer for more information.
One other possibility is that there is an alternate version of that window that is not enabled and so the URL field is missing. Best coding practice should prevent an illegal address error if an alternate window is not opened by security, either aborting the code or displaying a warning to change security settings. But maybe the developer has not followed best practices.
Regards
David
-
Hi Abdel
You are doing nothing wrong. Sadly, I have checked the source code and the original developer has not added a check for the required() function in the Scrolling window change script that does the saving.
So while you have correctly made the field required, there is nothing in the code to enforce the required fields.
You can use GP Power Tools Developer Tools to add a check for required fields and abort the save with the appropriate error message.
[Edit] I have passed the details of this bug back to Microsoft.
Kind regards
David
-
As an Australian, I have never worked with US Payroll.
However, the UPR_Transaction_HIST (UPR30300) and the UPR_Transaction_HIST_HDR (UPR30301) tables look like a good place to start.
If you look at the report in Report Writer you can confirm which tables are used for the data. What is the report name shown in the window titlebar when printing to the screen? Then I can confirm the tables on the report (assuming it is in core Dynamics.dic and not HR).
Can you tell smartlist to include all 5 decimal places? I have never tried.
David
