1 Topic by rtX

(1 replies, posted in Accounts Payable)

We do not use Items/Inventory, nor Purchase Orders and GRNs.  Sometimes this is because to do so would be an administrative burden, often because our suppliers are not providing us with something we are likely to re-order.

We just want to be able to enter supplier invoices and allocate them to the GL directly.  We do need to track VAT correctly on these purchases, though.  I need to be able to override the tax values assigned by the system to what I am entering.  This seems to always has a zero value.  Even if the system calculated the VAT, it would not always do it correctly nor as I want it to.  There are for example often rounding differences.

I do need to be able to get at net amounts and VAT amounts for the returns I submit, so as I understand it, entering the VAT amount into the GL directly as an extra line may not work for me.

Is the above possible, please?

Many thanks.

Go to forum: Accounts Payable

2 Reply by rtX

(5 replies, posted in Accounts Payable)

Would it be possible please to have a switch to turn on or turn off this functionality rather than assuming that everyone cannot understand entry into GL?

Many thanks.

Go to forum: Accounts Payable

3 Topic by rtX

(1 replies, posted in Accounts Payable)

I have set up a number of test companies using separate databases.  I want to enter a supplier's invoice.  I do not know if relevant, but this is a non-stock transaction.

The company I have set up as a default seems ok.  If I go into a company from which I can not create other companies (the company that is not the main one), I can not enter a direct invoice. When I click on Direct Invoice I get the message:
There are no suppliers defined in the system.

If I go to set up a supplier, I get the message:
There are no tax groups defined in the system. At least one tax group is required before proceeding.

If I go to set up a tax group on the setup tab the option is greyed (as is Create/Update Companies etc.)

The upshot is that I cannot enter an invoice.

I should add that I am logged in as FA2.1 System Administrator and this happens on all the non-main companies I have.

Sorry if I am being stupid...

Go to forum: Accounts Payable

4 Reply by rtX

(3 replies, posted in Report Bugs here)

I do not seem to have any item categories to delete!  When I click on the Items and Inventory tab, and the Item Categories, the list is empty.
Many thanks.

Go to forum: Report Bugs here

5 Reply by rtX

(4 replies, posted in Banking and General Ledger)

I looked at the MySQl database and found table 3_chart_master which looks like the table of the GL codes.

The table fields seem to be:
15 character account_code
15 character account_code2
60 character account_name
10 character account_type
1 character inactive

Could I get a comma separated file from Excel into the five columns.  If so, what would I use for account_type and inactive fields?

If I then put the csv file (called 'mychart.csv') into, say the root directory of c:\ could I use the following syntax from within phpmyadmin to import the data:

load data local infile 'c:\\mychart.csv' into table 3_chart_master
fields terminated by ','
enclosed by '"'
lines terminated by '\r\n'
(account_code, account_code2, account_name, account_type, inactive)

Would this work without damaging FA?

Many thanks.

Go to forum: Banking and General Ledger

6 Topic by rtX

(3 replies, posted in Report Bugs here)

I've only just started using FA, so I'm not sure if I am doing something wrong or if this is a bug.

I get the message:
"Cannot delete this account because it is used by one or more Item Categories"
when I try to delete an account that had previously been allocated as a stock account.

From within "Sales and General GL Setup" it was previously allocated to the following:
Inventory Account
Inventory Adjustments Account
Item Assembly Costs Account

However I have since pointed these to another account.  I have no Item Categories set up as I do not use them.

Does this look like a bug to anyone else?

Many thanks.

Go to forum: Report Bugs here

7 Reply by rtX

(4 replies, posted in Banking and General Ledger)

Thanks for your offer, Joe.  I do not think the COAs I use would be of particular interest to anyone else.  The way I work is we set up a new company for each of our projects.  The budgets for the projects are done by different people who use their own budget coding system, and I would like to be able to convert their coding system to form detailed cost codings in the GL.  I can usually get to a tab delimited file from what they give me.

I cannot see any way of importing such items from within FA.  Am I missing something?

Perhaps there is a way of importing it into the MySQL database outside FA?  Is that relatively straightforward for a competent person (but inexperienced with the MySQL system) or would I end up screwing up the system?

Many thanks.

Go to forum: Banking and General Ledger

8 Topic by rtX

(4 replies, posted in Banking and General Ledger)

How would I go about setting up a completely new chart of accounts from scratch for a new company?  Presently, I am using 2.3RC3.  Ideally, I'd really like to import using a comma/tab separated export from an existing accounts package - is that possible, please?

Go to forum: Banking and General Ledger