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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Customer Invoice - Different items same GL Account

(0) ShareShare
ReportReport
Posted on by 140

Hi I have to create and invoice with3 different items, but all go to the same Gl Account. once I created the invoice, the GL is all in one line for the 3 items. How could I get the tree line in the GL? I need to see in the GL all the transaction by item.

thank you for your help

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    I think in your invoice you can change Posting Group of items. If you have a posting group that has the setup you need (or you can create one) this way after changing posting group all those lines post in G/L that you needed as a standalone line for each item. 

    docs.microsoft.com/.../finance-posting-groups

  • Suggested answer
    Dallefeld Profile Picture
    211 User Group Leader on at

    Why would you want to see the 3 lines in the GL?

    Rather than different posting groups as MAHGAH suggests, If you absolutely need this information in the GL, then setup an Item No dimension. The values for this dimension should equal your item numbers. Be sure to default an Item No dimension on each item. Also, require your Item No dimension on your sales accounts. This will force 3 lines to be created in the general ledger, one for each item no dimension.

  • Suggested answer
    YUN ZHU Profile Picture
    95,649 Super User 2025 Season 2 on at

    Hi, As suggested by the two experts above, you can set up different posting groups for different items, and then post them to different accounts in General Posting Setup.

    pastedimage1656979553406v3.png

    pastedimage1656979420705v2.png

    Hope this helps.

    Thanks.

    ZHU

  • JPB 2022 Profile Picture
    140 on at

    Thank you !! to everyone!! amazing your help!.. And yes finally I created posting group!! and it works!!..

    Again thank you !!! =)

  • JPB 2022 Profile Picture
    140 on at

    Thank you.. I need the information in the GL because is a Balance Account is not a expenses. or income.. so the dimension doesn't affect . Thank you for your help. I figure it out with the Posting Groups.

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans