Looking to create a report listing the original transaction description behind the intercompany transaction created by Lawson, but running into challenges with the table relationships. Currently the following description is created by Lawson: "Auto Offset From Zone ##" for the intercompany transaction.
Searching for the amount , fiscal year, acct period and system I can find the records:
SELECT obj_id
FROM gltrans
WHERE base_amount = 19.37 AND fiscal_year = 2017
AND acct_period = 11 AND r_system = 'AP'
select * from apdistrib where GLT_OBJ_ID = 14784710 (value returned from above)
But anytime there's the same amount in the same period the above doesn't work, and basing logic on an amount is not my first preference.
Any help would be appreciated. Thanks!
Lawson v10.0.9.0
