Osf 1.0.2.11

Fixed

Data set was still open.

Added

SEXTERNALID to stock table for external reference. This can be seen and edited in export / import files but not in the interface. The OSCommerce plugin will use this field to identifie the record in osC.

OSCommerce

Now the SEXTERNALID is filled with the productid so the sql generated to update the stock can be more efficient.

Updating the stock level now will only update items that are in a uposted document. Then it will update the Qty to stock.QtyOnhand - Unprocessed sales + Unprocessed purchases.

This way the stock level will be more accurate.