Trtansaction Date instead of posting date for GL Query report

[John Wellar]

Can a user change the GL Query  Report from Transaction Date instead of Posting Date

Thanks

John

[Rushabh Mehta]

John, any reason for this? This is the very reason there are 2 dates! Transaction date is not for accounting use, it is for other (auditing etc) use.

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/39c5cb96-9190-4d04-a198-ced224106b58%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[John Wellar]

Yes, the posting date is the data entry date but we Use the reference date as the transaction date.

For example We might post on Sept 7th a Bank Charge that was charged on 31/08/2014.   If we go by the posting date then it is September Accounts  when really it is in the August.  So when we do Query on GL Report would like to see all transaction for August by showing Reference Dates not Posting Date.  Is this possible without doing custom Query Report?

On Monday, 8 September 2014 14:55:03 UTC+10, Rushabh Mehta wrote.  

John, any reason for this? This is the very reason there are 2 dates! Transaction date is not for accounting use, it is for other (auditing etc) use.

On 08-Sep-2014, at 7:37 am, John Wellar <jwel...@gmail.com> wrote:

Can a user change the GL Query  Report from Transaction Date instead of Posting Date

Thanks

John

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+unsub...@googlegroups.com.

[Umair Sayyed]

Hello John,

As per the given scenario, Posting Date of voucher should be 31/08/2014, and Transaction Date should be 7/09/2014. So Posting Date will be when this entry was actually executed, hence we have Posting Date column in the GL report.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/e567400d-ea85-4b7a-b003-ca9c236bcb26%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Thanks and Regards,
Umair Sayyed
www.erpnext.com

[Rushabh Mehta]

On 08-Sep-2014, at 12:34 pm, John Wellar <jwel...@gmail.com> wrote:

Yes, the posting date is the data entry date but we Use the reference date as the transaction date.

For example We might post on Sept 7th a Bank Charge that was charged on 31/08/2014.   If we go by the posting date then it is September Accounts  when really it is in the August.  So when we do Query on GL Report would like to see all transaction for August by showing Reference Dates not Posting Date.  Is this possible without doing custom Query Report?

Please use Posting Date as the reference dates. the transaction date is the date of data entry.

On Monday, 8 September 2014 14:55:03 UTC+10, Rushabh Mehta wrote.  

John, any reason for this? This is the very reason there are 2 dates! Transaction date is not for accounting use, it is for other (auditing etc) use.

On 08-Sep-2014, at 7:37 am, John Wellar <jwel...@gmail.com> wrote:

Can a user change the GL Query  Report from Transaction Date instead of Posting Date

Thanks

John

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/39c5cb96-9190-4d04-a198-ced224106b58%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/e567400d-ea85-4b7a-b003-ca9c236bcb26%40googlegroups.com.