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

Document Balance Sheet posting by line

(0) Share

Report

Posted on by Dixonsamuel

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.

All responses (2)

Answers (0)

Dixonsamuel 60 on at

Like (0)

Report

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 2,339 on at

Like (0)

Report

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)

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.

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