Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jeff Roe]

We have a situation where changes to an Item Card are not always saved.

The most confusing part is that it appears to be item based because some save all changes just fine but other items don’t save any changes.

An example is we have a part that we change the weight and save the item, reopen and the weight is still the original value, other parts however when we change the weight it saves as it should.

This form is modified and thought that might be the issue but we changed to the base GP form and had the same results.

Any ideas?

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————

[Kristen Hosman]

Hi @Jeff Roe

Can you narrow this down to just a user that is having the issue or is everyone having this issue?
?

——————————
Kristen Hosman
Independent Dynamics ERP Consultant
Mount Evans Consulting
——————————
——————————————-

[Charles Allen]

You might try creating a dex_sql.log file, using SQL Profiler, or both to see what is happening when you save the record.

——————————
Charles Allen
Senior Managing Consultant
BKD Technologies
Houston, TX
——————————
——————————————-

[David Musgrave]

This could be an issue I have seen when training Dexterity.

If the field is on a secondary window (not the window with the Save Button) and the user does not tab off the field before clicking save on the primary window, it is possible that the change can be lost.

If they press tab after the change then it works.

This can be fixed by a Dexterity command Window_PullFocus(window Secondary_Window) to programmatically move off the field so the change is acknowledged.

If you don’t have access to the source code, you can log a bug with the developer… and if you wish use a GP Power Tools trigger on the Save Button to fix it now so you don’t have to wait for the developer to release a fix.

To confirm is this is the issue, try saving with and without tabbing off the field.

Let me know if that was it.

Regards

David?

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Jeff Roe]

For this discussion the field we are updating is the item weight which is on the main item maintenance form.
1. Saving the change after tabbing off the filed and not garners the same result.
2. The issue appears to be item related since some items save weight changes fine and others don’t
3. Using the modified or basic GP form has the same results
4. I have run a SQL trace and an item that works makes a call (below)
                        declare @p1 int
                        set @p1=NULL
                        exec sp_prepexec @p1 output,N’@P1 int,@P2 datetime2,@P3 int,@P4 datetime2,@P5 char(32)’,N’BEGIN UPDATE KELEG.dbo.IV00101 SET                                   ITEMSHWT = @P1, MODIFDT = @P2 WHERE ITEMSHWT = @P3 AND MODIFDT = @P4 AND ITEMNMBR = @P5 SELECT @@rowcount END                             ‘,36,’2019-12-06 00:00:00′,1345,’2019-12-05 00:00:00’,’RIBU1C ‘
                         select @p1
For an Item that does not work an update similar to above is never executed.

I will try some Dex logging and GP Power Tools

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-

[Sally Diehl]

Joe ~

I had a client with the same issue recently.  We narrowed it down to a blank Item ?Valuation method on a Sales Inventory item.  The client had the item setup as “Service” which has a blank item valuation method.  They updated the item type to be Sales Inventory (Via SQL), but did not update the Item Valuation.  Those items did not allow the user to save any changes. 

Check the item’s valuation method.  If it is blank, a SQL update statement can resolve.

Good Luck,

——————————
Sally Diehl
Sr. Director, Technology Consulting
RSM
612.629.9058
Minneapolis, MN
——————————
——————————————-

[Jeff Roe]

When you say “Item Valuation Method” what table and field are you referring to?

Thank

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-

[Jeff Roe]

Are you referring to the FIFO LIFO ….?

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-

[Sally Diehl]

?Joe ~

That is the field I am referring to.

Sally

——————————
Sally Diehl
Sr. Director, Technology Consulting
RSM
612.629.9058
Minneapolis, MN
——————————
——————————————-

[Jeff Roe]

The correct value is in all the parts so that doesn’t seem to be the problem.

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-