4,226 Reply by joe

(43 replies, posted in Reporting)

Well, still, I can not understand all this objection. The only difference from before is:

The checkbox 'Balance Sheet' with an internal value of 0 and 1 was here before to mark if this account class was of type 'Balance Sheet'.
This checkbox has now been replaced by a built-in selector of 'Assets', 'Liabilities', 'Equities', 'Income', 'COGS' and 'Expense'.
If you want this class to be of 'Balance Sheet' you set the selector to either 'Assets', 'Liabilities' or 'Equity'.
By this new built-in selector we have the ability to make better analysis reports in the future. Remember that we don't know in the earlier 'Balance Sheet' checkbox if it is of type 'Assets', 'Liabilities' or 'Equity'. 'Equity' is by the way optional. You can make splendid reports without this. And you can put the equity as an account type inside the 'Liability' class. Look at the demo site: .

We are not changing this back, and believe me, this has nothing to do with a single member of the community. Some Audit companies from European countries have adviced us to go towards this direction.

So having enlightened the difference and you still feel that this doesn't fit into your organisation, well then feel free to fork FA into your own way. Just remember the license type, GPLv3, and let it be open to the public.

/Joe

Go to forum: Reporting

4,227 Reply by joe

(43 replies, posted in Reporting)

Hello again,
I am sorry that you dislike the new approach.
I must tell you, that I have been involved in Accounting Software Development during at least 25 years in Europe and around the world. Every Accountant knows that Assets, Liabilities and Equities belongs to a balance sheet. This is a one time setup, so why so much fuss for so little?
Believe me, the new class types is an improment for future development, as told before.

/Joe

Go to forum: Reporting

4,228 Reply by joe

(43 replies, posted in Reporting)

Hello Guys, you don't have to set these values to 1 - 6. If you don't touch them the reports will run in the old fashioned way.
If you have changed the values to the new 1-6 values, and you still want the reports to be like the old ones, you can set the variable

   

$use_oldstyle_convert = 0;

in config.php, line 78 to 1:

Then the reports are run as before!!

The new values 1-6 was changed because we now have better possibilities to make special reports with key values and analytics in the future.

And it is easy to determine if the created class belongs to a balance sheet.
If the built-in value is of type 'Assets', 'Liabilities' or 'Equities' this is of type balance sheet (right?)
All other values belongs to a PL sheet.

So please don't be freightened. Everything still works correctly.

/Joe

Go to forum: Reporting

4,229 Reply by joe

(13 replies, posted in Setup)

Yes when I test this on the demo server with a small test mail script.

/Joe

Go to forum: Setup

4,230 Reply by joe

(1 replies, posted in Wish List)

Yes, why not.
But we have to wait until 2.2 that is expected to ship in a month.

/Joe

Go to forum: Wish List

4,231 Reply by joe

(13 replies, posted in Setup)

I have no idea why this is not workning. Hopefully somebody in the community can help us.
You could make a test using the included class /reporting/includes/class.mail.inc and see if you can find something strange.

/Joe

Go to forum: Setup

4,232 Reply by joe

(24 replies, posted in Accounts Payable)

You shouldn't have any problems with that. Check that the Items have the correct Item Tax setup.

/Joe

Go to forum: Accounts Payable

4,233 Reply by joe

(1 replies, posted in Banking and General Ledger)

See my answer to a similar topic in Setup.

/Joe

Go to forum: Banking and General Ledger

4,234 Reply by joe

(1 replies, posted in Setup)

You are not doing anything wrong. The VAT is calculated inside FA. You will have some pennies calculated wrong in these cases, but it shouldn't bother you. It would be evened out over the transactions and most Tax payments/receivals are truncated to zero decimals.

/Joe

Go to forum: Setup

4,235 Reply by joe

(5 replies, posted in Items and Inventory)

You don't have to do anything specific to have the correct calculation. Just mark the Sales Type as Tax Included, then everything is done automatically. Try for yourself on the demo company.

/Joe

Go to forum: Items and Inventory

4,236 Reply by joe

(5 replies, posted in Items and Inventory)

Normally if tax is included, you would print the amount of tax that are included, for those that need this information. If you don't want to print this information on the invoice, then you will have to remove the line in the report /reporting/rep106.php.

/Joe

Go to forum: Items and Inventory

4,237 Reply by joe

(20 replies, posted in Accounts Receivable)

In the Company Setup, on Setup tab, you can mark the checkbox 'Search Customer List'. Then you can use the space bar to start the search (inside the combobox).

/Joe

Go to forum: Accounts Receivable

4,238 Reply by joe

(8 replies, posted in Accounts Payable)

You can reverse this transaction by voiding it. Select the transaction type and number. You get an option to look at the transaction before voiding it.

/Joe

Go to forum: Accounts Payable

4,239 Reply by joe

(13 replies, posted in Setup)

Hello again,
We are about to ship the release 2.1.4 (only bugfix release) in a couple of days. We have improved the email letter a bit and given the attachment a more normal description. Hopefully it helps.

/Joe

Go to forum: Setup

4,240 Reply by joe

(13 replies, posted in Setup)

Hello again,
I have done some research on this. If the recipient of the email has been delivered through a mail forwarder it seems to hang up in the first email spam filter and doesn't get forwarded at all. Will you check that too, jackel7007.
To avoid our emails with attachments to be catched by spam-filters we probably need to refrase the emails.
Anyone have any good ideas here?

Now it looks something like this:

Dear Sirs Ghostbusters Corp.,

Attached you will find  Order no. 56

Kindest regards

Demo User
Training Co.
Address 1
Address 2
Address 3
delta@delta.com
(222) 111.222.333

and the attachment may look like this:
4a6ef175e16b2.pdf (could this be a problem?)

/Joe

Go to forum: Setup

4,241 Reply by joe

(13 replies, posted in Setup)

Have you tested to see if the email has ended up in the receivers spam filter? Some spam filters are very 'cruel'.

/Joe

Go to forum: Setup

4,242 Reply by joe

(1 replies, posted in Modules Add-on's)

The development team doesn't have any plans for integrations, but there have been several plans to build semi integrations as modules. I think you can find them in this fofum.

/Joe

Go to forum: Modules Add-on's

4,243 Reply by joe

(2 replies, posted in Wish List)

Sure, we are doing our best.
In release 2.2 we have removed some redundant transaction types from the database table 0_sys_types. Instead we use translatable constants from the file /includes/types.inc.

/Joe

Go to forum: Wish List

4,244 Reply by joe

(2 replies, posted in Installation)

Have you tried to set the $go_debug flag in config.php to 1. This will capture the errors/warnings.

/Joe

Go to forum: Installation

4,245 Reply by joe

(2 replies, posted in Dimensions)

The reason for removing this from the dimension overview is that these transactions can get really huge. Therefore we are compacting them on a per account summary.
If you want to see a detailed inquiry, use the Gl Account Inquiry and filter by dimension.
If you want to see a detailed inquiry, you can also use the report GL Accounts Transactions. Select the first account and last account in the lists. Then filter by dimension. This way you will get a detailed report.

/Joe

Go to forum: Dimensions

4,246 Reply by joe

(1 replies, posted in Misc. Charts of Accounts)

Hello,
The last value in 0_chart_class is a reference to a system defined type value (from release 2.1.3). 1 = assets, 2 = liabilities, 3 = equity, 4 = income, 5 = cost of sales, 6 = expenses.
0_chart_master: 101 is a reference (foreign key) to 0_chart_types. 0 is a value for inactivity (normal 0).
0_chart_types: 4 is a reference to the class id. 1 is a reference to another chart_type (sub-type). You can have more levels, but this is not necessary. The default value is -1.

/Joe

Go to forum: Misc. Charts of Accounts

4,247 Reply by joe

(9 replies, posted in Banking and General Ledger)

The link is:



/Joe

Go to forum: Banking and General Ledger

4,248 Reply by joe

(9 replies, posted in Banking and General Ledger)

ok, thanks Tom,

/Joe

Go to forum: Banking and General Ledger

4,249 Reply by joe

(1 replies, posted in Reporting)

No, it is not planned. You can export a csv report from Excel/Open Office Calc.

/Joe

Go to forum: Reporting

4,250 Reply by joe

(9 replies, posted in Banking and General Ledger)

Look into the X_debtor_trans table to see if there are types 1 with a minus sign in front of the amount. If so, then remove the minus and download the new files from CVS.
Yes it might have got you trouble, because these payments (with minus sign) didn't show up in the allocation list.

/Joe

Go to forum: Banking and General Ledger