0003459: generate average costs no work correctly with invoice return

(0003941)
user71
2008-02-15 12:18
edited on: 2008-06-12 09:26

Logged In: YES
user_id=1701456
Originator: YES

i have solved this problem:
1. in generate_average_costs, i modified the pl in the cursor Cur_InOutLine. I added a "select union" of all invoice returns with lines not associated to m_inout:
   FOR Cur_InOutLine IN
      (SELECT M_INOUTLINE_ID, MOVEMENTQTY, M_PRODUCT_ID, MOVEMENTDATE,
        AD_CLIENT_ID, AD_ORG_ID, C_BPARTNER_ID, C_INVOICELINE_ID
      FROM
      (SELECT M_INOUTLINE.M_INOUTLINE_ID, M_INOUTLINE.MOVEMENTQTY, M_PRODUCT.M_PRODUCT_ID, M_INOUT.MOVEMENTDATE,
        M_INOUTLINE.AD_CLIENT_ID, M_INOUTLINE.AD_ORG_ID, M_INOUT.C_BPARTNER_ID, NULL AS C_INVOICELINE_ID
      FROM M_INOUT, M_INOUTLINE, M_PRODUCT
      WHERE M_INOUT.M_INOUT_ID=M_INOUTLINE.M_INOUT_ID
        AND M_INOUTLINE.M_PRODUCT_ID=M_PRODUCT.M_PRODUCT_ID
        AND M_PRODUCT.COSTTYPE='AV'
        AND M_INOUT.ISSOTRX='N'
        AND M_INOUT.PROCESSED='Y'
        AND M_INOUTLINE.MOVEMENTQTY>0
        AND NOT EXISTS
        (SELECT 1 FROM M_COSTING WHERE M_INOUTLINE_ID=M_INOUTLINE.M_INOUTLINE_ID)
       /**** new:
          UNION
        SELECT NULL, IL.QTYINVOICED AS MOVEMENTQTY, IL.M_PRODUCT_ID, I.DATEINVOICED AS DATEMOVEMENT,
        IL.AD_CLIENT_ID, IL.AD_ORG_ID, I.C_BPARTNER_ID, IL.C_INVOICELINE_ID
        FROM C_INVOICELINE IL, C_INVOICE I
        WHERE IL.M_INOUTLINE_ID IS NULL
        AND IL.C_INVOICE_ID = I.C_INVOICE_ID
        AND IL.C_ORDERLINE_ID IS NULL
        AND IL.QTYINVOICED <0
        AND NOT EXISTS (SELECT 1 FROM M_COSTING WHERE C_INVOICELINE_ID=IL.C_INVOICELINE_ID))
        ORDER BY M_PRODUCT_ID, MOVEMENTDATE, MOVEMENTQTY DESC) loop ****** end new***
2. in tab of costs, exists a field of invoiceLineFrom (like inoutLineFrom), but this field is hidden. I showed this field.

(0007048)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:44

This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1889633 [^]

(0050989)
gorkaion (developer)
2012-07-30 14:02

new cost engine manages return shipments and receipts.

Issue History
Date Modified	Username	Field	Change
2008-07-01 18:12	pjuvara	Relationship added	blocks 0004252
2008-07-01 18:12	pjuvara	Status	new => acknowledged
2008-11-16 07:44	pjuvara	Assigned To	user71 => pjuvara
2011-02-04 09:16	jpabloae	Assigned To	pjuvara => rmorley
2011-09-08 13:15	eintelau	Issue Monitored: eintelau
2012-07-30 14:01	gorkaion	Status	acknowledged => scheduled
2012-07-30 14:01	gorkaion	Assigned To	rmorley => gorkaion
2012-07-30 14:01	gorkaion	fix_in_branch	=> pi
2012-07-30 14:02	gorkaion	Note Added: 0050989
2012-07-30 14:02	gorkaion	Status	scheduled => closed
2012-07-30 14:02	gorkaion	Resolution	open => fixed
2012-07-30 14:02	gorkaion	Fixed in Version	=> 3.0MP13

Notes
(0003941) user71 2008-02-15 12:18 edited on: 2008-06-12 09:26	Logged In: YES user_id=1701456 Originator: YES i have solved this problem: 1. in generate_average_costs, i modified the pl in the cursor Cur_InOutLine. I added a "select union" of all invoice returns with lines not associated to m_inout: FOR Cur_InOutLine IN (SELECT M_INOUTLINE_ID, MOVEMENTQTY, M_PRODUCT_ID, MOVEMENTDATE, AD_CLIENT_ID, AD_ORG_ID, C_BPARTNER_ID, C_INVOICELINE_ID FROM (SELECT M_INOUTLINE.M_INOUTLINE_ID, M_INOUTLINE.MOVEMENTQTY, M_PRODUCT.M_PRODUCT_ID, M_INOUT.MOVEMENTDATE, M_INOUTLINE.AD_CLIENT_ID, M_INOUTLINE.AD_ORG_ID, M_INOUT.C_BPARTNER_ID, NULL AS C_INVOICELINE_ID FROM M_INOUT, M_INOUTLINE, M_PRODUCT WHERE M_INOUT.M_INOUT_ID=M_INOUTLINE.M_INOUT_ID AND M_INOUTLINE.M_PRODUCT_ID=M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.COSTTYPE='AV' AND M_INOUT.ISSOTRX='N' AND M_INOUT.PROCESSED='Y' AND M_INOUTLINE.MOVEMENTQTY>0 AND NOT EXISTS (SELECT 1 FROM M_COSTING WHERE M_INOUTLINE_ID=M_INOUTLINE.M_INOUTLINE_ID) /** new: UNION SELECT NULL, IL.QTYINVOICED AS MOVEMENTQTY, IL.M_PRODUCT_ID, I.DATEINVOICED AS DATEMOVEMENT, IL.AD_CLIENT_ID, IL.AD_ORG_ID, I.C_BPARTNER_ID, IL.C_INVOICELINE_ID FROM C_INVOICELINE IL, C_INVOICE I WHERE IL.M_INOUTLINE_ID IS NULL AND IL.C_INVOICE_ID = I.C_INVOICE_ID AND IL.C_ORDERLINE_ID IS NULL AND IL.QTYINVOICED <0 AND NOT EXISTS (SELECT 1 FROM M_COSTING WHERE C_INVOICELINE_ID=IL.C_INVOICELINE_ID)) ORDER BY M_PRODUCT_ID, MOVEMENTDATE, MOVEMENTQTY DESC) loop ** end new* 2. in tab of costs, exists a field of invoiceLineFrom (like inoutLineFrom), but this field is hidden. I showed this field.

(0007048) user71 2005-06-01 00:00 edited on: 2008-06-12 09:44	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1889633 [^]

(0050989) gorkaion (developer) 2012-07-30 14:02	new cost engine manages return shipments and receipts.