Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Check Transaction Dist...

Check Transaction Distribution Inquiry Window

(0) Share

Report

Posted on by Community Member

I am looking for the sql table that displays the transaction on this window. I am not finding a table with the Account numbers along with the Debits and Credits by employee

*This post is locked for comments

All responses (5)

Answers (1)

Verified answer

L Vail 65,271 on at

Like (0)

Report

RE: Check Transaction Distribution Inquiry Window

That's the one! The field to show the whole account number is the ACTNUMST, it's just before the DEX_ROW_ID.

Kind regards,

Leslie
Community Member on at

Like (0)

Report

RE: Check Transaction Distribution Inquiry Window

sorry I see the actindx is in both tables
Community Member on at

Like (0)

Report

RE: Check Transaction Distribution Inquiry Window

I don't see a relationship between the 2 tables
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Check Transaction Distribution Inquiry Window

Hi,

Look at UPR30401. This is the Payroll Distribution History Detail. You'll need to create a join between this table and the GL00105 table in order to get the actual account number string to show.

Kind regards,

Leslie
Community Member on at

Like (0)

Report

RE: Check Transaction Distribution Inquiry Window