Update Accounts "Include in Lookups" 1

[barbola]

I have one company database that for some reason alot of accounts that were created do not have all four modules selected in the Include in Lookups section.

Is there a way to mass update this? It does not show up on the Mass Modify screen.

This is what the DSPLKUPS field in GL00100 shows:

Correct Account setup: 0xFFFFFFFF
Incorrect Setup: 0x3C004200

I tried using "select actindx, actnumbr_1, actnumbr_2, actnumbr_3, actnumbr_4, actdescr, dsplkups from gl00100
where dsplkups like '0x3C004200%'
and I get no records.

thanks.

 

[klewis10367]

You could run the accounts through integration manager and just make sure that you choose to update the Lookup fields.

 

[barbola]

Great idea!

thanks.

 

[RobertC22]

Barbola,

The DSPLKUPS field is a binary field, not string. You need to treat it like a number when doing a comparison in t-sql so no single quotes.

The select would become something like:

select * from GL00100
where DSPLKUPS = 0x3C004200

Once you know what it should be, just do an update, like the following.

update GL00100
set DSPLKUPS = 0xFFFFFFFF
where DSPLKUPS = 0x3C004200

------
Robert

 

[barbola]

Perfect! thanks very much RC22.