Daily stock movement not getting Excise value

lally

Hi masters,


In My R.G. 1 ( Daily stock movement) report just getting item qty only, but it not getting excise values based on that item cost .

What is the problem.

How R.G. 1 will get the excise values including item qty.


Please share your valuaes.

ssingla

Sales Amount (Actual) from ILE is the value of the goods. Check in the related records.

lally

Thanks Mr ssingla,


I could not understanding what your trying to say.
Because why I need to for sales amount (actual) from ILE.
You know very well why we use R.G. 1 In manufacturing company.
Today they completed one production order and Posted out put Journal.
For that item I assign the Exccise product osting group in Item card.
Then I run the DSA for that location . Then daily stock Account report has that qty but it did not contain that what is the excise amount and Shecess…
I need that amount in daily stock account report.

Please suggest me.

ssingla

lally wrote:

Thanks Mr ssingla,


I could not understanding what your trying to say.
Because why I need to for sales amount (actual) from ILE.
You know very well why we use R.G. 1 In manufacturing company.
Today they completed one production order and Posted out put Journal.
For that item I assign the Exccise product osting group in Item card.
Then I run the DSA for that location . Then daily stock Account report has that qty but it did not contain that what is the excise amount and Shecess…
I need that amount in daily stock account report.

Please suggest me.

Ya I do know why we use RG1 I guess you need to understand. RG shows the physical qty of stock i.e. opening + production -sales = closing stock. Further Sale is classified in 2 parts i.e. Removable without payment of duty (the goods are dutiable) and Remove exempt goods(for export,sale against CT3 etc.) For the dutiable goods you need to show the excise amount charged which should match with your ER1 of that period.

As far as I know there is no need to show excise value for the goods in hand.

lally

Thanks SSingla,


I completed a production order and out put posted qty = 10.

Then i created a sales order for qty = 15 but the inventory is 10.
So in qty to ship field i enter = 10. with in couple of days i can send the remainng qty on the same sales order .
so I had taken the structure and caluc late structure then i shipped the qty = 10.
Then i go to R.G. 1 then here excise updated for qty = 15 not for 10.
So it is wrong?
it has to updated for the qty = 10 only .
now i created a Sales invoice for the qty = 10 then i gone through the RG 1, but here RG1 not getting the excise invoice number .
So how to get that Excise invoice number ?

please suggest me.