You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Vaibhav Jain <va...@hotwaxsystems.com> on 2017/11/07 12:15:15 UTC
Initial inventory import in OFBiz
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,
vaibhav.jain@hotwaxsystems.com
RE: Initial inventory import in OFBiz
Posted by Swapnil Shah <sw...@hotwaxsystems.com>.
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:arun.patidar@hotwaxsystems.com]
*Sent:* Monday, November 27, 2017 10:34 AM
*To:* Swapnil Shah <sw...@hotwaxsystems.com>
*Cc:* dev@ofbiz.apache.org; Vaibhav Jain <va...@hotwaxsystems.com>;
arunpatidar@apache.org
*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 <
swapnil.shah@hotwaxsystems.com> 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:arun.patidar@hotwaxsystems.com]
Sent: Wednesday, November 22, 2017 2:00 PM
To: Vaibhav Jain <va...@hotwaxsystems.com>
Cc: arunpatidar@apache.org; dev@ofbiz.apache.org
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 <
vaibhav.jain@hotwaxsystems.com> 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,
> vaibhav.jain@hotwaxsystems.com
>
> 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,
> > vaibhav.jain@hotwaxsystems.com
> >
>
Re: Initial inventory import in OFBiz
Posted by Arun Patidar <ar...@hotwaxsystems.com>.
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 <
swapnil.shah@hotwaxsystems.com> 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:arun.patidar@hotwaxsystems.com]
> Sent: Wednesday, November 22, 2017 2:00 PM
> To: Vaibhav Jain <va...@hotwaxsystems.com>
> Cc: arunpatidar@apache.org; dev@ofbiz.apache.org
> 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 <
> vaibhav.jain@hotwaxsystems.com> 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,
>
> > vaibhav.jain@hotwaxsystems.com
>
> >
>
> > 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,
>
> > > vaibhav.jain@hotwaxsystems.com
>
> > >
>
> >
>
RE: Initial inventory import in OFBiz
Posted by Swapnil Shah <sw...@hotwaxsystems.com>.
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:arun.patidar@hotwaxsystems.com]
Sent: Wednesday, November 22, 2017 2:00 PM
To: Vaibhav Jain <va...@hotwaxsystems.com>
Cc: arunpatidar@apache.org; dev@ofbiz.apache.org
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 <
vaibhav.jain@hotwaxsystems.com> 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,
> vaibhav.jain@hotwaxsystems.com
>
> 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,
> > vaibhav.jain@hotwaxsystems.com
> >
>
Re: Initial inventory import in OFBiz
Posted by Arun Patidar <ar...@hotwaxsystems.com>.
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 <
vaibhav.jain@hotwaxsystems.com> 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,
> vaibhav.jain@hotwaxsystems.com
>
> 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,
> > vaibhav.jain@hotwaxsystems.com
> >
>
Re: Initial inventory import in OFBiz
Posted by Vaibhav Jain <va...@hotwaxsystems.com>.
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,
vaibhav.jain@hotwaxsystems.com
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,
> vaibhav.jain@hotwaxsystems.com
>