Skip to main content
Business Central forum
Answered

Error when Selecting Average Costing method for Item with Type service

editSubscribe (0) ShareShare
ReportReport
Posted on by 258

Dears , I am getting error when Selecting the Average Costing method for an Item with Type service 

I wonder what's going on I have 10s of items with Type Service & Costing method is Average 

pastedimage1645124387589v2.png

I have a lot of items [Serivce] with Costing method [ Average ]

pastedimage1645124563744v3.png

  • mahmoud_algindy Profile Picture
    mahmoud_algindy 258 on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Thanks a lot yzhums

    You changed my way now to go deeper and check the code.

    Thanks a lot to all

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 59,926 Super User on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Hi, This is restricted in the standard code that if the "Costing Method" is not equal to FIFO, the Type must be equal to Inventory.

    pastedimage1645147582018v1.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,395 on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Thanks Mahmud for update. The strange part is I am in 19.3 and have 19.3 docker but I cannot create Service item with Avg Cost. I hope 19.4 solve this issue.

    Out of curiosity do you have any extension in Item Card or Item related?  

  • mahmoud_algindy Profile Picture
    mahmoud_algindy 258 on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Hi MahGah

    Thank you & thanks to Kim Dallefeld

    I added the item in the screenshot manually & did not use Conf. pkg or edit in Excel.

    That's why I feel a bug, I know it will not affect the calc. of the cost but my customer is not happy to see that, I can just hide it from the Item card but it's a very bad practice as the user will need it in Inventory Items.

    I hope it will be solved after the minor update 19.4 which has not yet appeared in my tenants.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,395 on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Hi

    Sorry I missed that part. it is strange that you have service parts with AVG Cost. I have tried to create such an item but had no success. Do you know if they are new item or "migrated" items through Configuration Package?

    I was successfully changed and upload one service item with AVg cost through Configuration Package. Basically if you turn off validation in configuration package you do not receive any error. 

    I hope this help 

    pastedimage1645133223322v1.png

  • Dallefeld Profile Picture
    Dallefeld 11,415 UG Leader on at
    RE: Error when Selecting Average Costing method for Item with Type service

    That seems crazy since it's not using any costing method....

  • mahmoud_algindy Profile Picture
    mahmoud_algindy 258 on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Thanks, MahGah

    I've read the same article several times earlier, my concern is:

    why I am able to add an Item with type service & Costing method is Average, and why sometimes I am not able to do the same,

    I created both items in less than a minute for testing purposes, it's very strange for me.

    I am using Config. pkgs as usual in my implementation and I know for many years that when I need to upload Items [Service type] I need to keep the Costing method blank or FIFO if I tried to add average in the Config. pkgs it will retuern  an error.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,415 UG Leader on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Service and inventory Items will track a last direct cost as they are posted through purchase invoices. This does not add value to the inventory but does give you a unit cost.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,395 on at
    RE: Error when Selecting Average Costing method for Item with Type service

    Hi

    See below article. For Service and non-inventory item Bc "The Service and Non-Inventory types do not support tracking of inventory quantities and values. Only selected item transaction types and features are supported." 

    Basically even if it shows Fifo that because that is the first option and has no other meaning. And for above reason you cannot change it. 

    docs.microsoft.com/.../inventory-about-item-types

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans