Initial inventory import in OFBiz

[Vaibhav Jain]

How to manage initial inventory import in OFBiz migrated from the legacy
system?

How to manage initial inventory cost in accounting module?

Vaibhav Jain
Hotwax Systems,
[hidden email]

[Vaibhav Jain]

Hello all,

As per the further findings, I found that there can be various ways to
import initial inventory from legacy system to OFBiz

1. We can import the inventory of the legacy system to OFBiz using receive
inventory. And inventory cost can be calculated according to respective
COGS method of the organisation.
2. We can create an inbound shipment in OFBiz for existing inventory of
legacy system.

Initial inventory import affects various modules of OFBiz.

Please share your thoughts on it.

Vaibhav Jain
Hotwax Systems,
[hidden email]

On Tue, Nov 7, 2017 at 5:45 PM, Vaibhav Jain <[hidden email]
> wrote:

> How to manage initial inventory import in OFBiz migrated from the legacy
> system?
>
> How to manage initial inventory cost in accounting module?
>
> Vaibhav Jain
> Hotwax Systems,
> [hidden email]
>

[Arun Patidar-2]

Hello Vaibhav,

Initial inventory import using a shipment looks good to me. What will be
the case when you will mark shipment received and the system will generate
purchase invoice for it?  Thia is possible that we are not purchasing
received inventory during system setup, that was already paid through the
offline system.

--
Thanks & Regards
---
Arun Patidar
Manager, Enterprise Software Development

HotWax Systems Pvt Ltd.

www.hotwaxsystems.com


On Mon, Nov 20, 2017 at 7:29 PM, Vaibhav Jain <
[hidden email]> wrote:

> Hello all,
>
> As per the further findings, I found that there can be various ways to
> import initial inventory from legacy system to OFBiz
>
> 1. We can import the inventory of the legacy system to OFBiz using receive
> inventory. And inventory cost can be calculated according to respective
> COGS method of the organisation.
> 2. We can create an inbound shipment in OFBiz for existing inventory of
> legacy system.
>
> Initial inventory import affects various modules of OFBiz.
>
> Please share your thoughts on it.
>
> Vaibhav Jain
> Hotwax Systems,
> [hidden email]
>
> On Tue, Nov 7, 2017 at 5:45 PM, Vaibhav Jain <vaibhav.jain@hotwaxsystems.
> com
> > wrote:
>
> > How to manage initial inventory import in OFBiz migrated from the legacy
> > system?
> >
> > How to manage initial inventory cost in accounting module?
> >
> > Vaibhav Jain
> > Hotwax Systems,
> > [hidden email]
> >
>

[swapnil]

If intent is to use this feature just one time for setting up foundation
data then we can keep the scope and purpose of it limited to sync up
product-wise on hand stock between any two systems. And in this given
context, it should suffice to:

   - Either take the stock in through InventoryItemVariance Or via Shipment
   & ShipmentReceipt.
   - Create respective InventoryItem along with InventoryItemDetails
   against each product (with some reasonable flag that signifies that its
   created as part of sync up or Import process)
   - Set
   QOH/ATP/unitCost/Facility/location/ownerPartyId/itemCondition/LotId/serialNumber
   on respective InventoryItem(s) based on what is already set in legacy
   system (rather than recalculating at our end) against each product. And
   percolate these set values to related entities.



Thanks,

Swapnil



-----Original Message-----
From: Arun Patidar [mailto:[hidden email]]
Sent: Wednesday, November 22, 2017 2:00 PM
To: Vaibhav Jain <[hidden email]>
Cc: [hidden email]; [hidden email]
Subject: Re: Initial inventory import in OFBiz



Hello Vaibhav,



Initial inventory import using a shipment looks good to me. What will be
the case when you will mark shipment received and the system will generate
purchase invoice for it?  Thia is possible that we are not purchasing
received inventory during system setup, that was already paid through the
offline system.



--

Thanks & Regards

---

Arun Patidar

Manager, Enterprise Software Development



HotWax Systems Pvt Ltd.



www.hotwaxsystems.com





On Mon, Nov 20, 2017 at 7:29 PM, Vaibhav Jain <
[hidden email]> wrote:



> Hello all,

>

> As per the further findings, I found that there can be various ways to

> import initial inventory from legacy system to OFBiz

>

> 1. We can import the inventory of the legacy system to OFBiz using

> receive inventory. And inventory cost can be calculated according to

> respective COGS method of the organisation.

> 2. We can create an inbound shipment in OFBiz for existing inventory

> of legacy system.

>

> Initial inventory import affects various modules of OFBiz.

>

> Please share your thoughts on it.

>

> Vaibhav Jain

> Hotwax Systems,

> [hidden email]

>

> On Tue, Nov 7, 2017 at 5:45 PM, Vaibhav Jain <vaibhav.jain@hotwaxsystems.

> com

> > wrote:

>

> > How to manage initial inventory import in OFBiz migrated from the

> > legacy system?

> >

> > How to manage initial inventory cost in accounting module?

> >

> > Vaibhav Jain

> > Hotwax Systems,

> > [hidden email]

> >

>

[Arun Patidar-2]

Thanks Swapnil for details. All your suggestions should consider while
stock inventory import. I am concern about accounting impact with this
import. How will we manage AP invoice generated by this process?

--
Thanks & Regards
---
Arun Patidar
Manager, Enterprise Software Development

HotWax Systems Pvt Ltd.

www.hotwaxsystems.com


On Fri, Nov 24, 2017 at 1:04 PM, Swapnil Shah <
[hidden email]> wrote:

> If intent is to use this feature just one time for setting up foundation
> data then we can keep the scope and purpose of it limited to sync up
> product-wise on hand stock between any two systems. And in this given
> context, it should suffice to:
>
>    - Either take the stock in through InventoryItemVariance Or via
>    Shipment & ShipmentReceipt.
>    - Create respective InventoryItem along with InventoryItemDetails
>    against each product (with some reasonable flag that signifies that its
>    created as part of sync up or Import process)
>    - Set QOH/ATP/unitCost/Facility/location/ownerPartyId/
>    itemCondition/LotId/serialNumber on respective InventoryItem(s) based
>    on what is already set in legacy system (rather than recalculating at our
>    end) against each product. And percolate these set values to related
>    entities.
>
>
>
> Thanks,
>
> Swapnil
>
>
>
> -----Original Message-----
> From: Arun Patidar [mailto:[hidden email]]
> Sent: Wednesday, November 22, 2017 2:00 PM
> To: Vaibhav Jain <[hidden email]>
> Cc: [hidden email]; [hidden email]
> Subject: Re: Initial inventory import in OFBiz
>
>
>
> Hello Vaibhav,
>
>
>
> Initial inventory import using a shipment looks good to me. What will be
> the case when you will mark shipment received and the system will generate
> purchase invoice for it?  Thia is possible that we are not purchasing
> received inventory during system setup, that was already paid through the
> offline system.
>
>
>
> --
>
> Thanks & Regards
>
> ---
>
> Arun Patidar
>
> Manager, Enterprise Software Development
>
>
>
> HotWax Systems Pvt Ltd.
>
>
>
> www.hotwaxsystems.com
>
>
>
>
>
> On Mon, Nov 20, 2017 at 7:29 PM, Vaibhav Jain <
> [hidden email]> wrote:
>
>
>
> > Hello all,
>
> >
>
> > As per the further findings, I found that there can be various ways to
>
> > import initial inventory from legacy system to OFBiz
>
> >
>
> > 1. We can import the inventory of the legacy system to OFBiz using
>
> > receive inventory. And inventory cost can be calculated according to
>
> > respective COGS method of the organisation.
>
> > 2. We can create an inbound shipment in OFBiz for existing inventory
>
> > of legacy system.
>
> >
>
> > Initial inventory import affects various modules of OFBiz.
>
> >
>
> > Please share your thoughts on it.
>
> >
>
> > Vaibhav Jain
>
> > Hotwax Systems,
>
> > [hidden email]
>
> >
>
> > On Tue, Nov 7, 2017 at 5:45 PM, Vaibhav Jain <vaibhav.jain@hotwaxsystems.
>
> > com
>
> > > wrote:
>
> >
>
> > > How to manage initial inventory import in OFBiz migrated from the
>
> > > legacy system?
>
> > >
>
> > > How to manage initial inventory cost in accounting module?
>
> > >
>
> > > Vaibhav Jain
>
> > > Hotwax Systems,
>
> > > [hidden email]
>
> > >
>
> >
>

[swapnil]

Hi Arun,

I believe the AP processes should come into effect if we are also planning
to migrate other transactions like Vendors, PO, Purchase/Tax Invoices,
Purchase Returns etc. into the system. Are we intending to include all
these transaction data as well under one-time Inventory migration effort.



Thanks & Regards,

Swapnil



*From:* Arun Patidar [mailto:[hidden email]]
*Sent:* Monday, November 27, 2017 10:34 AM
*To:* Swapnil Shah <[hidden email]>
*Cc:* [hidden email]; Vaibhav Jain <[hidden email]>;
[hidden email]
*Subject:* Re: Initial inventory import in OFBiz



Thanks Swapnil for details. All your suggestions should consider while
stock inventory import. I am concern about accounting impact with this
import. How will we manage AP invoice generated by this process?


--

Thanks & Regards

---

Arun Patidar

Manager, Enterprise Software Development

HotWax Systems Pvt Ltd.

www.hotwaxsystems.com



On Fri, Nov 24, 2017 at 1:04 PM, Swapnil Shah <
[hidden email]> wrote:

If intent is to use this feature just one time for setting up foundation
data then we can keep the scope and purpose of it limited to sync up
product-wise on hand stock between any two systems. And in this given
context, it should suffice to:

·  Either take the stock in through InventoryItemVariance Or via Shipment &
ShipmentReceipt.

·  Create respective InventoryItem along with InventoryItemDetails against
each product (with some reasonable flag that signifies that its created as
part of sync up or Import process)

·  Set
QOH/ATP/unitCost/Facility/location/ownerPartyId/itemCondition/LotId/serialNumber
on respective InventoryItem(s) based on what is already set in legacy
system (rather than recalculating at our end) against each product. And
percolate these set values to related entities.



Thanks,

Swapnil



-----Original Message-----
From: Arun Patidar [mailto:[hidden email]]
Sent: Wednesday, November 22, 2017 2:00 PM
To: Vaibhav Jain <[hidden email]>
Cc: [hidden email]; [hidden email]
Subject: Re: Initial inventory import in OFBiz



Hello Vaibhav,



Initial inventory import using a shipment looks good to me. What will be
the case when you will mark shipment received and the system will generate
purchase invoice for it?  Thia is possible that we are not purchasing
received inventory during system setup, that was already paid through the
offline system.



--

Thanks & Regards

---

Arun Patidar

Manager, Enterprise Software Development



HotWax Systems Pvt Ltd.



www.hotwaxsystems.com





On Mon, Nov 20, 2017 at 7:29 PM, Vaibhav Jain <
[hidden email]> wrote:



> Hello all,

>

> As per the further findings, I found that there can be various ways to

> import initial inventory from legacy system to OFBiz

>

> 1. We can import the inventory of the legacy system to OFBiz using

> receive inventory. And inventory cost can be calculated according to

> respective COGS method of the organisation.

> 2. We can create an inbound shipment in OFBiz for existing inventory

> of legacy system.

>

> Initial inventory import affects various modules of OFBiz.

>

> Please share your thoughts on it.

>

> Vaibhav Jain

> Hotwax Systems,

> [hidden email]

>

> On Tue, Nov 7, 2017 at 5:45 PM, Vaibhav Jain <vaibhav.jain@hotwaxsystems.

> com

> > wrote:

>

> > How to manage initial inventory import in OFBiz migrated from the

> > legacy system?

> >

> > How to manage initial inventory cost in accounting module?

> >

> > Vaibhav Jain

> > Hotwax Systems,

> > [hidden email]

> >

>