x Want to participate? Join the group to interact

Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Customization and Productivity Show Bin Location in Sales Order Entry Sage ERP 100 2014

Show Bin Location in Sales Order Entry Sage ERP 100 2014

Posted By MJZ over 9 years ago

I added a UDF in Sales Order Detail for the Bin Location, but I cannot find out how to get the default value.

I know the data is stored in the IM_ItemWarehouse for that Warehouse/Item combination.

The client had the Bin Location when they were using Shipping data entry, but they do not want to use that anymore.

Thank you in advance.

0 BigLouie over 9 years ago

Not sure what you are asking. What would the default value be? Why don't they want to use the Bin Location anymore? What do they want to use?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 MJZ over 9 years ago in reply to BigLouie

They do not want to use Shipping Data entry, Just Sales Order Entry/ Invoice data entry. Sales Order entry does not currently show a Bin Location and they would like to see it on the panel.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BigLouie over 9 years ago in reply to MJZ

You can use Custom Office to easily add the Bin Location field from IM_Warehouse to the grid in Sales Order Entry and in Sales Order Invoice Data Entry. Pretty simple. It would not show on the panel but in the line item primary or secondary grid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 MJZ over 9 years ago in reply to BigLouie

The Bin Location is in the IM_ItemWarehouse, not the IM_Warehouse, and I did not see where I could default it from there.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 9 years ago in reply to MJZ

You might have to write a script to look up and pull the value into a UDF whenever the ItemCode or WarehouseCode is updated.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel