Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Document Balance Sheet posting by line

Posted on by 60

Hi everyone,

I have a customer request that requires their balance sheet posting of Purchase Invoice to be posted by the line amounts and dimensions.

Am wondering if anyone has done this before?
Am trying to look out for the even that allows us to 'disable' the lumping up of the GL Entry for the balance sheet posting only.

Only require this for the GL Entry, not necessary for the vendor ledger entries.

Hope to get any feedback.

Thank you.

  • Dixonsamuel Profile Picture
    Dixonsamuel 60 on at
    RE: Document Balance Sheet posting by line

    Thanks Gavin.

    This was the last resort I had in mind too.

    To auto post the reclass journals after the invoice had been posted or auto insert the reclass journals at the invoice lines before posting.

    But the downside was that, the GL balance sheet account had to allow direct posting. ( Might have other ways to work around this validation if necessary.)

  • Suggested answer
    Gavin Profile Picture
    Gavin 2,339 on at
    RE: Document Balance Sheet posting by line

    Hi,

    I can't see a way you can do this with a "Purchase Invoice" however you could use the technique below using a General Journal (or Purchase Journal)

    pastedimage1686321978809v3.png

    This balances each expense posting to an accounts payable entry. The last two lines then record the Vendor posting and reverses from the accounts payable account.

    When I preview the GL postings you can see this is recording one accounts payable per expense entry and the last two entries of the journal go in and out of the accounts payables account. 

    pastedimage1686322015601v4.png

    You also get one Vendor Ledger Entry.

    Probably not what you are looking for but thats one way to do it.

    Hope this helps.

    Thanks

    Gavin

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans