How to repost all posted documents again

[Bilal muhammad]

Dear All,

Currently we are using "Standard Costing Method" and posted data with this method. Now we want to change costing method into " Avg PO "  and want to Re-post all data again with new method. Please help  me , how we can post all data again with new posting method .

Thanks 

Muhammad Bilal

[Bilal muhammad]

Dear All Please help me  on this matter.

Thanks

M .Bilal

[Patric]

Hi,

I don't know exactly what happens if you repost all documents but
it is a very hard step to repost all documents.
I would be prefer to make a clear cut and recalculate the avg price (based on the vendor invoices) and then I would be create a cost adjustment for all my products.

I think this is difficult enough ;-)

Patric
(Hans Auler GmbH)

[redhuan d. oon]

(please do not repeat question without providing more trial information. It might show you are lazy and just want free help. :) )

Take a look at http://red1.org/DocBook/ResubmitPostingPrc.html and i mean its source code as a guide. You should be able to (or get a developer in your company) reuse that code to solve your issue.

[Solutions Ocean.]

you will required to write a new module for it then write multiple procedures to do this, but as patric said, its really not very easy task which you can do until if you have a very good code knowledge of the system!

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/f91cb236-996c-441d-96d4-4d1c10f31a6f%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Carlos Antonio Ruiz Gómez]

Please allow me to jump in:

iDempiere has actually the options to do the reposting:

Step 1:

As you're saying that you're doing this to change the costing method - then the Reset Accounting process will not delete the related costing tables, you would need to delete them manually from SQL.

I would say backup and delete the records from tables M_Cost, M_CostDetail, M_CostHistory

Step 2:

http://wiki.idempiere.org/en/Reset_Accounting_(Process_ID-176)

Check the flag "Delete existing accounting entries"

This will delete all the accounting entries

Step 3:

The next run of accounting processor must repost all documents, but if that doesn't happen you can force it with:

http://wiki.idempiere.org/en/Resubmit_Posting_(Process_ID-175)

Regards,

Carlos Ruiz