1 (edited by A.A 03/11/2018 03:42:26 pm)

Topic: Voucher numbering

How can I Sort transaction numbers by date in web version?

I need to classified the Documents for auditing so my vouchers need to have numbering sort.

Re: Voucher numbering

no Idea about it?

Re: Voucher numbering

I'm waiting for your guidance.

Re: Voucher numbering

State the navigation to which page you refer to.

Re: Voucher numbering

I checked my voucher in "Reports and Analysis/General Ledger/List of journal entries"

I'm going to open my voucher from "Banking and General Ledger/Journal Inquiry" and print one by one.

If the FA gives me in better way, I mean each Voucher in one sheet A4 with arranged number by date please let me know.


Re: Voucher numbering

The Rep702 - List of Journal Entries is in report format and is already arranged by Date, but several vouchers are in each page to conserve space.

The "Banking and General Ledger/Journal Inquiry" is a screen display and you can print them one by one.

If you want to print the latter as one per page then just copy the URLs to a file and run a batch file on them and then print them all in one go.

Post's attachments

rep702_ListOfJournalEntries.pdf 6.7 kb, 14 downloads since 2018-03-12 

You don't have the permssions to download the attachments of this post.

Re: Voucher numbering

Thanks dear apmuthu

what about sort of numbers by date?
is it possible to do?

Re: Voucher numbering

Unless filtered by a specific voucher type, the number wise sorting will be erroneous as the same number can appear across different dates if they belong to different voucher types.

As the vouchers are sorted by date, all transaction numbers across all voucher types will get listed in the order they were entered by default.

In the case of rep702.php here, the list of transactions are obtained from the function get_gl_transactions() defined in gl/includes/db/gl_db_trans.inc where the sort order in line 176 is: ORDER BY tran_date, counter, the latter being the real sequence element within the transaction date.

Re: Voucher numbering

is it possible to change the voucher No in management Panel  "Plesk/Databases/PHP My admin" ????

Re: Voucher numbering

doesn't it make problems???

Re: Voucher numbering

Dear apmuthu

let me have your answer.

Re: Voucher numbering

Voucher numbering is a delicate issue needing utmost care as to whether they are primary keys or have other fields as primary keys and what linkages exist with similar numbered ones during the change process.