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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Release product setup and changes

(1) ShareShare
ReportReport
Posted on by 249

The client is currently using inventory tracking on excel. For the first go-live they want to use Dynamics to buy the items but they do not want to maintain inventory. Item numbers needs to be setup as item model group as non-stocked initially but later on  they want to use the same items number but change the item model groups to stocked.

 

Also currently because they won't track the inventory in system for phase 1, the Tracking dimension group will be none (no batch or serial), however later on in phase two when they want to track inventory in system they want Tracking dimension group to change to Batch or serial.

 

They do not want to create new item numbers. In phase two they want to update Item model group, storage dimension group, Tracking dimension group.

 

During phase 2 they are willing to close all open transactions against these items. Can we change  these dimensions on Released product after they are used in the system?

 

Note: We cannot use procurement categories because they have vendor pricing for these items

  • Suggested answer
    SoumitraforD365 Profile Picture
    290 Super User 2026 Season 2 on at

    Hi @CU13032032-0 

    Although this is not very usual way but I believe , it is technically doable for these items, precisely because non-stocked items don’t generate inventory transactions.

    The validations that normally block dimension group changes get triggered on the existence of InventTrans / InventSum records for the item. A non-stocked item model group bypasses inventory posting entirely — PO receipt and invoice go straight to expense/consumption accounts, no on-hand, no inventory transactions. So after phase 1 the item should be “clean” from an inventory perspective even though it has years of purchase history.


    Before phase 2, table-browse InventTrans, InventSum, and InventTransOrigin filtered on ItemId. If those return zero rows and no open documents exist, the changes shall go through.

    However i would strongly suggest Create a new item model group that’s set as stocked, then change each item to point at that new group. Don’t just tick the “Stocked product” box on the existing group. That group is shared by every item using it, so one tick changes all of them at once — including items you never meant to touch. And undoing it afterwards is far messier than simply moving items back.

    Also, I would suggest Set the final storage and tracking dimension groups right at the start in phase 1. Leave batch or serial switched on from day one. Nothing will ask for a batch number while the item is non-stocked, because no receipt is being registered. But the tracking dimension group is the setting most likely to get blocked later. Set it now and Phase 2 becomes a single field change instead of three.

    I would also highlight to test/validate this process in a sandbox first: run a full purchase cycle on a non-stocked item that has batch enabled. If nothing prompts for a batch number, you’ve removed most of the Phase 2 risk.

    Thanks



     


     


     

  • Suggested answer
    Syed Haris Shah Profile Picture
    1,925 Super User 2026 Season 2 on at

    Hi @CU13032032-0 ,

    I don’t think this approach will help in the long run. D365 allows the Storage and Tracking Dimension Groups to be changed under the required conditions, but it does not support changing the Item Model Group from Non-stocked to Stocked in the way being proposed.

    Therefore, I wouldn’t recommend designing Phase 1 around this transition. If the intent is not to track inventory in D365 initially, they can continue maintaining the inventory financials through the GL, and when they are ready to manage inventory in D365, start proper recording inventory subledger and GL from that point.

     

    Regards,

    Syed Haris Shah

  • Suggested answer
    Shri Ranjani Profile Picture
    217 on at

    Hi,
    You cannot execute this strategy cleanly without changing item numbers.

    While the system technically allows updates to storage and tracking dimension groups (if inventory is zeroed and closed), it strictly blocks changing an item model group from non-stocked to stocked once transactions exist.

    You can try using stocked item model groups in Phase 1, but immediately expense the items upon receipt (e.g., use a "post to expense" setup or write them off to zero via journals). This allows you to change tracking dimensions and keep the same item numbers for Phase 2.
  • CU13032032-0 Profile Picture
    249 on at

    @Shri Ranjani Thank you for your comment. When you say “ Use Post to expense” setup what do you mean by that? where are you suggesting to configure this?

    Can you explain when you say expense the items upon receipt - how do I configure this?

  • Suggested answer
    Shri Ranjani Profile Picture
    217 on at

    Hi,
     What I meant as "post to expense" is the configuration or action of routing a financial transaction directly to a Profit and Loss (P&L) expense account rather than holding it on the balance sheet (such as in an asset, clearing, or work-in-progress account)

    This method redirects the accounting entries. Instead of the system posting the item's value to a balance sheet asset account during Purchase Order (PO) receipt and invoicing, you configure the inventory posting profile to send the value directly to a P&L expense account.
    1. Go to Inventory Posting: Navigate to Inventory management > Setup > Posting > Posting.
    2. Configure the Receipt (Product Receipt):
      • Click the Inventory tab and select Receipt.
      • Add a new line.
      • Set the item code to Table (for a specific item) or Group (for an item group).
      • Select your Phase 1 item/group.
      • In the Main account field, select your target P&L Expense Account instead of an asset account.
    3. Configure the Issue (Invoicing/Sales):
      • Do the same under the Issue section so any physical reductions also clear out of the same expense account.
    4. Configure Purchase Order Posting:
      • Go to the Purchase Order tab.
      • Ensure that purchase receipts, purchase expenditures, and uninvoiced lines for this item point to your operational expense accounts.
    Result: The inventory quantity is tracked in the system (allowing tracking dimensions), but the financial value is immediately expensed upon receipt.
    Kindly mark as verified if it helps
     
     
  • Aayush Tiwari Profile Picture
    384 on at

    Hello @Shri Ranjani 

     

    Are you suggesting to maintain stock products but at the time of product receipt the consumption of the item happens automatically? or the user also have to post the consumption entry by inventory adjustment or item journal?

     

    Regards

    Aayush Tiwari

  • Suggested answer
    Shri Ranjani Profile Picture
    217 on at

    Hi,
    The intention is not to ask the users to manually post an inventory adjustment for every purchase.

    For Phase 1, the idea is to use the item as a stocked item but configure the accounting so that the purchase value is posted directly to the P&L expense account rather than an inventory asset account.

    However, this means the inventory quantity would still be maintained in D365. The product receipt would increase the on-hand quantity, even though the financial value is expensed.

    If the requirement is that the item should be automatically consumed at the time of product receipt, then that would be a separate requirement and would need an additional automated/customised consumption transaction.

  • Suggested answer
    Aayush Tiwari Profile Picture
    384 on at

    So of you go forward with Shri suggestion you have to create item model group with stocked product as true and post financial inventory and post physical inventory as false so the inventory accounting doesn't get's trigger at GRN or Purchase order invoice, you can map the expense ledger in posting type Purchase expenditure for product. But this is increase the inventory quantity at every GRN. You have to perform a set of activities before phase 2 ;-

    1. Reduce inventory to 0 on cut off -1 date
    2. Close inventory on cut off - 1 date
    3. Upload opening  inventory quantities as on cut off date.

    Regards

    Aayush Tiwari 

  • CU13032032-0 Profile Picture
    249 on at

    @Shri Ranjani  Thank you for the explanation. For Storage dimension and tracking dimension- since they said they want to have location and batch/serial in phase two I marked it and allowed for Blank receipt. The plan is to keep blank receipt as yes in phase 1 and make it No in phase 2.

    However when I am testing this, after I post a transaction I am unable to uncheck the blank receipt. I received and invoiced a purchase order, I removed the inventory- but I still cannot change the blank receipt to no.

     

    Do you know what I am missing?

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 Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 99 Super User 2026 Season 2

#2
Paolo Cecchelli Profile Picture

Paolo Cecchelli 79 Super User 2026 Season 2

#3
Aayush Tiwari Profile Picture

Aayush Tiwari 71

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans