Returns all columns of transaction number series for companies specified in the list. Useful for auditing number series in multi-company or shared services systems.
Adapt this query as required to return columns of other dimensions.
Returns journal lines for the journal number or numbers in the bracketed list. Adapt to specific requirements.
Returns finance entries where the company number of the entry does not match the company number of the employee referenced in the entry. Adapt to your own purpose, especially elements in red.
Convert or adapt the red elements for your own query.
Adapt this query to the target system by changing the elements in red. Add or remove companies and dimension combinations as required.