Dynamics GP - Update GL Segment Descriptions

update gl40200 set dscriptn = 'Freehold Land' where sgmtnumb = 1 and sgmntid = 1000


Excel Formula, col D
=IF(LEN(B3)>0,"update gl40200 set dscriptn = '"&LEFT(B3,31)&"' where sgmtnumb = "&A$22& " and sgmntid = '"&A3&"'","")