details: /erp/stable/2.50/rev/10a4cc5f375f
changeset: 9408:10a4cc5f375f
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Tue May 03 12:23:26 2011 +0200
summary: Fixes issue 0016533: the invoice date, when the invoice is voided,
should be updatable
It has been modified the READ ONLY LOGIC condition to make the invoice date
editable for void invoices not only for the reversed void invoice
details: /erp/stable/2.50/rev/fb72eee86408
changeset: 9409:fb72eee86408
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Wed May 04 18:11:19 2011 +0200
summary: Fixes issue 0017004: M_INOUT_CREATE, Products are not taken in the
correct order. Movements between bins modifies the FIFO order.
It has been modified the sentence that gets the bin to priorityze by the
CREATED field of the M_ATTRIBUTESETINSTANCE table
diffstat:
src-db/database/model/functions/M_INOUT_CREATE.xml | 7 +++++--
src-db/database/model/functions/M_PRODUCTION_RUN.xml | 6 ++++--
src-db/database/sourcedata/AD_COLUMN.xml | 2 +-
3 files changed, 10 insertions(+), 5 deletions(-)
diffs (59 lines):
diff -r 5faf0ae12810 -r fb72eee86408
src-db/database/model/functions/M_INOUT_CREATE.xml
--- a/src-db/database/model/functions/M_INOUT_CREATE.xml Thu May 05
11:13:43 2011 +0200
+++ b/src-db/database/model/functions/M_INOUT_CREATE.xml Wed May 04
18:11:19 2011 +0200
@@ -105,7 +105,9 @@
T.M_PRODUCT_UOM_ID,
COALESCE(T.QtyOnHand, 0) AS QtyOnHand,
T.QtyOrderOnHand AS QtyOrder
- FROM M_STORAGE_DETAIL T,
+ FROM M_STORAGE_DETAIL T LEFT OUTER JOIN
+ M_ATTRIBUTESETINSTANCE A
+ ON T.M_ATTRIBUTESETINSTANCE_ID = A.M_ATTRIBUTESETINSTANCE_ID,
M_LOCATOR L
WHERE T.M_PRODUCT_ID=p_Product AND
T.M_LOCATOR_ID=L.M_LOCATOR_ID AND
@@ -115,7 +117,8 @@
COALESCE(T.M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_Attribute,
COALESCE(T.M_ATTRIBUTESETINSTANCE_ID, '0')) AND
COALESCE(T.QtyOnHand, 0)>0
ORDER BY L.PRIORITYNO,
- T.CREATED;
+ A.CREATED, T.CREATED;
+
v_storage Cur_Storage%ROWTYPE;
--
v_NextNo varchar2(32);
diff -r 5faf0ae12810 -r fb72eee86408
src-db/database/model/functions/M_PRODUCTION_RUN.xml
--- a/src-db/database/model/functions/M_PRODUCTION_RUN.xml Thu May 05
11:13:43 2011 +0200
+++ b/src-db/database/model/functions/M_PRODUCTION_RUN.xml Wed May 04
18:11:19 2011 +0200
@@ -76,7 +76,9 @@
T.M_PRODUCT_UOM_ID,
COALESCE(T.QtyOnHand, 0) AS Qty,
T.QtyOrderOnHand AS QtyOrder
- FROM M_STORAGE_DETAIL T,
+ FROM M_STORAGE_DETAIL T LEFT OUTER JOIN
+ M_ATTRIBUTESETINSTANCE A
+ ON T.M_ATTRIBUTESETINSTANCE_ID = A.M_ATTRIBUTESETINSTANCE_ID,
M_LOCATOR L, M_WAREHOUSE W
WHERE T.M_PRODUCT_ID=Product_ID
AND T.C_UOM_ID=UOM
@@ -89,7 +91,7 @@
END
),
L.PRIORITYNO,
- T.M_ATTRIBUTESETINSTANCE_ID,
+ A.CREATED, T.CREATED,
T.M_PRODUCT_UOM_ID;
v_storage CUR_STOCK%ROWTYPE;
-- ProductionLines which are non-stocked BOMs (need to be resolved)
diff -r 5faf0ae12810 -r fb72eee86408 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Thu May 05 11:13:43 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed May 04 18:11:19 2011 +0200
@@ -62369,7 +62369,7 @@
<!--3783--> <ISPARENT><![CDATA[N]]></ISPARENT>
<!--3783--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
<!--3783--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--3783--> <READONLYLOGIC><![CDATA[@Posted@='Y' | (@Processed@='Y' &
(@DocStatus@!'VO' | (@DocStatus@='VO' &
@VoidAutomaticallyCreated@=0)))]]></READONLYLOGIC>
+<!--3783--> <READONLYLOGIC><![CDATA[@Posted@='Y' | (@Processed@='Y' &
(@DocStatus@!'VO'))]]></READONLYLOGIC>
<!--3783--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
<!--3783--> <SEQNO><![CDATA[250]]></SEQNO>
<!--3783--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
