Asset balances extraction through script issue
This script is picking duplicate asset lines, beacuase of following reason i.e FA additions window we have two tabs i.e Source lines and Assignments, we need to map unique records between these 2 tabs, so that we can extract exact balances from backend.
Ex:- Asset-1 is having 3 Units, is having 2 source lines.
Asset cost=10000, this 10000 belongs to 3 Invoice amounts (3000, 3000, 4000) in this case rather than showing 3 lines and cost as 10000 it is showing 30000. i.e each line is showing total cost of the asset.