Personalization, Customization and Productivity Tools

[it_q-lab]

Is it possible to create a UDT, and then to add a grid to the sales order header panel that references the UDT as a datasource? For instance if I wanted to created a UDT called weights and dimensions. There might be several fields witihin the UDT for packaging type, weight, size, length, etc. Now, with this new table I want to let the user enter as many packages as it will take to ship this order (i.e. via a grid). Can I drop a grid on the for mand point it to the UDT?

[it_q-lab]

Is there anyone out there who can help with this?

[rolandc]

I would love to know the official answer to this as well. I asked a similar question a while back but didn't receive any responses... http://community.sagemas.com/t5/Business-Object-Interface/Listbox-Reference/m-p/50460

I scoured all over the Customizer module but couldn't find anywhere to add a Grid or List View control, so apparently it cannot be done without source code modification. I came across an alternative where (if you have BOI and .NET knowledge) you could create a button link in customizer, set it to execute your .NET app and pass a variable to it, and then load the data you need into a list-view control so that the grid would be in the separate window.

[VKZIMM]

I am not sure what you want to do, but if you want to select a value from a UDT then create a UDF in the

Sales Order Header with Validation against your UDT.

You can add a panel to Sales Order through Customizer.  On the DMain panel   Right Click and under Custom Tabs Click New

It will give you Tab 5 and then add your UDF from the Sales Order Header which is verifying against your UDT.

I hope this helps.

[it_q-lab]

I agree, that looks like the only alternative. Were you able to update records in tables using your .NET app? If so could you give any advice in this realm? From what I see we still have no insert or update ability with the ODBC driver, and I thought I heard that VI is being deprecated. So I am wondering if there is any simple way to insert a sales order record into the SO_SalesOrderHeader table for example.

[it_q-lab]

VKZIMM  - Thanks for the response. What I am trying to do is to actually have a grid of my own on the sales order screen where a user can add one or more records to a UDT. In your example a control is validating against an administration table. What I would like to do is have the ability to enter data into the administration table from an end user screen such as Sales Order Header.

[rolandc]

As far as updating records in either a UDT or standard MAS tables, if you have taken the BOI class, this would be a piece of cake! I took it about 6 months ago, and along with the course and this forum, I accomplished so much than what older versions of MAS would allow. Anyway, I can tell you the course does provide source code examples in both VB and C# .NET of some basic projects, including one that creates a record in SO_SalesOrderHeader.

The main reason why the ODBC driver is read-only is to comply with the business rules in MAS, for instance if there is a field that accepts only uppercase characters and validates against a list among other things, ODBC would allow for this whereas the BOI would catch this and throw an error right away.