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

Notifications

Announcements

No record found.

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... / Is it possible to have...
Small and medium business | Business Central, N...
Suggested Answer

Is it possible to have one posting per line, not per account?

(0) ShareShare
ReportReport
Posted on by Sleina

Hi all 

We have over 50 Lines in one invoice, after we post them, we would like to see each line with the description in general ledger entries.

But currently, BC combines the line amounts per account, so it looks like this:

On the invoice (50 lines in total)

pastedimage1670329333586v1.png

And on the posted G/L Entries we can only see a summed posting per account (seven in total).

pastedimage1670329384168v2.png

Is it possible to have one posting per line ?

thank you for your help

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    Hi

    it is not possible to do this, perhaps if the rows had different dimensions you would have an additional unpacking

    the key to standard unpacking is as follows:

    Format(TypeValue) +
    "G/L Account" +
    "Gen. Bus. Posting Group" +
    "Gen. Prod. Posting Group" +
    "VAT Bus. Posting Group" +
    "VAT Prod. Posting Group" +
    "Tax Area Code" +
    "Tax Group Code" +
    Format("Tax Liable") +
    Format("Use Tax") +
    Format("Dimension Set ID") +
    "Job No." +
    Format("Fixed Asset Line No.") +
    "Deferral Code" +
    "Service Tariff No." +
    Format("Related Entry No.") +
    Format("Include in VAT Transac. Rep.") +
    Format(RefersToPeriod) +
    "Contract No.";

    so you would need a customisation in the following FillInvPostingBufferPrimaryKey function of the Invoice Post table. Buffer that drives the writing in G/L Entry.

    pastedimage1670337271246v1.png

    check my answer if it helped you, thanks

    DAniele

  • Suggested answer
    DanKalion Profile Picture
    DanKalion 80 on at

    Hi Selina,

    Why do you need to see the description of each line in the general ledger? BC uses the posting description on the document header while posting to the customer ledger/general ledger.

    You can run the posted sales invoice line page to extract details of invoices posted to a customer(you can use different filtering options as well).

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,226

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,047 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans