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

Announcements

News and Announcements icon
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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans