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.s...@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.pati...@hotwaxsystems.com] > Sent: Wednesday, November 22, 2017 2:00 PM > To: Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> > Cc: arunpati...@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.j...@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.j...@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.j...@hotwaxsystems.com > > > > > > > >