Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Linking a receiving transaction to the final receivables transaction in a smartlist

Posted on by 5

I am trying to build a smartlist that will show the customer invoice (receivable) that generated from our purchasing/receiving document internally. More specifically I want to know what the original receiving item was coded to on the ledger as well as how the customer invoice (receivable) that generated from the receiving doc was coded. Currently we run a smartlist for our COGS account and zero in on each transaction until we get the customer order and invoice that was generated and then compare then compare the invoices to our sales journal entries to verify the correct territory codes were used. I feel like there has to be a better way to pull this data without have to click through 5 screens but I have not been able to find a smart list or manipulate a smartlist that will show me both the sales and the purchasing side of a transaction. Help.

Categories:
  • Suggested answer
    Lucas Reuss Profile Picture
    Lucas Reuss on at
    RE: Linking a receiving transaction to the final receivables transaction in a smartlist

    Hello Elizabeth,

    Thank you for your post!  Unfortunately, we do not have anything built into Dynamics GP that would help you evaluate this information out of the box.  My recommendation would be to create a SQL view to connect the distributions of the various document types involved and use that in SmartList Designer to create the report that you are looking for.

    I will leave the post up for the community to post their ideas as well.

    Thank you,

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans