getting to the source document in dynamics

(0) Share

Report

Posted on by Community Member

Hi everyone-

I'd like to preface this post by saying I don't want to use SQL in order to do this. I want to be able to use the accounting system on an as is basis.

My frustration is that we have to click several times from the g/l summary or detail screen in order to get to the source document screen. I need to do that frequently. Is there a way to shortcut this so that I can just cut to the chase and view the source document window for the particular amount in question, instead of hunting/pecking? It seems like a gigantic waste of time. Maybe I'm not using the system correctly.

Someone please set me straight. Thank you.

Neil

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Angel Nuñez on at

Like (1)

Report

Hi Neil. I think a Smartlist will take care of your frustration. Try the Account Transactions under Financial. Just double click on the journal and it'll take you to the source.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Angel, thank you very much for the reply. That does work, but it's not exactly what I'm looking for. What I was hoping for was a way to go directly to the source doc from the inquiry screen-without having to go anywhere else. Do you know if Dynamics has the horsepower to do that? Seems ridiculous to click 3 times every time I want to drill in to research further on something. Which happens constantly. Thanks again.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (1)

Report

When you reference the Source Document, are you talking about an attached Invoice or just the 'voucher' created when you create the invoice record in the system?

I find that trying to jump to many steps into data can be a challenge and as a non-programmer, I can not think of a simple way to get from a JE to a Invoice in less steps.

As to horse power, wondering if you are finding the data, finding it slowly or is it just that you feel it is cumbersome to move around the system.

Just my thoughts.

Was this reply helpful? Yes No
Suggested answer

iruser2 2,048 on at

Like (1)

Report

Smart list could likely have the destination window of the double click be the source document window that you refer to. It may be tricky to know if you are going to Sales, Purchasing or Inventory however.

Smart list can pull the originating master ID and Name getting you vendor or customer, and it can pull the originating master number getting you the document number. You already have the distribution, or part of it if you are starting at the gl.

What are you looking to see on the source document screen that smart list cannot deliver?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bill, thank you. I'll try to clarify. From the summary inquiry screen, I click on 'Net Change', from there the 'Detail Inquiry' screen pops up, and then I click 'Journal Entry' for the amount I wish to further investigate. This happens all day, every day. I then find my amount in the 'Transaction Entry Zoom' window, and click 'Source Document' (this is the Source Doc I'm referring to above). Now I'm in 'Purchasing Zoom', which is the entire batch. Now I have to hunt and peck (which could take time, depending on the size of the batch) for the amount I care about before I then click 'Voucher/Payment Number' and I'm finally in the 'Payables Transaction Entry Zoom', which is what I'm interested in.

Is there a way to be able to click with one-click, from the g/l detail screen direct to the 'Payables Transaction Entry Zoom' screen? Because of the amount of times we are doing this, using a smartlist probably doesn't cut down on our time. Thank you again.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (1)

Report

Neil, thanks for the clarification to the issue - as you describe I am sure I will tire of that in testing.

I will give it a go later today and will post when I have something to contribute.

Of course others will share as soon as they can.

Was this reply helpful? Yes No
Verified answer

Angel Nuñez on at

Like (0)

Report

The only way I see this happening is with some customization involved. Maybe modify the window with VBA. I would design a SSRS report or a customized smartlist with Smarlist Designer, but maybe you're not an IT guy like some of us here.

Was this reply helpful? Yes No
Verified answer

Bill Campbell 12 on at

Like (0)

Report

Neil to some degree I have to agree with Angel - short of customization or building a Smartlist that bypasses all the intermediate screens, I have not seen a faster way to get to the Source Document - when starting off looking at the Summary / Detail account dollars in the Finance module.

As Angel points out there are a number of 'IT Solutions' that could be made to work - but, without violating your first comment - not using SQL - I am pretty much stuck. There are people in this community that can and likely do make these things happen - I am not one of them - but I can tell you that if it can be done - this is the place to work from.

Sorry not able to provide better news.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Bill, thank you again for your reply. Angel is correct, I am not an IT guy, I'm a CPA. I do appreciate everyone trying to help.

Was this reply helpful? Yes No