You’re offline. This is a read only version of the page.
Announcements
5
Hello everyone,
do you happen to know whether the structure of query 261 for the material items has changed in the update? The Source_Type and Source_No columns are missing.
Thank you!
Entry No_,
Transaction No_,
G_L Account No_,
Posting Date,
Document Date,
Document Type,
Document No_,
Amount,
Source Code,
IC Partner Code,
Dimension Set ID,
Source No_,
Source Type
Best
Frank
Thank you for the comparison, it was very helpful for me.
Best Frank
Hi
What was your previous version? I compared 18.1 and 19.3 and looks like nothing has changed
Version 18.1:
query 261 "G/L Entries"
{
Caption = 'G/L Entries';
elements
{
dataitem(G_L_Entry; "G/L Entry")
{
column(Entry_No; "Entry No.")
{
}
column(Transaction_No; "Transaction No.")
{
}
column(G_L_Account_No; "G/L Account No.")
{
}
column(Posting_Date; "Posting Date")
{
}
column(Document_Date; "Document Date")
{
}
column(Document_Type; "Document Type")
{
}
column(Document_No; "Document No.")
{
}
column(Source_Code; "Source Code")
{
}
column(Job_No; "Job No.")
{
}
column(Business_Unit_Code; "Business Unit Code")
{
}
column(Reason_Code; "Reason Code")
{
}
column(Gen_Posting_Type; "Gen. Posting Type")
{
}
column(Gen_Bus_Posting_Group; "Gen. Bus. Posting Group")
{
}
column(Gen_Prod_Posting_Group; "Gen. Prod. Posting Group")
{
}
column(Tax_Area_Code; "Tax Area Code")
{
}
column(Tax_Liable; "Tax Liable")
{
}
column(Tax_Group_Code; "Tax Group Code")
{
}
column(Use_Tax; "Use Tax")
{
}
column(VAT_Bus_Posting_Group; "VAT Bus. Posting Group")
{
}
column(VAT_Prod_Posting_Group; "VAT Prod. Posting Group")
{
}
column(IC_Partner_Code; "IC Partner Code")
{
}
column(Amount; Amount)
{
}
column(Debit_Amount; "Debit Amount")
{
}
column(Credit_Amount; "Credit Amount")
{
}
column(VAT_Amount; "VAT Amount")
{
}
column(Additional_Currency_Amount; "Additional-Currency Amount")
{
}
column(Add_Currency_Debit_Amount; "Add.-Currency Debit Amount")
{
}
column(Add_Currency_Credit_Amount; "Add.-Currency Credit Amount")
{
}
column(Dimension_Set_ID; "Dimension Set ID")
{
}
column(G_L_Account_Name; "G/L Account Name")
{
}
}
}
}
Version 19.3:
query 261 "G/L Entries"
{
Caption = 'G/L Entries';
elements
{
dataitem(G_L_Entry; "G/L Entry")
{
column(Entry_No; "Entry No.")
{
}
column(Transaction_No; "Transaction No.")
{
}
column(G_L_Account_No; "G/L Account No.")
{
}
column(Posting_Date; "Posting Date")
{
}
column(Document_Date; "Document Date")
{
}
column(Document_Type; "Document Type")
{
}
column(Document_No; "Document No.")
{
}
column(Source_Code; "Source Code")
{
}
column(Job_No; "Job No.")
{
}
column(Business_Unit_Code; "Business Unit Code")
{
}
column(Reason_Code; "Reason Code")
{
}
column(Gen_Posting_Type; "Gen. Posting Type")
{
}
column(Gen_Bus_Posting_Group; "Gen. Bus. Posting Group")
{
}
column(Gen_Prod_Posting_Group; "Gen. Prod. Posting Group")
{
}
column(Tax_Area_Code; "Tax Area Code")
{
}
column(Tax_Liable; "Tax Liable")
{
}
column(Tax_Group_Code; "Tax Group Code")
{
}
column(Use_Tax; "Use Tax")
{
}
column(VAT_Bus_Posting_Group; "VAT Bus. Posting Group")
{
}
column(VAT_Prod_Posting_Group; "VAT Prod. Posting Group")
{
}
column(IC_Partner_Code; "IC Partner Code")
{
}
column(Amount; Amount)
{
}
column(Debit_Amount; "Debit Amount")
{
}
column(Credit_Amount; "Credit Amount")
{
}
column(VAT_Amount; "VAT Amount")
{
}
column(Additional_Currency_Amount; "Additional-Currency Amount")
{
}
column(Add_Currency_Debit_Amount; "Add.-Currency Debit Amount")
{
}
column(Add_Currency_Credit_Amount; "Add.-Currency Credit Amount")
{
}
column(Dimension_Set_ID; "Dimension Set ID")
{
}
column(G_L_Account_Name; "G/L Account Name")
{
}
}
}
}
Hi Marc,
we are using SaaS release of business central with current "DE Business Central 19.3 (Plattform 19.0.34506.36038 + Anwendung 19.3.34541.34662)" version.
many thanks
Frank
Hello,
Are you using SaaS release of Business Central or OnPrem release and and what wave / CU?
Thanks.
#1
André Arnaud de Cal...
294,095
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
