I am very beginner to the Acumatica ERP.I have to do a customization which is in Sales Price Worksheet screen summary area invisible effectiveDate,expirationDate and Promotional fields and add them into same screen but into the details area(Grid). and then when user insert the input on the grid and saving of the Sales Price Worksheet and press remove hold then the release button and the Sales Prices screen prices should updated properly.The inputs of those added fields to the grid of sales price worksheet screen should be pass to the sales prices screen similarly.
In the sales price worksheet screen, the grid retrieve data from ARPriceWorksheetDetail Dac but Sales price screen grid retrieve data from ARSalesPrice Dac. The issue is those two Dac s are not connected in direct references. I couldn’t get same value of effectiveDate field in sale price worksheet screen to Sales Prices screen.
Basically I need to know how to connect ARWorksheetDetail Dac and ARSalesPrice Dac
