How to add a column to price sheets?

Question

Hi All, 
 First post, a little bit about myself: I'm an IT intern for a small manufacturing company in Northern Colorado, I've been given some projects that involve MAS 500, mainly report customization. There currently is no on-site IT staff, so I've come here for a bit of insight. 
 So, I'm looking to add a column to a grid; specifically our price sheets. (Inventory Management > maintenance > Maintain Prices > Price Sheets) 
 As they are, we have an item # and associated pricing attributes, but many users of the system are requesting we add an 'Item Description' to the gird. After some research I've found that reports and lookups are generated through SQL views, and that MAS is meta-data driven; so there should a record in a table that contains the columns to be returned for the price sheets. 
 I've searched in the 'tsmLookupView' tables, and haven't found anything matching our price sheet; and haven't found a view that returns our pricing information. I have run a SQL trace, and found the SQL query that is being executed when calling the price sheets, but haven't found where to edit that statement and to add any meta-data for the price sheet. 
 Any assistance or insight would be appreciated!

LouDavis · Accepted Answer

Unfortunately the task Maintain Price Sheets is not built using Meta-Data. It is a standard VB 6 program. In order to add an additional column to the grid, you will need have a modification done to the source code. This will require the Sage 500 SDK as well as the source code for the IM Module. Customizer is not a viable solution for this as it is "quirky" when working with grids in Sage 500 depending on the task being customized. 
 From your post it appears you may not havethe SDK or source code, so if you need this customization done I would suggest contacting your reseller to see if they could do it or sub-contract the work to a reseller such as E2B Teknologies to do the work. 
 In regards to underlying views being used for lookups you are correct. Views are also used to populate the various Business Insights Explorers in Sage 500 with data. However, for report tasks that generate a Crystal Report file, these are created using work tables and stored procedures to populate those. The task that creates the Crystal Report is responsible for this. 
 I hope this helps.

Sage 500

How to add a column to price sheets?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING