Sage 100

I need to modify beginning quantities and cost in the IM_PeriodPostingHistory table for 01/2017. These fields are not available in VI. I have this cheat sheet on how to add read only fields, but don't know what version it was for and can't figure out what I need to change to make this happen. Any ideas?

This one is 4.x framework - I don't think it will harm anything to try it. You can always switch the field back to read only. DFDM MAS90\providex.ddf Lookup by name to find the VI entity to modify - get the key ID. DFDM MAS90\providex.dde Search by Key. Find the field record you want to modify Edit field 20 (15,1) a zero is importable. a 1 is read only.

I see where I may be missing it. #1. looks at providexddf #3. looks at providexdde

I figured it out and modifed this doc with pics.

@MoiraGoggin good for Evernote KB. ??

It's there Jim.

This is where SQL is perfect for this type stuff! But beware of what you are doing!!