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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Item Model Group configuration

(0) ShareShare
ReportReport
Posted on by 584

Hi. We sell many ad-hoc products that are not stocked and are purchased solely to fulfil a sales order line.  Because there are many of these "bought-in" items, the item id used for them is a generic one called "SPBUY-INS".   The inventory model is standard cost with a cost of $0.01.   This works in a fashion, as actual cost is debited to PPV in the cot of goods sold area. However, sales analysis by item is totally misleading.   Is there a better approach to handling these type of items?         

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Item Model Group configuration

    Hello James,

    What I could imagine to get a different and hopefully better cost of sales analysis would be allocating the PPV at the end of the month to the different product issue transactions such as the sales that you record and post.

    Such an allocation is, however not very easy and is based on a number of assumptions.

    (You will probably need sales order or customer related findims that you can refer to and the amounts will be allocated based on the sales amount, which can be a wrong assumption).

    Also, the allocation tools that we have available in AX are impacting the General Ledger only.

    In other words, if you run a report in sales and marketing, you won't see the effect of those GL allocations.

    In short, there is no good solution available for this in my opinion but a couple of workarounds that you will have to test and discuss internally before applying them in your live environment.

    Best regards,

    Ludwig

  • Hendo Profile Picture
    584 on at
    RE: Item Model Group configuration

    Hi Ludwig. This happened before my time here and there is no documentation around this matter.  I suspect that this method was chosen because the wide range of actual cost associated with individual buy ins make the use of other valuation methods less reliable.  It may well be that standard cost with end of month adjustment redistributing the PPV values is the most appropriate solution. Regards. James.  

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Item Model Group configuration

    Hello James,

    Do you know why a standard cost evaluation was chosen in the first place?

    There must have been a reason for that and I would expect that this issue of the sales analysis has been discussed that time.

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    297,200 Super User 2025 Season 2 on at
    RE: Item Model Group configuration

    Hi James,

    If you need the correct cost for analysis, you need to use an actual costing method instead of standard cost. You can then use inventory marking (or automated) to have the correct cost updated on the sales transactions. You can also consider then to use e.g. a serial number dimension to ensure it is always one on one.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans