how to separate calculator Gst and Rate in windows form c#

Jyoti Jodha

9y9.9kWindows Forms

Some Item price including Gst, how to separate calculator Gst and Rate in windows form c#

in some Item including GST and some item add GST

how to manage it....??

in windows application c#

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
if you know the rate o then you can calculate sgst or cgst
if you know the sgst or cgst then you can calculate rate
0
sujit jha7y ago
hi all

if you calculate sgst or cgst then u can use this code 100% work

first take 6 textbox
1 button
1st textbox is quantity, 2nd textbox is rate, 3rd textbox is amount & 4th cgst% , and textbox5 is cgst amount & last net amount

now use this method...
double clik on button event
{
   int a = convert.toint32(textbox1.tex);
   int b = convert.toint32(textbox2.tex);

   int c = a+b
textbox3.tex = c.tostring();
// now gst calculate

int d = convert.toint32(textbox3.tex);
int e = convert.toint32(textbox4.tex);
int f=d*e/100
textbox5.tex = f.tostring();

//now you get total (net amount)
int g=c+f
textbox6.tex=g.tostring();

}
0
Ramesh Palanivel9y ago
Hi Jyothi,

The best way is , while entering product master update the product GST details also.

whether the product MRP is included with GST or Separate GST.

IF it included GST enter the GST percentage and store in product master.

If it is not included in GST , enter the proper GST for that product.,

If it is everything in master, it will be easy to biling. Otherwise you have write some manual code in biling module
0
Jyoti Jodha9y ago
how to create Query if checkBox_includ_Gst.Checked == true

if (qtytxtprice.Text != "" && checkBox_includ_Gst.Checked == true)
{
//?? What code write here.....
}
else if (checkBox_includ_Gst.Checked == false && qtytxtprice.Text != "" )
{
double Qty = Convert.ToDouble(isEmpty(txtqty.Text));
double Unit_Price = Convert.ToDouble(isEmpty(qtytxtprice.Text));
double Amount = (Qty * Unit_Price);
double discount = ((Amount * Convert.ToDouble(isEmpty(txtdiscount.Text))) / 100);
double afterdicount = Amount - discount;
double sgst = (Convert.ToDouble(txttax.SelectedValue) * GlobalVariable.SGST) / 100;
double cgst = (Convert.ToDouble(txttax.SelectedValue) * GlobalVariable.CGST) / 100;
double Igst = (Convert.ToDouble(txttax.SelectedValue) * GlobalVariable.IGST) / 100;
DataTable dt = new DataTable();
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Customer_Details where CustID=" + Convert.ToInt16(comboBox_Custname.SelectedValue.ToString()) + " and State=(select State_ID from cmpny_dtl where id=" + GlobalVariable.companyId + ")", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
con.Close();
}
catch { }
if (dt.Rows.Count > 0 || comboBox_Custname.SelectedIndex < 0)
Igst = 0;//customer state and comany state same remainig all 50
else
cgst = 0;////customer state and comany not state same remaini all 50
// double taxamount= ((afterdicount * Convert.ToDouble(txttax.SelectedValue)) / 100);
double cgstAmount = ((afterdicount * cgst) / 100);
double sgstAmount = ((afterdicount * sgst) / 100);
double igstAmount = ((afterdicount * Igst) / 100);
double totalgst = cgstAmount + sgstAmount + igstAmount;
double TotalAmount = afterdicount + cgstAmount + sgstAmount + igstAmount;
}

0
Jyoti Jodha9y ago
if Item MRP including GST
then SGST and CGST amount lessthen MRP...???
otherwise MRP+GST.....
0
Karthi Keyan9y ago
Hi Jodha,

You Question :

bUT some Item MRP including GST, and some item MRP +GST
how to manage it....??

   Answer :

Before Enter into the Calcuation of rate, you must check whether the MRP of the ITEM including GST or not? if it including GST you don't need to calculate the GST. simply calculate the Rate. if the MRP of the ITEM is not include with GST then calculate the GST for your Item.
0
Jyoti Jodha9y ago
bUT some Item MRP including GST, and some item MRP +GST
how to manage it....??
0
Ramesh Palanivel9y ago
Hi Jyothi,

Your total amount is 500.

so, sgst 6 % +cgst 6% =12%

percent=(totalamount*12)/100=60

sgst= percent/2; //30
cgst=sgst; //30

Rate =totalamount+percent ; //560
sgst=30,cgst=30 ,rate =560,totalamount=500
0
Amit Gupta9y ago
Are you asking to calculate the gross price excluding gst?

If yes, then formula is
BasicCost = (Qty * Rate)/(1+(GST/100))
0
Jyoti Jodha9y ago
yes i am know the sgst(6%) or cgst(6%)
0
Jyoti Jodha9y ago
how to calculate Mrp price to GST Tax And Rate....??

Mrp Rate sgst cgst total amount
500 ? ? ? 500
0
Rafnas T P9y ago
hi,
before calculating gst you can chack if that item is applicable for gst, if its applicabal then you can calculate gst and add to that item cost, else same item cost
0

Mrp	Rate	sgst	cgst	total amount
500	?	?	?	500