We have the same issue with the conversion factor... when we buy precut sheets of aluminum. We want to use the full sheet as the part number and not have a new part number for each partial sheet ... but when you do this the numbers don't come out right... if they would increase the # decimals it would help....
-----Original Message-----
From: Mitchell Kirby [mailto:m.kirby@...]
Sent: Wednesday, November 05, 2003 7:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UM - Conversion from the Selling Qty to the Inventory Qty
We had the same problem two years ago and I also thought that the factor
should be multiplied and not divided. Never did find a work around. We
finally changed the unit of measure. This was for purchased items so we had
some latitude. I can't help you on a finished good. Epicor was not
inclined to change at that time either.
Mitchell Kirby
V. P. Manufacturing
Riten Industries, Inc.
740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX
-----Original Message-----
From: stelios koutsoukos [mailto:s.koutsoukos@...]
Sent: Wednesday, November 05, 2003 4:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] UM - Conversion from the Selling Qty to the Inventory Qty
Importance: High
Hi all
We are facing a huge issue with the conversion from the Selling Qty to the
Inventory Qty (Inventory Qty = Selling Qty / Selling Factor) when the
Selling Factor is very small.
For example:
Lets assume that we have a part with inventory U/M "piece" and selling
U/M "box of 6500 pieces". The selling factor should be 1 / 6500
(0.00015385).
When we enter a sales order for 1 box (selling qty) the inventory qty that
we get
as a result is 6499.84, which is incorrect.
The problem is even bigger with the Purchase Factor which has only 4
decimals,
as opposed to the selling factor which has 8 decimals
The long term solutions to the above, could be as follows:
The inventory qty could be computed by multiplying with the selling or the
purchasing
factor, instead of dividing. This approach could cause to Epicor a lot of
work BUT
we think that this is what should be done
In the meantime, though, we would appreciate it very much, if any of you,
could
propose some kind of solution / workaround.
PS.
It is also very difficult to manage different units of measure being a text
field without
any validations behind it. The ANSI standards are not applicable to every
country.
The length of the field (just 2 characters) and the lack of a table where we
could
have descriptions (more characters), creates quite a problem in supporting
many units
of measure.
Stelios Koutsoukos
Financial Products Sales Manager
ATC-InTarget
Phone : +30 210 6855 560
Fax : +30 210 6855 564
Mobile: + 30 6944 354626
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
-----Original Message-----
From: Mitchell Kirby [mailto:m.kirby@...]
Sent: Wednesday, November 05, 2003 7:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UM - Conversion from the Selling Qty to the Inventory Qty
We had the same problem two years ago and I also thought that the factor
should be multiplied and not divided. Never did find a work around. We
finally changed the unit of measure. This was for purchased items so we had
some latitude. I can't help you on a finished good. Epicor was not
inclined to change at that time either.
Mitchell Kirby
V. P. Manufacturing
Riten Industries, Inc.
740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX
-----Original Message-----
From: stelios koutsoukos [mailto:s.koutsoukos@...]
Sent: Wednesday, November 05, 2003 4:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] UM - Conversion from the Selling Qty to the Inventory Qty
Importance: High
Hi all
We are facing a huge issue with the conversion from the Selling Qty to the
Inventory Qty (Inventory Qty = Selling Qty / Selling Factor) when the
Selling Factor is very small.
For example:
Lets assume that we have a part with inventory U/M "piece" and selling
U/M "box of 6500 pieces". The selling factor should be 1 / 6500
(0.00015385).
When we enter a sales order for 1 box (selling qty) the inventory qty that
we get
as a result is 6499.84, which is incorrect.
The problem is even bigger with the Purchase Factor which has only 4
decimals,
as opposed to the selling factor which has 8 decimals
The long term solutions to the above, could be as follows:
The inventory qty could be computed by multiplying with the selling or the
purchasing
factor, instead of dividing. This approach could cause to Epicor a lot of
work BUT
we think that this is what should be done
In the meantime, though, we would appreciate it very much, if any of you,
could
propose some kind of solution / workaround.
PS.
It is also very difficult to manage different units of measure being a text
field without
any validations behind it. The ANSI standards are not applicable to every
country.
The length of the field (just 2 characters) and the lack of a table where we
could
have descriptions (more characters), creates quite a problem in supporting
many units
of measure.
Stelios Koutsoukos
Financial Products Sales Manager
ATC-InTarget
Phone : +30 210 6855 560
Fax : +30 210 6855 564
Mobile: + 30 6944 354626
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/