web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Change Decimal Points on Inventory Item

(0) ShareShare
ReportReport
Posted on by 12

We have a situation where a client created a NON-INVENTORY item with ZERO decimal points - seems to have recorded whole items against the code and now learns that they need 2 decimal points - to record .25 units.

The Change Decimal points option on the Inventory Utility page states that the item in use on SOP document.

Questions

1. if we clear the SOP documents from OPEN will that then allow the change? or since they are on any SOP (open or history) are we stuck

2. can anyone confirm that PSTL will allow us to make the change without having to remove data

3. what happens if the developer of the integrated package, makes that change in the SQL table - what happens to the data - after the rebuild and reconcile of the inventory?

Thanks in advance - kind of a major issue.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Lyn Barr Profile Picture
    1 on at

    For your Q#1, it is only the unposted SOP/POP transactions that you need to address. Having transaction history for the item will not prevent you from using the Change Decimal Place utility.

    Off the top of my head, I'm not sure about Q#2.

    For Q#3, I would recommend making the change via the GP utility instead of via a SQL update. (Is that what you were asking? I wasn't sure.)

  • Bill Campbell Profile Picture
    12 on at

    Lyn thanks for the feedback - we will stop the integration of the SOP documents, clear the ones in OPEN and make that change.

    Thanks again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans