Issue #23507:tweak implementation files

diff --git a/foundation-database/manifest.js b/foundation-database/manifest.js
index 6cfa1ba..faa09c4 100644 (file)
--- a/foundation-database/manifest.js
+++ b/foundation-database/manifest.js
@@ -1014,12 +1014,13 @@
 
     "public/tables/bankrecitem.sql",
     "public/tables/cashrcpt.sql",
+    "public/tables/itemsite.sql",
+    "public/tables/location.sql",
     "public/tables/metric.sql",
     "public/tables/priv.sql",
     "public/tables/tax.sql",
     "public/tables/taxpay.sql",
 
-    "public/tables/location.sql",
     "public/views/address.sql",
     "public/views/apmemo.sql",
     "public/views/armemo.sql",
@@ -1625,6 +1626,8 @@
     "public/tables/report/WarehouseMasterList.xml",
     "public/tables/report/items.xml",
 
-    "public/patches/fixacl.sql"
+    "public/patches/fixacl.sql",
+
+    "public/tables/setVersion.sql"
   ]
 }

diff --git a/foundation-database/public/tables/itemsite.sql b/foundation-database/public/tables/itemsite.sql
new file mode 100644 (file)
index 0000000..39c225d
--- /dev/null
+++ b/foundation-database/public/tables/itemsite.sql
@@ -0,0 +1,9 @@
+-- incident 23507:change how qoh, qoh available, and qoh netable are determined
+do $$
+begin
+if fetchMetricText('ServerVersion') < '4.7.0' then
+  update itemsite set itemsite_qtyonhand=(itemsite_qtyonhand + itemsite_nnqoh);
+  -- drop column itemsite_nnqoh ???
+  update itemsite set itemsite_nnqoh=0;
+end if;
+end$$;
\ No newline at end of file

diff --git a/foundation-database/public/tables/location.sql b/foundation-database/public/tables/location.sql
index 09447d0..a5cf13d 100644 (file)
--- a/foundation-database/public/tables/location.sql
+++ b/foundation-database/public/tables/location.sql
@@ -14,7 +14,5 @@ do $$
 begin
 if fetchMetricText('ServerVersion') < '4.7.0' then
   update location set location_usable=true;
-  update itemsite set itemsite_qtyonhand=(itemsite_qtyonhand + itemsite_nnqoh);
-  -- drop column itemsite_nnqoh ???
 end if;
-end$$;
\ No newline at end of file
+end$$;

diff --git a/foundation-database/public/tables/metric.sql b/foundation-database/public/tables/metric.sql
index 6f9894e..21c8615 100644 (file)
--- a/foundation-database/public/tables/metric.sql
+++ b/foundation-database/public/tables/metric.sql
@@ -2,5 +2,3 @@
 insert into metric (metric_name, metric_value)
 select 'UnifiedBuild', 'true'
 where not exists (select c.metric_id from metric c where c.metric_name = 'UnifiedBuild');
-
-SELECT setMetric('ServerVersion', '4.5.0Beta');

diff --git a/foundation-database/public/tables/setVersion.sql b/foundation-database/public/tables/setVersion.sql
new file mode 100644 (file)
index 0000000..8d468a4
--- /dev/null
+++ b/foundation-database/public/tables/setVersion.sql
@@ -0,0 +1 @@
+SELECT setMetric('ServerVersion', '4.5.0Beta');