"Ex Cost" to be entered while creating Posted Invoices 4 PO

santoshmkcet

Dear All,

I am stuck for solving a scenarion for one of our clients.

While creating Posted Invoices for Purchase Order,

users will enter the Excise Duty amount, Ecess amount, SHE cess amount, Special Additional Duty amount & "Ex Cost" Amount in PO.

The users will enter the above amounts from the Supplier Invoice they get from their suppliers.

Requirement:
Our client has to creat a GRN based on the Supplier Invoice details

They enter the ED, eCESS, SHE CESS & SAD AMOUNT based on the values given in Supplier Invoice.
Say for 1000 nos, ED is 5922.12, Ecess is 118.44, she Cess is 59.22 & SAD amount is 3218.57.

Then they calculate Ex Cost = Taxable amount - ED - Ecess - She Cess - Rate * GRN qty
= 114320 - 5922.12 - 118.44 - 59.22 - 74.0265 * 1000
= 34193.72

Taxable amount, ED amount, Ecess amount, She Cess amount, Rate, GRN qty all values are available in their Supplier Invoice

They calculate rate = Excise(Value in Supplier Invoice) / Qty / Rate of duty (Value in Supplier Invoice) * 100
= 5922.12/ 1000 / 8 % *100 = 74.0265
Solution provided:

Excise, Ecess, She cess & SAD amount can be mapped in BED amount, eCess amount, SHE cess amount & SAED amount respectively in Nav

Issue:
Now how to map Ex cost in Nav. Ex cost is the amount which should be accounted along with Line amount (Qty * Rate) but not excisable.

P.S. Client will enter manually SAD & Ex Cost Amount


Thanks in advance

santoshmkcet

Dear All,

Ex Cost can be entered in Item charges so that the cost is hits in Purchase Account.

But the issue now facing is how to calculate tax for this amount.

We cannot enter manally in Tax amont field. Am I right?

Thanks

santoshmkcet

Dear All,

The above issue is solved.

Just create a field Ex Cost in Purchase Line & in Posted Invoice Line.

Then add the value entered in Ex Cost field into the Line Amount field
For eg., for 1000 nos at unit cost of 10 and Ex Cost is 20000

Then Line Amount field will be = 1000x10 + 20000
= 30000

This amount will get hit into Purchase Account.

Tax will be calculated.

And in Purchase Invoice Report you can show all the relevant fields ie. Excise Duty, Ecess, She Cess, SAD & Ex Cost amounts along with the Base amount ( Qty x Rate)