Purchases from IInd Stage dealers

aps

Hi All,
I am facing a problem relating to purchases order issued to II nd stage dealers.
If I want to issue a Order to a IInd Stage dealer. How can I calculate the Excise Amount included in the item Price
e.g.

Item Price---> 1000 (Excise is calculated on rs.400 /- i.e. rs.65.92/-)

Now the vendor should get credited by Rs.1000/- only....
Excise Amount should get debited by Rs. 65.92
Inventory should get debited by Rs. 934.08/-

How can I handle it......
Waiting for your precious reply..

reagrds,
Aman

ssingla

New hotfix provides the option if manual excise in case of II stage dealer. You can manually enter the excise amount in the purchase line and then post the transaction. There is a boolean field which allows you to enter the excise amount manually.

reema

Hi SSingla,

Thanks for u r valuable information. I keen observed onething that u have good commnd and knowledge on Navision and localised of indian version.
I can access patnersouce.
I would like to ask one thing how can i get that hotfixes from microsoft patner source. that means how to check that hotfixes are only for india.Do i need to check that hot fixes daily . For example taody some hotfix released by MS. How can i know that purpose of hot fix.

I am excepting cool response from u.

Thanks and regards

ssingla

Hot fixes can be filtered for APAC region and then for Country India. Update mails for hotfix are released by Microsoft India to all the partners. You can ask the concerned person in your company to forward the same to you.
The update mail narrated in brief the modification made and link to the partnersource where you can download the hotfix.

reema

Thank U SSingla,


"Hot fixes can be filtered for APAC region and then for Country India"

What is APAC region. Could u explain that . I cannot get that word.


thanks and regards

darshanm

APAC = Asia Pacific Region

aps

Sandeepji,
Sorry for the late reply....
I tried as you said but while posting Pur. Invoice, Excise G/L Account is not getting affected.
What I did is, I subtracted the Excise Amount from the LINE AMOUNT EXCL. VAT column...it will give the right effect in the G/L account....
the problem arises when Discount is involved in the invoice..

When I subtract the Amount as mentioned above it will change the LINE DISC % and further will reflect incorrect values in the report...

Kindly let me know how to handle it.....I am in a fix and got to find same solution to it...

Sandeep ji do let me know if I can contact you...
My email id is amanpreet.singh@info-spectrum.com

Regards,
Aman

aps

Hi all,
please let me know if any customization is required....

how can we do it....


regds,
aps

ssingla

I dont think any customization is required. I will test tonight and will confirm you. Well have you tried marking the field "Include Line Discount" in the structure.

aps

Thanks for the reply Sandeepji,
I have tried it all the ways.....still cant get the desired result

The order structure should be like
Qty-> 100
rate-> 125
Disc> 20%
Vat-> 4%
Excise is Inclusive and the Assessable Value is 40

The vendor should be credited with 10400/- only
[12500-2500 (disc)=10000, 10000 is the amount in which excise in included and Vat should be calculated seperately]

I hope you can get what I mean to say...

regds,
APS

aps

I think Only I am facing such type of problem......
But purchase from II nd stage dealers is a normal transaction.....

Even if I try to post the transaction by placing check mark in the INCLUDE PIT CALCULATION in the STRUCTURES, its not working.....