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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Document Balance Sheet...
Small and medium business | Business Central, N...
Suggested Answer

Document Balance Sheet posting by line

(0) ShareShare
ReportReport
Posted on by CU17121206-0 12

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.

I have the same question (0)
  • Suggested answer
    Gavin Profile Picture
    Gavin 2,510 on at

    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

  • CU17121206-0 Profile Picture
    CU17121206-0 12 on at

    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.)

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 572 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 331 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 330 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans