Share
Report
Microsoft Dynamics GP 10.0
SQL Server 2005
I know I've done this before, but it was some years ago. I'm digging through SQL tables but am not having any luck. In a former company we had an issue years ago where we had some posted invoices that somehow did not post to the GL. I've been asked to make a report to periodically check to ensure this is not the case again. Not sure why this happened, why it has come up now, and am doubtful the report would ever populate.
Can anyone tell me which sales SQL table (e.g. SOP30200) links with which general ledger SQL table (e.g. GL10000).
thanks!
brad
SQL Server 2005
I know I've done this before, but it was some years ago. I'm digging through SQL tables but am not having any luck. In a former company we had an issue years ago where we had some posted invoices that somehow did not post to the GL. I've been asked to make a report to periodically check to ensure this is not the case again. Not sure why this happened, why it has come up now, and am doubtful the report would ever populate.
Can anyone tell me which sales SQL table (e.g. SOP30200) links with which general ledger SQL table (e.g. GL10000).
thanks!
brad
*This post is locked for comments
All responses (
Answers (
75,730
