Phil Daintree | 1 Sep 01:44 2011
Picon

Re: Units of measure

The item is defined in the units in which you sell it predominantely. The when you define suppliers who can
supply you enter the unit they supply in and the conversion factor to the item units. So a 200 foot coild
would have a conversion factor of 200 when the unit for the item is a foot. The supplier price is for the
suppliers unit of a coil.
When you receive the hose you have to receive it in our units i.e. how many feet.
HTH 
-- 
Phil
Phil Daintree
+64 (0)275 567890 GMT+12
http://www.logicworks.co.nz

DebiCates <debimailbox-weberp@...> wrote:

>I'm installing a new webERP system, my first. The client sells all
>kinds of
>hoses. I'm stumped by a units of measure issue.
>
>1. Hose will be sold in feet, cut to order. (Possibly sold in fractions
>of
>feet as well.)
>2. But hose is bought in reels only. Some reels hold 350 feet, while
>another
>type of hose will come 200 feet on a reel. 
>3. Buying one reel will need to update the inventory qty on  hand by
>the
>appropriate number of feet.
>
>Hoping someone here has some ideas on how I could best handle this
>situation.
(Continue reading)

DebiCates | 1 Sep 02:10 2011
Picon

Re: Units of measure

Aha! Thanks, Phil. I'll look into that.

--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Units-of-measure-tp3782414p3782512.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better 
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
DebiCates | 1 Sep 02:25 2011
Picon

Stock category - good design

Here to pick brains...

Beyond the GL accounts for the GL interface, what are some considerations
for good design of stock categories?

Correct me if I'm wrong, stock categories are used in part inquiries. So a
well-designed stock category system could help with quicker stock finds,
especially in a large inventory. 

But what other ways are stock categories used in webERP? I need to import a
large inventory and it would be nice if I didn't learn what would have been
the best way to categorize after we were live, the hard way. :\

(FYI, we basically have three main categories: hose, couplings, and
accessories. But within those categories there are other subcategories, like
air hose, petroleum hose, hydraulic hoses, etc. Within hydraulic hoses, for
example, we also have braided, non-conductive, etc. Just giving you an idea
of the levels of possible categories.)

--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Stock-category-good-design-tp3782523p3782523.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better 
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
(Continue reading)

Terry Porter | 1 Sep 02:47 2011
Picon

Re: Stock category - good design

On Thu, Sep 1, 2011 at 10:25 AM, DebiCates
<debimailbox-weberp@...> wrote:
> Here to pick brains...

There will be slim pickings with me then ;-)

>
> Beyond the GL accounts for the GL interface, what are some considerations
> for good design of stock categories?
>
> Correct me if I'm wrong, stock categories are used in part inquiries. So a
> well-designed stock category system could help with quicker stock finds,
> especially in a large inventory.

I agree and think time designing here would be time well spent.

>
> But what other ways are stock categories used in webERP? I need to import a
> large inventory and it would be nice if I didn't learn what would have been
> the best way to categorize after we were live, the hard way. :\

I'm going thru the same thinking at the moment as I design my WebERP
parts categories.

>
> (FYI, we basically have three main categories: hose, couplings, and
> accessories. But within those categories there are other subcategories, like
> air hose, petroleum hose, hydraulic hoses, etc. Within hydraulic hoses, for
> example, we also have braided, non-conductive, etc. Just giving you an idea
> of the levels of possible categories.)
(Continue reading)

DebiCates | 1 Sep 03:04 2011
Picon

Re: Stock category - good design

Thank you for your thoughts, Terry. 

"I'm pre pending part
numbers with a three character code, so I can run a SQl query and find
out the value of stock by supplier. "

I hadn't got that far in my thinking yet, but it's possible that would be of
interest to my client. I'll have to ask. It's also possible, though, the
supplier is not of interest to them as they may buy a part from a variety of
suppliers. Again, an interesting question to ask.

So far I've not tackled installing the wiki. I hope you get your issue
worked out satisfactorily.

--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Stock-category-good-design-tp3782523p3782561.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better 
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
Phil Daintree | 1 Sep 03:18 2011
Picon

Re: Stock category - good design

Stock categories are also used in sales analysis so how deep the business wishes to delve into sales by
category is important too.
Otherwise it sounds as though you are well prepared to help your client.
-- 
Phil
Phil Daintree
+64 (0)275 567890 GMT+12
http://www.logicworks.co.nz

DebiCates <debimailbox-weberp@...> wrote:

>Here to pick brains...
>
>Beyond the GL accounts for the GL interface, what are some
>considerations
>for good design of stock categories?
>
>Correct me if I'm wrong, stock categories are used in part inquiries.
>So a
>well-designed stock category system could help with quicker stock
>finds,
>especially in a large inventory. 
>
>But what other ways are stock categories used in webERP? I need to
>import a
>large inventory and it would be nice if I didn't learn what would have
>been
>the best way to categorize after we were live, the hard way. :\
>
>(FYI, we basically have three main categories: hose, couplings, and
(Continue reading)

Phil Daintree | 1 Sep 07:21 2011
Picon

Re: small issue with update part

Hi Brian,

In the latest this issue is fixed.

Thanks anyway

Phil

Quoting Brian May <brianm@...>:

> This is for version 4.04.4
>
> When I Modify Item details, Click on Update - It updates everything, however
> the button for update disappears.  So, If I want to change something else -
> I have to go back out and back in again.
>
> --
> Brian May
>

------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better 
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
Terry Porter | 1 Sep 12:13 2011
Picon

List of the legal characters to use in part (item) names ?

Hi all,
Does anyone have a list of the legal characters to use in part (item) names ?

I ask because in my testing to find out which characters to use as
delimiters ("-" or "_" etc) with WackoWicki, I found out that WebERP
doesn't like "#" used in item names as it renders all characters
following the '#" invisible.

This meant that I couldn't delete my test item "FNA#RD-5G30", which
only showed as part "FNA" and oddly had no delete button in the edit
menu.

Fortunately Z_ChangeStockCode.php allowed me to change it to
"FNA-RD-5G30", which has increased my confidence in getting myself out
of trouble with WebERP.

Existing Inventory Code: FNA#RD-5G30
New Inventory Code:FNA-RD-5G30

Adding the new stock master record ... completed
Changing stock location records ... completed
Changing stock movement records ... completed
...
Deleting the old stock master record ... completed
Stock Code: FNA#RD-5G30 was successfully changed to : FNA-RD-5G30

WebERP V4.05
Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny9 with Suhosin-Patch Server

--
(Continue reading)

Warren Olds | 1 Sep 12:24 2011

GetStockImage.php


Apologies I am not familiar with the open-source development process but I would like to offer a piece of
revised code for GetStockImage.php. It appears to work however I am no php expert. It enables stock images
to be resized proportionally.

To replace lines 270-282:

	$sw = imagesx($im);
	$sh = imagesy($im);
	if ( isset($width) && ($width != $sw) || isset($height) && ($height != $sh)) {
		if( !isset($width) )
			$width = imagesx($im);
		if( !isset($height) )
			$height = imagesy($im);
			$resize_scale = min($width/$sw, $height/$sh);
		if ($resize_scale < 1) {
		$resize_new_width = floor($resize_scale*$sw);
		$resize_new_height = floor($resize_scale*$sh);
		} else {
		$resize_new_width = $sw;
		$resize_new_height = $sh;
		}
		
		$tmpim = imagecreatetruecolor($resize_new_width, $resize_new_height);
		imagealphablending ( $tmpim, true);
		imagecopyresampled($tmpim,$im,0,0,0,0,$resize_new_width, $resize_new_height, $sw, $sh );
		imagedestroy($im);
		$im = $tmpim;
		unset($tmpim);

(Continue reading)

Tim Schofield | 1 Sep 14:43 2011

Re: List of the legal characters to use in part (item) names ?

Hi Terry,

The ones checked for are ' + ? . \ & \\ " > < and I believe a space character.

However there are a large number of characters that won't work in a
stock code with the way the code is currently written. These include
(but may not be all) :

# [ Ç ü é â ä à å ç ê ë è ï î ì Ä Å É æ Æ ô ö ò û ù ÿ Ö Ü ¢ £ ¥ ₧ ƒ

As I have argued before we should get rid of this restriction, and I
have written the code to remove it, its not that hard. However Phil
wont take my changes so you currently have to live with this.

Thanks
Tim

On 1 September 2011 11:13, Terry Porter <terry <at> tjporter.com.au> wrote:
> Hi all,
> Does anyone have a list of the legal characters to use in part (item) names ?
>
> I ask because in my testing to find out which characters to use as
> delimiters ("-" or "_" etc) with WackoWicki, I found out that WebERP
> doesn't like "#" used in item names as it renders all characters
> following the '#" invisible.
>
> This meant that I couldn't delete my test item "FNA#RD-5G30", which
> only showed as part "FNA" and oddly had no delete button in the edit
> menu.
>
(Continue reading)


Gmane