Requirement:
Calculate the amount on the vendor bill automatically based on the TDS % on the vendor record.
Solution:
- A new field will be created to store the India Tax Section Code on vendor records.
- Also will create a new transaction line checkbox field “Tax Code Update” on a bill to record whether a different tax code needs to be applied for an item line when compared to the tax code on the vendor record.
- If the Tax Code Update is unchecked, the tax section code for the corresponding line will be automatically populated from the vendor record after creating the billing record.
- If the Tax Code Update is checked, the script will not overwrite the existing tax code on that field.
- The Tax Section Code will be imported for the vendors after getting the files from the Zupee.
Assumption:
Calculate the amount on the vendor bill automatically based on the TDS % on the vendor record.
Risk:
- If there are any changes needed for the Tax Section Code for any lines when compared with the vendor record, the user should check the field Tax Code Update on the vendor bill line.
- These modifications will occur on the historical transaction only if corresponding open transactions are edited.
- In addition, if the user imports vendor bills, we should check the Run Server Script field on the import page to run the proposed script.