Acumatica BQL

BQL in Acumatica 

Acumatica gives different options to query the data, before Acumatica I never heard of such language. BQL Business Query Language seems to be native to Acumatica 

Luckily, it is not too far from SQL, below is an example and its SQL equivalent:

Complex BQL 

Equivalent in SQL

     Select *  From BalancedAPDocument
            Left Join APInvoice
                On APInvoice.docType=BalancedAPDocument.docType
                    And APInvoice.refNbr=BalancedAPDocument.refNbr
            Left Join APPayment
                On APPayment.docType=BalancedAPDocument.docType
                    And APPayment.refNbr=BalancedAPDocument.refNbr
            Left Join APAdjust
                On APAdjust.adjgDocType=BalancedAPDocument.docType
      Group By BalancedAPDocument.docType,
               BalancedAPDocument.refNbr,
               BalancedAPDocument.released,
               BalancedAPDocument.prebooked,
               BalancedAPDocument.openDoc