org.adempiere.exceptions.AverageCostingNegativeQtyException

332 views
Skip to first unread message

Derek Lew

unread,
Jul 31, 2013, 10:19:02 AM7/31/13
to idem...@googlegroups.com
Hi

i am running through Adempiere 3.4 ERP solution book, using GlobalGss 361 truck.  

Refer to page 189.  i have configured the manufactured product "Shirt" with 4 raw materials (Average PO) and 1 Labour & Electricity (Standard Costing), yet when i post the account, it prompt me that the org.adempiere.exceptions.AverageCostingNegativeQtyException is due to the Labour & Electricity using Average PO costing method.

Anyone has any idea?

Best regards,

Derek
error.jpg

armenrz

unread,
Jul 31, 2013, 11:45:00 PM7/31/13
to idem...@googlegroups.com
Hi Derek,

One of your raw materials must be less qty than you plan to use in production. Check their current qty in table M_Cost, cost element Average PO.

Regards,

Armen Rizal
Goodwill.co.id

Derek Lew

unread,
Aug 1, 2013, 2:15:57 AM8/1/13
to idem...@googlegroups.com
Product ID 1000006 is actually Labour and Electricity, and using Standard Costing, not Average PO.  and it is a overhead, not raw material.

Chuck Boecking

unread,
Aug 28, 2013, 5:25:45 PM8/28/13
to idem...@googlegroups.com
Hi Derek,

Even though you are using standard cost, the system will maintain all active cost elements found in the 'Cost Element' window. To solve this issue, de-activate all cost elements that do not use a Costing Method of Standard Costing.

It is unfortunate that you need to disable these elements because they are handy when validating/reviewing the 'cost at source' element of your standard cost. I have not taken the time to review the code to see if (a) you really need a positive qty for the system to calculate an average cost or (b) it just gives you a courtesy posting error. 

This error appears (as an example) when you are using a product configured as a service (not stocked) to represent labor and/or overhead in a production process.

I hope this helps!

Chuck Boecking
512.850.6068 (office and cell)
ch...@chuboe.com
ChuckBoecking.com
chuck.boecking (skype)
http://www.linkedin.com/pub/chuck-boecking/10/970/17b

armenrz

unread,
Aug 29, 2013, 2:05:57 AM8/29/13
to idem...@googlegroups.com
Hi all,

As I remember, the same case has been reported earlier. I think we should notify Hengsin that for non-stocked item, we should not throw any negative qty error.

Regards,

Armen Rizal

Heng Sin Low

unread,
Aug 29, 2013, 2:30:39 AM8/29/13
to idem...@googlegroups.com
ok, noted. will work on this.


--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

rishi rinku

unread,
Aug 15, 2015, 7:02:07 AM8/15/15
to iDempiere

hii all

My question is about accounting effect of Production

Let me give u example of my transaction

Product A

Finish Good

Production Qty 1

 

Product B

RM for A

Consume Qty   1

$100 Each

Product C

RM for A

Consume Qty   1

$150 Each

 When I create production for first time .The posting of transaction Shows

Account

Dr

Cr

Product

Rate Variance

350

0.00

Product A

Product Asset

0.00

0.00

Product A

Product Asset

0.00

100

Product B

Product Asset

0.00

150

Product C

But Accounting Effect should be

Account

Dr

Cr

Product

Product Asset

350

0.00

Product A

Product Asset

0.00

100

Product B

Product Asset

0.00

150

Product C

 Please help to solve this .

Thanks in advance.

Reply all
Reply to author
Forward
0 new messages