I'm currently facing an issue with Zoho Invoices and I'm seeking your assistance.
Here's what I'm looking to achieve:
I need to incorporate a custom field to account for can deposits on my invoices. These deposits are additional charges added to beverage cans and are refunded to the customer when they return the empty can. Can deposits are not taxable.
I believe this can be done using custom fields and formulas. I'm thinking of creating a formula that calculates the deposit only if the product has an attribute "is_can_deposit" or something similar. However, I'm not sure how to add this calculated value to the "Amount" column since it seems to be locked.
Another option could be to automatically add a second row called "Deposit" whenever a product with a deposit is added, but I have no idea how to go about this.