MS Dynamics GP - Adding Distribution References

(0) Share

Report

Posted on by cbucks723

260

community.dynamics.com/.../ms-dynamics-gp-adding-distribution-references.aspx

I came across this original post and I was wondering if you can add the GL description to the Edit List ? (Right before you post the batch)

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Olaf Laos 1,890 on at

Like (0)

Report

I don’t think you can. If you look at the report via report writer, it just has field1, field2 etc. from a temp table. But it doesn’t include the reference and you won’t be able to link the temp table to the distribution table to get the reference because it doesn’t hold enough information to create the link.

Was this reply helpful? Yes No
Suggested answer

Jim Lines 4 on at

Like (0)

Report

Hi. I just added the GL Distribution Field in General Transaction Edit List. If you open the report in RW and choose Allocation Amounts from the drop down, the field is called Description. I was able to get my unposted transaction GL Line Reference on the report when printing the edit list from the batch.

Jim

Was this reply helpful? Yes No
Suggested answer

Jim Lines 4 on at

Like (0)

Report

Hi. I just added the GL Distribution Field in General Transaction Edit List. If you open the report in RW and choose Allocation Amounts from the drop down, the field is called Description. I was able to get my unposted transaction GL Line Reference on the report when printing the edit list from the batch.

Jim

Was this reply helpful? Yes No
Olaf Laos 1,890 on at

Like (0)

Report

Yes, Jim's solution works for the GL Transaction Edit List.

But Payables Transaction Edit List and others, I don't think you can.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

KB865470 Will show you how to add the distrobution reference to the payables transaction edit list.

Was this reply helpful? Yes No
cbucks723 260 on at

Like (0)

Report

Thank you Jim - I'm looking to see if I can get it on the AP Edit List. We base a Crystal Report off of the "Trip #" that is entered in the description.

It would be great if I could look and verify this # before a batch is posted. Now we have to go into each entry and look at the info....

I'll keep searching for a solution.

Was this reply helpful? Yes No
cbucks723 260 on at

Like (0)

Report

Do you have a link to KB865470 ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

THe only issue that I have is that when I try this KB article, it works great as long as you don't have any inter company transactions. THen it pulls the account index from the originating company. What have I left off that is causing this issue?

thanks

Carolyn

Was this reply helpful? Yes No
Kerry Brooks 50 on at

Like (0)

Report

Yes. KB Article KB865470 says not to use this method if you are utilizing Intercompany. Is there a way to drag in this field if you do use Intercompany?

Was this reply helpful? Yes No
cbucks723 260 on at

Like (0)

Report

The GL Distribution Reference is what I'm talking about. (I just revisited this post and realized I wasn't very spot on with my location)

Was this reply helpful? Yes No