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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Object Query 261 Column Structure

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    Are you using SaaS release of Business Central or OnPrem release and and what wave / CU?

    Thanks.

  • DigitalFinance Profile Picture
    5 on at

    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

  • Suggested answer
    MahGah Profile Picture
    15,583 on at

    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")

               {

               }

           }

       }

    }

  • DigitalFinance Profile Picture
    5 on at

    Thank you for the comparison, it was very helpful for me.

    Best Frank

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,822 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,136 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 956 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans