Sistematika’s Journal

Diberkati untuk memberkati

Introduction to Adempiere Costing implementation

Posted by: Bayu Cahya P on: December 15, 2008

Long time a go, when get impressed with Adempiere for first time, I just found this Adempiere No Costs message while try to accomplish Adempiere goods shipment — via Shipment (Customer) window –

adempiere no costs error message

Here a step by step to reproduce this message

1. Using Garden World default client installation
2. Make a Sales Order that contains some product (whatever). Here, we used Elm Tree products, complete and post this document
3. Generate shipments
4. Post your shipments document

And then we are introduced to the first error message. Brrrrr….. It might be the first bad impression with Adempiere :) Strugling to find what’s happened, somebody at community just recommend to perform Performance Analysis -> Costing -> Create Costing records. Just like chicken which doesn’t have any other options, I just followed his/her suggestion.

“It doesn’t work. I am still facing Adempiere shipment (customer) no costs message :(

“Okay. You shall check the product costs for this stuff”

“Product costs?”

“Yes. You could access this window with Performance Analysis -> Costing -> Product Costs”

“I see. I have checked product costs tab for this product, and found that It has standard costing cost element (only) and already set current cost price to $24″

“And it still cann’t post shipment (customer) documents? Strange…..”

Read the rest of this entry »

Review Adempiere Standard Costing

Posted by: Bayu Cahya P on: November 27, 2008

I am studying Adempiere standard costing, and needed your view concerning with Adempiere accounting facts generated especially for purchasing, receiving and invoicing this goods. As per our understanding, standard cost will be correlated with purchase price variance. Here, we are using http://www.accountingcoach.com/online-accounting-course/30Xpg01.html for our Standard Costing reference.

We will take a look about accounting generated facts with samples provided by accounting coach as follows

  1. First Condition (Normal transaction)
    Denim standard cost $2.9 per square yard. Purchase price $2.9 per square yards. We buy for 1000 yards and Invoicing with $2.9 per square yards

    This is general journal format for this condition (no more and no less)

    journal-standard

    This is complete results while performing, Material Receipt, Invoicing, Match PO-Receipt and Match Invoice-Receipt with Adempiere.

    adempiere-standard-cost-journal

    Although there are no purchase price variance, Adempiere generates variance. This calculation comes from Doc_MatchPO lines 204 [a result from poCost.subtract(costs)]. In a human words, this values rose from (Purchase Cost for each Qty substract with Total cost). From mathematical side, this is the equation 2,897.1 = 2.9 – (1000 * 2.9)

  2. Read the rest of this entry »

Studying accounting facts for Adempiere Invoice Price Variance

Posted by: Bayu Cahya P on: November 12, 2008

“Kriing….. Kriing…. Kriing…..” I picked up my phone and starting to have conversation with our student.

“Hello, This is Gloria speaking. May I speak with Bayu?”

“Yes, This is Bayu. What can I do for you, Gloria”

“We have some problem with Adempiere while having different Invoice Price againts our Purchase Order price”

“What kind of problem did you have? Could you explain me more details…”

“While posting our Match Invoice document, it seems that, accounting fact generated by Adempiere was wrong. Especially for Invoice Price Variance”

“Did you still use the same configuration for your environtment?”

Exactly. I was following those standard configuration. It’s means that we have used IDR for purchase price transaction and using USD as our default accounting schema. We use rev 6955 for Adempiere branch/stable”

“Okay. I will take a look, and inform you later”

“Thank you and awaiting your suggestion. Bye”

Well, in our last discussion, I just talk to our student to do some exercises particularly within this Adempiere Invoice Price Variance area.

Read the rest of this entry »

SEO Powered by Platinum SEO from Techblissonline