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!
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)
Thanks
ZHU
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!
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;
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.
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!!!
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
Here the purchase invoice..
it is possible that i need to add some configuration,?
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.
I recommend using the Posted Purchase Invoice Lines page, which is much more convenient than GL Entries.
Hope this helps.
Thanks.
ZHU
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:
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
