Average PO costing for a Service Product

224 views
Skip to first unread message

Chuck Boecking

unread,
Aug 29, 2016, 4:53:27 PM8/29/16
to idem...@googlegroups.com
Hi Heng Sin,

If you have a moment, will you take a look at the below situation?

Problem Summary: Creating a Receipt against a 'Non-Stocked' Product set to Average PO costing does not update the Average PO cost record.

Steps to reproduce:
  • Create a new Product Category called 'AvgPO'
  • Update the 'AvgPO' Product Category => Accounting sub-tab to set the Cost Method = 'Average PO'
  • Create a new Product called AvgPO01, and uncheck its Stocked field
  • Add it to a Purchase Price List for convenience
  • Create and Complete a Purchase Order for this Product
  • Create and Complete a Material Receipt for this Product
  • Go to the Product window => Costs sub-tab and notice the system:
    • did not create a Average PO costing record
    • Set the 'Material' cost instead
The same situation applies if the Product is it Product Type = 'Service'

I assume this not desired behavior. Said another way, it seems reasonable to expect the system to track my Average PO cost for a non-stocked item.

Will you kindly share your thoughts?

Regards,


Chuck Boecking
512.850.6068 (office and cell)
ch...@chuboe.com
ChuckBoecking.com
chuck.boecking (skype)

Heng Sin Low

unread,
Aug 30, 2016, 1:05:16 AM8/30/16
to idem...@googlegroups.com
Hi Chuck,

As you have observed, Average PO costing is not implemented for non-stock item.

I guess an implementation should be possible, we just need to decide what should be the algorithm for recalculation of average po cost for non-stock item.

Regards,
Low

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CA%2Bw%3D76gFxJv08aUUkNfepkMWBO88L9XNVYhFrzS8sjpaca8%3Ddw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Chuck Boecking

unread,
Aug 30, 2016, 12:24:20 PM8/30/16
to iDempiere
Hi Heng Sin,

Thank you! Would it be acceptable to use a System Configurator entry to represent the non-stocked qty to use for average costing calculations (one qty value for all products). I am inclined to say yes for my case. If you agree, will you kindly let me know how many hours you believe it will take to implement?

Thanks,
Chuck
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

osy gomez

unread,
Dec 19, 2020, 11:37:46 AM12/19/20
to iDempiere

Hello, good afternoon.

I have a similar case, a new product uncheck Stocked field was ordered, received and invoiced, later it was marked Stocked  and now how can I generate its corresponding record of its average cost?

I use iDempiere 7.1. 

Thanks in advance
Reply all
Reply to author
Forward
0 new messages