Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Error when Selecting Average Costing method for Item with Type service

(0) ShareShare
ReportReport
Posted on by 277

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
    277 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
    81,802 Super User 2025 Season 1 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
    15,437 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
    277 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
    15,437 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
    175 User Group 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
    277 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
    175 User Group 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
    15,437 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

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,269 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans