timItem.AvailForSale

Question

Hi All, 
 I just want to ask, in timItem table, there is a column for 'AvailForSale' (Available For Sale). 
 
 Where can I find this on the front end in Maintain Item? 
 I can't find where this is being set or controlled. 
 Thank you, 
 Tony

Ramon M. · Accepted Answer

I took a brief look at this from the back-end. Given the schema browser definition of this field, I would guess that many, many, moons ago there was a plan for this field and it was put into schema but never implemented. There does not appear to be a reference to it in any of the client source, and only passing references to it in database source. There does not appear to be any processing that supports the schema browser explanation that it stops an item from being placed on a sales order, but allows them to be placed as a kit component, effectively making it a kit component item only. 
 If you have an item in inventory and set the AvailForSale to 0, the behaviors do not change. I would consider it a field that was never implemented. It always has a value of 1 due to a default constraint. 
 At this point, I would assume it could only be used for a customization where customization code could manipulate the value and base decisions upon it without any Sage 500 ERP core support. 
 Consider saving the support case for something else.

Sage 500

timItem.AvailForSale

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING