I am trying to add the Finished Product Bin Location to a Crystal Reports Picking Sheet form. Can anyone assist?
It all depends on what version of MAS90 errr Sage 100 ERP you are on. If current you would create a UDF in the works table and make as it's source the bin location field from the Item Warehouse table.
I am somewhat of a novice at this - can you give me more details?
Your reseller can show you. My suggestion is to have your reseller come on site and show you how if you are a novice. Not hard. Once you had done this you have to verify the database in the report to get the new field to show up.
You do know that you can go into the Help files and type in UDF and the first thing that is listed is how to add a UDF to a Crystal works table.
The IM_ItemWareouse data source will get you data for the component, not the parent bill. The bin location for the component is in the wrk table already.
*Community Hub is the new name for Sage City