Convert All to Items

 The function Convert All to Items found on the Wgt.grp. menu in ShipWeight is not working properly in the 8.0 version. Weight groups with status 'E' (estimated) and 'D' (design) will not be converted. A workaround on this to be used until the 9.0 version is released, is here provided: 

1. Make a copy of your database (Save As). It is convenient to use the same ID with a suffix "_items".

2. Open the SQL window by selecting the menu item Database | Query | Project Database in the main window.

3. Copy in the SQL-command: "UPDATE SHIP_POST SET SHIP_POST.sStatus = 'A' WHERE (((SHIP_POST.sStatus)='E' Or (SHIP_POST.sStatus)='D'));" (skip quatation marks) and push the Execute-button.

4. Close the project without saving.

5. Reopen the project

6. Select the menu command Convert All to Items from the Wgt.grp. menu to konvert all weight group figures (e.g. estimates) to line items. Be sure that the uppermost weightgroup in the coding hierarchy is selected when running the command if you want all defined weight groups to be converted to line items.