what are best practices for auditing payroll in netsuite

AI generated answer (using internal Slack threads):

Based on the conversations, here are some best practices for auditing payroll in NetSuite: 1. System Notes Search: This is a powerful tool that captures all activities in NetSuite. It can be used to audit what a user has been doing in NetSuite, including payroll-related activities. 2. SuiteQL: This is a SQL-like language that allows you to query your NetSuite data. You can use SuiteQL to retrieve payroll data for auditing purposes. Here's a sample SuiteQL query that was shared in the conversations:

code
SELECT
    PayCheck.ID,
    PayCheck.TranDate,
    PayCheck.BatchNumber,
    PayCheck.TranID AS CheckNumber,
    Paycheck.Entity,
    PayCheck.ChkAmount,
    PayCheck.Location AS LocationID,
    Location.Name AS LocationName,
    Employee.ID AS EmployeeID,
    Employee.FirstName,
    Employee.LastName,
    Employee.Email,
    BUILTIN.DF( PayCheckSummary.ItemCategory ) AS ItemCategory,
    BUILTIN.DF( PayCheckSummary.PayItem ) AS PayItem,
    BUILTIN.DF( PayCheckSummary.PayItemType ) AS PayItemType,
    PayCheckSummary.Value,
    PayCheckSummary.Amount
FROM
    Paycheck    
    INNER JOIN Employee ON
        ( Employee.ID = Paycheck.Entity )
    INNER JOIN Location ON
        ( Location.ID = PayCheck.Location )    
    INNER JOIN PayCheckSummary ON
        ( PayCheckSummary.Paycheck = Paycheck.ID )        
WHERE
    ( Paycheck.Entity = 9999 )
    -- AND ( PayCheck.TranDate BETWEEN TO_DATE( '2020-01-01', 'YYYY-MM-DD' ) AND TO_DATE( '2020-12-31', 'YYYY-MM-DD' ) )
ORDER BY
    PayCheck.TranDate

3. Data Backup: If you're planning to stop using NetSuite for payroll, it's important to back up all your payroll data, including paystubs for all current and previous employees. You can use SuiteQL to retrieve this data and then export it for safekeeping. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******