Hi,
This is an expected error while running inventory closing/recalculation....cant
do this prior to cancellation the closing.
Santosh
--- On Thu, 18/9/08, Yadhav Krishnan <[EMAIL PROTECTED]> wrote:
From: Yadhav Krishnan <[EMAIL PROTECTED]>
Subject: Re: [Axapta-Knowledge-Village] Inventory Recalculation
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Thursday, 18 September, 2008, 12:02 AM
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] com> 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] co.in> wrote:
From: Yadhav Krishnan <[EMAIL PROTECTED] co.in>
Subject: [Axapta-Knowledge- Village] Inventory Recalculation
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.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
Did you know? You can CHAT without downloading messenger. Go to
http://in.webmessenger.yahoo.com/
