Trtansaction Date instead of posting date for GL Query report

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+un…@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, 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 <jw...@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+un…@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-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/3B85080E-3E22-41F1-A43A-A50C5D73676D%40gmail.com.

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

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 <jw...@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+un…@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-forum+un…@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.

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.

On Mon, Sep 8, 2014 at 12:34 PM, John Wellar <jw...@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?

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 <jw...@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+un…@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-forum+un…@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


On 08-Sep-2014, at 12:34 pm, John Wellar <jw...@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 <jw...@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+un…@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-forum+un…@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.




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+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/1BAE9E76-0864-48D0-AD46-4B601249C17E%40gmail.com.

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