Deposit

[Former Member]

Good Day,

I would like to ask how the system sort the data in deposit window before it add all "For deposit" checks. I noticed that after the checks deposited, it was sorted in ascending order base on internal ID but before it was added the data arranged randomly. It is not base on the sequence of incoming payments or even the date or any other field. Anyone who has an idea how this being sorted? see screenshot below.

Before deposit the check.

After

Thank you.

RD

[Former Member]

Hi Ardie,

Before you add a deposit, its sorted by Date.

You may add some dummy postings in a test db with different dates to check.

Thanks,

Joseph

[Former Member]

Yes, it is sorted by date. But what is the second filter after the date? It looks like it is randomly selected after it was sorted by date. Look at my pint screen above. You'll see there that before the posting has been deposited, internal ID is not properly arrange.

Thank you.

Regards,

RD

[Former Member]

Funny, before adding, its sorted by date  but the moment you add the document, its sorted by the internal id and not the date anymore.

Thanks,

Joseph

[Former Member]

I don't think it is funny. I hope you notice the difference between the two screenshot above. Anyway, thanks for your reply.

Regards,

RD

[Former Member]

You may report it to SAP if you like. I just checked what you reported and shared the result with you.

[KennedyT21]

Hi Aride Trinidad...

I think at the time of posting they might order and save the document or At the time of the view mode also have a chance to order the data and list in the grid. . so it is possible both ways ...

If you want to know how the posting is happen use the SQL Server Profiler and check the posting query you will get the clear idea how they process the data in the add mode and the view mode.

Try with the SQL Server Profiler

Hope helpful

Regards

Kennedy

[Former Member]

Hi Sir,

SQL Server provider sounds helpful but the problem is I don't know how to use it. It shows lot of records when tracing. Can you guide me or give me a simple instruction on how to use it?

Thank you so much.

Regards,

RD