First read this topic: Before you Upgrade.
update
SETTINGS S set
S.MYVALUE = (select
S1.MYVALUE from
SETTINGS S1 where
S1.ACCESSID = 10000 and
S1.STAFFID = S.STAFFID)
where
S.ACCESSID = 10135;
commit
work;
It should be clear that if you are using standalone Estimates as well as Quotations, you could end up with all sorts of confusing scenarios (eg. linking an Estimate which has excluded items to a Quotation). It is therefore recommended that clients standardise on a model - Standalone Estimates or Quotations.
It should also be clear that if you use Quotations with Estimates and Items, you are not able to use SO/WO combined.
When adding multiple Estimates to a Quotation, you can obviously not run SO/WO combined.
Finishing/Services - A Calculate Qty Out (Sheets) function has been added to Finishing (in Print Estimates) and Services (in Generic Estimates). This functionality provides an alternative to using a non-printing press in the print wizard to calculate sheets when they are not printed. See image below.
When using Winflector you are able to Copy and Paste the grid selection into a spreadsheet.
Only the selected Customer/Supplier is updated, not the entire Age Analysis
If you switch to the new images, the following SQL can be used to link the existing Status list to the new images by Group (Pending = Yellow, Active = Blue, Complete = Green, Cancelled = Red)
update
STATUS set
IMAGEID = 9 where
GROUPID = 0;
update
STATUS set
IMAGEID = 15 where
GROUPID = 1;
update
STATUS set
IMAGEID = 14 where
GROUPID = 2;
update
STATUS set
IMAGEID = 5 where
GROUPID = 3;
commit
work;