Dear All
I can find GL code in ACTNUMST in table GL00105 in , if I want to link it to a invoice, such as a record in SOP30300 or RM20201. how can I join it?
Thanks in advance.
Wilson
,
*This post is locked for comments
Dear All
I can find GL code in ACTNUMST in table GL00105 in , if I want to link it to a invoice, such as a record in SOP30300 or RM20201. how can I join it?
Thanks in advance.
Wilson
,
*This post is locked for comments
SELECT * FROM SOP30300
INNER JOIN
GL00105 ON GL00105.ACTINDX = SOP30300.SLSINDX
The above shows the link to the SOP30300 table to GL00105 using the Sales Account Index.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156