Jon Kears
03/14/2021, 11:28 PMAccount Department Amount
Salaries Sales 10000
Salaries Finance 6000
Salaries Tech 8000
Tax (blank) -10000
Net pay (blank) -14000
And the custom transaction would be:
Account Department Amount Employee
Salaries Sales 2000 Joe Bloggs
Salaries Sales 3000 Jane Doe
Salaries Sales 5000 Harriet Smith
Salaries Sales -10000 (blank)
Salaries Finance 2500 Accountant A
Salaries Finance 3500 Accountant B
Salaries Finance -6000 (blank)
...etc
If you had a mismatch, e.g. if the salaries for tech by person was $7000, you would still have a balanced report but there would be $1000 left over that went to an unknown employee.
Has anyone else had this requirement? Is there a simpler way to achieve what I want (maybe a custom segment?) I want to have good testing coverage on this - I don't want to have some small section or report of Netsuite where the information can creep in which is why I'm thinking custom transactions might be the safer path