Hi, I have applied Brand name from none to existing items. When I try to see Gross Profit by Brand I can only see the transaction after Brand name was assigned. Old transactions have no Brand info even if all the item have Brand name. How to fix this problem?
Thank you.
All Item details including Brand are fetched into transactions while selecting the Item master link. Changes in the Item master won’t be updated in older records but as you noticed, will be reflecting in all new transactions.
OK. Is there a SQL command to update old transactions manually?
Thank you.