|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Fumbles
   |
Posted - 2008.11.30 12:27:00 -
[1]
Edited by: Fumbles on 30/11/2008 12:28:23
Firstly, congratulations on the launch of EMMA 1.x. and for including some requested features which will make reports even better.
Secondly I'm unable to create a new group. I click New Group, type in a word then click ok and the error comes up.
"Cannot insert the value NULL into column id....column does not allow NULLS. insert fails" (I can post the whole error message if you need it). Any ideas? Windows XP btw.
|
Fumbles
|
Posted - 2008.12.01 09:41:00 -
[2]
I'm having a bit of trouble with the item report.
It seems to not be picking up some values from the transactions history...
The 'average sell price' and 'units sold' columns appear to be working as normal, however 'average buy price' and 'units bought' columns have missing values in the majority of rows.
i.e. the report seems to be seeing the sales but not the purchases.
Also for those items that it does pick up values for each of the above columns, there are no values for cost of units sold, net margin % etc. But it does pick up transaction taxes. The gross profit column is giving a result equal to (transaction taxes).
If you could please have a look into this as Item Report is my personal fav :-)
|
Fumbles
|
Posted - 2008.12.01 20:47:00 -
[3]
 Originally by: Ambo
Originally by: Erah
Originally by: Ambo
Edited by: Ambo on 01/12/2008 12:10:33
If you take a look in the transactions view then are all the entries in there sales? (easy to tell because they will have green amounts, buy transactions have red).
that's exactly what i did, sorry i wasn't clear
all green!
Bizzaro.. the import works fine for me and I'm sure others would have noticed if it was a general problem. I'll have a think...
It is the same for me, all transactions that were imported are sell orders.
|
Fumbles
|
Posted - 2008.12.07 09:02:00 -
[4]
I'm wondering if the formula in the Cost of Goods Sold column in the Item Report is functioning correctly.
The reason is that in the report I have several items which have a higher average buy price than the cost of goods sold value. E.g. average buy 145k, cost of goods sold is 93K. In one case the cost of goods sold is shown as 700K or so when the actual item always costs me at least several million.
|
|
|
| |
|