When I go to posted transactions, and look up a sales invoice, there is a button to void the invoice. However, since we've changed our chart of accounts, the void will post to the old GL accounts. We have been reclassing the entry to the correct accounts. Is there a way to directly void the invoice in less steps?
*This post is locked for comments
The point of Leslie's post is that if you had used the PSTL solution then all the account idexes attached to OPEN / WORK and HISTORICAL transactions would have been modified to the NEW account numbers.
All the Account numbers exist only in the GL tables, after that the Account number that is stored with the transaction in (as example) sales is an Index. This index is a short numeric value that is easy to spot i the table, and much smaller for purpose of storage in the table.
Anyway the point is that we are trying to get at is that by simply creating new accounts and making them the NEW transaction default, it does nothing to address all the HISTORY transaction that still reference the OLD account index.
Long and short is that you will not be able to simplify the process and if you VOID and HISTORICAL INVOICE / CHECK or other document, it will VOID to the OLD account number and you will need to make a Journal Entry to move the value.
Sorry for the long winded answer, but I hope this helps somewhat with your situation.
By reclassing the accounts I am to understand that you are moving the balances from the OLD account to the NEW account.
To do this you have to do a Journal Entry to move the dollars.
That is what I was meaning.
I am not sure what you mean but we did JE transactions from 1 account to another.
How did you change your Chart - did you simply open the segments at the end of the account and then start building new accounts?
Did you use the MOVE / COPY from within the system or did you just do JE transactions from one account to another?
Just want to help get more information on the table - it will help to answer your issue.
Thank you for the response. We didn't use the tool you mentioned. First, because we did not know of it. Also, we went from 3 categories to 7.
Thank you for the response. We didn't use the tool you mentioned. First, because we did not know of it. Also, we went from 3 categories to 7.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
