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...
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
    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,529 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

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