Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Tracking Shares of Stock
Small and medium business | Business Central, N...
Suggested answer

Tracking Shares of Stock

(1) ShareShare
ReportReport
Posted on by JE-29041340-0 378
Hi:
 
We have a customer who needs to keep track of its investments, number of shares, and cost.  (There's no real need to keep up with market valuations.)
 
It's not a trading situation.  In fact, the companies for the investments are not listed.  They're privately owned. 
 
There might be a case when some or all shares of a particular company will be sold.  The customer needs to keep track of that, as well, including capital gains. 
 
Premiums, indexing, and stock certificates along with their dates and number of shares remaining after sale would need to be tracked.
 
I'm not sure if inventory would be a way to do it.
 
Does anyone have any ideas?
 
Thanks!
 
John
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,272 Super User 2025 Season 1 on at
    Tracking Shares of Stock
    KasparsSemjonovs's idea could work. You could also look into using statistical accounts to track this information, or perhaps customizing the system to do it. It really depends how much functionality they need, there is a pretty big BC add-on for doing all of that too - Financial Services Unified Software Solutions Specialists (elysys.com) 
     
     
    Valentin Castravet
    Zander ERP Services
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,761 Super User 2025 Season 1 on at
    Tracking Shares of Stock
    from the look of it, I doubt BC is suitable to meet needs of such situation. even user might be able create workaround using out of box inventory related features, there might be situation that BC couldn't meet more industry specific requirements. 
    I would say be cautious to recommend BC for this customer.
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,250 Super User 2025 Season 1 on at
    Tracking Shares of Stock
    From the description - it seems that Inventory would suit the best to fulfill the needs. 
    The type of item most likely would be Inventory - as You want to see how much quantity you have "on-hand", and be able to register several decreases of the initial quantity, and You cannot go into negative quantity. 
    Item revaluation Journal can be used to revaluate the value of the remaining quantity on periodical basis - to keep up with the stock value change over time.
     
    The Gen Prod. Posting group for the such items would be different, from regular inventory, so that the value would be put into a separate GL account (some Investments/Stocks account) and regular items would be with different group that goes to Inventory GL account. 

    Also the number series relationships can be configured, so that when You create a new item and choose the Stock number series - the Item number would be different from regular items.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans