I had the unfortunate brainwave of entering Account Numbers as ... text because
the perp setup wizard didn't disallow that :J and the account chart has no
option to edit them.... and adding new, then changing from old to new set of
accounts (with proper numbers on them this time) and assigning to the whole
inventory anew, is something I'd rather avoid if can be done quickly and /relatively/
Is it OK to manipulate the table(s) where the Account Numbers are stored,
directly on db (eg. with MySQLAdmin) ? Will I have to subst the acc. no.
in the inventory table too (are the Account Numbers used as ID directly)?
I guess no other egw/perp activity is advisable then, but that's not a problem
(It's single user at the moment);
since I decided to go through every place the account /numbers/ are, and to correct them,
(and it seems to not be as bad a process as I thought, tabs in Firefox are a wonderful thing...)
does the Account Group ID also have to be numeric-only for things to work correctly?
(thing is, in Admin- General Ledger - Admin-account_group, i already have balance
(in on hand and adjust groups)...)
or is it OK to leave group ID alphanumeric instead of number-only?
On 29/10/2012 22:35, Nathan Gray wrote:
> On Mon, Oct 29, 2012 at 4:13 AM, Lukasz Sokol <[hidden email]> wrote:
>> I had the unfortunate brainwave of entering Account Numbers as ... text
> In general, accountants use integers. In some countries however, they
> use things that look like integers, but aren't: 00100
> You're right, it should probably have been checked...
>> Is it OK to manipulate the table(s) where the Account Numbers are stored,
>> directly on db (eg. with MySQLAdmin) ? Will I have to subst the acc. no.
>> in the inventory table too (are the Account Numbers used as ID directly)?
> Sure, just remember that the account numbers are the primary key for
> pretty much everything using accounting. You may have to go through
> some of the setup steps again - everything where you set an account.