Skip to main content

Notifications

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

Quantity field in GL journal, is empty

Posted on by 140

Hi!! We are traying to use the Quantity field, to track the KWH in each of our electric invoice purchase. 

But when i run the GL this field is empty. Do I miss something in the configuration?

I will appreciate any help!

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,110 Super User 2024 Season 2 on at
    RE: Quantity field in GL journal, is empty

    Hi, just update some info.

    Last week I discovered a new feature in BC22, which can manage quantities individually, and I hope it can give you some new hints.

    Use statistical accounts to collect data for financial reports (new Statistical Accounts Module)

    https://yzhums.com/36234/

    Thanks

    ZHU

  • JPB 2022 Profile Picture
    JPB 2022 140 on at
    RE: Quantity field in GL journal, is empty

    Ok I share what I did.

    As my company don't want to do any configuration.

    We are testing to use "item" so then trough the Item general ledger, we can have all the quantity,  invoice date, vendor, etc.

    And with that we are ok!..

    Thank everyone for the help!

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Quantity field in GL journal, is empty

    You can try to use this event in Codeunit 90

    [IntegrationEvent(false, false)]

       local procedure OnInsertICGenJnlLineOnBeforeICGenJnlLineInsert(var TempICGenJournalLine: Record "Gen. Journal Line" temporary; PurchaseHeader: Record "Purchase Header"; PurchaseLine: Record "Purchase Line"; CommitIsSuppressed: Boolean)

       begin

       end;

  • JPB 2022 Profile Picture
    JPB 2022 140 on at
    RE: Quantity field in GL journal, is empty

    Ok i am in a conversation with the consultant

    Thank you

  • JPB 2022 Profile Picture
    JPB 2022 140 on at
    RE: Quantity field in GL journal, is empty

    Ok Perfect thank you!!.. I thought it was the same field!!..  

    How can I do that customized?  

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Quantity field in GL journal, is empty

    The quantity you enter on a purchase invoice will not show in the G/L Entries.

    Only the quantity entered in a General journal line will be visible in the G/L Entries.

    If you want the quantity from the purchase invoice line then this needs to be customized.

  • Suggested answer
    JPB 2022 Profile Picture
    JPB 2022 140 on at
    RE: Quantity field in GL journal, is empty

    Thank ZHU I haven't know that option, but i was testing and it is ok show me the quantity, but i can not filter by posting date., i dont see as available field in the personalize option.

    But it is still strange, i can see the quantity, with this report, but I don't see it in the GL!!!

  • Suggested answer
    JPB 2022 Profile Picture
    JPB 2022 140 on at
    RE: Quantity field in GL journal, is empty

    Thank Kind for your help. I put that field as visible, and when i book and invoice, I complete that field but then it appear empty.

    Here the imagen of my GL, quantity is 0

    pastedimage1678858351700v1.png

    Here the purchase invoice.. 

    pastedimage1678858505331v2.png

    it is possible that i need to add some configuration,?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,110 Super User 2024 Season 2 on at
    RE: Quantity field in GL journal, is empty

    Hi, as far as I know, this is the standard, unless you manually add the quantity in General Journals, and then post, otherwise the quantity here is 0.

    pastedimage1678839139468v5.png

    I recommend using the Posted Purchase Invoice Lines page, which is much more convenient than GL Entries.

    pastedimage1678838978784v3.png

    pastedimage1678839186490v6.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Quantity field in GL journal, is empty

    There should be no specific configuration needed for this. 

    As long as the field is filled in to the journal line the quantity should be visible also on the G/L Entries.

    But you have to make that field visible through personalization:

    pastedimage1678826900110v1.png 

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