Lawson Payroll Data Extraction

I need an expert who can tap into our Lawson environment and pull the financial-side payroll information we keep there. The end goal is a clear, well-structured Excel workbook—no other format will do—containing every payroll field we agree on (earnings, deductions, taxes, cost center coding, and any other columns you know are standard for Lawson’s payroll tables).

Here is what matters to me:

• Source: Lawson (on-premise LSF, version 10)
• Scope: Financial data tied specifically to payroll—nothing HR-only or attendance-related.
• Delivery: A single Excel file, cleanly formatted and ready for pivoting or upload into Power BI.

You may use whatever extraction method you are most comfortable with—Lawson SQL queries, the Lawson API, or an ETL tool such as Informatica or SSIS—as long as the process is repeatable. Document each step briefly so my internal analyst can rerun the pull next month.

Acceptance criteria
• All requested payroll fields present and populated.
• No duplicate rows or orphaned records.
• Refresh instructions validated on a second machine.

If you have successfully extracted payroll data from Lawson before, I’d like to hear how you approached security tokens, data dictionaries, and large record sets. Let’s keep it straightforward and get this data into Excel quickly and cleanly.