Accounts Balances not correct after cancelling Journal Entry then Amend it

h_farid_gm · September 12, 2012, 12:56pm

After a user canceled a Journal Entry we found that balances are not corrected.

The user first made a journal entry then submit it then he canceled the document then Amend it then canceled the amended document and after all that we found that the Account Group balance is not correct under which this account is a child.

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/anQlAlOnAe4J.

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

nabinhait · September 13, 2012, 4:55am

Hi HF,

Please check after reposting account balance for the current financial year.

You can do it from Accounts –> Fiscal Year –> Repost Balance, select company before reposting.

On Wed, Sep 12, 2012 at 6:26 PM, HF <h…@gmail.com> wrote:

After a user canceled a Journal Entry we found that balances are not corrected.
The user first made a journal entry then submit it then he canceled the document then Amend it then canceled the amended document and after all that we found that the Account Group balance is not correct under which this account is a child.

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/anQlAlOnAe4J.

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

–
Regards,
Nabin Hait

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

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

h_farid_gm · September 13, 2012, 12:33pm

Hi Nabin;

I found the problem, it was because we have made changes to the chart of accounts and changed a ledger account to group then put some accounts under this group so the tree did not update correctly (tabAccount.lft , tabAccount.rgt) I found there are mistakes in those fields for the changed Account.

Please advice and tell me how to re-organize the tree ?

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/2VdWw6WYw5sJ.

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

rmehta · September 13, 2012, 5:54pm

Hi HF,

We will push an update to this with a button to rebuild indexes (lft, rgt) of the Chart of Accounts.

- Rushabh

W: https://erpnext.com
T: @rushabh_mehta

On 13-Sep-2012, at 6:03 PM, HF <h....@gmail.com> wrote:

Hi Nabin;

I found the problem, it was because we have made changes to the chart of accounts and changed a ledger account to group then put some accounts under this group so the tree did not update correctly (tabAccount.lft , tabAccount.rgt) I found there are mistakes in those fields for the changed Account.

Please advice and tell me how to re-organize the tree ?

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/2VdWw6WYw5sJ.

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

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

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

nabinhait · September 14, 2012, 5:12am

Hi HF,

Pull latest update from master branch and repost account balances from fiscal year.

Now it will rebuild account tree (lft, rgt) before reposting balances.

Regards,
Nabin Hait

On Thu, Sep 13, 2012 at 11:24 PM, Rushabh Mehta <rm…@gmail.com> wrote:

Hi HF,

We will push an update to this with a button to rebuild indexes (lft, rgt) of the Chart of Accounts.

- Rushabh

W: https://erpnext.com
T: @rushabh_mehta

On 13-Sep-2012, at 6:03 PM, HF <h....@gmail.com> wrote:

Hi Nabin;

I found the problem, it was because we have made changes to the chart of accounts and changed a ledger account to group then put some accounts under this group so the tree did not update correctly (tabAccount.lft , tabAccount.rgt) I found there are mistakes in those fields for the changed Account.

Please advice and tell me how to re-organize the tree ?

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/2VdWw6WYw5sJ.

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

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

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

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

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

h_farid_gm · September 16, 2012, 7:44am

Hi Rushabh;

Thank you.

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/yTrVwxlkJ2YJ.

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