Sage 100

Bad records in IM_ItemWarhouse, version 4.5 PU4. I have records tied to WH codes like '45' and '23' - 2-digit WH codes that I can't add to the IM_Warehouse table, so we have items that are bombing on the item quantity tab because MAS can't find the WH - Sage fix is to add the WH but I can't add a 2 character WH. I ran rebuilds and sorts on all IM files. Not sure where to go from here - I can delete the bad records using DFDM but there are hundreds, maybe thousands - not sure how they got in there to begin with (took this client over from a reseller no longer around). Any help would be appreciated.

Can you VI the WH codes after removing validation?

Wayne - you can't remove validation for IM files on 4.4 and above. Eric - not sure how to quickly address this. If they were on the SQL version, it could be handled rather easily. Are they quantities on hand and things of this nature for these bad records? I was thinking perhaps a UDS, but it will not delete the record if the business logic says it cannot.

Warehouse code is part of the key, so VI'ing would only work if you exported, reinitialized, and imported. How about DFDM to add the 2 digit warehouse codes? You just need to determine whether the space is at the start or end, then modify a current record and when it asks if you want to delete the old rec, say no and it will create a new one.

Most are 0 but some have qty on hand. I don't see a way a way to use VI to fix because the WH code is part of the key.

That's the crazy thing - from what I can tell there is no space. It's 2 digits in the key, not 2 and a space. The brackets are around 2 characters only, not two and a space. And I don't see any way to add a 2-digit WH code to IM_Warehouse.

You can setup WH 023, then goto DFDM and edit the rec and change WH code to 23. The warehouse can then be selected in WH maint via lookup.

@LeeGraham - that worked. They already have a 023 so I created WH code XX, and then changed to '23' with DFDM. Thanks everyone!!