Product Associations

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Benjamin Jugl]

Hi there,

I would say yes, the code implies this usage.

See ProductDetail.groovy:

obsolenscenseProducts = dispatcher.runSync("getAssociatedProducts", [productIdTo : productId, type : "PRODUCT_OBSOLESCENCE", checkViewAllow : true, prodCatalogId : currentCatalogId]);
context.obsolenscenseProducts = obsolenscenseProducts.assocProducts;



Am 25.04.18 um 18:13 schrieb [hidden email]:

> Ok Dumb question of the day!
>
> In product associations if Product 12345 is the New Version Replacement
> to Product 38726 inside of Catalog
>
> Product is 12345 is the Product From and Product 38726 is the Product to
> and the association is New Version Replacement Correct?
>
> Thanks,
>
> James
> -------- Original Message --------
> Subject: RE: Best Practice Uploading Sales Orders
> From: <[hidden email]>
> Date: Wed, April 25, 2018 4:56 am
> To: [hidden email]
>
> Thanks guys! I know this might sound stupid but what is the no-eca
> delegator?
>
> -------- Original Message --------
> Subject: Re: Best Practice Uploading Sales Orders
> From: Yashwant Dhakad <[hidden email]>
> Date: Tue, April 24, 2018 9:55 pm
> To: [hidden email]
>
> Hi James,
>
> You can create custom import service and use store operation to create
> the
> new records for orders with default-no-eca delegator. Please create all
> the
> related entities data for order and by default-no-eca delegator, eca and
> seca would not be triggered and inventory and the financial records
> would
> not be affected.
>
> Thanks & Regards
> --
> Yashwant Dhakad
> HotWax Systems
> http://www.hotwaxsystems.com/
>
> On Tue, Apr 24, 2018 at 5:35 PM, <[hidden email]> wrote:
>
>> Anyone have any experience uploading a closed sales order that would not
>> affect inventory or financials. I would like to import closed sales
>> order just to use for returns
>> -------- Original Message --------
>> Subject: RE: Best Practice Uploading Sales Orders
>> From: <[hidden email]>
>> Date: Tue, April 24, 2018 12:07 am
>> To: [hidden email]
>>
>> What happens when you need to return a Sales Order? I think you have to
>> have it in the system. So how do you import a closed sales order
>>
>> -------- Original Message --------
>> Subject: Re: Best Practice Uploading Sales Orders
>> From: James Yong <[hidden email]>
>> Date: Mon, April 23, 2018 5:00 pm
>> To: <[hidden email]>
>>
>> Hi James,
>>
>> 1. You can use Receive Inventory function and just receive the product.
>>
>> 2. No need to migrate closed sales orders to the new system.
>>
>> Regards,
>> James Yong
>>
>> On 2018/04/17 23:36:40, <[hidden email]> wrote:
>>> When you first launch Ofbiz it is extremely important to upload Open
>>> Sales, Open Purchase Orders, Trial Balances as well as initial inventory
>>> quantities and open accounts receivable and open accounts payable. This
>>> is a minimum to get a corporate system ready to utilize.
>>>
>>> Now comes the question. Typically closed sales orders are not imported,
>>> but there comes the issue where a customer wants to return a product
>>> from a closed sales order which is not in Ofbiz.
>>>
>>> Question:
>>>
>>> 1. Is there a way to create a blanket return not against a sales order?
>>> 2. If not is there a way of uploading closed sales order that doesn't
>>> affect financials?
>>>
>>> Thanks,
>>>
>>> James
>>>

--
Benjamin Jugl
Consultant

Fon       [phone]
Fax       [phone]
Mobil     [phone]
Xing      xing.com/profile/Benjamin_Jugl3/
LinkedIn  linkedin.com/in/benjamin-jugl-693664ab/

Company and Management Headquarters:
ecomify GmbH, Gustav-Winkler-Str. 22, 33699 Bielefeld, Deutschland
Fon: [phone], Fax: [phone], www.ecomify.de

Court Registration: Amtsgericht Bielefeld HRB 41683
Chief Executive Officer: Martin Becker, Michael Brohl

[Rishi Solanki]

In addition you need to change the association from and to.
>>> Product is 12345 is the Product From and Product 38726 is the Product to
and the association is New Version Replacement Correct?

38726 should be product from and 12345 should be product to.

Please refer the demo data for association type mentioned by Benjamin.



Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: [phone]
http://www.hotwaxsystems.com
www.hotwax.co

On Wed, Apr 25, 2018 at 9:57 PM, Benjamin Jugl <[hidden email]>
wrote:

> Hi there,
>
> I would say yes, the code implies this usage.
>
> See ProductDetail.groovy:
>
> obsolenscenseProducts = dispatcher.runSync("getAssociatedProducts",
> [productIdTo : productId, type : "PRODUCT_OBSOLESCENCE", checkViewAllow :
> true, prodCatalogId : currentCatalogId]);
> context.obsolenscenseProducts = obsolenscenseProducts.assocProducts;
>
>
>
> Am 25.04.18 um 18:13 schrieb [hidden email]:
>
> Ok Dumb question of the day!
>>
>> In product associations if Product 12345 is the New Version Replacement
>> to Product 38726 inside of Catalog
>>
>> Product is 12345 is the Product From and Product 38726 is the Product to
>> and the association is New Version Replacement Correct?
>>
>> Thanks,
>>
>> James
>> -------- Original Message --------
>> Subject: RE: Best Practice Uploading Sales Orders
>> From: <[hidden email]>
>> Date: Wed, April 25, 2018 4:56 am
>> To: [hidden email]
>>
>> Thanks guys! I know this might sound stupid but what is the no-eca
>> delegator?
>>
>> -------- Original Message --------
>> Subject: Re: Best Practice Uploading Sales Orders
>> From: Yashwant Dhakad <[hidden email]>
>> Date: Tue, April 24, 2018 9:55 pm
>> To: [hidden email]
>>
>> Hi James,
>>
>> You can create custom import service and use store operation to create
>> the
>> new records for orders with default-no-eca delegator. Please create all
>> the
>> related entities data for order and by default-no-eca delegator, eca and
>> seca would not be triggered and inventory and the financial records
>> would
>> not be affected.
>>
>> Thanks & Regards
>> --
>> Yashwant Dhakad
>> HotWax Systems
>> http://www.hotwaxsystems.com/
>>
>> On Tue, Apr 24, 2018 at 5:35 PM, <[hidden email]> wrote:
>>
>> Anyone have any experience uploading a closed sales order that would not
>>> affect inventory or financials. I would like to import closed sales
>>> order just to use for returns
>>> -------- Original Message --------
>>> Subject: RE: Best Practice Uploading Sales Orders
>>> From: <[hidden email]>
>>> Date: Tue, April 24, 2018 12:07 am
>>> To: [hidden email]
>>>
>>> What happens when you need to return a Sales Order? I think you have to
>>> have it in the system. So how do you import a closed sales order
>>>
>>> -------- Original Message --------
>>> Subject: Re: Best Practice Uploading Sales Orders
>>> From: James Yong <[hidden email]>
>>> Date: Mon, April 23, 2018 5:00 pm
>>> To: <[hidden email]>
>>>
>>> Hi James,
>>>
>>> 1. You can use Receive Inventory function and just receive the product.
>>>
>>> 2. No need to migrate closed sales orders to the new system.
>>>
>>> Regards,
>>> James Yong
>>>
>>> On 2018/04/17 23:36:40, <[hidden email]> wrote:
>>>
>>>> When you first launch Ofbiz it is extremely important to upload Open
>>>> Sales, Open Purchase Orders, Trial Balances as well as initial inventory
>>>> quantities and open accounts receivable and open accounts payable. This
>>>> is a minimum to get a corporate system ready to utilize.
>>>>
>>>> Now comes the question. Typically closed sales orders are not imported,
>>>> but there comes the issue where a customer wants to return a product
>>>> from a closed sales order which is not in Ofbiz.
>>>>
>>>> Question:
>>>>
>>>> 1. Is there a way to create a blanket return not against a sales order?
>>>> 2. If not is there a way of uploading closed sales order that doesn't
>>>> affect financials?
>>>>
>>>> Thanks,
>>>>
>>>> James
>>>>
>>>>
> --
> Benjamin Jugl
> Consultant
>
> Fon       [phone]
> Fax       [phone]
> Mobil     [phone]
> Xing      xing.com/profile/Benjamin_Jugl3/
> LinkedIn  linkedin.com/in/benjamin-jugl-693664ab/
>
> Company and Management Headquarters:
> ecomify GmbH, Gustav-Winkler-Str. 22, 33699 Bielefeld, Deutschland
> Fon: [phone], Fax: [phone], www.ecomify.de
>
> Court Registration: Amtsgericht Bielefeld HRB 41683
> Chief Executive Officer: Martin Becker, Michael Brohl
>
>
>

[Benjamin Jugl]

Are you sure?

Because the code I mentioned tries to find the old/replaced/obsolescence
Product and refers to "productIdTo".

Thus I think that 38726 should be productIdTo.

I can be mistaken, though. :)


Am 26.04.18 um 10:59 schrieb Rishi Solanki:

> In addition you need to change the association from and to.
>>>> Product is 12345 is the Product From and Product 38726 is the Product to
> and the association is New Version Replacement Correct?
>
> 38726 should be product from and 12345 should be product to.
>
> Please refer the demo data for association type mentioned by Benjamin.
>
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: [phone]
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Wed, Apr 25, 2018 at 9:57 PM, Benjamin Jugl <[hidden email]>
> wrote:
>
>> Hi there,
>>
>> I would say yes, the code implies this usage.
>>
>> See ProductDetail.groovy:
>>
>> obsolenscenseProducts = dispatcher.runSync("getAssociatedProducts",
>> [productIdTo : productId, type : "PRODUCT_OBSOLESCENCE", checkViewAllow :
>> true, prodCatalogId : currentCatalogId]);
>> context.obsolenscenseProducts = obsolenscenseProducts.assocProducts;
>>
>>
>>
>> Am 25.04.18 um 18:13 schrieb [hidden email]:
>>
>> Ok Dumb question of the day!
>>> In product associations if Product 12345 is the New Version Replacement
>>> to Product 38726 inside of Catalog
>>>
>>> Product is 12345 is the Product From and Product 38726 is the Product to
>>> and the association is New Version Replacement Correct?
>>>
>>> Thanks,
>>>
>>> James
>>> -------- Original Message --------
>>> Subject: RE: Best Practice Uploading Sales Orders
>>> From: <[hidden email]>
>>> Date: Wed, April 25, 2018 4:56 am
>>> To: [hidden email]
>>>
>>> Thanks guys! I know this might sound stupid but what is the no-eca
>>> delegator?
>>>
>>> -------- Original Message --------
>>> Subject: Re: Best Practice Uploading Sales Orders
>>> From: Yashwant Dhakad <[hidden email]>
>>> Date: Tue, April 24, 2018 9:55 pm
>>> To: [hidden email]
>>>
>>> Hi James,
>>>
>>> You can create custom import service and use store operation to create
>>> the
>>> new records for orders with default-no-eca delegator. Please create all
>>> the
>>> related entities data for order and by default-no-eca delegator, eca and
>>> seca would not be triggered and inventory and the financial records
>>> would
>>> not be affected.
>>>
>>> Thanks & Regards
>>> --
>>> Yashwant Dhakad
>>> HotWax Systems
>>> http://www.hotwaxsystems.com/
>>>
>>> On Tue, Apr 24, 2018 at 5:35 PM, <[hidden email]> wrote:
>>>
>>> Anyone have any experience uploading a closed sales order that would not
>>>> affect inventory or financials. I would like to import closed sales
>>>> order just to use for returns
>>>> -------- Original Message --------
>>>> Subject: RE: Best Practice Uploading Sales Orders
>>>> From: <[hidden email]>
>>>> Date: Tue, April 24, 2018 12:07 am
>>>> To: [hidden email]
>>>>
>>>> What happens when you need to return a Sales Order? I think you have to
>>>> have it in the system. So how do you import a closed sales order
>>>>
>>>> -------- Original Message --------
>>>> Subject: Re: Best Practice Uploading Sales Orders
>>>> From: James Yong <[hidden email]>
>>>> Date: Mon, April 23, 2018 5:00 pm
>>>> To: <[hidden email]>
>>>>
>>>> Hi James,
>>>>
>>>> 1. You can use Receive Inventory function and just receive the product.
>>>>
>>>> 2. No need to migrate closed sales orders to the new system.
>>>>
>>>> Regards,
>>>> James Yong
>>>>
>>>> On 2018/04/17 23:36:40, <[hidden email]> wrote:
>>>>
>>>>> When you first launch Ofbiz it is extremely important to upload Open
>>>>> Sales, Open Purchase Orders, Trial Balances as well as initial inventory
>>>>> quantities and open accounts receivable and open accounts payable. This
>>>>> is a minimum to get a corporate system ready to utilize.
>>>>>
>>>>> Now comes the question. Typically closed sales orders are not imported,
>>>>> but there comes the issue where a customer wants to return a product
>>>>> from a closed sales order which is not in Ofbiz.
>>>>>
>>>>> Question:
>>>>>
>>>>> 1. Is there a way to create a blanket return not against a sales order?
>>>>> 2. If not is there a way of uploading closed sales order that doesn't
>>>>> affect financials?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> James
>>>>>
>>>>>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Rishi Solanki]

<ProductAssoc  productAssocTypeId="PRODUCT_OBSOLESCENCE" productId="38726"
productIdTo="12345" fromDate="2001-05-13 12:00:00.0" quantity="1.000000"
reason="Any reason."/>

This is what I was suggesting, as I understand from James initial email
that 38726 is an product and its new version will be 12345. I was referring
to - https://demo-trunk.ofbiz.apache.org/ecommerce/big-gizmo-GZ-8544-p

Here productId="GZ-8544" and productIdTo="WG-9943" used in the demo data.

Please let me know if something is unclear or I misunderstood something.

Thanks!


Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: [phone]
http://www.hotwaxsystems.com
www.hotwax.co

On Thu, Apr 26, 2018 at 4:18 PM, <[hidden email]> wrote:

> I thought the same thing.  Product 12345 was the product from.  Can we
> clarify?
>
> -------- Original Message --------
> Subject: Re: Product Associations
> From: Benjamin Jugl <[hidden email]>
> Date: Thu, April 26, 2018 3:02 am
> To: [hidden email]
>
> Are you sure?
>
> Because the code I mentioned tries to find the old/replaced/obsolescence
>
> Product and refers to "productIdTo".
>
> Thus I think that 38726 should be productIdTo.
>
> I can be mistaken, though. :)
>
>
> Am 26.04.18 um 10:59 schrieb Rishi Solanki:
> > In addition you need to change the association from and to.
> >>>> Product is 12345 is the Product From and Product 38726 is the Product
> to
> > and the association is New Version Replacement Correct?
> >
> > 38726 should be product from and 12345 should be product to.
> >
> > Please refer the demo data for association type mentioned by Benjamin.
> >
> >
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: [phone]
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Wed, Apr 25, 2018 at 9:57 PM, Benjamin Jugl <[hidden email]
> >
> > wrote:
> >
> >> Hi there,
> >>
> >> I would say yes, the code implies this usage.
> >>
> >> See ProductDetail.groovy:
> >>
> >> obsolenscenseProducts = dispatcher.runSync("getAssociatedProducts",
> >> [productIdTo : productId, type : "PRODUCT_OBSOLESCENCE", checkViewAllow
> :
> >> true, prodCatalogId : currentCatalogId]);
> >> context.obsolenscenseProducts = obsolenscenseProducts.assocProducts;
> >>
> >>
> >>
> >> Am 25.04.18 um 18:13 schrieb [hidden email]:
> >>
> >> Ok Dumb question of the day!
> >>> In product associations if Product 12345 is the New Version Replacement
> >>> to Product 38726 inside of Catalog
> >>>
> >>> Product is 12345 is the Product From and Product 38726 is the Product
> to
> >>> and the association is New Version Replacement Correct?
> >>>
> >>> Thanks,
> >>>
> >>> James
> >>> -------- Original Message --------
> >>> Subject: RE: Best Practice Uploading Sales Orders
> >>> From: <[hidden email]>
> >>> Date: Wed, April 25, 2018 4:56 am
> >>> To: [hidden email]
> >>>
> >>> Thanks guys! I know this might sound stupid but what is the no-eca
> >>> delegator?
> >>>
> >>> -------- Original Message --------
> >>> Subject: Re: Best Practice Uploading Sales Orders
> >>> From: Yashwant Dhakad <[hidden email]>
> >>> Date: Tue, April 24, 2018 9:55 pm
> >>> To: [hidden email]
> >>>
> >>> Hi James,
> >>>
> >>> You can create custom import service and use store operation to create
> >>> the
> >>> new records for orders with default-no-eca delegator. Please create all
> >>> the
> >>> related entities data for order and by default-no-eca delegator, eca
> and
> >>> seca would not be triggered and inventory and the financial records
> >>> would
> >>> not be affected.
> >>>
> >>> Thanks & Regards
> >>> --
> >>> Yashwant Dhakad
> >>> HotWax Systems
> >>> http://www.hotwaxsystems.com/
> >>>
> >>> On Tue, Apr 24, 2018 at 5:35 PM, <[hidden email]> wrote:
> >>>
> >>> Anyone have any experience uploading a closed sales order that would
> not
> >>>> affect inventory or financials. I would like to import closed sales
> >>>> order just to use for returns
> >>>> -------- Original Message --------
> >>>> Subject: RE: Best Practice Uploading Sales Orders
> >>>> From: <[hidden email]>
> >>>> Date: Tue, April 24, 2018 12:07 am
> >>>> To: [hidden email]
> >>>>
> >>>> What happens when you need to return a Sales Order? I think you have
> to
> >>>> have it in the system. So how do you import a closed sales order
> >>>>
> >>>> -------- Original Message --------
> >>>> Subject: Re: Best Practice Uploading Sales Orders
> >>>> From: James Yong <[hidden email]>
> >>>> Date: Mon, April 23, 2018 5:00 pm
> >>>> To: <[hidden email]>
> >>>>
> >>>> Hi James,
> >>>>
> >>>> 1. You can use Receive Inventory function and just receive the
> product.
> >>>>
> >>>> 2. No need to migrate closed sales orders to the new system.
> >>>>
> >>>> Regards,
> >>>> James Yong
> >>>>
> >>>> On 2018/04/17 23:36:40, <[hidden email]> wrote:
> >>>>
> >>>>> When you first launch Ofbiz it is extremely important to upload Open
> >>>>> Sales, Open Purchase Orders, Trial Balances as well as initial
> inventory
> >>>>> quantities and open accounts receivable and open accounts payable.
> This
> >>>>> is a minimum to get a corporate system ready to utilize.
> >>>>>
> >>>>> Now comes the question. Typically closed sales orders are not
> imported,
> >>>>> but there comes the issue where a customer wants to return a product
> >>>>> from a closed sales order which is not in Ofbiz.
> >>>>>
> >>>>> Question:
> >>>>>
> >>>>> 1. Is there a way to create a blanket return not against a sales
> order?
> >>>>> 2. If not is there a way of uploading closed sales order that doesn't
> >>>>> affect financials?
> >>>>>
> >>>>> Thanks,
> >>>>>
> >>>>> James
> >>>>>
> >>>>>
>