Skip to Content
author's profile photo Former Member
Former Member

Deposit

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

1.jpg (70.9 kB)
2.jpg (55.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 15, 2013 at 03:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2013 at 04:51 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.