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

Question

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#

Rafnas T P · 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

Ramesh Palanivel · Answer

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

Jyoti Jodha · Answer

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 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; }

Jyoti Jodha · Answer

if Item MRP including GST then SGST and CGST amount lessthen MRP...??? otherwise MRP+GST.....

Karthi Keyan · Answer

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.

Jyoti Jodha · Answer

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

Ramesh Palanivel · Answer

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=30cgst=30 rate =560totalamount=500

Amit Gupta · Answer

Are you asking to calculate the gross price excluding gst? If yes then formula is BasicCost = (Qty * Rate)/(1+(GST/100))

Jyoti Jodha · Answer

yes i am know the sgst(6%) or cgst(6%)

Jyoti Jodha · Answer

how to calculate Mrp price to GST Tax And Rate....?? Mrp Rate sgst cgst total amount 500 ? ? ? 500

Rafnas T P · Answer

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