Hello Tom,
In the Bank Deposit form it is possible to enter a Deposit from a Supplier and the same thing in the Bank Payment enter a payment to a customer.
It may seems odd, but it is possible to do it. This is the reason for the column.
However it seems right to show the supplier reference number on the Payment to Suppliers instead of our transaction no.

/Joe

3,877

(40 replies, posted in Report Bugs here)

CVS Main updated with /includes/banking.inc

/Joe

3,878

(40 replies, posted in Report Bugs here)

Yes, tom. We will have to test for null values in currency_code. I will fix this in /includes/banking.inc

/Joe

The bug arose when purchasing service items from a supplier. And something was changed a while ago.

This bug has been fixed and CVS Main trunk is updated. You can also download the affected file, /sales/includes/db/sales_deliveries_db.inc, here:



/Joe

If you create a service item, it should never show up in the GL inventory account. It is the Item Type (Service) that controls how the item is handled. The Category type is only a way of categorize the items.
Even if there are accounts for inventory in the database, it has no effect of how the item is handled. It is the item type that controls how to handle it.

/Joe

3,881

(13 replies, posted in Reporting)

Hi,
Maybe your folder /company/X/pdf_files,  where X is your company number, is write protected?

/Joe

Hello, I have put your topic into the developers mailing list, Khaled.
We are having a good discussion here in the developers mailing list, and it seems to go your way, thanks to among others, Tom Hallman, US.

/Joe

3,883

(3 replies, posted in Installation)

Default the en_US-new.sql COA follows, which is a small US COA.
On the Download section of this website you can find UK COA.
After you have installed the Training Company (en_US), you can create your own UK comapny.

/Joe

I see. Please Khaled, enter this topic in the developers mailing list. So we can have the material inside one thread here.

/Joe

3,885

(40 replies, posted in Report Bugs here)

Hello everybody that have had this db error message.
I have found the reason for this message  "Cannot retrieve exchange rate for currency as of 31/01/2010".
It occurred when doing cash sales (that includes a payment).
There is a missing Cash Bank Account for the Default Sales Pos.
Please create one or check that you have the correct Cash Bank Account for your Sales Pos. Then it works.

This is a very rare error message. It may happen in the foreign COAs if no bank accounts are defined but a sales pos is defined with a non existing cash account. These COAs should have had an initial 'no cash' defined.
I will see if we can get a better error message.

/Joe

3,886

(13 replies, posted in Reporting)

Have you tried to look into the error_log?
Even if the debug reports jibberish, it might tell us something, or?

/Joe

3,887

(2 replies, posted in Accounts Receivable)

I am not sure I follow you. Sales Invoices and Credit Notes have different series.

/Joe

We are having a discussiong regarding this in the developers mailing list. Please participate here. However, I see no reason to increase the account code field from 11 to 15 characters.
If the discussion find this ok, it will be implemented in 2.3

/Joe

Hi,

a) How many months there are in a Tax Report Period.
b) Number of months back for the last period.
Example.
----------
You should report the Tax for a month. Today is Feb 15. If the last period is 1 months back and the periods are 1, the report will be Jan 01 to Jan 31. If the last period is 2, then the period would be Dec 01 to Dec 31.
Esample 2.
------------
If the report period is 2 months and the months back is 1 month, then the period would be Dec 01 to Jan 31.

/Joe

Yes, there was a bug in /includes/ui/ui_view.inc. You can get the fixed file here:



/Joe

Hello again Kerrsmith,

It seems that you have detected a bug. It should have worked the way you did. I will have a look into this and will be back soon.

/Joe

I tried the link today, and it worked.

/Joe

Hello again,
If you have tax included and the shipping cost is £10 whereof £0.91 is tax included that is correct.
Example: £10 - £0.91 = £9.09
£9.09 * 10% = 0.909 rounded to £0.91. So you see it is not the same as 10% of £10 but 10% of £9.09, right?

/Joe
BTW, you should calculate the tax included first and then the remainder in your quick entry lines.
Look in the Tips and Tricks under Quick Entries in the FA Wiki

Hello,
If you create a Quick Entry for the shipping with the correct tax type for the supplier it will be updated on the tax row below on the form.

In the GL the tax is shown as 2 entries. One for the items and one for the GL entries.

/Joe

We are working on that. There are, however, complications involved. In the mean-time you can void the transaction (in Setup tab) and do a new one.

/Joe

The main record is still $25000 where the allocated part is $15000. Left to allocate is $10000. This is the way it works.

/Joe

3,897

(4 replies, posted in Manufactoring)

Hello again, obahey,
I have now had a closer look into this complexity. I understand why we never implemented it by using the GL work in progress.
There are so many operations in the advanced assembly. Releasing, extra issues, overhead and labour cost adds, changing the workorder during the operations. To all the time keep track of the correct GL updates would be a huge task.
It is, however, updated correctly when producing. Maybe we in the future can dive into this and get it work as you mention, but not now. It will with guarantee give side-effects doing it now.

/Joe

You get this warning is you have not set the profit and loss year account or the retained earnings account. Check this in System and GL setup.
Try to retrieve the exchange rate manually in Exchange Rate.

/Joe

3,899

(4 replies, posted in Manufactoring)

Yes, of course you are right. It was only very complex when disassembling and extra issues and overhead costs and labour costs.
But I will have another look into it and see if we can correct it.

/Joe

3,900

(4 replies, posted in Manufactoring)

There are no GL transactions before the productions (unless there are overhead or labout costs). The stocks are automatically issued (according to the BOM) when creating the work order. We have had discussions forth and back regarding this, and came up with the approach we have now.
The items are reserved in the same way as if you create a sales order.

/Joe