Re: [Axapta-Knowledge-Village] Inventory recalculation
Hi James, I didn't meant that check box selection, that option is for recalculating the Inventory values after closing.. My question is how I can stop the inventory recalculation during closing? I will breaf my isue; My invetory valuation method is 'Weighted avg. In Axapta the valuation methods you are specified at invent model group will be considered only during Inventory closing process. Till inventory closing the valuation will be @ Pepectual moving (running) avg. basis. So when you are performing an inventory closing the inventory will be revalued based on my Inventory model defined and COGS will be recalculated. So my question is; can we stop\avoid this recalculation during closing process, so that my COGS will be untouched and this won't affect my reporting also. I can avoid this issue by not running the Inventory closing process, but is there any option that you can run the periodic process without recalculation. Regards Sudeep On 3/31/09, James Flavell djf1...@gmail.com wrote: mmm I assume you mean unticking the last option on the closing to do recalcuation after closing? If this is not what you mena I think you have misunderstood the reason for about inventory closing...in which case if you dont wnat your inventory value change then dont run inventory closing or recalc... Will wait to hear what you really are trying to do or avoid :) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of sudeep s gopalkrishnan Sent: 31 March 2009 15:03 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory recalculation Hi, Can we stop inventory recalculation during Inventory closing process?? Currently in Ax Inventory gets revalued during Inventory closing process -- Warm Regards Sudeep.G -- Warm Regards Sudeep.G
RE: [Axapta-Knowledge-Village] Inventory recalculation
mmm I assume you mean unticking the last option on the closing to do recalcuation after closing? If this is not what you mena I think you have misunderstood the reason for about inventory closing...in which case if you dont wnat your inventory value change then dont run inventory closing or recalc... Will wait to hear what you really are trying to do or avoid :) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of sudeep s gopalkrishnan Sent: 31 March 2009 15:03 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory recalculation Hi, Can we stop inventory recalculation during Inventory closing process?? Currently in Ax Inventory gets revalued during Inventory closing process -- Warm Regards Sudeep.G
Re: [Axapta-Knowledge-Village] Inventory Recalculation
Hi, the PO 2 is not Invoiced at all.. Its only Packing slip updated.. But the items have been consumed... Anyway I am checking out all possible combinations. Also if the Include physical value check box is marked, I closed the Invventory for that month. I made an invoice for that PO in the next Month, When i run recalculation again, its throws an error msg that I cant recalculate beacuse the Inventory is already closed.. i dont understand it On Wed, Sep 17, 2008 at 12:26 PM, Arvind Ramesh [EMAIL PROTECTED] wrote: Hi, Most of the time in a real scenario, heaps of material arrive in the receiving store. The store-keeper makes an entry in the system upon receipt (packing-slip update) and by EOD he (or a QA) approves all the materials received during the day (invoice-update). In between these two activities of the store keeper if the company wishes to calculate the average cost price of its materials, the only data it has is the packing-slip price. Whether to include the packing-slip price or not is set in the include physical value parameter in that particular inventory model group. One other functionality of this parameter is that, upon checking this box, the cost of the item is taken from the P.O. and not from the items form. When using FIFO, it is also equally important to know at what point the materials have been received and at what point they have been consumed. First check the timelines and then see the status of the purchase order. From your calculation it looks that PO2 is only partially invoiced for 100 pcs. Cheers! Arvind Ramesh. --- On *Tue, 9/16/08, Yadhav Krishnan [EMAIL PROTECTED]* wrote: From: Yadhav Krishnan [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Inventory Recalculation To: Axapta-Knowledge-Village@yahoogroups.com Date: Tuesday, September 16, 2008, 1:04 PM Hi friends I have a query. Can anyone (anyone Please!! !!) update me on the significance of Using Include physical Value Check Box in the Inventory Model group Form. My client wants to calculate inventory on a weighted average basis during the Month. At the time of Recalculation and Inventory Closing, The Cost has to be calculated on a FIFO Basis and the adjustments distributed accordingly. These are the following settings which I did. Inventory Management -- Inventory Model Group Inventory model field is set to FIFO Include Physical Value Check Box is enabled. Post Financial Inventory check Box is enabled Post Physical Inventory check Box is enabled Actually during the month the cost of the item is taken as the Average of the Packing Slips Received for the Purchase Orders. E.g.: If there are 3 PO's Purchase Order 1 for 100 Nos @ Rs.10 Purchase Order 2 for 200 Nos @ Rs.15 Purchase Order 3 for 150 Nos @ Rs.20 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (200 x 15) + (150 x 20) / (200 + 150) = 6000/350 = Rs. 17.14 For the same scenario if I do not mark the Include Physical value Check Box in the Inventory model group Form Purchase Order 1 for 100 Nos @ Rs.10 = 1000 Purchase Order 2 for 200 Nos @ Rs.15 = 3000 Purchase Order 3 for 150 Nos @ Rs.20 = 3000 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (100 x 15) + (150 x 20) / (100 + 150) = 4500/250 = Rs. 18. Its takes the cost of the Item as Financial cost available (at that instant) divided by the Remaining physical Quantity available. At the time of recalculation the adjustments entries are getting posted according to the selection of the check box of Include Physical Value I read in another forum that the Inventory Model field must be set to Weight Average during the month process.. and Before recalculation set it to FIFO, Do the recalculation and Closing. After Closing Set the Inventory model field back to Weighted average. Some one Kindly let me know the procedure... Thanks in advance Yadhav -- Thanks and regards Yadhava Krishnan T.G. Ph +91 94450 19912
Re: [Axapta-Knowledge-Village] Inventory Recalculation
Hi Mukesh, But here, My requirement is such that During the Invoice(which is received during the next month), the rate of the item might Change. So how will it affect the Item rate since the Inventory is already closed for the month. I have packing slip updated the item for Rs.10 but the Invoice Rate shows Rs 9.00 Or there is a provision Ax 4.0 that u can cancel the latest closing and reclose it.. May be that would deal with this deviation I suppose. Am i Right??? regards Yadhav On Wed, Sep 17, 2008 at 11:14 AM, Mukesh Kumar [EMAIL PROTECTED]wrote: Hi, It depends upon the client what kind of inventory model he wants to use. if you select the physical check box checked, in this case Ax considers the physical value of those items which are a part of inventory means packing slip updated but not invoiced. Bcoz financial value comes after the purchase order is invoiced. In Packing slip updated cases we dont have financial value of inventory but we have physical value. So if you use this check box checked, Ax considers the physical value of those cases in recalculation or closing which are not invoiced but packing slip updated. It helps us to get the true value of the inventory in our stock. Regards, Mukesh On Tue, Sep 16, 2008 at 5:34 PM, Yadhav Krishnan [EMAIL PROTECTED]wrote: Hi friends I have a query. Can anyone (anyone Please) update me on the significance of Using Include physical Value Check Box in the Inventory Model group Form. My client wants to calculate inventory on a weighted average basis during the Month. At the time of Recalculation and Inventory Closing, The Cost has to be calculated on a FIFO Basis and the adjustments distributed accordingly. These are the following settings which I did. Inventory Management -- Inventory Model Group Inventory model field is set to FIFO Include Physical Value Check Box is enabled. Post Financial Inventory check Box is enabled Post Physical Inventory check Box is enabled Actually during the month the cost of the item is taken as the Average of the Packing Slips Received for the Purchase Orders. E.g.: If there are 3 PO's Purchase Order 1 for 100 Nos @ Rs.10 Purchase Order 2 for 200 Nos @ Rs.15 Purchase Order 3 for 150 Nos @ Rs.20 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (200 x 15) + (150 x 20) / (200 + 150) = 6000/350 = Rs. 17.14 For the same scenario if I do not mark the Include Physical value Check Box in the Inventory model group Form Purchase Order 1 for 100 Nos @ Rs.10 = 1000 Purchase Order 2 for 200 Nos @ Rs.15 = 3000 Purchase Order 3 for 150 Nos @ Rs.20 = 3000 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (100 x 15) + (150 x 20) / (100 + 150) = 4500/250 = Rs. 18. Its takes the cost of the Item as Financial cost available (at that instant) divided by the Remaining physical Quantity available. At the time of recalculation the adjustments entries are getting posted according to the selection of the check box of Include Physical Value I read in another forum that the Inventory Model field must be set to Weight Average during the month process.. and Before recalculation set it to FIFO, Do the recalculation and Closing. After Closing Set the Inventory model field back to Weighted average. Some one Kindly let me know the procedure... Thanks in advance Yadhav -- Mukesh Mutreja # 09818421567 -- Thanks and regards Yadhava Krishnan T.G. Ph +91 94450 19912
Re: [Axapta-Knowledge-Village] Inventory Recalculation
Hi, Most of the time in a real scenario, heaps of material arrive in the receiving store. The store-keeper makes an entry in the system upon receipt (packing-slip update) and by EOD he (or a QA) approves all the materials received during the day (invoice-update). In between these two activities of the store keeper if the company wishes to calculate the average cost price of its materials, the only data it has is the packing-slip price. Whether to include the packing-slip price or not is set in the include physical value parameter in that particular inventory model group. One other functionality of this parameter is that, upon checking this box, the cost of the item is taken from the P.O. and not from the items form. When using FIFO, it is also equally important to know at what point the materials have been received and at what point they have been consumed. First check the timelines and then see the status of the purchase order. From your calculation it looks that PO2 is only partially invoiced for 100 pcs. Cheers! Arvind Ramesh. --- On Tue, 9/16/08, Yadhav Krishnan [EMAIL PROTECTED] wrote: From: Yadhav Krishnan [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Inventory Recalculation To: Axapta-Knowledge-Village@yahoogroups.com Date: Tuesday, September 16, 2008, 1:04 PM Hi friends I have a query. Can anyone (anyone Please!! !!) update me on the significance of Using Include physical Value Check Box in the Inventory Model group Form. My client wants to calculate inventory on a weighted average basis during the Month. At the time of Recalculation and Inventory Closing, The Cost has to be calculated on a FIFO Basis and the adjustments distributed accordingly. These are the following settings which I did. Inventory Management -- Inventory Model Group Inventory model field is set to FIFO Include Physical Value Check Box is enabled. Post Financial Inventory check Box is enabled Post Physical Inventory check Box is enabled Actually during the month the cost of the item is taken as the Average of the Packing Slips Received for the Purchase Orders. E.g.: If there are 3 PO's Purchase Order 1 for 100 Nos @ Rs.10 Purchase Order 2 for 200 Nos @ Rs.15 Purchase Order 3 for 150 Nos @ Rs.20 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (200 x 15) + (150 x 20) / (200 + 150) = 6000/350 = Rs. 17.14 For the same scenario if I do not mark the Include Physical value Check Box in the Inventory model group Form Purchase Order 1 for 100 Nos @ Rs.10 = 1000 Purchase Order 2 for 200 Nos @ Rs.15 = 3000 Purchase Order 3 for 150 Nos @ Rs.20 = 3000 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (100 x 15) + (150 x 20) / (100 + 150) = 4500/250 = Rs. 18. Its takes the cost of the Item as Financial cost available (at that instant) divided by the Remaining physical Quantity available. At the time of recalculation the adjustments entries are getting posted according to the selection of the check box of Include Physical Value I read in another forum that the Inventory Model field must be set to Weight Average during the month process.. and Before recalculation set it to FIFO, Do the recalculation and Closing. After Closing Set the Inventory model field back to Weighted average. Some one Kindly let me know the procedure... Thanks in advance Yadhav
Re: [Axapta-Knowledge-Village] Inventory Recalculation
Hi, Inventory price calculation happens by weighted avg.(except Standard cost) even if you specify valuation method as FIFO, LIFO etc Only when we Run - Recalculation or closing it is going to consider the valuation for cost price calculation and the significance of include physical value is simply - used to consider the physically updated transactions also while calculating the cost price I dont think while doing month end we need to change the valuation method... Thanks, Jagadeeh K - Original Message From: Mukesh Kumar [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, September 17, 2008 11:14:32 AM Subject: Re: [Axapta-Knowledge-Village] Inventory Recalculation Hi, It depends upon the client what kind of inventory model he wants to use. if you select the physical check box checked, in this case Ax considers the physical value of those items which are a part of inventory means packing slip updated but not invoiced. Bcoz financial value comes after the purchase order is invoiced. In Packing slip updated cases we dont have financial value of inventory but we have physical value. So if you use this check box checked, Ax considers the physical value of those cases in recalculation or closing which are not invoiced but packing slip updated. It helps us to get the true value of the inventory in our stock. Regards, Mukesh On Tue, Sep 16, 2008 at 5:34 PM, Yadhav Krishnan [EMAIL PROTECTED] co.in wrote: Hi friends I have a query. Can anyone (anyone Please!! !!) update me on the significance of Using Include physical Value Check Box in the Inventory Model group Form. My client wants to calculate inventory on a weighted average basis during the Month. At the time of Recalculation and Inventory Closing, The Cost has to be calculated on a FIFO Basis and the adjustments distributed accordingly. These are the following settings which I did. Inventory Management -- Inventory Model Group Inventory model field is set to FIFO Include Physical Value Check Box is enabled. Post Financial Inventory check Box is enabled Post Physical Inventory check Box is enabled Actually during the month the cost of the item is taken as the Average of the Packing Slips Received for the Purchase Orders. E.g.: If there are 3 PO's Purchase Order 1 for 100 Nos @ Rs.10 Purchase Order 2 for 200 Nos @ Rs.15 Purchase Order 3 for 150 Nos @ Rs.20 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (200 x 15) + (150 x 20) / (200 + 150) = 6000/350 = Rs. 17.14 For the same scenario if I do not mark the Include Physical value Check Box in the Inventory model group Form Purchase Order 1 for 100 Nos @ Rs.10 = 1000 Purchase Order 2 for 200 Nos @ Rs.15 = 3000 Purchase Order 3 for 150 Nos @ Rs.20 = 3000 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (100 x 15) + (150 x 20) / (100 + 150) = 4500/250 = Rs. 18. Its takes the cost of the Item as Financial cost available (at that instant) divided by the Remaining physical Quantity available. At the time of recalculation the adjustments entries are getting posted according to the selection of the check box of Include Physical Value I read in another forum that the Inventory Model field must be set to Weight Average during the month process.. and Before recalculation set it to FIFO, Do the recalculation and Closing. After Closing Set the Inventory model field back to Weighted average. Some one Kindly let me know the procedure... Thanks in advance Yadhav -- Mukesh Mutreja # 09818421567
Re: [Axapta-Knowledge-Village] Inventory Recalculation
Hi, It depends upon the client what kind of inventory model he wants to use. if you select the physical check box checked, in this case Ax considers the physical value of those items which are a part of inventory means packing slip updated but not invoiced. Bcoz financial value comes after the purchase order is invoiced. In Packing slip updated cases we dont have financial value of inventory but we have physical value. So if you use this check box checked, Ax considers the physical value of those cases in recalculation or closing which are not invoiced but packing slip updated. It helps us to get the true value of the inventory in our stock. Regards, Mukesh On Tue, Sep 16, 2008 at 5:34 PM, Yadhav Krishnan [EMAIL PROTECTED]wrote: Hi friends I have a query. Can anyone (anyone Please) update me on the significance of Using Include physical Value Check Box in the Inventory Model group Form. My client wants to calculate inventory on a weighted average basis during the Month. At the time of Recalculation and Inventory Closing, The Cost has to be calculated on a FIFO Basis and the adjustments distributed accordingly. These are the following settings which I did. Inventory Management -- Inventory Model Group Inventory model field is set to FIFO Include Physical Value Check Box is enabled. Post Financial Inventory check Box is enabled Post Physical Inventory check Box is enabled Actually during the month the cost of the item is taken as the Average of the Packing Slips Received for the Purchase Orders. E.g.: If there are 3 PO's Purchase Order 1 for 100 Nos @ Rs.10 Purchase Order 2 for 200 Nos @ Rs.15 Purchase Order 3 for 150 Nos @ Rs.20 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (200 x 15) + (150 x 20) / (200 + 150) = 6000/350 = Rs. 17.14 For the same scenario if I do not mark the Include Physical value Check Box in the Inventory model group Form Purchase Order 1 for 100 Nos @ Rs.10 = 1000 Purchase Order 2 for 200 Nos @ Rs.15 = 3000 Purchase Order 3 for 150 Nos @ Rs.20 = 3000 Purchase Order 1 is invoiced for 100 Nos @ Rs.10. and consumed. And Out of PO 2, 100 Nos is consumed. Now if I am consuming another 50 Nos the Cost of the Item is taken as (100 x 15) + (150 x 20) / (100 + 150) = 4500/250 = Rs. 18. Its takes the cost of the Item as Financial cost available (at that instant) divided by the Remaining physical Quantity available. At the time of recalculation the adjustments entries are getting posted according to the selection of the check box of Include Physical Value I read in another forum that the Inventory Model field must be set to Weight Average during the month process.. and Before recalculation set it to FIFO, Do the recalculation and Closing. After Closing Set the Inventory model field back to Weighted average. Some one Kindly let me know the procedure... Thanks in advance Yadhav -- Mukesh Mutreja # 09818421567