Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

COGS setup for service item

Posted on by Microsoft Employee

Hi,


We are using AX 2009. There are services which we sell to customer by using service item in sales order. These services are mainly for supplying our man power to customer. I would like to know if below would be possible. 

1. Set up cost price at item master since my unit cost will remain fixed and contribution at sales quote/order level for such items as contribution will vary from customer to customer. 

2. Currently invoice posting will pass only one GL entry that is debit to customer balance and credit to sales revenue for total invoice value. I want additional entry to be passed as debit to COGS (cost of goods sold) and credit to underlying source GL of cost as per total cost arrived at based unit cost setup in item master. This additional COGS entry is possible for item type item and cost is known to system by way of underlying inventory transaction but I am not able configure the same for item type service and there is no underlying transaction for cost part in case of such service.

Appreciate any solution.


Thanks and regards

Sanjieyv Thakker

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COGS setup for service item

    Created New tread, community.dynamics.com/.../305180

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COGS setup for service item

    Sure, I will create a new tread.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: COGS setup for service item

    Hi,

    You replied to a very old case here.

    Can you please create a new one and provide some information on your system version used.

    Many thanks and best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COGS setup for service item

    Hello, We are using 2012 R3. I tried stocked option for service item. I see inventory transaction.

    But Cost is populating only for PO, SO have does not getting the cost. not able populate COGS entry while posting SO. Only revenue and AR is populating. 

    Also Let me know what am I missing here.

    4774.PIC2.JPG4774.PIC2.JPG

  • Raj Patil Profile Picture
    Raj Patil 49 on at
    RE: COGS setup for service item

    Sorry for getting back so late, but I did create another thread for this, but never got any response on that one.

    My issue has been resolved though.

  • RE: COGS setup for service item

    Hi Raj, when you issue AX uses the inventory cost, and for an item that is normally created by purchasing the item.  But for a service that is just sold and never purchased use an item model group of FIFO and tick Fixed receipt price.  Then setup a cost price on the item, or activate the cost price per Site.   Then you will see that AX will issue your service at that fixed cost price.    This will certainly work for a new item (with no transaction history) - not sure what will happen with an existing item or if you can convert though.    Try this out in a Test system.  

    Tim

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: COGS setup for service item

    Hi Raj Patil,

    It would be great if you could create a new thread for your issue and provide some supporting information such as screenprints from your item master, etc.

    Many thanks,

    Ludwig

  • Raj Patil Profile Picture
    Raj Patil 49 on at
    RE: COGS setup for service item

    Hi Ax gurus,

    I have scenario, I have item (not service type) with stocked option as 'model group' now client is asking us to change the item to (service type), but when we do so Ax is picking up cost price from on hand instead from item master.

    Is there parameter that I can use? Once I change item to service type? Any help is REALLY appreciated.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COGS setup for service item

    Hi Brandon,

    We have manged to address this in line with what you have suggested.

    Many thanks and best regards

    Sanjieyv Thakker

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: COGS setup for service item

    Thanks and agreed Ludwig,

    However nature of business is more of trading activity and project module will not be the best choice due to that for multiple reasons.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans