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.
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.
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.