/**
* Load Invoice Line
*
* @return DocLine Array
*/
private DocLine[] loadLines(ConnectionProvider conn) {
ArrayList<Object> list = new ArrayList<Object>();
DocLineCostAdjustmentData[] data = null;
try {
data = DocLineCostAdjustmentData.select(conn, Record_ID);
for (int i = 0; i < data.length; i++) {
String Line_ID = data[i].mCostadjustmentlineId;
DocLine_CostAdjustment docLine =
new DocLine_CostAdjustment(DocumentType, Record_ID, Line_ID);
docLine.loadAttributes(data[i], this);
docLine.setTrxType(data[i].mTransactionId);
docLine.m_C_Currency_ID = data[i].cCurrencyId;
docLine.setWarehouseId(data[i].mWarehouseId);
docLine.m_DateAcct = data[i].dateacct;
docLine.m_C_BPartner_ID = data[i].cBpartnerId;
docLine.setSourceProcess(data[i].sourceProcess);
docLine.setIsSource("Y".equals(data[i].issource));
// -- Source Amounts
String amt = data[i].adjustmentAmount;
docLine.setAmount(amt);
list.add(docLine);
}
} catch (ServletException e) {
log4jDocCostAdjustment.warn(e);
}
// Return Array
DocLine[] dl = new DocLine[list.size()];
list.toArray(dl);
return dl;
} // loadLines
/**
* Get Document Confirmation
*
* <p>not used
*/
public boolean getDocumentConfirmation(ConnectionProvider conn, String strRecordId) {
boolean isGeneratedAccounting = false;
DocLine[] local_p_lines = new DocLine[0];
local_p_lines = loadLines(conn);
// Lines
for (int i = 0; local_p_lines != null && i < local_p_lines.length; i++) {
DocLine_CostAdjustment line = (DocLine_CostAdjustment) local_p_lines[i];
BigDecimal amount = new BigDecimal(line.getAmount());
if (amount.signum() != 0) {
isGeneratedAccounting = true;
}
}
if (!isGeneratedAccounting) {
setStatus(STATUS_DocumentDisabled);
}
return isGeneratedAccounting;
}
/**
* Create Facts (the accounting logic) for MMS, MMR.
*
* <pre>
* Shipment
* CoGS DR
* Inventory CR
* Shipment of Project Issue
* CoGS DR
* Project CR
* Receipt
* Inventory DR
* NotInvoicedReceipt CR
* </pre>
*
* @param as accounting schema
* @return Fact
*/
public Fact createFact(
AcctSchema as, ConnectionProvider conn, Connection con, VariablesSecureApp vars)
throws ServletException {
// Select specific definition
String strClassname =
AcctServerData.selectTemplateDoc(conn, as.m_C_AcctSchema_ID, DocumentType);
if (StringUtils.isEmpty(strClassname)) {
strClassname = AcctServerData.selectTemplate(conn, as.m_C_AcctSchema_ID, AD_Table_ID);
} else {
try {
DocCostAdjustmentTemplate newTemplate =
(DocCostAdjustmentTemplate) Class.forName(strClassname).newInstance();
return newTemplate.createFact(this, as, conn, con, vars);
} catch (Exception e) {
log4j.error("Error while creating new instance for DocCostAdjustmentTemplate - ", e);
}
}
C_Currency_ID = as.getC_Currency_ID();
// create Fact Header
Fact fact = new Fact(this, as, Fact.POST_Actual);
String Fact_Acct_Group_ID = SequenceIdData.getUUID();
String amtDebit = "0";
String amtCredit = "0";
// Lines
for (int i = 0; p_lines != null && i < p_lines.length; i++) {
DocLine_CostAdjustment line = (DocLine_CostAdjustment) p_lines[i];
String transactionType = line.getTransactionType();
BigDecimal amount = new BigDecimal(line.getAmount());
ProductInfo p = new ProductInfo(line.m_M_Product_ID, conn);
log4jDocCostAdjustment.debug(
"antes del creteline, line.getAmount(): "
+ line.getAmount()
+ " - TransactionType: "
+ transactionType);
if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_SHIPMENT)) {
// Cogs DR
// Inventory Asset CR
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ p.getAccount(ProductInfo.ACCTTYPE_P_Cogs, as, conn).C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = "";
amtCredit = amount.toPlainString();
} else {
amtDebit = amount.toPlainString();
amtCredit = "";
}
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Cogs, as, conn),
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
} else if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_RECEIPT)) {
Account acct = null;
// Inventory Asset DR
if (line.getIsSource() && ("PDC").equals(line.getSourceProcess())) { // Price Diff
// Correction
// Invoice Price Variance CR
acct = p.getAccount(ProductInfo.ACCTTYPE_P_IPV, as, conn);
} else if (line.getIsSource() && ("LC").equals(line.getSourceProcess())) {
throw new IllegalStateException(OBMessageUtils.messageBD("LCNotAccounting"));
} else {
// Product Exp CR
acct =
getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn);
}
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ p.getAccount(ProductInfo.ACCTTYPE_P_Expense, as, conn).C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = amount.toPlainString();
amtCredit = "";
} else {
amtDebit = "";
amtCredit = amount.toPlainString();
}
fact.createLine(
line,
acct,
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
} else if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_INVENTORY)) {
// Inventory Asset DR
// Inventory Adjustment CR
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn)
.C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = amount.toPlainString();
amtCredit = "";
} else {
amtDebit = "";
amtCredit = amount.toPlainString();
}
fact.createLine(
line,
getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn),
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
} else if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_INTERNALMOVEMENTFROM)) {
// Inventory Asset DR
// Inventory Adjustment CR
M_Warehouse_ID = line.getWarehouseId();
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn)
.C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = amount.negate().toPlainString();
amtCredit = "";
} else {
amtDebit = "";
amtCredit = amount.negate().toPlainString();
}
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
} else if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_INTERNALMOVEMENTTO)) {
// Inventory Asset DR
// Inventory Adjustment CR
M_Warehouse_ID = line.getWarehouseId();
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn)
.C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = amount.toPlainString();
amtCredit = "";
} else {
amtDebit = "";
amtCredit = amount.toPlainString();
}
fact.createLine(
line,
getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn),
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
} else if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_INTERNALCONSUMPTION)) {
// Inventory Asset DR
// Inventory Adjustment CR
M_Warehouse_ID = line.getWarehouseId();
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn)
.C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = amount.toPlainString();
amtCredit = "";
} else {
amtDebit = "";
amtCredit = amount.toPlainString();
}
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
} else if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_BOM)) {
// Inventory Asset DR
// Inventory Adjustment CR
M_Warehouse_ID = line.getWarehouseId();
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn)
.C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = amount.toPlainString();
amtCredit = "";
} else {
amtDebit = "";
amtCredit = amount.toPlainString();
}
fact.createLine(
line,
getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn),
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
} else if (transactionType.equals(DocLine_CostAdjustment.TRXTYPE_MANUFACTURING)) {
// Inventory Asset DR
// Inventory Adjustment CR
M_Warehouse_ID = line.getWarehouseId();
log4jDocCostAdjustment.debug(
"********** DocCostAdjustment - factAcct - account - "
+ getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn)
.C_ValidCombination_ID);
if (line.isTransactionNegative()) {
amtDebit = amount.toPlainString();
amtCredit = "";
} else {
amtDebit = "";
amtCredit = amount.toPlainString();
}
fact.createLine(
line,
getAccountByWarehouse(
AcctServer.ACCTTYPE_InvDifferences, as, line.getWarehouseId(), conn),
line.m_C_Currency_ID,
amtDebit,
amtCredit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
fact.createLine(
line,
p.getAccount(ProductInfo.ACCTTYPE_P_Asset, as, conn),
line.m_C_Currency_ID,
amtCredit,
amtDebit,
Fact_Acct_Group_ID,
nextSeqNo(SeqNo),
DocumentType,
line.m_DateAcct,
null,
conn);
}
} // lines
SeqNo = "0";
return fact;
} // createFact
