Hello we just went live with Acumatica Monday. I am trying to learn to use the Generic Inquiry interface.
Basically I have 2 questions.
First question - I am working with multiple tables and trying to create joins using the interface. Having some trouble getting my head around setting up proper joins. I am use to just creating a SQL view (Oracle) and then access that view through our ERP via a report interface. Is there a specific method for me to see the code behind a Generic Inquiry that I create. I think that would really help me figure things out. If I understand correctly that would be the BQL code or some sort of combination of that and something else.
Second question - As I mentioned I am used to creating SQL views in our previous ERP (IFS). Reading through some post on line it appears we have that capability in Acumatica where we can create a SQL view and then create a DAC (Data Access Class) to look at that SQL view and then access that DAC via a Generic Inquiry or a Report. They mentioned the piece to create the SQL view is done outside of Acumatica by just going into the SQL database and creating the view. Since we don’t have the physical data base here I am trying to picture the process to achieve that. If anyone can explain the specifics of that it would be greatly appreciated.
Thanks
Joe Neumann
Peerless-AV
Aurora Illinois (Chicago burbs)