We are having an issue with this view. It is duplicating records due to this table....
Left outer join [[X3Schema]].[GTYPACCENT] GT on GD.TYP_0 = GT.TYP_0 AND GT.PER_0 <> 2
For example we have a CSINV type that is a blank Ledger and one for USA ledger. I not sure how to correct the joins to ensure correct data.
Has anyone had this issue and know how to resolve?