// Added by Bharat on 16/May/2017
public Dictionary <string, object> GetBPDocTypeData(Ctx ctx, string fields)
{
int C_BPartner_ID = Util.GetValueOfInt(fields);
Dictionary <string, object> retDic = new Dictionary <string, object>();
MBPartner bp = new MBPartner(ctx, C_BPartner_ID, null);
retDic["C_PaymentTerm_ID"] = bp.GetC_PaymentTerm_ID();
retDic["PaymentRule"] = bp.GetPaymentRule();
retDic["InvoiceRule"] = bp.GetInvoiceRule();
retDic["DeliveryRule"] = bp.GetDeliveryRule();
retDic["FreightCostRule"] = bp.GetFreightCostRule();
retDic["PaymentRulePO"] = bp.GetPaymentRulePO();
retDic["DeliveryViaRule"] = bp.GetDeliveryViaRule();
retDic["PO_PaymentTerm_ID"] = bp.GetPO_PaymentTerm_ID();
return(retDic);
}
} // prepare
/// <summary>
/// Perform Process.
/// </summary>
/// <returns>Message (clear text)</returns>
protected override String DoIt()
{
int index = 1;
StringBuilder sql = new StringBuilder("SELECT * "
+ "FROM S_TimeExpense e "
+ "WHERE e.Processed='Y'"
+ " AND e.AD_Client_ID=@param1"); // #1
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
index++;
sql.Append(" AND e.C_BPartner_ID=@param2"); // #2
}
if (_DateFrom != null)
{
index++;
sql.Append(" AND e.DateReport >=@param3"); // #3
}
if (_DateTo != null)
{
index++;
sql.Append(" AND e.DateReport <=@param4"); // #4
}
// JID_0868
// chanegs done by Bharat on 12 September 2018 to handle the case if invoice is created with an expense for the selected Business Partner
sql.Append(" AND EXISTS (SELECT * FROM S_TimeExpenseLine el "
+ "WHERE e.S_TimeExpense_ID=el.S_TimeExpense_ID"
+ " AND el.C_InvoiceLine_ID IS NULL"
+ " AND el.ConvertedAmt<>0) "
+ "ORDER BY e.C_BPartner_ID, e.S_TimeExpense_ID");
//
int old_BPartner_ID = -1;
MInvoice invoice = null;
MTimeExpense te = null;
//
//PreparedStatement pstmt = null;
SqlParameter[] param = new SqlParameter[index];
IDataReader idr = null;
DataTable dt = null;
try
{
//pstmt = DataBase.prepareStatement (sql.toString (), get_TrxName());
int par = 0;
//pstmt.setInt(par++, getAD_Client_ID());
param[0] = new SqlParameter("@param1", GetAD_Client_ID());
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
par++;
//pstmt.setInt (par++, _C_BPartner_ID);
param[par] = new SqlParameter("@param2", _C_BPartner_ID);
}
if (_DateFrom != null)
{
par++;
//pstmt.setTimestamp (par++, _DateFrom);
param[par] = new SqlParameter("@param3", _DateFrom);
}
if (_DateTo != null)
{
par++;
//pstmt.setTimestamp (par++, _DateTo);
param[par] = new SqlParameter("@param4", _DateTo);
}
//ResultSet rs = pstmt.executeQuery ();
idr = DataBase.DB.ExecuteReader(sql.ToString(), param, Get_TrxName());
dt = new DataTable();
dt.Load(idr);
idr.Close();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
// ********* Expense Line Loop
{
te = new MTimeExpense(GetCtx(), dr, Get_TrxName());
// New BPartner - New Order
//
if (te.GetC_BPartner_ID() != old_BPartner_ID)
{
CompleteInvoice(invoice, te);
MBPartner bp = new MBPartner(GetCtx(), te.GetC_BPartner_ID(), Get_TrxName());
log.Info("New Invoice for " + bp);
invoice = new MInvoice(GetCtx(), 0, Get_TrxName());
invoice.SetBPartner(bp);
if (invoice.GetC_BPartner_Location_ID() == 0)
{
log.Log(Level.SEVERE, "No BP Location: " + bp);
AddLog(0, te.GetDateReport(),
null, "No Location: " + te.GetDocumentNo() + " " + bp.GetName());
invoice = null;
break;
}
// Siddheshwar: added a code to check for payment method if null
if (bp.GetVA009_PO_PaymentMethod_ID() <= 0)
{
paymethod = GetPaymentMethod(te);
if (paymethod <= 0)
{
if (!noPayMethEmp.Contains(bp.GetC_BPartner_ID()))
{
noPayMethEmp.Add(bp.GetC_BPartner_ID());
if (string.IsNullOrEmpty(bpNameNoPM))
{
bpNameNoPM = bp.GetName();
}
else
{
bpNameNoPM += bp.GetName() + ", ";
}
return(Msg.GetMsg(GetCtx(), "NoPayMethEmp") + bpNameNoPM);
}
}
else
{
invoice.SetVA009_PaymentMethod_ID(paymethod);
}
}
else
{
//JID_1783_1 if active paymentMethod not found ,then dont create the invoice.
if (Util.GetValueOfString(DB.ExecuteScalar("SELECT IsActive FROM VA009_PaymentMethod WHERE VA009_PaymentMethod_ID=" + bp.GetVA009_PO_PaymentMethod_ID(), null, Get_Trx())).Equals("Y"))
{
invoice.SetVA009_PaymentMethod_ID(bp.GetVA009_PO_PaymentMethod_ID());
}
else
{
return(Msg.GetMsg(GetCtx(), "IsActivePaymentMethodInv"));;
}
}
// Checking payment term
if (bp.GetPO_PaymentTerm_ID() <= 0)
{
payterm = GetPaymentTerm(te);
if (payterm <= 0)
{
if (!PayTermEmp.Contains(bp.GetC_BPartner_ID()))
{
PayTermEmp.Add(bp.GetC_BPartner_ID());
if (string.IsNullOrEmpty(bpNamePT))
{
bpNamePT = bp.GetName();
}
else
{
bpNamePT += bp.GetName() + ", ";
}
return(Msg.GetMsg(GetCtx(), "NoPayTerm") + bpNamePT);
}
}
else
{
invoice.SetC_PaymentTerm_ID(payterm);
}
}
else
{
//JID_1783_1 if active paymentTerm not found ,then dont create the invoice.
if (Util.GetValueOfString(DB.ExecuteScalar("SELECT IsActive FROM C_PaymentTerm WHERE C_PaymentTerm_ID=" + bp.GetPO_PaymentTerm_ID(), null, Get_Trx())).Equals("Y"))
{
invoice.SetC_PaymentTerm_ID(bp.GetPO_PaymentTerm_ID());
}
else
{
return(Msg.GetMsg(GetCtx(), "IsActivePaymentTermInv"));
}
}
invoice.SetIsExpenseInvoice(true); //added by arpit asked by Surya Sir on DEC 28,2015
invoice.SetClientOrg(te.GetAD_Client_ID(), te.GetAD_Org_ID());
//invoice.SetVA009_PaymentMethod_ID(bp.GetVA009_PO_PaymentMethod_ID());
// JID_0868
// chanegs done by Bharat on 12 September 2018 to set the document type where Expense Invoice checkbox is true.
// String qry = "SELECT C_DocType_ID FROM C_DocType "
//+ "WHERE AD_Client_ID=@param1 AND DocBaseType=@param2"
//+ " AND IsActive='Y' AND IsExpenseInvoice = 'Y' "
//+ "ORDER BY C_DocType_ID DESC , IsDefault DESC";
String qry = "SELECT C_DocType_ID FROM C_DocType "
+ "WHERE AD_Client_ID=" + GetAD_Client_ID() + @" AND DocBaseType='" + MDocBaseType.DOCBASETYPE_APINVOICE + @"'"
+ " AND IsActive='Y' AND IsExpenseInvoice = 'Y' AND AD_Org_ID IN(0," + te.GetAD_Org_ID() + ") "
+ " ORDER BY AD_Org_ID Desc, C_DocType_ID DESC , IsDefault DESC";
//int C_DocType_ID = DB.GetSQLValue(null, qry, GetAD_Client_ID(), MDocBaseType.DOCBASETYPE_APINVOICE);
int C_DocType_ID = Util.GetValueOfInt(DB.ExecuteScalar(qry));
if (C_DocType_ID <= 0)
{
log.Log(Level.SEVERE, "Not found for AC_Client_ID="
+ GetAD_Client_ID() + " - " + MDocBaseType.DOCBASETYPE_APINVOICE);
return(Msg.GetMsg(GetCtx(), "NoDocTypeExpInvoice"));
}
else
{
log.Fine(MDocBaseType.DOCBASETYPE_APINVOICE);
}
invoice.SetC_DocTypeTarget_ID(C_DocType_ID);
//invoice.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APINVOICE); // API
//commented by Arpit on Jan 4,2015 Mentis issue no. 0000310
//invoice.SetDocumentNo(te.GetDocumentNo());
//
invoice.SetM_PriceList_ID(te.GetM_PriceList_ID());
invoice.SetSalesRep_ID(te.GetDoc_User_ID());
String descr = Msg.Translate(GetCtx(), "S_TimeExpense_ID")
+ ": " + te.GetDocumentNo() + " "
+ DisplayType.GetDateFormat(DisplayType.Date).Format(te.GetDateReport());
invoice.SetDescription(descr);
if (!invoice.Save())
{
return(GetRetrievedError(invoice, "Cannot save Invoice"));
// new Exception("Cannot save Invoice");
}
//added by arpit asked by Surya Sir on 29/12/2015*******
else
{
old_BPartner_ID = bp.GetC_BPartner_ID();
}
//end***************
}
// JID_0868
//Description include all document numbers which is come from Time And Expense Recording window to expense invoice in case of multiple records
else if (old_BPartner_ID > 0)
{
String descr = invoice.GetDescription() + "\n" + Msg.Translate(GetCtx(), "S_TimeExpense_ID")
+ ": " + te.GetDocumentNo() + " "
+ DisplayType.GetDateFormat(DisplayType.Date).Format(te.GetDateReport());
invoice.SetDescription(descr);
}
MTimeExpenseLine[] tel = te.GetLines(false);
for (int i = 0; i < tel.Length; i++)
{
MTimeExpenseLine line = tel[i];
// Already Invoiced or nothing to be reimbursed
if (line.GetC_InvoiceLine_ID() != 0 ||
Env.ZERO.CompareTo(line.GetQtyReimbursed()) == 0 ||
Env.ZERO.CompareTo(line.GetPriceReimbursed()) == 0)
{
continue;
}
// Update Header info
if (line.GetC_Activity_ID() != 0 && line.GetC_Activity_ID() != invoice.GetC_Activity_ID())
{
invoice.SetC_Activity_ID(line.GetC_Activity_ID());
}
if (line.GetC_Campaign_ID() != 0 && line.GetC_Campaign_ID() != invoice.GetC_Campaign_ID())
{
invoice.SetC_Campaign_ID(line.GetC_Campaign_ID());
}
if (line.GetC_Project_ID() != 0 && line.GetC_Project_ID() != invoice.GetC_Project_ID())
{
invoice.SetC_Project_ID(line.GetC_Project_ID());
}
if (!invoice.Save())
{
return(GetRetrievedError(invoice, "Cannot save Invoice"));
//new Exception("Cannot save Invoice");
}
// Create OrderLine
MInvoiceLine il = new MInvoiceLine(invoice);
//
if (line.GetM_Product_ID() != 0)
{
il.SetM_Product_ID(line.GetM_Product_ID(), true);
}
//added by arpit asked by Surya Sir on 28/12/2015_____***************************
if (line.GetC_Charge_ID() != 0)
{
il.SetC_Charge_ID(line.GetC_Charge_ID());
}
//end here *****************************
il.SetQty(line.GetQtyReimbursed()); // Entered/Invoiced
il.SetDescription(line.GetDescription());
//
il.SetC_Project_ID(line.GetC_Project_ID());
il.SetC_ProjectPhase_ID(line.GetC_ProjectPhase_ID());
il.SetC_ProjectTask_ID(line.GetC_ProjectTask_ID());
il.SetC_Activity_ID(line.GetC_Activity_ID());
il.SetC_Campaign_ID(line.GetC_Campaign_ID());
//
// il.setPrice(); // not really a list/limit price for reimbursements
il.SetPrice(line.GetPriceReimbursed()); //
il.SetC_UOM_ID(line.GetC_UOM_ID());
// JID_0868
// chanegs done by Bharat on 12 September 2018 to set the Amount in List price column.
il.SetPriceList(line.GetPriceReimbursed());
il.SetTax();
if (!il.Save())
{
return(GetRetrievedError(il, "Cannot save Invoice"));
//new Exception("Cannot save Invoice Line");
}
// Update TEL
line.SetC_InvoiceLine_ID(il.GetC_InvoiceLine_ID());
line.SetIsInvoiced(true);
line.Save();
} // for all expense lines
}
}
else
{
message = Msg.GetMsg(GetCtx(), "NoRecForInv");
}
// ********* Expense Line Loop
dt = null;
//dt.Clear();
}
catch (Exception e)
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql.ToString(), e);
}
finally
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
}
CompleteInvoice(invoice, te);
//if (_noInvoices == 0)
//{
// message = " @No Record Found for Invoice Creation@";
//}
//Code for Showing Message when PaymentTerm is null
if (!string.IsNullOrEmpty(bpNamePT))
{
message += Msg.GetMsg(GetCtx(), "NoPayTerm") + bpNamePT + "\n";
}
//code for showing Error Message when Invoice is not completed
if (!string.IsNullOrEmpty(bpNameInvoice))
{
message += Msg.GetMsg(GetCtx(), "NoInvoiceCreated") + bpNameInvoice + "\n";
}
if (!string.IsNullOrEmpty(bpNameNoPM))
{
message = Msg.GetMsg(GetCtx(), "NoPayMethEmp") + bpNameNoPM + "\n";
}
if (_noInvoices > 0)
{
message += "" + _noInvoices + " " + Msg.GetMsg(GetCtx(), "VIS_InvGenerated");
}
//return "" + _noInvoices + " @Invoices Generated Successfully@";
return(message);
} // doIt
/// <summary>
/// Create PO for Vendor
/// </summary>
/// <param name="C_BPartner_ID">vendor</param>
/// <param name="so">sales order</param>
/// <returns>MOrder</returns>
public MOrder CreatePOForVendor(int C_BPartner_ID, MOrder so, string _shipDrop)
{
MOrder po = new MOrder(GetCtx(), 0, Get_TrxName());
po.SetClientOrg(so.GetAD_Client_ID(), so.GetAD_Org_ID());
po.SetRef_Order_ID(so.GetC_Order_ID());
po.SetIsSOTrx(false);
// method edited to set unreleased document type for PO
po.SetC_DocTypeTarget_ID(false);
//
po.SetDescription(so.GetDescription());
po.SetPOReference(so.GetDocumentNo());
po.SetPriorityRule(so.GetPriorityRule());
po.SetSalesRep_ID(so.GetSalesRep_ID());
// Code Commented by Vivek Kumar on 20/09/2017 Assigned By Pradeep for drop shipment
//po.SetM_Warehouse_ID(so.GetM_Warehouse_ID());
// Set Vendor
MBPartner vendor = new MBPartner(GetCtx(), C_BPartner_ID, Get_TrxName());
if (Env.IsModuleInstalled("VA009_"))
{
// Set PO Payment Method from Vendor
if (Util.GetValueOfInt(vendor.GetVA009_PO_PaymentMethod_ID()) > 0)
{
po.SetVA009_PaymentMethod_ID(Util.GetValueOfInt(vendor.GetVA009_PO_PaymentMethod_ID()));
}
else
{
if (string.IsNullOrEmpty(messageErrorOrSetting.ToString()))
{
messageErrorOrSetting.Append(Msg.GetMsg(GetCtx(), "VIS_PaymentMethodNotDefined") + " : " + vendor.GetName());
}
else
{
messageErrorOrSetting.Append(" , " + Msg.GetMsg(GetCtx(), "VIS_PaymentMethodNotDefined") + " : " + vendor.GetName());
}
po = null;
return(po);
}
}
//JID_1252: If Vendor do not have Po Pricelist bind. System should give message.
if (vendor.GetPO_PriceList_ID() > 0)
{
po.SetM_PriceList_ID(vendor.GetPO_PriceList_ID());
}
else
{
if (string.IsNullOrEmpty(messageErrorOrSetting.ToString()))
{
messageErrorOrSetting.Append(Msg.GetMsg(GetCtx(), "VIS_VendorPrcListNotDefine") + " : " + vendor.GetName());
}
else
{
messageErrorOrSetting.Append(" , " + Msg.GetMsg(GetCtx(), "VIS_VendorPrcListNotDefine") + " : " + vendor.GetName());
}
po = null;
return(po);
}
// JID_1262: If Payment Term is not bind BP, BP Group and No Default Payment Term. System do not create PO neither give message.
if (vendor.GetPO_PaymentTerm_ID() > 0)
{
po.SetC_PaymentTerm_ID(vendor.GetPO_PaymentTerm_ID());
}
else
{
if (string.IsNullOrEmpty(messageErrorOrSetting.ToString()))
{
messageErrorOrSetting.Append(Msg.GetMsg(GetCtx(), "VIS_VendorPaytemNotDefine") + " : " + vendor.GetName());
}
else
{
messageErrorOrSetting.Append(" , " + Msg.GetMsg(GetCtx(), "VIS_VendorPaytemNotDefine") + " : " + vendor.GetName());
}
po = null;
return(po);
}
po.SetBPartner(vendor);
// Code Commented by Vivek Kumar on 20/09/2017 Assigned By Pradeep for drop shipment
// Drop Ship
//po.SetIsDropShip(so.IsDropShip());
//if (so.IsDropShip())
//{
// po.SetShip_BPartner_ID(so.GetC_BPartner_ID());
// po.SetShip_Location_ID(so.GetC_BPartner_Location_ID());
// po.SetShip_User_ID(so.GetAD_User_ID());
//}
if (_shipDrop == "Y")
{
po.SetIsDropShip(true);
po.SetShipToPartner_ID(so.GetC_BPartner_ID());
po.SetShipToLocation_ID(so.GetC_BPartner_Location_ID());
int _Warehouse_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select M_WareHouse_ID From M_Warehouse Where AD_Org_ID=" + so.GetAD_Org_ID() + " AND Isdropship='Y' AND IsActive='Y'"));
if (_Warehouse_ID >= 0)
{
po.SetM_Warehouse_ID(_Warehouse_ID);
}
}
// Added by Bharat on 29 Jan 2018 to set Inco Term from Order
if (po.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
po.SetC_IncoTerm_ID(so.GetC_IncoTerm_ID());
}
// References
po.SetC_Activity_ID(so.GetC_Activity_ID());
po.SetC_Campaign_ID(so.GetC_Campaign_ID());
po.SetC_Project_ID(so.GetC_Project_ID());
po.SetUser1_ID(so.GetUser1_ID());
po.SetUser2_ID(so.GetUser2_ID());
//
po.Save();
return(po);
}
/// <summary>
/// Create PO for Vendor
/// </summary>
/// <param name="C_BPartner_ID">vendor</param>
/// <param name="so">sales order</param>
/// <returns>MOrder</returns>
public MOrder CreatePOForVendor(int C_BPartner_ID, MOrder so, string _shipDrop)
{
MOrder po = new MOrder(GetCtx(), 0, Get_TrxName());
po.SetClientOrg(so.GetAD_Client_ID(), so.GetAD_Org_ID());
po.SetRef_Order_ID(so.GetC_Order_ID());
po.SetIsSOTrx(false);
// method edited to set unreleased document type for PO
po.SetC_DocTypeTarget_ID(false);
//
po.SetDescription(so.GetDescription());
po.SetPOReference(so.GetDocumentNo());
po.SetPriorityRule(so.GetPriorityRule());
po.SetSalesRep_ID(so.GetSalesRep_ID());
// Code Commented by Vivek Kumar on 20/09/2017 Assigned By Pradeep for drop shipment
//po.SetM_Warehouse_ID(so.GetM_Warehouse_ID());
// Set Vendor
MBPartner vendor = new MBPartner(GetCtx(), C_BPartner_ID, Get_TrxName());
if (Env.IsModuleInstalled("VA009_"))
{
// Set PO Payment Method from Vendor
if (Util.GetValueOfInt(vendor.GetVA009_PO_PaymentMethod_ID()) > 0)
{
po.SetVA009_PaymentMethod_ID(Util.GetValueOfInt(vendor.GetVA009_PO_PaymentMethod_ID()));
}
else
{
if (string.IsNullOrEmpty(messageErrorOrSetting.ToString()))
{
messageErrorOrSetting.Append(Msg.GetMsg(GetCtx(), "VIS_PaymentMethodNotDefined") + " : " + vendor.GetName());
}
else
{
messageErrorOrSetting.Append(" , " + Msg.GetMsg(GetCtx(), "VIS_PaymentMethodNotDefined") + " : " + vendor.GetName());
}
po = null;
return(po);
}
}
//JID_1252: If Vendor do not have Po Pricelist bind. System should give message.
if (vendor.GetPO_PriceList_ID() > 0)
{
po.SetM_PriceList_ID(vendor.GetPO_PriceList_ID());
}
else
{
if (string.IsNullOrEmpty(messageErrorOrSetting.ToString()))
{
messageErrorOrSetting.Append(Msg.GetMsg(GetCtx(), "VIS_VendorPrcListNotDefine") + " : " + vendor.GetName());
}
else
{
messageErrorOrSetting.Append(" , " + Msg.GetMsg(GetCtx(), "VIS_VendorPrcListNotDefine") + " : " + vendor.GetName());
}
po = null;
return(po);
}
// JID_1262: If Payment Term is not bind BP, BP Group and No Default Payment Term. System do not create PO neither give message.
if (vendor.GetPO_PaymentTerm_ID() > 0)
{
po.SetC_PaymentTerm_ID(vendor.GetPO_PaymentTerm_ID());
}
else
{
if (string.IsNullOrEmpty(messageErrorOrSetting.ToString()))
{
messageErrorOrSetting.Append(Msg.GetMsg(GetCtx(), "VIS_VendorPaytemNotDefine") + " : " + vendor.GetName());
}
else
{
messageErrorOrSetting.Append(" , " + Msg.GetMsg(GetCtx(), "VIS_VendorPaytemNotDefine") + " : " + vendor.GetName());
}
po = null;
return(po);
}
po.SetBPartner(vendor);
// Code Commented by Vivek Kumar on 20/09/2017 Assigned By Pradeep for drop shipment
// Drop Ship
//po.SetIsDropShip(so.IsDropShip());
//if (so.IsDropShip())
//{
// po.SetShip_BPartner_ID(so.GetC_BPartner_ID());
// po.SetShip_Location_ID(so.GetC_BPartner_Location_ID());
// po.SetShip_User_ID(so.GetAD_User_ID());
//}
if (_shipDrop == "Y")
{
po.SetIsDropShip(true);
po.SetShipToPartner_ID(so.GetC_BPartner_ID());
po.SetShipToLocation_ID(so.GetC_BPartner_Location_ID());
int _Warehouse_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select M_WareHouse_ID From M_Warehouse Where AD_Org_ID=" + so.GetAD_Org_ID() + " AND Isdropship='Y' AND IsActive='Y'"));
if (_Warehouse_ID >= 0)
{
po.SetM_Warehouse_ID(_Warehouse_ID);
}
}
// Added by Bharat on 29 Jan 2018 to set Inco Term from Order
if (po.Get_ColumnIndex("C_IncoTerm_ID") > 0)
{
po.SetC_IncoTerm_ID(so.GetC_IncoTerm_ID());
}
// References
po.SetC_Activity_ID(so.GetC_Activity_ID());
po.SetC_Campaign_ID(so.GetC_Campaign_ID());
po.SetC_Project_ID(so.GetC_Project_ID());
po.SetUser1_ID(so.GetUser1_ID());
po.SetUser2_ID(so.GetUser2_ID());
//Set VA077 values on header level
if (Env.IsModuleInstalled("VA077_"))
{
//Get the org count of legal entity org
string sql = @"SELECT Count(AD_Org_ID) FROM AD_Org WHERE IsActive='Y'
AND (IsProfitCenter ='Y' OR IsCostCenter ='Y') AND
AD_Client_Id=" + so.GetAD_Client_ID() + @" AND LegalEntityOrg = " + so.GetAD_Org_ID();
int result = Util.GetValueOfInt(DB.ExecuteScalar(sql));
if (result > 0)
{
po.SetVA077_IsLegalEntity(true);
}
}
// Handle error done by rakesh kumar on 17/Mar/2021
if (!po.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string msg = string.Empty;
if (pp != null)
{
msg = pp.GetName();
//if GetName is Empty then it will check GetValue
if (string.IsNullOrEmpty(msg))
{
msg = Msg.GetMsg("", pp.GetValue());
}
}
if (string.IsNullOrEmpty(msg))
{
msg = Msg.GetMsg(GetCtx(), "RecordNotSaved");
}
log.Info("CreatePOfromSO : Not Saved. Error Value : " + msg);
AddLog(0, null, null, msg + " : @DocumentNo@ : " + so.GetDocumentNo());
}
return(po);
}
