Difference between revisions of "Sponsored Development: Libero Costing Engine"

Revision as of 19:45, 27 September 2010

Project

Source Code

Tracker

How to Install?

• Apply the cost engine script for Database from: Cost Engine SQL Script
• Download the binary liberoCE.jar and patchs.jar files from: Binary files
• Open Terminal command
• Change the ADempiere Home directory

    #cd $ADEMPIERE_HOME

• Copy the liberoCE.jar file to package directory

    #cp liberoCE.jar $ADEMPIERE_HOME/package

• Copy the patchs.jar file to Lib directory

    #cp patchs.jar $ADEMPIERE_HOME/lib

• Run ADempiere setup

    #RUN_setup.sh

Sponsored

Sysnova

Development & Consulting

• Teo Sarca
• Anca Bradau
• Victor Perez, http://www.e-evolution.com

Roadmap Document

Roles

• Analyst
• Any Role
• Architect
• Developer
• Project Manager
• Stakeholder
• Tester

Tasks

Develop Vision

[Document Specification in process ---]

Identify Stakeholders Ok

• Warehouse Clerk
• Accountant Cost Clerk
• Financial Management Clerk
• Purchase Manager Clerk
• Implementor Clerk

Gain agreement on the problem to resolve

• You can not give to tracking and monitoring the costs for any costing method. ie currently you can not generated a valuation of inventories at a effective date. solved
• All documents reverted with cost are created with accounting incorrectly.
• In the average cost is not possible to process correction of incorrect entry of quantities or prices. solved
• Can not generate of transaction cost accounting for any revaluation or change cost.
• Only is possible to management a method costing by company or organization.
• The FIFO/LIFO costs, currently not working properly.
• Currently is not possible to have different method cost by organization
• Currently is not possible have a good historial cost for all method cost, solved

Also add some new functionality.

• Development the functionality that support manufacturing support Average and FIFO/LIFO cost.
• Allow that the ADempiere support different costing method by organization, this way a organization can have the average cost and the other is standard cost.
• New Inventory report valuation, solved
• Revaluation Cost. solved
• COGS Adjustment. solved

Gather stakeholder requests

• Optimize the Calculated Cost
• Optimize the Calculated Sales Price based on % margin
• Optimize the Right General Ledger record
• Optimize the Right Record the COGs for Income Statement
• Optimize the Right inventory valuation with different method cost. solved

Define the scope of the solution

The objectives to reach within the first milestone of the project are:

• Create New Cost Engine
• Get the right calculated and register of cost
• Implement Average Cost and FIFO/LIFO Cost for Manufacturing Management
• Get the right Inventory Cost Valuation
• Get the right General Ledger Cost records
• Get the right Current Cost for each cost element

Define features of the system

• Define Multiples Cost Element with different Cost Method, implemented
• New Inventory Valuation Report , implemented
• New cost collector cost for cost adjustment and revaluation, implemented
• New option to generate the posting in batch process , implemented
• New option to generate the adjustment cost in batch process , implemented
• New transaction valuation report, implemented

Important questions

When I reviewed the FIFO/LIFO cost found Questions and Cases :

Well is here where I have some doubt about the Business Logic:

We need define the strategy about that How should work the Material Policy and Costing Method, current do not is clear?

I think that the Material Policy and Costing Method should work the way independent so that in general the Material Policy is focus to the logic material issue and the costing method is focus to Cost Account

Victor Perez

www.e-evolution.com

• What is the logic to consumed the FIFO/LIFO Cost Layers , we should sort by?
  • Account Date
  • Movement Date
  • ID ASI
  • Guarantee Date

I think that for FIFO/LIFO Cost Layers should be consumed based in the Account Date , the reason is because exist a lot the business that can entry your material movement in time left. other important reason is because when you revert some document it should reverting using the same date that original document and the same original cost. so this way we can complaint the requirement the Accountant Costs.

Victor Perez

www.e-evolution.com

• What is the Logic to consumed the Material considering the Material Policy?
  • Accounts Date
  • Movement Date
  • ID ASI
  • Guarantee Date

I think that the FIFO/LIFO Material Policy should be consumed based in of the Guarrantee Date and discarding the Layer that do not have complaint with the Min Guarantee Days , next we would use the Movement Date. The reason is because the must important for this business case is that the raw material more old and a good status should be issue first. this way we can complaint the requirement the Production man.

Victor Perez

www.e-evolution.com

• We should mix the Material Policy FIFO/LIFO with Costing Method FIFO/LIFO?

No I think that the Material Policy FIFO/LIFO and Costing Method FIFO/LIFO are different , the first is focus to material and next to Cost. So I think that we need change the current logic where the Material Policy FIFO/LIFO is use to calculate the Cost.

Victor Perez

www.e-evolution.com

• We should adding the costing method to level Product Category the same way that Material Policy?

Yes, is very necessary so that exist business that need have a costing method for specific Product Category. Here I do not sure if with different account cost.

Victor Perez

www.e-evolution.com

• We should create a record into Cost Detail for each Cost Element and Material Transaction?

Yes, I think that it would be very useful to implement the FIFO/LIFO cost in Manufacturing Cost and can use other Cost Element Type as (Labor, Burden , Overhead , Outside Processing, etc),

Victor Perez

www.e-evolution.com

• We should include the Current Cost Price and Current Cost Price LL into Cost Detail?

Yes, I think that it would be very useful to implement report Effective Date Valuation, Calculate Cost Revelation and Reversal Documents

Victor Perez

www.e-evolution.com

• We should include the account date in the logic to Costing Method FIFO/LIFO?

Yes,I think that is very important it date is mandatory to create reversal and correction cost for error in entry quantity.

Victor Perez

www.e-evolution.com

• How should include the landed cost be based on the FIFO/LIFO Costing Method?

Achieve concurrence

Capture a common vocabulary

• Glossary

Identify and Outline Requirements

Detail Use-Case Scenarios

• Cost Cases

Detail System-Cost Management

Implementation

Entity Relationship Model

Business Test Case

• Spread Sheet Average Invoice Business Case include following example transaction:
• Source Test File
  • Generate Cost Transaction for GardenWord based on the history Transaction.
  • Adjustment Cost in Invoice Vendor Transaction
  • Correction of Material Receipt using reversal transaction.
  • Register the a MAterial Receipt entry Earlier Transaction

Test Result

• Inventory_Valuation_Report.pdf
• Transaction_Valuation_Report.pdf

Images

Generate Cost Transaction

• Parameters Generate Cost Transaction

Transaction Value

• Transaction Value Report Paramaters

• Transaction Value Report

Valuation Effective date Report

• Parameters for Valuation Effective date Report

Discussion Chats

Cost Engine Chat Bayu and Victor 23/09/2010

Cost Engine Chat Colin and Victor 24/09/2010

Cost Engine Chat Susanne and Victor 24/09/2010

Cost Engine Chat Luis and Victor 25/09/2010

following using google wave here