Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

COGS setup for service item with Stocked Option in AX 2012 R3

Posted on by Microsoft Employee

Hello,

We are using AX 2012 R3, here is our requirement. We get lot of special order items that may not be ordered again. We don't want to create them as individual physical item. I tried to use One Service item with Stocked Option checked. When I tried I see cost amount for PO's. But for SO, cost is not populating and only Revenue and AR entry populating. Please let me know what am I missing here and is there better option one time inventory item. 

2543.PIC1.JPG3223.PIC2.JPG

*This post is locked for comments

  • Santosh Durgam Profile Picture
    Santosh Durgam 446 on at
    RE: COGS setup for service item with Stocked Option in AX 2012 R3

    Hi Ludwig and Everyone,

    I see the same behavior as posted in this thread. We have certain software license products that we are planning to create as Item type "Service" and "stocked" product selected in the item model group.

    When we purchase these items, I see the cost is showing up on the Inventory transactions where in when I see the same items, system is showing up the cost as blank. I have also checked the accounting entries for the Sales Invoice, only revenue is posted but not the cost. Due to this, it looks as if we are making a 100% margin.

    Any thoughts from anyone? appreciate your help.

    pastedimage1636376585125v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: COGS setup for service item with Stocked Option in AX 2012 R3

    Hi Dhamu,

    If you make use of the stocked option parameter, what makes your service item different from any other item except the name?

    Closing and adjustment is mandatory if you use a current costing method, such as FIFO, LIFO, weighted average, etc.

    If you use standard costs or moving average it is not mandatory but highly recommended.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COGS setup for service item with Stocked Option in AX 2012 R3

    Sorry for delayed response. Is closing and adjustment is mandatory?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COGS setup for service item with Stocked Option in AX 2012 R3

    Sorry for delayed response. I raised the same question. Now they are changing the option.

    Is it possible to populate cost when posting sales order for an service item with Stocked option checked?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: COGS setup for service item with Stocked Option in AX 2012 R3

    Hi,

    How can you guarantee that the costs of a 'special order item' does not get mixed up with the cost of another 'special order items' if you use only a single item for all 'special order items'?

    Best regards,

    Ludwig

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: COGS setup for service item with Stocked Option in AX 2012 R3

    Hi Dhamu,

    That means that system cannot find the cost when you invoice the sales order.

    Do you invoice PO before invoicing SO?

    And i see your model  group does not match with transaction, you disable the physical negative inventory in model group but your item is negative.

    Please recalculate the item value in closing and adjustment.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans