[David david@winthropdc.com]

Up

0

Down

::

Hi David

You need to remove the VBA so you can recode the business logic using GP Power Tools. 😁

Your technique should work.

1) Import packages with VBA

2) Exit GP and delete all .VBA files.

3) Go back into GP and export packages without VBA.

My usual approach is actually to keep the VBA in a system until the GPPT scripts are written to replace each part and then remove the window from VBA. Once all the code has been converted, then delete the .VBA files to cleanup.

David

[David david@winthropdc.com]

Up

0

Down

::

Hi David

I would just install the 4.8.1 .Net Framework.

https://dotnet.microsoft.com/en-us/download/dotnet-framework/net481

v18.7 wants 4.6 and v18.8 was updated to 4.7.2.

Kind regards

David

[David david@winthropdc.com]

Up

0

Down

::

I know we could use GP Power Tools to send an email based on any event in GP using a custom development project.

[David david@winthropdc.com]

Up

0

Down

::

Hi David

We would be able to use GP Power Tools to debug this and find out when the next GL Journal number is being returned and is less than the previous value.

We can then add a trigger to prevent that from happening.

Kind regards

David

[David david@winthropdc.com]

Up

0

Down

::

Hi Richard

It is possible that the window is exempt from security.

If you have GP Power Tools, it will show you who has access to what and will identify if a window is exempt from security.

If the window is exempt, you can then use the Enhanced Security window to hide the menu option.

If you haven’t looked already, please what the Benefits Presentation:

• Benefits Presentation PowerPoint Presentation

Kind regards

David

[David david@winthropdc.com]

Up

1

Down

::

Have you checked that Security is enabled for all companies.

You need to check one by one looking at Tools >> Setup >> Company >> Company and make sure the Security checkbox is selected.

Or run this script on the DYNAMICS database to find the companies and update them if needed.

select CMPANYID, CMPNYNAM, USESCRTY from SY01500 where USESCRTY <> 1

–update USESCRTY = 1 from SY01500 where USESCRTY <> 1

Tasks and Roles do nothing unless Security is enabled.

If you have GP Power Tools installed, it will highlight companies without security enabled as a security risk.

[David david@winthropdc.com]

Up

0

Down

::

How are you planning to do the import?

What tool?

There are always methods available, but they depend on where the source data is and how you are importing.

Regards

David

[David david@winthropdc.com]

Up

0

Down

::

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

[David david@winthropdc.com]

Up

0

Down

::

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

[David david@winthropdc.com]

Up

0

Down

::

PS: I believe that the views as created in my article are better than the views created by extender as they better handle when data is missing.

[David david@winthropdc.com]

Up

0

Down

::

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

[David david@winthropdc.com]

Up

0

Down

::

Hi Calvin

I believe there is a tool in the Professional Services Tools Library (PSTL pronounced Pistol) that can return a transaction from history to open.

PSTL can be installed from the Dynamics GP DVD image as a dictionary module.

Hope this helps

Regards

David

[David david@winthropdc.com]

Up

0

Down

::

Has the Purchase order form been modified. I would check if the original version of the form prints the correct values.

It is possible that the report is set up incorrectly to format the decimal places incorrectly.

Regards

David

[David david@winthropdc.com]

Up

0

Down

::

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

[David david@winthropdc.com]

Up

0

Down

::

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