Microsoft GP 2010 General Posting Journal Report: Journal Entries sorted by Input

(0) Share

Report

Posted on by Rszeto

765

Hi everyone,

One of our clients recently asked for their General Journal Entry Inquiry Reports to be sorted by the order they entered the information. They found that in this specific report GP sorts the report by their account numbers. As a result, it becomes difficult for their team to review these entries.

After looking at the General Journal Edit List, this report sorts the accounts in which they were inputted. Does anyone know how to modify the General Posting Journal Report in Report Writer to do the same as the General Posting Edit list?

I looked into the account number string for both reports in Report Writer (General Journal Edit List and General Posting Journal) and they share the same properties - Table: GL_Allocation_Register_WORK. TableName: Allocation Amounts Temporary.

Thanks,

Ronald

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

Check this out,

How to sort the GL Posting Journal report by the account number in Microsoft Dynamics GP

Was this reply helpful? Yes No
Rszeto 765 on at

Like (0)

Report

Hi Mahmoud,

Thanks for the reply, I've looked into this article previously, but I think this only helps to change the report so that it sorts by ACCOUNT NUMBER. I'm looking to have the General Journal Posting Report to sort by ENTRY (how the user entered the entries). Note that the General Journal Edit List does sort by entry.

Thanks again,

Ronald

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

You need to consider the line Line Sequence Number (Distribution Sequence Number), in which you will find increments of the "16384", For instance (16384, 32768, 49152, 65536 ... etc)

Each distribution table in Dynamics GP has a corresponding Distribution Sequence Number stored in the original distribution table, which indicates its position in the distribution entry window (as it is inserted).

In this essence, consider the same logic included in the reference above by creating a new sort based on the Sequence Number.

Hope this helps,

Was this reply helpful? Yes No
Rszeto 765 on at

Like (0)

Report

Hi Mahmoud,

Sounds good, I'll try that and reply back here if I can successfully do this. Thanks again!

Best,

Ronald

Was this reply helpful? Yes No
Rszeto 765 on at

Like (0)

Report

Hi,

When I initially create the Journal Entry, I can enter the information in the order I'd like.

Debit Credit

1a x

2b x

2a xx

1b xx

When Idecide to print the transaction from the Transaction Entry Window or Batch Window, GP will keep the line distribution sequence of the transactions in this table, the Unposted Table. In other words, the General Posting Edit List will pull data in the format it is currently in from the Unposted Table.

The issue here is once I post the Journal Entry, GP automatically sorts the entries by account.

Debit Credit

1a x

1b xx

2a xx

2b x

This happens when the Unposted Table is moved to the Open Table. Furthermore, GP does NOT save the original format of the data when it was in the Unposted Table. Ultimately, once Ipost the Journal Entry, the General Posting Journal Report will pull data in the format it is currently in from the Open Table.

Is there a way to make it so that the original format will remain the same in the Open Table?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Journal before posting:

After posting

I don't see the sorting you are talking about. GP 2013/SP2

Cheers!

Sanjay

Was this reply helpful? Yes No
Rszeto 765 on at

Like (0)

Report

Hi,

I'm using 2010. Hope this provides a better example.

Best,

Ronald

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Lets play GP Poker, here is my Account format set up - how about your setup ?

Tools - Setup - Company - Account Format - Sorting.

Your turn!

Cheers!

Sanjay

Was this reply helpful? Yes No
Rszeto 765 on at

Like (0)

Report

Hi,

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

So there is your answer. You have enabled sorting option and that is why your journal is getting sorting by account, department and product/project....

Case closed.

Cheers!

Sanjay

Was this reply helpful? Yes No