Dear All,
I have created a table in BC but inserting data from Sql insert query. Unfortunately, this table is disappearing from Sql server but can be seen/accessed from AL report.
I am wondering why my table is in Sql because it was been there initially. I created another and inserted the data and again it disappeared. When I ran the select query I get an error referring to inexistence of an object.
Whoes got the idea on what happened on that table?.
Suresh,
Since am unable to do Summation in AL, am using SQL to do all my summation since its more flexible, then the result of summation am inserting it in AL table then I will build a report that will be ran and transfer the data to Journal. That's what am doing.
I am sorry are you using SQL Query for AL Report? Please provide more details.
What version are you running? and why are you using SQL insert to insert the data? What happens if you insert the data from BC? I don't believe inserting data from SQL will cause that but I also don't like the idea of inserting data using SQL, either do that from AL or using Integration.
Hello,
This does not sound familiar to me. Please consider raising a support request with Microsoft support if you have a repro of the scenario in a demo database.
Thanks.
#1
YUN ZHU
499
Super User 2025 Season 1
#2
Sagar Dangar, MCP
373
#3
Mansi Soni
327
Share
Report
All responses (
Answers (
