Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Charlie Melendez]

Hello,

I am new to Navision, but have been working with Dynamics GP for almost 10 years. Is there a table in Navision 2009 that contains trial balance information? Similar to GP’s GL11110 table.

Or is there a SQL script someone can share? 

Thanks in advance!

——————————
Charlie Melendez
Storm Industries, Inc.
Torrance CA
——————————

[Jason Taylor]

Hi.

 

Have you tried the table, 85 Acc. Schedule Line?

 

This should have all lines that relate to the entries.

 

Hope this helps

 

 

Jason Taylor

 

JTaylor@archerpoint.com

 

https://www.linkedin.com/in/jastay2726

 

 

 

Website: http://www.archerpoint.com • Phone: (984) 208-9020

 

Please note that ArcherPoint will be closed for a companywide event on Friday, July 21. Due to this, we will have limited support available on Thursday, July 20 and Friday, July 21. Customers should contact support via email, portal or regular phone number but only emergency issues will be dealt with immediately. All other issues will be taken care of the following Monday. If you have a business impacting or system down emergency please call 866-343-4517, option 2 and someone will assist you.

 

The information transmitted is intended only for the person or entity to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer

 

——Original Message——

Hello,

I am new to Navision, but have been working with Dynamics GP for almost 10 years. Is there a table in Navision 2009 that contains trial balance information? Similar to GP’s GL11110 table.

Or is there a SQL script someone can share? 

Thanks in advance!

——————————
Charlie Melendez
Storm Industries, Inc.
Torrance CA
——————————

[Andrew Good]

Why are you looking for a table to see the Trial Balance? What are you trying to accomplish? There may be other ways in NAV to meet your needs.

You can filter the Chart of Accounts or use one of the Balance functions from there.

The Trial Balance in NAV is the created from the General Ledger Entries (table 17) by applying date filters.

——————————
Andrew Good
President
Liberty Grove Software
Oakbrook Terrace IL
——————————
——————————————-

[James Hummer]

There is no summary or beginning balance concept as in Dynamics GP.    You might want to consider to use the BI360 Data Warehouse if you want those features.

——————————
Jim Hummer
Consultant
Solver
Los Angeles CA
——————————
——————————————-