[Kerry Hataley]

Up

0

Down

::

All the detail information will be in the PA tables. Specifically PA30xxx for what I think you are trying to accomplish… but your references are very vague.

You are NOT telling us field names…

[Kerry Hataley]

Up

0

Down

::

Hi Deanne,

I am not sure of the question…

The GL should not have items in ‘WORK’ status from other sub-modules, only from the GL module.

Can you explain the business case you are trying to solve for?

[Kerry Hataley]

Up

0

Down

::

I am assuming you mean Dynamics GP 18.xx.

To make it a required field, you need to do a customization.

This can be completed with VBA (Assuming you are NOT on Web Client), using Dexterity code customization or use David’s GP Power Tools.

[Kerry Hataley]

Up

0

Down

::

Hi Stephanie,

You need to have both the “RED CLERK” and “RED MANAGER” assign in security roles.

[Kerry Hataley]

Up

0

Down

::

Hi Jim,

Notes are available now on the Summit 2023 site now, for those presenters that posted them. As for the recording, they will be available in a month or so.

[Kerry Hataley]

Up

0

Down

::

You need to contact Membership Inquiries, from the Contact Us Page…

https://dynamicscommunities.com/contact-us/

[Kerry Hataley]

Up

0

Down

::

Good Morning @david-morinellotruckpro-com

OK, I can replicate this, give me the weekend to try something…

It all has to do with the fact when calling the insert & deletes from the update trigger temp tables, the insert and delete need to be in a single sql statement using a JOIN.

I can have my solution on Monday for you…

[Kerry Hataley]

Up

0

Down

::

Looking at the code quickly, I think the issue is with the Primary Key for RM00101 an the order in which the DMLs are triggering.

Try changing the ‘for UPDATE’ to ‘AFTER UPDATE’.

If not I will dig in more with you…

[Kerry Hataley]

Up

0

Down

::

Hi Ashton,

The short answer is NO, it doesn’t do electronic 1099’s. But in 18.6 they are doing a feature in the October release where now all 1099 forms can be printed with lines, like we did the NEC form last year.

But here is a BLOG from Microsoft explaining all the changes. I received this from Terry Heley #Microsoft.

https://community.dynamics.com/blogs/post/?postid=2246f6af-3f2a-4faf-9da5-544613326c20

community.dynamics.com

Dynamics Community Blog Post Details

Dynamics Community Blog Post Details

[Kerry Hataley]

Up

0

Down

::

Hi David,

I am thinking that the issue steams from the fact that triggers are NOT executed once per row, but only once per DML operation. So you need to explicit out the triggers. This means that you ALWAYS should have individual triggers per event type. Meaning a trigger of the insert, update and delete. Each need to have their own definition. This hold true when there are other triggers attached to the table. I have seen this issue with Paramount and their triggers.

Also remember to exclude the Dex_xxx from updates, since this will fill your audit table when doing maintenance routines.

[Kerry Hataley]

Up

0

Down

::

I have sent an email to the techies at DCI to see what is happening…

Thank You

[Kerry Hataley]

Up

0

Down

::

I have forwarded this question to @TerryHeley at Microsoft…

We should have a response in a couple of days.

[Kerry Hataley]

Up

0

Down

::

Yes, just verify that within your Profile >> Notification Settings, Activity Feeds is enabled.

Also, when you replay select the ‘Notify me of new replies’ at the bottom left corner.

[Kerry Hataley]

Up

0

Down

::

Hi Sandra,

As a developer consultant and integration specialist, I use and recommend both the products to every company that needs to do any integrations into Dynamics GP. For most normal business operations it handles your needs. If it doesn’t you should to find a Dynamics GP integrations specialist that knows all the backend and has access to source code.

As for SmartConnect, I have developed many integrations using this for customers. I even have one that does 150k – 200k per day with it. – Even connects to a MSMQ system!

SmartConnect is very rich in features, and can be designed with advanced programming in C# or VBA if you want to make a truly personalized business rules based process. You can even automate the integrations, if you so choose.

You will need to have some training or do a lot of practice, if doing them yourself. You will need to understand eConnect and its concepts. I suggest if you have many integrations, to take the course from eOne or if you need it for just a few specific integrations, then have your partner or an integration specialist develop them for you.

Let me know if you want more information…

[Kerry Hataley]

Up

0

Down

::

This is not my world, but maybe @noahmoseley can help you, or others on the discussion board?