HotWax Media and OFBiz – 2009 OFBiz Contributions – Part 3

For the third volume in our series highlighting the contributions of HotWax Media to Apache Open For Business (OFBiz) in 2009, we will focus on OFBiz ERP-related components.  Specifically, we will review our OFBiz development contributions to:

  1. Accounting
  2. Manufacturing and Facility Management


The Accounting Manager (along with the A/R and A/P applications) in OFBiz have come a long way recently.  HotWax Media is proud of our recent contributions to OFBiz Accounting, which include the following:

  1. Added the generation of a PDF for the AcctgTrans and related AcctgTransEntry.
  2. Allow the user to void a payment.
  3. Fixed Accounting invoice section the InvoiceSubBar Menu.
  4. Added the ability to receive payments in A/R batches.
  5. Fixed the Commission Invoice to show correct price and quantity.
  6. Added a screen under Accounts Payable -> Invoice, which will search for a purchase invoice within a given date range.
  7. Added JUnit test cases for the Accounts Receivable -> Batch Payments.
  8. Added JUnit test cases for the Accounting -> Void Payment and Cancel Invoice services.
  9. Added JUnit test case for the Accounts Payable services which create payment groups for given invoices.
  10. Created a new screen under the Accounting -> Report tab to show comparative income statements.  Added the functionality for generating CSV and PDF from this same form.
  11. Added the ability to cancel a reconciliation.
  12. Created a new accounting screen to associate GL Accounts to “Cost Centers”.
  13. Added the ability to create sales tax entries on an invoice without an order.
  14. Added a Deposit/Withdraw facility for user to deposit/withdraw payments in the Bank Account.
  15. Added a deposit slip facility to the Bank Account/Fin Account so that user can make a logical group of Payments for bulk deposit/withdraw.
  16. Added the ability for the user to create a new payment and directly associate to the current Bank Account.
  17. Added the ability to add a facility to reconcile a Bank Account by creating a new GlReconciliation record and assign bank transaction to that reconciliation id.
  18. Fixed numerous issues in the reconciliation of Gl Account.
  19. Added a new field to the FinAccountTransaction entity – statusId, Created/Approved/Canceled.
  20. Added a new field to GlReconciliation entity – statusId, Created/Reconciled.
  21. In Accounts Payable -> Invoice -> Purchase Invoice – User can now issue a check payment for incoming invoices with a given bank account id.
  22. In Account Payable -> Invoice -> Commission Run – Added a search for outgoing invoices which require a commission payment and ability to easily create commission invoices from there.
  23. In Accounts Receivable -> Payment -> Batch Payment – Added a new feature by which user can create a group of payments that can be used for reconciliation.
  24. Added/Updated most Accounting reports – Inventory Valuation, Income Statements, Comparative Income Statement, Transaction Total, Gl Account Trail Balance, Monthly Trial Balance, Cost Center, etc.  Added ability to export each to CSV and PDF.
  25. Added consolidated balance of its ROLLUP party for the aforementioned reports.
  26. Prepared JUnit test cases to verify GL Account Balance updated after execution of various accounting business process.
  27. Added support Hindi UiLables for Accounting and Party and Common component.
  28. Improved Commission Invoice services and fixed issues in Commission Invoice screens

Manufacturing and Facility Management

HotWax Media also made some solid contributions to the OFBiz Manufacturing and Facility Management components in 2009.  These OFBiz development contributions include:

  1. Enhanced support for product costing algorithms: cost formula, manufacturing costs, standard and actual costs.
  2. Implemented ability to define and import content for production runs.
  3. Added a new fulfillment process by introducing Verify Pick and Weight Package Only screens.
  4. Pick User can now select options for preparing a group on the basis of shipping method, warehouse area and number of order items – the group of orders is created according to selected options.
  5. Added additional options on the picking screen to show detailed information for each order (shipping method, number of order items per order, etc).

What’s Next?

In the final chapter in our series (Part 4), I will discuss HotWax Media’s OFBiz development contributions in the area of integrations: shipping, multi channel sales and payment processors.

– Tim

Tim Ruppert is Chief Operating Officer at HotWax Media as well as an OFBiz project committer and active community member. Tim will join other HotWax Media employees and advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

DATE: Jan 22, 2010
AUTHOR: HotWax Systems
OFBiz Ecommerce, OFBiz Development, OFBiz Shipping, OFBiz Contributions, ofbiz accounting, Tim Ruppert, OFBiz, OFBiz Integrations, ofbiz manufacturing, Facility Management