Isaac
07/26/2025, 2:14 AMCeligo AI
07/26/2025, 2:14 AMAI generated answer (using internal Slack threads):Based on the conversations provided, it appears that Payroll data, including Payroll Liability Check transactions, can be accessed via SuiteQL. One of the users shared a SuiteQL query that they use to access Payroll data in a custom employee portal. Here is the query:
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
However, the conversations do not provide any information about accessing Payroll Liability Check transactions via the REST API.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
07/26/2025, 2:14 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830278158
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814966917
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814770758
Celigo AI
07/26/2025, 2:14 AM