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
I have the same question (0)
Share
Report
All responses (
Answers (
65,271
