"Allow price adjustment" on a retail item in AX

I need to update a single field in all released products.

The field is in the MRCInventTable (above) which has only 17 columns.

The field is in the "Sell" fast tab on the released products form...

Field is called "Allow Price adjust" Which is a checkbox field (enum).

I've tried to update the field using Excel-Add-In but I get the below error message...

 

Field 'Reference' must be filled in.

   Error found when validating record.

Field 'Reference' must be filled in.

   Error found when validating record.

  Creation has been canceled

My Excel file has only 2 columns.

Items.Item number

Allow price adjust

1. Item number

2. Yes

Can anyone help?

Thanks

Joe

Related
Recommended