Hello,

i have a tricky question from my accountant i don't have a solution.

We have sales orders that are imported from Shopify automatically. Some of the sales orders have the product "discount". My income account in the product "discount' is set to "3003 - Discount of Sales".

When i generate the sales invoice, the product 'discount' is getting the Account "3003 - Discount of Sales". That's all good so far. 

However, from the accounting point of view, not all discounts are discounts. Some of them are product returns which with a different Account (e.g. 3000 - Sales of Goods).

 Shopify does not make any difference between product return and discounts.  

Is there a way that i can override the account when the invoice is created based on some triggers ? 

e.g. when a specific tag in the sales order (e.g. tag #refund), for all products = "discount" the account in the sales order will replaced with 3000 (instead of 3003) ?