update the record of forecastsale table

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi Guys.

please help i am beginner in Axapta to make it short i am trying to apply this SQL code

UPDATE FORECASTSALES
SET SALESQTY = FORECASTSALES.SALESQTY - PURCHREQLINE.PURCHQTY
FROM FORECASTSALES INNER JOIN
PURCHREQLINE ON FORECASTSALES.PROJID = PURCHREQLINE.PROJECT AND FORECASTSALES.ACTIVITYCODE = PURCHREQLINE.ACTIVITYCODE AND
FORECASTSALES.ITEMID = PURCHREQLINE.ITEMID

how could be code in x++ i am trying to put this in method

Many thanks and best regards.

rj

2

Use this query for updating multiple records…

update_recordset FORECASTSALES setting SalesQty = (FORECASTSALES.SalesQty - purchReqLine.PurchQTy)

join purchReqLIne where .purchReqLine.ProjId == FORECASTSALES.ProjId

&& purchReqLine.ItemId== FORECASTSALES.ItemId

&& purchReqLIne.ProjId != “”;