From: ExsonQu <hex...@gm...> - 2014-05-29 15:15:37
|
*Dear all:* I've received a question about how to correct the wrong cost data. The scenario is that: 1. The original input cost is wrong. The mistake has not been detected until some goods received and vendors' invoice has been input. 2. Some goods sold at this wrong cost. Total 5 transactions happened. Is there any way to correct the wrong data of those transaction? Thanks in advance for your comments! Best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/How-to-change-the-wrong-material-cost-tp4657487.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
From: Phil D. <ph...@lo...> - 2014-06-01 03:09:16
|
Hi Exson, For the transactions you describe the Standard Cost and Weighted Average cost journals are the same. So each journal needs to be restated at the correct cost When goods are received the entry is: DR stock at standard x quantity received CR GRN suspense However, the standard at the time the goods are recieved is recorded in the GRN record - so when the purchase invoice is entered only the amount recorded in the GRN record is reversed - DR GRN suspense, CR account payable control DR/CR purchase price variance - so when the invoice comes in another journal needs to be done to correct the variance - if using weighted average then the variances is posted the stock value and value recalculated - i.e. the cost will fix itself. When goods are sold the entries are: DR COGS @ standard x quantity CR Stock @ standard x quantity Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 30/05/14 03:14, ExsonQu wrote: > *Dear all:* > > I've received a question about how to correct the wrong cost data. The > scenario is that: > > 1. The original input cost is wrong. The mistake has not been detected > until some goods received and vendors' invoice has been input. > 2. Some goods sold at this wrong cost. Total 5 transactions happened. > > Is there any way to correct the wrong data of those transaction? > > Thanks in advance for your comments! > > Best regards! > > Exson > > > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/How-to-change-the-wrong-material-cost-tp4657487.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Time is money. Stop wasting it! Get your web API in 5 minutes. > www.restlet.com/download > http://p.sf.net/sfu/restlet > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
From: ExsonQu <hex...@gm...> - 2014-06-02 01:39:55
|
*Hi, Phil,* Thank you for your nice reply. Does that mean we have correct in the database level? Or we can correct in webERP interface? Thanks and Best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/How-to-change-the-wrong-material-cost-tp4657487p4657492.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
From: Phil D. <ph...@lo...> - 2014-06-02 03:09:25
|
If you do it through the interface the GL entries are accounted for. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 02/06/14 13:39, ExsonQu wrote: > *Hi, Phil,* > > Thank you for your nice reply. > > Does that mean we have correct in the database level? Or we can > correct in webERP interface? > > Thanks and Best regards! > > Exson > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/How-to-change-the-wrong-material-cost-tp4657487p4657492.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
From: ExsonQu <hex...@gm...> - 2014-06-02 07:28:25
|
*Hi, Phil,* Thank you for your reply. After considering your comments and studying the scripts again, I've found a way out like this: The scope of journal to restate: 1) Invoice to debtors; 2) Invoice to suppliers; 3) GRNs received; The journal to add is: 1) Item Cost Update Before we restate those journals, we have to reverse(Credit) those wrong journals. So the procedure should be like this: 1) Credit all those invoices to debtors involved. ( Return all of those items to respect locations). 2) Credit all those invoices to suppliers involved. (Reverse all of those invoiced items to grns-suspend account). 3) Reverse all those grns involved. Here we come to the point where the mistake happened. 4) Update Items cost by the StockCostUpate.php scripts. It'll generate relative journals. Then we have a correct base to restate those transactions: 1. Receive goods to grns. 2. Invoice those grns against the suppliers. 3. Confirm_Invoice to debtors. So up to now, every recovered. Does this procedure right? Thanks and best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/How-to-change-the-wrong-material-cost-tp4657487p4657494.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |