Hi all -
I'm looking for a script that can pull the SOP Invoices (all status) with the GL accounts that were posted. I think Victoria Yudin has one but it only shows the debits and credits, and not the actual GL accounts.
Thanks!
Od
*This post is locked for comments
Thanks guys -
Harry, I will start with your script and keep you posted.
Oumar Diop
I do not know what your SQL skill level is, but here's a quick script to get you started. It identifies the tables you'd likely need for this kind of report.
select GLD.ACTNUMST Acct_Number,* from SOP10102 SDT
left join sop10200 SOOL on SDT.SOPTYPE = SOOL.SOPTYPE and SDT.SOPNUMBE = SOOL.SOPNUMBE and SDT.SEQNUMBR = SOOL.LNITMSEQ
Left Join SOP10100 SOOH on SDT.SOPTYPE = SOOH.SOPTYPE and SDT.SOPNUMBE = SOOH.SOPNUMBE
left join GL00105 GLD on SDT.ACTINDX = GLD.ACTINDX
Hi diop,
You need along with item codes or at document level. Can you please share the format you desire. It would help to understand your requirement.
Regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (