Item Specific UOM for Ordering

[camo]

We are going to use the Item Cross Ref Aplication to map our EAN.UCC numbers to our internal One World Item Master Numbers.
Our customers will want to use the EAN.UCC numbers on their purchase orders. There will be two EAN.UCC numbers for each finished goods item in One World, representing different packaging levels. The number is used on the purchase will also indicate the UOM for the order.
As an example :
One World Item = 123456
EAN.UCC for EA UOM = 9876541234560
EAN.UCC for BX UOM = 19876541234561
Both of these are cross referenced to the one world item.
However, the similarity (and length) of the EAN.UCC numbers would make it hard for Sales Order Entry staff to distinguish.

Is there functionality within One World (either Item or Sales side) that allows us to only allow EA to be used if the corresponding EAN.UCC number is entered at order entry - and similarly for the BX UOM.

Thanks in anticipation.

CAMO

 

[ame]

I don't know if this is exactly what you are looking for, but there is
UCC128 functionality that will differentiate the number based on your part
number and the "levels" of unit of measure for that item. You can access it
from the Storage/Shipping screen from the Item Master in OW... let me know
if this is what you are looking for. thanks, Bobby


Our customers will want to use the EAN.UCC numbers on their purchase orders.
There will be two EAN.UCC numbers for each finished goods item in One World,
representing different packaging levels. The number is used on the purchase
will also indicate the UOM for the order.
As an example :
One World Item = 123456
EAN.UCC for EA UOM = 9876541234560
EAN.UCC for BX UOM = 19876541234561
Both of these are cross referenced to the one world item.
However, the similarity (and length) of the EAN.UCC numbers would make it
hard for Sales Order Entry staff to distinguish.

Is there functionality within One World (either Item or Sales side) that
allows us to only allow EA to be used if the corresponding EAN.UCC number is
entered at order entry - and similarly for the BX UOM.

Thanks in anticipation.

CAMO

 

[Craig_Potter]

Camo,

I cannot think how you could control this using Xref numbers with the
standard software.

An alternative method to consider would be the setting up of Kits to
represent each of your EAN numbers. On the Kit Item Master records that you
create you would only set up 1 valid UOM (EA or BX) and in the Kit
definition (Bill of Materials) you would specify the number of units of Item
123456 that are represented by each EAN number.

Hope this helps,

Regards

Craig



Craig Potte

 

[camo]

Thanks for your replies.
I'll have to investigate the kits option a bit further to see if it meets our needs.

Sorry for confusing the issue earlier with the X-Ref functionality. Our basic requirements is this :

For the same product, one item number represents EA, one number represents BXs. I was wondering if One World could apply a rule at order entry that said ....
- you could only submit a line in the order with EA as the UOM if using the EA number
OR
- if using the EA number the EA UOM automatically comes into the order line
OR
- cannot place an order for BX UOM if using the EA number.


CAMO

 

[Sef]

Hi Cam

How's things in the beautiful King's Valley?
Maybe a solution to your problem can be found in pricing:
Option 1 (Base Pricing): Set your pricing UOM to 'PC' for the item you only which to sell in EA. In the conversion table you set 1 EA = 1 PC, but there is no conversion factor from BX to PC and as such a warning will be given that no base price is in effect.

Option 2 (advanced pricing): Create a new mandatory adjustment and include this in your schedules. In the adjustment details (base code = 1 with 0% markup or base code 5 and zero dollars or base code 1 and 100% price override) you only set up details with matching UOM's. When an incompatible combination is found a mandatory adjustment error will be displayed.

Good luck,

 

[JDE Freelancer]

May be u guy should test it out, I think using 'lot' to differential the EA and BX may be a better solution...