Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Increasing of item cost at PO without posting in accounting

Posted on by 322

Dear community,

my customer wants to calculate a particular percentage of cost for particular items and whenever the items get purchased, the stock value should increase (e.g. 3 % for transportation costs).

I know that there's a possibility in standard to connect e.g. transport invoices to items afterwards, but doing this for every purchase order line would mean a lot of manual work for the users which they want to avoid.

I first tried to use charges (setup debit item, credit any account) which actually works (increases the item cost in inventory) but I don't want the calculated cost to get posted on my trade good P&L account as in fact no vendor invoices exactly this calculated amount.

So actually I'm searching for a solution to get costs on my inventory value of the item at the time of the purchase order receipt and invoice but not as a profit and loss in my accounting. The "real" profit and loss for e.g. for transportation cost will get posted with the invoice of the carrier anyway. If I have to post it nevertheless, I could use the same account (or two new accounts) for debit and credit in accounting, this wouldn't be a problem, but when I tried to set this up in charges, I didn't get the cost on the item value anymore, just on the accounts (debit P&L, credit P&L).

Does anybody have experience with this topic or probably just a very good idea?

Solutions and suggestions are greatly appreciated.

Kind regards,

Katy

*This post is locked for comments

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Increasing of item cost at PO without posting in accounting

    Dear Ludwig,

    at least you understand what I mean, I was afraid I explained it a bit too complicated ;)

    Well, if I setup the charge code with debit item and credit P&L it would work, I agree with you, but my P&L gets mixed up ('real' item cost and 'not so real' additional cost). Main issue is maybe, that my customer has several accounts for trade goods (not just one), depending on a couple of things, I forgot to say that. So they can't just post it vice versa at the end of the ... month or whatever, because it will get split up ...

    Costing sheet sounds more interesting to me, let me check that, thanks a lot in the meantime.

    Kind regards

    Katy

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Increasing of item cost at PO without posting in accounting

    Hello Katy,

    What I have seen companies doing is using an item related charge code - as you mentioned - that debits the item and credits a P&L account.

    The P&L account is an offset account to what you call 'real' transportation cost account and provides you an indication of whether your charge percentage is too high or to low and needs adjustment. This can be identified by the sum of the real transportation cost account and the P&L account you use for the charge code.

    Something similar can be achieved by making use of the costing sheet. Here you can setup a specific charge that is posted at the time you record a purchase. However, also here, you make use of a 'theoretical' allocation that results in an amount that might be above or below your 'real' transportation costs.

    Best regards,

    Ludwig

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Increasing of item cost at PO without posting in accounting

    Oh sorry. Thanks Martin!

  • Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on at
    RE: Increasing of item cost at PO without posting in accounting

    Hi Katy, please separate individiaul tags with comma and words in tags with spaces. You attached a single long tag AX2012r3 Costcalculation Stockvalue Itemcost Charges Calculation (I've already fixed it for you).

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans