Posting salary costs by employee We forecast salar...
# general
j
Posting salary costs by employee We forecast salaries by person in another system, but I can't currently post actuals by employee as I don't want every user who can run a TB to be able to see them. I'm thinking if we did a custom transaction with employee on it, that had a contra line that had a blank employee, I could separately control access to and export this record to our forecasting system. So the "normal" (standard journal) payroll transaction would be:
Copy code
Account    Department    Amount  
Salaries    Sales           10000
Salaries    Finance          6000
Salaries    Tech             8000
Tax         (blank)        -10000
Net pay     (blank)        -14000
And the custom transaction would be:
Copy code
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