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:[email protected]] Sent: Wednesday, November 22, 2017 2:00 PM To: Vaibhav Jain <[email protected]> Cc: [email protected]; [email protected] 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 < [email protected]> 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, > [email protected] > > 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, > > [email protected] > > >
