Skip to main content
Solved

lBqlTable


Forum|alt.badge.img

I am in the process of trying to connect a SQL Server View to Acumatica. Right now I am on the “Create Code File” and there should be, in the drop down the ability to select lBqlTable but it does not exist. 

The only selections that are available are:

New Graph, New DAC, Graph Extension, DAC Extension, Code File, and Customization Plug-in.

 

Best answer by Giri K

Hi @billmarmc 

If you want to access View from Sql in Acumatica.You have to create DAC for that View.

View original
Did this topic help you find an answer to your question?

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • May 3, 2023

Hi @billmarmc  SQL VIEW will be treated as a table in Acumatica so that you can create a DAC file to SQL View and use it accordingly.


Forum|alt.badge.img+1
  • Pro I
  • 59 replies
  • Answer
  • May 3, 2023

Hi @billmarmc 

If you want to access View from Sql in Acumatica.You have to create DAC for that View.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 16 replies
  • May 3, 2023

Thank you both for your reply, but I still don’t understand why the lBqlTable does not show up in the drop list when attempting to link a View to Acumatica. I have Views already and trying to “tie” those Views to Acumatica. The steps involved cite using the “Create Code File” and there should be, in the drop down, the ability to select a lBqlTable which does not exist. 

The only selections that are available are in the drop down are:

New Graph, New DAC, Graph Extension, DAC Extension, Code File, and Customization Plug-in.

unless there exists another way to “tie” the View to Acumatica or I am missing a step somewhere.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 16 replies
  • May 3, 2023

Both of you are correct in your answers. I was able to use “Adding a custom SQL view to Acumatica” put out by Cloud 9 Videos, walked me through the steps and nowhere was there any mention of selecting the mysterious lBqlTable. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings