/// <summary> /// Load Invoice Line /// </summary> /// <param name="inout">shipment/receipt</param> /// <returns>DocLine Array</returns> private DocLine[] LoadLines(MInOut inout) { List <DocLine> list = new List <DocLine>(); MInOutLine[] lines = inout.GetLines(false); for (int i = 0; i < lines.Length; i++) { MInOutLine line = lines[i]; if (line.IsDescription() || line.GetM_Product_ID() == 0 || Env.Signum(line.GetMovementQty()) == 0) { log.Finer("Ignored: " + line); continue; } // PO Matching if (_MatchRequirementR.Equals(X_M_InOut.MATCHREQUIREMENTR_PurchaseOrder) || _MatchRequirementR.Equals(X_M_InOut.MATCHREQUIREMENTR_PurchaseOrderAndInvoice)) { Decimal poDiff = line.GetMatchPODifference(); if (Env.Signum(poDiff) != 0) { _matchProblem += "; Line=" + line.GetLine() + " PO Match diff=" + poDiff; } else if (!line.IsMatchPOPosted()) { _matchProblem += "; PO Match not posted for Line=" + line.GetLine(); } } // Inv Matching else if (_MatchRequirementR.Equals(X_M_InOut.MATCHREQUIREMENTR_Invoice) || _MatchRequirementR.Equals(X_M_InOut.MATCHREQUIREMENTR_PurchaseOrderAndInvoice)) { Decimal invDiff = line.GetMatchInvDifference(); if (Env.Signum(invDiff) != 0) { _matchProblem += "; Line=" + line.GetLine() + " PO Match diff=" + invDiff; } else if (!line.IsMatchInvPosted()) { _matchProblem += "; Inv Match not posted for Line=" + line.GetLine(); } } DocLine docLine = new DocLine(line, this); Decimal Qty = line.GetMovementQty(); docLine.SetQty(Qty, GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_MATERIALDELIVERY)); // sets Trx and Storage Qty // log.Fine(docLine.ToString()); list.Add(docLine); } // Return Array DocLine[] dls = new DocLine[list.Count]; dls = list.ToArray(); return(dls); }
/// <summary> /// Load Document Details /// </summary> /// <returns>error message or null</returns> public override String LoadDocumentDetails() { SetC_Currency_ID(NO_CURRENCY); _issue = (MProjectIssue)GetPO(); SetDateDoc(_issue.GetMovementDate()); SetDateAcct(_issue.GetMovementDate()); // Pseudo Line _line = new DocLine(_issue, this); _line.SetQty(_issue.GetMovementQty(), true); // sets Trx and Storage Qty // Pseudo Line Check if (_line.GetM_Product_ID() == 0) { log.Warning(_line.ToString() + " - No Product"); } log.Fine(_line.ToString()); return(null); }
/// <summary> /// Load Invoice Line /// </summary> /// <param name="move"></param> /// <returns>document lines (DocLine_Material)</returns> private DocLine[] LoadLines(MMovement move) { List <DocLine> list = new List <DocLine>(); MMovementLine[] lines = move.GetLines(false); for (int i = 0; i < lines.Length; i++) { MMovementLine line = lines[i]; DocLine docLine = new DocLine(line, this); docLine.SetQty(line.GetMovementQty(), false); // log.Fine(docLine.ToString()); list.Add(docLine); } // Return Array DocLine[] dls = new DocLine[list.Count]; dls = list.ToArray(); return(dls); }
/// <summary> /// Load Invoice Line /// </summary> /// <param name="inventory"></param> /// <returns>DocLine Array</returns> private DocLine[] LoadLines(MInventory inventory) { List <DocLine> list = new List <DocLine>(); MInventoryLine[] lines = inventory.GetLines(false); for (int i = 0; i < lines.Length; i++) { MInventoryLine line = lines[i]; // nothing to post if (line.GetQtyBook().CompareTo(line.GetQtyCount()) == 0 && Env.Signum(line.GetQtyInternalUse()) == 0) { continue; } // DocLine docLine = new DocLine(line, this); Decimal Qty = line.GetQtyInternalUse(); if (Env.Signum(Qty) != 0) { Qty = Decimal.Negate(Qty); // Internal Use entered positive } else { Decimal QtyBook = line.GetQtyBook(); Decimal QtyCount = line.GetQtyCount(); Qty = Decimal.Subtract(QtyCount, QtyBook); } docLine.SetQty(Qty, false); // -5 => -5 // log.Fine(docLine.ToString()); list.Add(docLine); } // Return Array DocLine[] dls = new DocLine[list.Count]; dls = list.ToArray(); return(dls); }
/// <summary> /// Load Invoice Line /// </summary> /// <param name="invoice">invoice</param> /// <returns>DocLine Array</returns> private DocLine[] LoadLines(MInvoice invoice) { List <DocLine> list = new List <DocLine>(); // MInvoiceLine[] lines = invoice.GetLines(false); for (int i = 0; i < lines.Length; i++) { MInvoiceLine line = lines[i]; if (line.IsDescription()) { continue; } DocLine docLine = new DocLine(line, this); // Qty Decimal Qty = line.GetQtyInvoiced(); bool cm = GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_ARCREDITMEMO) || GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_APCREDITMEMO); docLine.SetQty(cm ? Decimal.Negate(Qty) : Qty, invoice.IsSOTrx()); // Decimal LineNetAmt = line.GetLineNetAmt(); Decimal PriceList = line.GetPriceList(); int C_Tax_ID = docLine.GetC_Tax_ID(); // Correct included Tax if (IsTaxIncluded() && C_Tax_ID != 0) { MTax tax = MTax.Get(GetCtx(), C_Tax_ID); if (!tax.IsZeroTax()) { Decimal LineNetAmtTax = tax.CalculateTax(LineNetAmt, true, GetStdPercision()); log.Fine("LineNetAmt=" + LineNetAmt + " - Tax=" + LineNetAmtTax); LineNetAmt = Decimal.Subtract(LineNetAmt, LineNetAmtTax); for (int t = 0; t < _taxes.Length; t++) { if (_taxes[t].GetC_Tax_ID() == C_Tax_ID) { _taxes[t].AddIncludedTax(LineNetAmtTax); break; } } Decimal PriceListTax = tax.CalculateTax(PriceList, true, GetStdPercision()); PriceList = Decimal.Subtract(PriceList, PriceListTax); } } // correct included Tax docLine.SetAmount(LineNetAmt, PriceList, Qty); // qty for discount calc if (docLine.IsItem()) { _allLinesService = false; } else { _allLinesItem = false; } // log.Fine(docLine.ToString()); list.Add(docLine); } // Convert to Array DocLine[] dls = new DocLine[list.Count]; dls = list.ToArray(); // Included Tax - make sure that no difference if (IsTaxIncluded()) { for (int i = 0; i < _taxes.Length; i++) { if (_taxes[i].IsIncludedTaxDifference()) { Decimal diff = _taxes[i].GetIncludedTaxDifference(); for (int j = 0; j < dls.Length; j++) { if (dls[j].GetC_Tax_ID() == _taxes[i].GetC_Tax_ID()) { dls[j].SetLineNetAmtDifference(diff); break; } } // for all lines } // tax difference } // for all taxes } // Included Tax difference // Return Array return(dls); }
/// <summary> /// Load Invoice Line /// </summary> /// <param name="prod">production</param> /// <returns> DoaLine Array</returns> private DocLine[] LoadLines(X_M_Production prod) { List <DocLine> list = new List <DocLine>(); // Production // -- ProductionPlan // -- -- ProductionLine - the real level String sqlPP = "SELECT * FROM M_ProductionPlan pp " + "WHERE pp.M_Production_ID=@param1 " + "ORDER BY pp.Line"; IDataReader idrPP = null; String sqlPL = "SELECT * FROM M_ProductionLine pl " + "WHERE pl.M_ProductionPlan_ID=@param2 " + "ORDER BY pl.Line"; IDataReader idrPL = null; try { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@param1", Get_ID()); idrPP = DataBase.DB.ExecuteReader(sqlPP, param, GetTrx()); //idrPP.setInt(1, get_ID()); //ResultSet rsPP = idrPP.executeQuery(); while (idrPP.Read()) { int M_Product_ID = Utility.Util.GetValueOfInt(idrPP["M_Product_ID"]); int M_ProductionPlan_ID = Utility.Util.GetValueOfInt(idrPP["M_ProductionPlan_ID"]); // try { param = new SqlParameter[1]; param[0] = new SqlParameter("@param2", M_ProductionPlan_ID); idrPL = DataBase.DB.ExecuteReader(sqlPL, param, GetTrx()); //idrPL.setInt(1, M_ProductionPlan_ID); //ResultSet rsPL = idrPL.executeQuery(); while (idrPL.Read()) { X_M_ProductionLine line = new X_M_ProductionLine(GetCtx(), idrPL, GetTrx()); if (Env.Signum(line.GetMovementQty()) == 0) { log.Info("LineQty=0 - " + line); continue; } DocLine docLine = new DocLine(line, this); docLine.SetQty(line.GetMovementQty(), false); // Identify finished BOM Product docLine.SetProductionBOM(line.GetM_Product_ID() == M_Product_ID); // log.Fine(docLine.ToString()); list.Add(docLine); } idrPL.Close(); } catch (Exception ee) { if (idrPL != null) { idrPL.Close(); idrPL = null; } log.Log(Level.SEVERE, sqlPL, ee); } } idrPP.Close(); } catch (Exception e) { if (idrPP != null) { idrPP.Close(); idrPP = null; } log.Log(Level.SEVERE, sqlPP, e); } // Return Array DocLine[] dl = new DocLine[list.Count]; dl = list.ToArray(); return(dl); }