You’re offline. This is a read only version of the page.
Hi all,
Two background comments:
1. I am coming from a developer background, not accounting
2. We are in the process of migrating to Dynamics GP. Therefore, we don't have much data to populate in our tables.
My Question:
I've modified in Dynamics the report Marked Transaction Report in order to make sure that it shows received from. That works perfectly fine for one company since the field CMTrxNum is unique in table CM20200 (aka CM Transactions).
Now we've migrated data for another company. Since there was a batch which was imported into the table CM20200 but the column CMTrxNum isn't populated properly.
My question is as follows:
Should I ask to re import this data but make sure that it is populated correctly?
Alternatively, is there a way to modify the report according to the company that it tries to handle? Or is there another way to link CM20200 and CM20300 together?
The code used to be in SQL (for the previous database) like this:
SELECT * FROM [dbo].[CM20200] LEFT JOIN [dbo].[CM20300] ON [CM20200].CMTrxNum = [CM20300].depositnumber
And to work perfectly fine. (of course instead of "*" it was the required fields).
Thanks in advance for your help,
H.
*This post is locked for comments
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,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
