Interprise Suite Community / Interprise Suite Community Forums / Questions and Comments About Features, Functions and Workarounds / eCommerce / Vew ALL orders on web / Latest Posts

RE: Vew ALL orders on web

BJ Dimes — Thu, 18 Jun 2009 09:37:31 GMT

Jim,

IS does not look at the default property inside of SQL Server database when populating data. IS does look at the default property inside the data dictionary but on system tables and views, you can not change this property.

RE: Vew ALL orders on web

BJ Dimes — Thu, 18 Jun 2009 09:34:54 GMT

David,

Have you tried going into the Data Dictionary, locating the CustomerSalesOrderView view, and filling in the lookup properties?

1) System Manager -> Manage Data Dictionary
2) Locate CustomerSalesOrderView view under the System Views section
3) Locating the WebSiteCode field (towards the bottom of the list of fields)
4) Update the following in the Column Properties:
List Type = Dynamic List
Pull Down Table = WebSite
Pull Down Column = WebSiteCode
5) Save and close the data dictionary

After you have made the changes, you will need to go into your user role, remove the field, save the user role, exit and relog back into IS (needs to refresh the internal cache), go back into your user role, and add the field again. You should notice that it now is a dropdown box instead of a text field.

Hope this helps.

RE: Vew ALL orders on web

Jim Wolf — Thu, 18 Jun 2009 05:54:46 GMT

What about changing the data item properties in the SQL table to default to WEB-000001?

RE: Vew ALL orders on web

David — Wed, 17 Jun 2009 10:13:11 GMT

Had a quick go at changing the user roll to allow website allocation. It works :D

- However I was expecting a pull down list of available websites - instead had to type in the exact name .i.e. 'WEB-000001' which will be too much effort day-to-day.

RE: Vew ALL orders on web

David — Wed, 17 Jun 2009 08:52:56 GMT

Thanks for your quick reply, it sounds logical.

As we do not plan to have more than one web site, the second of the 2 solutions will be by far the best. As I hate having lots of SQL scripts running all over the place (support often blames those kind of things for breaking the main software) is there any way to set the default web site to any new order/invoice

RE: Vew ALL orders on web

BJ Dimes — Tue, 16 Jun 2009 09:18:19 GMT

David,

The reason why you are not seeing all the orders is because you could have multiple sites setup in IS pointing to your single database. IS didnt want orders from website 2 to show up on website 1.

The way to get around this is to add the 'WebSite' code to the Sales Order Entry Form using the User Role Manager (I believe they have already assigned the table lookup so when you drop it on, you'll get a validated list of sites). Then during order entry, the user will then need to select the website code.

Another way to get around this is if you only have one site, create a SQL Job that stuffs the website code (normally WEB-000001) into all sales orders that do not have the code filled in and have it run every 10 minutes or so. This way you dont have to worry about it and every 10 minutes, the code will be placed automatically into the sales order record so it shows up on the web.

Hope this helps.

Vew ALL orders on web

David — Tue, 16 Jun 2009 08:25:08 GMT

Currently only orders placed via the web are displayed in the 'Order/Billing history' when viewed by a 'logged in' web customer. With "One Business Logic and One database" being the main motto of Interprise, I am disapointed not to see all customer orders displayed on the web. (i.e. phone orders)

Any ideas how to get this info to show?

David