Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Hit the P&L upon receipt, not invoice

(0) ShareShare
ReportReport
Posted on by 4

Hi All!

We have a client on D365 F&O who wants all their costs to hit their P&L upon receipt, not upon invoice. They need this to be automatic. Their AP invoices are handled by an invoice matching solution (in case this makes a difference for the solution).

I imagine there may be a number of ways to get this to work.

Does anyone have experience of doing this, and which is the most efficient way to make this work?

Thanks!

  • EUH Profile Picture
    EUH 4 on at
    RE: Hit the P&L upon receipt, not invoice

    Thanks Saurabh

  • EUH Profile Picture
    EUH 4 on at
    RE: Hit the P&L upon receipt, not invoice

    Thanks Ludwig, I will check out your post

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Hit the P&L upon receipt, not invoice

    Good morning EUH,

    You can realize what you need with the standard posting framework.

    In my home country, there is a specific accounting regulation, which asks for this early P&L cost recognition.

    If you want then you can run this method of early P&L cost recognition in parallel to what is commonly known as cost of sales method in international accounting standards.

    To get some inspiration how the early cost recognition and the parallel accounting stuff works, you can have a look at the following post: dynamicsax-fico.com/.../

    Your situation seems less complex and easier but still, you can use those posts to see what you might to change in the accounting setup.

    Best regards,

    Ludwig

  • Verified answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2024 Season 2 on at
    RE: Hit the P&L upon receipt, not invoice

    So you can map "Purchase expenditure un-invoiced" on inventory posting > Purchase order tab with final P&L expense account.

    But remember that will get reversed on final invoice.

  • EUH Profile Picture
    EUH 4 on at
    RE: Hit the P&L upon receipt, not invoice

    Thanks Saurabh, Please see my reply to Ludwig, they need it to hit the final P&L expense account for reporting purposes.

    Bets regards

  • EUH Profile Picture
    EUH 4 on at
    RE: Hit the P&L upon receipt, not invoice

    Hi Ludwig, thank you for your reply.

    In terms of the reason, the company puts a lot of emphasis on the P&L, they report on it almost daily to see their position. They consider any receipts as committed and would like to see their exact position in a way that everyone in the business (including non-finance) can understand. Also, their costs are usually on procurement categories so there is usually no stock involved. And when there are physical goods these are not stock-controlled, they usually form part of a service provided, like socks for trampolining which do not need to be returned for hygiene reasons. They are not sold as a separate line. I hope that helps.

    As for you suggestion, which is the parameter you are referring to? And in this case what happens when the invoice arrives, usually the accrual is reversed, but here there will be no accrual.

    Many thanks

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2024 Season 2 on at
    RE: Hit the P&L upon receipt, not invoice

    In my opinion , on receipt you already have P& L impact on product receipt as offset of purchase accrual.

    Debit Purchase expenditure-Univoiced ( This can be your P&L Account)

    Credit Purchase Accrual

    This can be enabled from AP parameters and inventory management (Inventory accounting tab) parameters

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Hit the P&L upon receipt, not invoice

    Hi EUH,

    If you post your packing slip into ledger - there is a AP parameter available for that - then you should be able to achieve that.

    Before doing that can you elaborate why this would be needed?

    Don't you put the items you receive on stock first?

    If you post those costs early then there might be a timing mismatch between costs and revenues in case the items are sold in future periods.

    To avoid such an issue, it would be great if you could elaborate on the requirement.

    Many thanks,

    Ludwig

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans