There aren’t many developers out there who know how to make the Acumatica Framework sing in specific business situations. Dhiren Chhapgar is one of those developers.
Dhiren has been cranking out useful Acumatica customizations (like this one) for years and I’m pretty sure that he might even dream in BQL. Extremely talented and a great person.
Even though this session was pretty much over my head since I don’t know C#, I attended it because Dhiren was the presenter.
Note: Dhiren graciously reviewed these notes and provided two corrections. They are noted underneath the relevant screenshots.
Starting the xRP Framework session with Dhiren #AcumaticaSummit pic.twitter.com/tB0khN3kmD
— Tim Rodman (@TimRodman) January 28, 2019
What you can do with xRP Framework #AcumaticaSummit pic.twitter.com/CJV0mIJmKC
— Tim Rodman (@TimRodman) January 28, 2019
We are going to build a new screen. I'm hoping without needing Visual Studio #AcumaticaSummit pic.twitter.com/QXPVpIgC1I
— Tim Rodman (@TimRodman) January 28, 2019
These will be our tables #AcumaticaSummit pic.twitter.com/eoB1PTSrnk
— Tim Rodman (@TimRodman) January 28, 2019
Our SQL Script #AcumaticaSummit pic.twitter.com/qWEx9pyye1
— Tim Rodman (@TimRodman) January 28, 2019
Adding our SQL table to a DAC in a Customization Project #AcumaticaSummit pic.twitter.com/8C9uV5Mcml
— Tim Rodman (@TimRodman) January 28, 2019
The RentalLine DAC #AcumaticaSummit pic.twitter.com/0DWcPmcVlb
— Tim Rodman (@TimRodman) January 28, 2019
OrderNbr holds the value and orderNbr is used in queries like a Generic Inquiry #AcumaticaSummit pic.twitter.com/FN6vXlGDhy
— Tim Rodman (@TimRodman) January 28, 2019
Correction from Dhiren: orderNbr represents the data field in BQL (Business Query language) statements.
Then pasted in new code #AcumaticaSummit pic.twitter.com/uIVNNbKwxZ
— Tim Rodman (@TimRodman) January 28, 2019
PXDefault to make something mandatory or supply default value #AcumaticaSummit pic.twitter.com/f4r69fzXcU
— Tim Rodman (@TimRodman) January 28, 2019
PXParent to link the DACs together #AcumaticaSummit pic.twitter.com/7NvDMmAwHc
— Tim Rodman (@TimRodman) January 28, 2019
Now we'll create a new screen #AcumaticaSummit pic.twitter.com/9cYHIg7hqJ
— Tim Rodman (@TimRodman) January 28, 2019
RentalOrderEntry DAC automatically created. Also ASPX page automatically created. #AcumaticaSummit pic.twitter.com/EW1N6Bqeul
— Tim Rodman (@TimRodman) January 28, 2019
Replace MasterTable with our DACs pic.twitter.com/Pw7iOK6NMd
— Tim Rodman (@TimRodman) January 28, 2019
Changing DataMember pic.twitter.com/dwtW4JlKqP
— Tim Rodman (@TimRodman) January 28, 2019
This is the screen we are building pic.twitter.com/SMi54TMkhj
— Tim Rodman (@TimRodman) January 28, 2019
Need to add a Numbering Sequence to our screen #AcumaticaSummit pic.twitter.com/2w8qjA04U1
— Tim Rodman (@TimRodman) January 28, 2019
Adding new field to SO101000 pic.twitter.com/hDOqh7aZVv
— Tim Rodman (@TimRodman) January 28, 2019
Making this field a Selector pic.twitter.com/6nEVTjW4Ae
— Tim Rodman (@TimRodman) January 28, 2019
Now we can add the field to the screen pic.twitter.com/x8E1lcro8P
— Tim Rodman (@TimRodman) January 28, 2019
We can define the Numbering Sequence for our field pic.twitter.com/1Fgk7gIRxr
— Tim Rodman (@TimRodman) January 28, 2019
Now the field is on the screen pic.twitter.com/vSYg33V4wK
— Tim Rodman (@TimRodman) January 28, 2019
Have to add this attribute to get the field to use the Numbering Sequence pic.twitter.com/p7fzJfe9vi
— Tim Rodman (@TimRodman) January 28, 2019
Now the Order Nbr. field respects the Numbering Sequence pic.twitter.com/oQoqu4iTjL
— Tim Rodman (@TimRodman) January 28, 2019
We can also add lines to our Rental Order pic.twitter.com/ard3aPxSps
— Tim Rodman (@TimRodman) January 28, 2019
This is the formula that calculates Ext. Price pic.twitter.com/lK2UpjjHl8
— Tim Rodman (@TimRodman) January 28, 2019
Correction from Dhiren: This is the formula that calculates line Ext. Price and Order Total.
Overview of what we did pic.twitter.com/wouM581m4w
— Tim Rodman (@TimRodman) January 28, 2019