View source | View content page | Page history | Printable version   

Projects:XSQL Insert Update Review/Development Status

Contents

XSQL Insert Update Review - Development Status

Overview

The XSQL Insert Update Review project aims to review the *.java files of all manual windows (processes) that have methods that insert or update records in the database.

Development evolution can also be tracked at xsql-insert-update-review branch.

Important notes:

| class="green_cell" | Complete


Application Dictionary

Process name Application path File path Insert/Update methods Comments Status
Test In
  • Application Dictionary >> Automated Test >> Instructions
src/org/openbravo/erpCommon/ad_actionButton/Test_In.java
  • TestInData.insert() inside OBError processButton() method.
processButton() method type has been changed from string to OBError. Complete


Master Data Management

Process name Application path File path Insert/Update methods Comments Status
Import File Loader
  • Master Data Management >> Import Data >> Import File Loader
src/org/openbravo/erpCommon/ad_forms/FileImport.java
  • FileImportData.insert() inside OBError importarFichero() method.
  • FileImportData.update() inside OBError importarFichero() method.
Complete


Procurement Management

Process name Application path File path Insert/Update methods Comments Status
Copy Lines - Products From Invoices
  • Procurement Management >> Transactions >> Purchase Invoice
  • Procurement Management >> Transactions >> Vendor Expense Invoice
  • Procurement Management >> Transactions >> Expense Invoice
  • Sales Management >> Transactions >> Sales Invoice
  • Master Data Management >> Business Partner Setup >> Business Partner Info
src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice.java
  • CopyFromInvoiceData.insert() inside OBError processButton() method.
Complete
Copy Lines - Products From History of Document Type
  • Procurement Management >> Transactions >> Purchase Order
  • Sales Management >> Transactions >> Simple Sales Order
  • Sales Management >> Transactions >> Sales Order
  • Master Data Management >> Business Partner Setup >> Business Partner Info
src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrder.java
  • CopyFromOrderData.insertCOrderline() inside OBError processButton() method.
Complete
Copy from Order
  • Procurement Management >> Transactions >> Purchase Order
  • Sales Management >> Transactions >> Sales Order
src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder.java
  • CopyFromPOOrderData.insertCOrderline() inside OBError processButton() method.
Complete
Create Lines From
  • Procurement Management >> Transactions >> Goods Receipt
  • Sales Management >> Transactions >> Goods Shipment
  • Master Data Management >> Business Partner Setup >> Business Partner Info
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java
  • CreateFromBankData.insert() inside OBError saveBank() method.
  • CreateFromInvoiceData.insert() inside OBError saveInvoice() method.
  • CreateFromInvoiceData.deleteC_Order_ID() inside OBError saveInvoice() method.
  • CreateFromInvoiceData.updateC_Order_ID() inside OBError saveInvoice() method.
  • CreateFromShipmentData.insert() inside OBError saveShipment() method.
  • CreateFromShipmentData.updateInvoice() inside OBError saveShipment() method.
  • CreateFromShipmentData.updateInvoiceOrder() inside OBError saveShipment() method.
  • CreateFromShipmentData.deleteC_Order_ID() inside OBError saveShipment() method.
  • CreateFromShipmentData.deleteC_Invoice_ID() inside OBError saveShipment() method.
  • CreateFromShipmentData.updateC_Invoice_ID() inside OBError saveShipment() method.
  • CreateFromSettlementData.update() inside OBError saveSettlement() method.
  • CreateFromDPManagementData.insert() inside OBError saveDPManagement() method.
  • CreateFromCRemittanceData.insert() inside OBError saveCRemittance() method.
Complete
Create From Multiple
  • Procurement Management >> Transactions >> Goods Receipt
  • Sales Management >> Transactions >> Goods Shipment
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple.java
  • CreateFromMultipleReceiptData.insert() inside OBError saveReceipt() method.
  • CreateFromMultipleShipmentData.insert() inside OBError saveShipment() method.
invisible Complete
Pending Goods Receipts
  • Procurement Management >> Transactions >> Pending Goods Receipts
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending.java
  • MaterialReceiptPendingData.insert() inside OBError processPurchaseOrder() method.
  • MaterialReceiptPendingLinesData.insert() inside OBError processPurchaseOrder method.
Complete
Requisition To Order
  • Procurement Management >> Transactions >> Matching PO-Receipt-Invoice
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java
  • RequisitionToOrderData.insertCOrder() inside OBError processPurchaseOrder method.
  • RequisitionToOrderData.insertCOrderline() inside OBError processPurchaseOrder method.
  • RequisitionToOrderData.insertRequisitionOrder inside OBError processPurchaseOrder method.
Complete


Warehouse Management

Production Management

Process name Application path File path Insert/Update methods Comments Status
Edit CCP Measured Values Production Management >> Transactions >> Quality Control Report >> Date and Shift src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues.java
  • EditCCPMeasureValuesData.update() inside OBError updateValues() method.
updateValues() method type has been changed from void to OBError. Complete
Create from Maintenance Part Production Management >> Transactions >> Maintenance Order src/org/openbravo/erpCommon/ad_actionButton/UpdateMaintenanceScheduled.java
  • UpdateMaintenanceScheduledData.update() inside String updateValues() method.
updateValues() method type has been changed from string to OBError. Complete


Sales Management

Process name Application path File path Insert/Update methods Comments Status
Change Order Organization Sales Management >> Transactions >> Change Order Organization src/org/openbravo/erpCommon/ad_process/ChangeOrderOrg.java
  • ChangeOrderOrgData.updateDocAction() inside OBError processSave() method.
  • ChangeOrderOrgData.updateLines() inside OBError processSave() method.
  • ChangeOrderOrgData.update() inside OBError processSave() method.
  • ChangeOrderOrgData.updateDocAction() inside OBError processSave() method.
  • ChangeOrderOrgData.updateShipment() inside OBError processSave() method.
  • ChangeOrderOrgData.updateShipmentlines() inside OBError processSave() method.
  • ChangeOrderOrgData.updateMtransaction() inside OBError processSave() method.
Complete


Project and Service Management

Process name Application path File path Insert/Update methods Comments Status
Create Sales Orders from Expenses Project & Service Management >> Transactions >> Create Sales Orders from Expenses src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder.java
  • ExpenseSOrderData.insertCOrder() inside OBError processButton() method.
  • ExpenseSOrderData.insertCOrderline() inside OBError processButton() method.
  • PInstanceProcessData.insertPInstance() inside String processOrder() method.
  • ExpenseSOrderData.updateTimeExpenseLine() inside OBError processButton() method.
processOrder() method type has been changed from String to OBError. Complete
Create AP Expense Invoices Project & Service Management >> Transactions >> Create AP Expense Invoices src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice.java
  • ExpenseAPInvoiceData.insert() inside OBError processExpense() method.
  • ExpenseAPInvoiceData.insertLine() inside OBError processExpense() method.
  • ExpenseAPInvoiceData.insertInvoicelineAcctdimension() inside OBError processExpense() method.
  • ExpenseAPInvoiceData.updateInvoiceline() inside OBError processExpense() method.
  • ExpenseAPInvoiceData.updateAcctdimension() inside OBError processExpense() method.
  • ExpenseAPInvoiceData.updateExpense() inside OBError processExpense() method.
processExpense() method type has been changed from void to OBError. Complete
Close Project
  • Project & Service Management >> Transactions >> Multiphase Project
  • Project & Service Management >> Transactions >> Service Project
  • Financial Management >> Accounting >> Setup >> Accounting Dimension >> Project Dimension
src/org/openbravo/erpCommon/ad_actionButton/ProjectClose.java
  • ProjectCloseData.update() inside OBError processButton() method.
  • ProjectCloseData.updateLines inside OBError processButton() method.
Invisible.

ProcessButton() method type has been changed from string to OBError.

Complete
Copy Details From Existing Project
  • Project & Service Management >> Transactions >> Multiphase Project
  • Project & Service Management >> Transactions >> Service Project
  • Financial Management >> Accounting >> Setup >> Accounting Dimension >> Project Dimension
src/org/openbravo/erpCommon/ad_actionButton/ProjectCopyFrom.java
  • ProjectCopyFromData.insertProjectTask() inside OBError processButton() method.
  • ProjectCopyFromData.insertProjectLine() inside OBError processButton() method.
  • ProjectSetTypeData.update() inside OBError processButton() method.
Complete
Set Project Type
  • Project & Service Management >> Transactions >> Multiphase Project
  • Project & Service Management >> Transactions >> Service Project
src/org/openbravo/erpCommon/ad_actionButton/ProjectSetType.java
  • ProjectSetTypeData.insertProjectTask() inside OBError processButton() method.
  • ProjectSetTypeData.insertProjectLine() inside OBError processButton() method.
  • ProjectSetTypeData.update inside OBError processButton() method.
Invisible. Complete


Product Management

Financial Management

Process name Application path File path Insert/Update methods Comments Status
Copy from Settlement
  • Financial Management >> Receivables & Payables >> Transactions >> Manual Settlement
src/org/openbravo/erpCommon/ad_actionButton/CopyFromSettlement.java
  • CopyFromSettlementData.insertDebtPayment() inside OBError processButton() method.
  • CopyFromSettlementData.insert() inside OBError processButton() method.
Complete
Create Reg Fact Acct
  • Financial Management >> Accounting >> Setup >> Fiscal Calendar >> Calendar >> Year
src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct.java
  • CreateRegFactAcctData.updatePeriods() inside String processButton() method.
  • CreateRegFactAcctData.updatePeriodsClose() inside String processButton() method.
  • CreateRegFactAcctData.insert() inside String String processButtonReg() method.
  • CreateRegFactAcctData.insertClose() inside String processButtonClose() method.
processButton() method type has been changed from String to OBError. Complete
Drop Reg Fact Acct
  • Financial Management >> Accounting >> Setup >> Fiscal Calendar >> Calendar >> Year
src/org/openbravo/erpCommon/ad_actionButton/DropRegFactAcct.java
  • DropRegFactAcctData.updatePeriods() inside String processButtonReg() method.
  • DropRegFactAcctData.deleteFactAcct() inside String processButtonReg() method.
  • DropRegFactAcctData.updatePeriodsOpen() inside String processButtonClose() method.
  • DropRegFactAcctData.updatePeriodsClose() inside String processButtonClose() method.
  • DropRegFactAcctData.deleteFactAcctClose() inside String processButtonClose() method.
Complete
Create Vat Registers
  • Financial Management >> Receivables & Payables >> Transactions >> Tax Payment
src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters.java
  • TaxPayment.deleteRegisterLinesChild() inside OBError CreateRegisters() method.
  • TaxPayment.deleteRegisterChild() inside OBError CreateRegisters() method.
  • TaxRegister.insert() inside OBError CreateRegisters() method.
  • TaxRegister.updateTaxTotalAmt() inside OBError CreateRegisters() method.
  • TaxRegister.updateRegAccumAmt() inside OBError CreateRegisters() method.
  • TaxPayment.updateGeneratePayment() inside OBError CreateRegisters() method.
Complete
Funds Transfer
  • Financial Management >> Receivables & Payables >> Transactions >> Funds Transfer
src/org/openbravo/erpCommon/ad_process/CashBankOperations.java
  • CashBankOperationsData.insertSettlement inside void process() method.
  • CashBankOperationsData.insertDebtpayment inside void process() method.
  • CashBankOperationsData.updateSettlement inside void process() method.
process() method type has been changed from void to OBError. Complete
Copy Details From Journal Batch
  • Financial Management >> Accounting >> Transactions >> G/L Journal >> Batch
src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal.java
  • CopyFromGLJournalData.insertGLJournal() inside OBError processButton() method.
  • CopyFromGLJournalData.insertGLJournalLine()' inside OBError processButton() method.
Complete
Create Cash Flow Statement
  • Financial Management >> Accounting >> Analysis Tools >> Create Cash Flow Statement
src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement.java
  • CreateCashFlowStatementData.insertStatements() inside void insertCFS() method.
  • CreateCashFlowStatementData.updateDifference()' inside void insertCFS() method.
added method OBError process() Complete
Change Payment Status
  • Financial Management >> Receivables & Payables >> Transactions >> Change Payment Status
src/org/openbravo/erpCommon/ad_forms/DebtPaymentUnapply.java
  • DebtPaymentUnapplyData.updateGenerate() inside int updateSelection() method.
  • DebtPaymentUnapplyData.updateCancel() inside int updateSelection() method.
updateSelection() method type has been changed from int to OBError. Complete
Remittance Cancellation/Return
  • Financial Management >> Receivables & Payables >> Transactions >> Remittance Cancellation/Return
src/org/openbravo/erpCommon/ad_forms/RemittanceCancel.java
  • RemittanceCancelData.insertDPManagement() inside void processReturn() method.
  • RemittanceCancelData.insertSettlement() inside void processCancel() method.
processReturn() and processCancel() methods type has been changed from void to OBError. Complete

Retrieved from "http://wiki.openbravo.com/wiki/Projects:XSQL_Insert_Update_Review/Development_Status"

This page has been accessed 6,158 times. This page was last modified on 8 June 2012, at 05:31. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.