Topic: Purchase Order Report 209 extended with Non Field DB Data
If a supplier provides free Pre Paid Freight if the order exceeds a certain value (eg., PPFrt#2000) and accepts orders above a certain Minimum Order value (eg., MO#100) and we need these values on the Purchase Order, the commit in my GitHub repo does it.
The said formatted values should already exist in the #_suppliers.notes field.
During the preparation of this mod, starting with a fresh FA install with customer, supplier and items imported, the sql statements necessary to reset the FA database after testing POs were:
TRUNCATE TABLE `1_audit_trail`;
TRUNCATE TABLE `1_comments`;
TRUNCATE TABLE `1_gl_trans`;
TRUNCATE TABLE `1_grn_batch`;
TRUNCATE TABLE `1_grn_items`;
TRUNCATE TABLE `1_purch_data`;
TRUNCATE TABLE `1_purch_order_details`;
TRUNCATE TABLE `1_purch_orders`;
TRUNCATE TABLE `1_refs`;
-- SELECT * FROM `1_stock_master` WHERE material_cost <> 0'
-- UPDATE `1_stock_master` SET `material_cost`='0' WHERE `material_cost`<>'0'
UPDATE `1_stock_master` SET `material_cost`='0' WHERE `stock_id`='ITEM001';
TRUNCATE TABLE `1_stock_moves`;
TRUNCATE TABLE `1_supp_invoice_items`;
TRUNCATE TABLE `1_supp_trans`;
-- SELECT * FROM `1_sys_types` WHERE next_reference <> 1;
UPDATE 1_sys_types SET next_reference=1 WHERE next_reference <> 1;