It would certainly help but it doesn't really solve the problem IMHO. Does
anyone on the list benefit from using division instead of multiplication to
handle these issues? Why was this approach taken? I have installed two
different ERP systems in the past and neither one used division. I was
"very" surprised to stumble on this in Vantage.
Even simple stuff like 12 bottles per case is difficult.
Mitchell Kirby
V. P. Manufacturing
Riten Industries, Inc.
740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, November 05, 2003 9:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UM - Conversion from the Selling Qty to the Inventory
Qty
Would expanding the decimal places resolve the issue, if so how many places?
8, 10, 12
I also have this issue with the quanity per parent in the BOM, it's limited
to 5 decimal places.
Patrick Winter
-----Original Message-----
From: stelios koutsoukos [mailto:s.koutsoukos@...]
Sent: Wednesday, November 05, 2003 3: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/
anyone on the list benefit from using division instead of multiplication to
handle these issues? Why was this approach taken? I have installed two
different ERP systems in the past and neither one used division. I was
"very" surprised to stumble on this in Vantage.
Even simple stuff like 12 bottles per case is difficult.
Mitchell Kirby
V. P. Manufacturing
Riten Industries, Inc.
740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, November 05, 2003 9:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UM - Conversion from the Selling Qty to the Inventory
Qty
Would expanding the decimal places resolve the issue, if so how many places?
8, 10, 12
I also have this issue with the quanity per parent in the BOM, it's limited
to 5 decimal places.
Patrick Winter
-----Original Message-----
From: stelios koutsoukos [mailto:s.koutsoukos@...]
Sent: Wednesday, November 05, 2003 3: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/