Nope, no quick solution for this one.
We are currently exploring other options för another company-wide app.
/rini
2 04/10/2008 11:01:18 am
Re: Bug in Inventory Item Cost Update (8 replies, posted in Report Bugs here)
I seem to have found something.
The first item, the PP3, seems to have status D (service) in the db, but i'm almost sure i set it up as a purcharge.
I'll make a item-table-dump and try to add a "first" item again to see if there is in fact a bug or user error 
EDIT:
Seems to be user error this time.
Sorry for the fuzz.
/EDIT
/Rikard
3 04/10/2008 10:38:24 am
Re: Bug in Inventory Item Cost Update (8 replies, posted in Report Bugs here)
I think so.
I sent you pm with url and login to my setup.
There is no live data in the current setup so you can't break anything
/Rikard
4 04/10/2008 05:58:44 am
Re: Bug in Inventory Item Cost Update (8 replies, posted in Report Bugs here)
Hi and thanks,
SQL echoed is
SELECT stock_id, 0_stock_master.description, 0_stock_category.description FROM 0_stock_master,0_stock_category WHERE 0_stock_master.category_id=0_stock_category.category_id AND mb_flag !='D'And the resultset from phpmyadmin is:
stock_id description description
IX67PH2 Intertex 67 PH2 HÃ¥rdvara
IX67PH2AIR Intertex 67 PH2 Air HÃ¥rdvara
DPD16_10 Företagspaket 16 10kg Frakt
DPD16_3 Företagspaket 16 3kg Frakt
DPD16_35 Företagspaket 16 35kg Frakt
DPD16_5 Företagspaket 16 5kg Frakt
DPD16_7 Företagspaket 16 7kg Frakt
PP10 Postpaket 10kg Frakt
PP20 Postpaket 20kg Frakt
PP5 Postpaket 5kg Frakt
PP7 Postpaket 7kg FraktWhat i did to the inventory is a deleted everything from the webgui, and then inputed my own stuff.
Is there anything else i can post or extract to make debugging easier?
I'm running latest cvs version.
/Rikard
5 04/09/2008 02:11:04 pm
Re: Bug in Inventory Item Cost Update (8 replies, posted in Report Bugs here)
Hi
I wasn't aware about the update-thingie but it's clear now.
For the droplist however, view the sql-dump below:
+------------+-------------+------------------------+-------+
| stock_id | category_id | description | units |
+------------+-------------+------------------------+-------+
| DPD16_10 | 5 | Företagspaket 16 10kg | st |
| DPD16_3 | 5 | Företagspaket 16 3kg | st |
| DPD16_35 | 5 | Företagspaket 16 35kg | st |
| DPD16_5 | 5 | Företagspaket 16 5kg | st |
| DPD16_7 | 5 | Företagspaket 16 7kg | st |
| IX67PH2 | 6 | Intertex 67 PH2 | st |
| IX67PH2AIR | 6 | Intertex 67 PH2 Air | st |
| PP10 | 5 | Postpaket 10kg | st |
| PP20 | 5 | Postpaket 20kg | st |
| PP3 | 5 | Postpaket 3kg | st |
| PP5 | 5 | Postpaket 5kg | st |
| PP7 | 5 | Postpaket 7kg | st |
+------------+-------------+------------------------+-------+with the source from the droplist:
<option value='IX67PH2'>Hårdvara - Intertex 67 PH2</option>
<option value='IX67PH2AIR'>Hårdvara - Intertex 67 PH2 Air</option>
<option value='DPD16_10'>Frakt - Företagspaket 16 10kg</option>
<option value='DPD16_3'>Frakt - Företagspaket 16 3kg</option>
<option value='DPD16_35'>Frakt - Företagspaket 16 35kg</option>
<option value='DPD16_5'>Frakt - Företagspaket 16 5kg</option>
<option value='DPD16_7'>Frakt - Företagspaket 16 7kg</option>
<option value='PP10'>Frakt - Postpaket 10kg</option>
<option value='PP20'>Frakt - Postpaket 20kg</option>
<option value='PP5'>Frakt - Postpaket 5kg</option>
<option selected value='PP7'>Frakt - Postpaket 7kg</option>As you can see i don't get the PP3 in the drop-list, while it's in the DB.
It seems it skips one row when creating the drop-list.
PP3 was the first new item to be added.
EDIT: Perhaps freight is a service ans not something purcharged. I got it as purcharged in this setup tho.
/EDIT
6 04/09/2008 12:33:35 pm
Topic: Bug in Inventory Item Cost Update (8 replies, posted in Report Bugs here)
When setting a new cost, all items updates to the new cost.
Also, not all items show in the drop-list.
Seems to list with 1 in offset.
Using latest cvs update from this afternoon.
/Rikard
7 04/07/2008 06:04:59 am
Re: Error adding Taxes > Tax Type (2 replies, posted in Report Bugs here)
I'll keep debug in mind.
/Rikard
8 04/06/2008 04:36:50 pm
Topic: Error adding Taxes > Tax Type (2 replies, posted in Report Bugs here)
I enter description, tax % (25 for swedish) and tried different accounts for out and in then press save.
I get returned to the Tax Types-page which contains no info.
I use the lastest cvs 2 version, updated from cvs 10mins ago.
Regards
Rikard
9 03/29/2008 11:15:39 am
Re: Sales Order Entry - Ajax/JS +/- button on quantity (2 replies, posted in Wish List)
Perhaps an option to show the extra controls would be a good idea? You could configure in which sections you would like to use which controls, like in my case, the ability to quickly add another item of the same type.
Regards
Rikard
10 03/22/2008 12:06:31 am
Topic: Quick-order/Cash-order (4 replies, posted in Wish List)
Would be good if you have the occasional cash-order or walk-ins that pick up inventory.
Could contain an id/reference-field, customer name, address, phone to create a cash-order-reciept.
This would also enable POS-terminal tie-ins if the cash-order-page is extremely simple as most pos have small touchscreens. This would make for the combined use in store, and at warehouse for shipping.
Regards
Rikard
11 03/22/2008 12:00:46 am
Topic: Sales Order Entry - Ajax/JS +/- button on quantity (2 replies, posted in Wish List)
Would be good to have a js/ajax-button for adding or removeing by quantity on an iten placed on the order.
Good for adjusting picking orders quickly over-counter-sales if they want more of that item.
EDIT:
Or if you add the same item once more, it updates the quantity by one instead of giving an error stating the same item is already added.
/EDIT
Regards
Rikard
12 03/21/2008 11:25:50 pm
Topic: RMA/Return/Damaged items (1 replies, posted in Wish List)
Section for used, returnd or RMA-goods.
This could either be item-unique (mac/seriel/id or whatever) or as a whole, like "Radio, broken antenna" put into the service or warranty-department with status broken, in-repair or discarded or similar. The cost to put a separate expenseaccount.
And then perhaps an internal list of fixed/used item with a reduced price.
This list might not have to require login if only for diplaying or linking into another system (like sales-terminal for clerks in the store).
And the return of an assemblyd item (like a switch with two fibre-modules for example) you could ask you if you want to place the item as a whole, or dis-asembly the item into chassi + 2 fibre modules to the stock/assemblyinventory.
Marked as used ofcourse.
So basicly each item could have a duplicate "used" item to handle returnes or swapped items.
Regards
Rikard
13 03/21/2008 11:20:03 pm
Topic: Forecasting/Re-order/item deliverytimes (0 replies, posted in Wish List)
Hi
I've been testing FA for a few hours now and it basiclly does what i need so i dont need to contiue develop my own project further. hoorayy!!
1; Now, i our firm we sell items that have long deliverytimes, from 6 weeks to 3 month.
And cuz of this, we're in constant need of forecasting on a per daily, weekly and monthly routine.
Today we take the dalie sales and use the past 30/90 days to generate forecasting as per this:
(Current stock / (previous 30 days sales))
+
(Current stock / (prev 90 days)/3)
/2 = approx monthly sales
Manuel work today, but was going to be automated in my project.
Example: Stock = 1000 units, forecasting approx 300 units sold/month, when it drops to 900 (or equivalent weeks in forecasting vs deliverytime - 3month in this case) it would generate alertmail.
Example2: In the next few months sales increases, and when the stock is 1800 and projected sales are 500 per month, it would generate alert at 1500 (deliverytime 3 month).
---
2; Adding deliverytimes to items or items to be assemblyd so you can tie that in to expected re-ordering alerts.
--
Hope anyone understand my bad writings.
Regards,
Rikard