AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register

xRP Framework Fundamentals – Summit 2019

January 28, 2019 by Tim Rodman

Acumatica Summit 2019 Session – xRP Framework Fundamentals (Dhiren Chhapgar)

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

Filed Under: Acumatica Learning, Miscellaneous Tagged With: Acumatica, Acumatica 2019 R1, Acumatica Blog, Acumatica Learning, Acumatica Training

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
  • EP 35: Ideas for AUGForums.com Live with Ryan Brown (Podcast) December 12, 2020
  • EP 34: Talking Acumatica eCommerce and the Next Normal for Distribution, Wholesale, and Manufacturing with Ted Stenstrom (Podcast) December 11, 2020
Acumatica Learning Resources

Recent Forum Posts

  • Acumatica Payroll PTO Banks adjustment

    Has anyone figured out how you would make a manual entr...

    By MSylvia, 4 hours ago

  • Best Practices/Suggested Processes for Before and After Acumatica Version Upgrade

    We have a process in Sage 100 where we will run various...

    By CLove26, 4 hours ago

  • Denominated Currency Accounts, Foreign Currency and Project Accounting

    I'm noting this here for some future reference. I've s...

    By megan.friesen, 5 hours ago

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    I tried a simple test in 2020R1 and 2020R2 and it doesn...

    By AhmedBahar, 6 hours ago

  • Combining Bill Retainage Invoices to one AR Invoice in Construction

    Hi was wondering if anyone has come up with a good work...

    By Mike Baio, 11 hours ago

  • RE: Generic Inquiry RESULTS GRID Column Order

    On the Results Grid tab you can drag and drop the items...

    By Michael Roszkowski, 13 hours ago

  • RE: Acumatica 2020 R2 OwnerID Field

    Thank you, Tim. Just faced this problem in a customized...

    By Anna Borisova, 1 day ago

  • Import Azure AD Groups to User Roles Screen

    Hi AUG, I'm cross posting this from the community as I ...

    By Michael.Barker, 1 day ago

  • Link EPApproval to APInvoice

    I am trying to write a GI that will link an Invoice to ...

    By Michael Roszkowski, 1 day ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.