How can I track batch numbers of products sold?

I need to track batch numbers of products sold and had expected to simply add
a one-to-many custom entity under the order product entity.

However it seems that you cannot create relationships between Order Product
and - well - anything!

Is this a system limitation, and can anyone suggest a workaround? Thanks!

Mayank
Thu Apr 19 11:04:04 CDT 2007

On Apr 18, 10:50 pm, BillB <B...@discussions.microsoft.com> wrote:
> I need to track batch numbers of products sold and had expected to simply add
> a one-to-many custom entity under the order product entity.
>
> However it seems that you cannot create relationships between Order Product
> and - well - anything!
>
> Is this a system limitation, and can anyone suggest a workaround? Thanks!


I haven't checked if this is a customizable entity. If so, you could
add a custom field ~~ BatchId.
Auto populate the field for all order products every time the related
order is fulfilled, or as per your business requirement.

Cheers
-- Mayank

BillB
Tue Apr 24 16:48:02 CDT 2007

Hi Mayank -

Thanks for the suggestion - yes, you can add attributes to Order Product.
Problem is there could be a quantity of product > 1, each with a different
batch number - i.e. a one > many relationship.

My work around has been to create a 1 > many relationship with the Order
entity instead.

"Mayank" wrote:

> On Apr 18, 10:50 pm, BillB <B...@discussions.microsoft.com> wrote:
> > I need to track batch numbers of products sold and had expected to simply add
> > a one-to-many custom entity under the order product entity.
> >
> > However it seems that you cannot create relationships between Order Product
> > and - well - anything!
> >
> > Is this a system limitation, and can anyone suggest a workaround? Thanks!
>
>
> I haven't checked if this is a customizable entity. If so, you could
> add a custom field ~~ BatchId.
> Auto populate the field for all order products every time the related
> order is fulfilled, or as per your business requirement.
>
> Cheers
> -- Mayank
>
>

Mayank
Thu Apr 26 05:47:05 CDT 2007

On Apr 25, 2:48 am, BillB <B...@discussions.microsoft.com> wrote:
> Hi Mayank -
>
> Thanks for the suggestion - yes, you can add attributes to Order Product.
> Problem is there could be a quantity of product > 1, each with a different
> batch number - i.e. a one > many relationship.
>
> My work around has been to create a 1 > many relationship with the Order
> entity instead.
>
>
>
> "Mayank" wrote:
> > On Apr 18, 10:50 pm, BillB <B...@discussions.microsoft.com> wrote:
> > > I need to track batch numbers of products sold and had expected to simply add
> > > a one-to-many custom entity under the order product entity.
>
> > > However it seems that you cannot create relationships between Order Product
> > > and - well - anything!
>
> > > Is this a system limitation, and can anyone suggest a workaround? Thanks!
>
> > I haven't checked if this is a customizable entity. If so, you could
> > add a custom field ~~ BatchId.
> > Auto populate the field for all order products every time the related
> > order is fulfilled, or as per your business requirement.
>
> > Cheers
> > -- Mayank- Hide quoted text -
>
> - Show quoted text -

Hi Bill
You are right, This needed more thought.
I have a question on your solution.
An order could consume products from more than one batches as there
can be multiple order products attached and in high quantities.
For this case 1-many relationship from order to batch would do.

But then, a number of orders could be sourcing products from a single
batch too. To track this, you would need a many-1 relationship from
order to batch.
So, basically you would need a many-many relationship between order
and batch.

Please correct me if im wrong somewhere.

-- Mayank