Solved

Adjustment to Sales Price Worksheets input

  • 22 March 2024
  • 2 replies
  • 56 views

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

icon

Best answer by Atiq 23 March 2024, 01:51

View original

2 replies

Userlevel 5
Badge +1

Hi @rashmi96 ,

The ARWorksheetDetail is custom, I can not find it and check fields in Acumatica. Could provide fields from this DAC? I think you need to write join or two commands SelectFrom<IBQLTable> your tables and match results by fields

Userlevel 3
Badge

Hi @rashmi96 ,

                            The  ARPriceWorksheetDetail Dac, and ARSalesPrice Dac  Donot have a Direct Relationship,  you need to give relation Via  ARPriceClass Dac

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved