Invalid Reference Row Error - Sales Taxes and Charges Table

roshrnair · June 28, 2024, 10:41am

I am trying to add 2 discounts as part of the Sales Taxes and Charges Table. But unable to do so.

volkswagner · June 28, 2024, 11:15am

You say you’d like to add two discounts but from the limited info you provided (only a screenshot), it appears you are trying to apply the same Output Tax twice. If you are trying to apply two discounts, shouldn’t they be unique?

roshrnair · June 28, 2024, 11:51am

Yes, they are Unique, one is Cash Discount and the next one is Trade Discount.
Ideally the rate should have been -ve as well. My bad.

Smit_Vora · July 1, 2024, 3:45am

Hi,

I wasn’t able to replicate the issue.

It’s triggered from here:

github.com

resilient-tech/india-compliance/blob/6760eab8d8924d406eed2d8e8210f595ec036d26/india_compliance/gst_india/overrides/transaction.py#L460


      
          
              if row.charge_type == "On Previous Row Amount":
                  _throw(
                      _(
                          "Row #{0}: Charge Type cannot be <strong>On Previous Row"
                          " Amount</strong> for a GST Account"
                      ).format(row.idx),
                      title=_("Invalid Charge Type"),
                  )
              if row.charge_type == "On Previous Row Total":
                  previous_row_references.add(row.row_id)
          
              # validating charge type "On Item Quantity" and non_cess_advol_account
              validate_charge_type_for_cess_non_advol_accounts(row)
          
          used_accounts = set(row.account_head for row in rows_to_validate)
          if not is_inter_state:
              if used_accounts and not set(intra_state_accounts[:2]).issubset(used_accounts):
                  _throw(
                      _(
                          "Cannot use only one of CGST or SGST account for intra-state"

It’s looping over GST Accounts (rows_to_validate) to ensure reference row number (in my example 4) is same for CGST and SGST.

Possible Causes of the issue:

Incorrect GST Account setup in GST Settings
Customisations gone wrong

roshrnair · July 1, 2024, 2:02pm

Solved now.
Missed to provide reference row for row 3. It is mandatory to provide reference row even if a row references just the previous row.

Thank You for all the pointers.

Smit_Vora · July 2, 2024, 4:37am

This was already set in your original screenshot with error.

However, nice to know you figured it out.