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.pati...@hotwaxsystems.com] *Sent:* Monday, November 27, 2017 10:34 AM *To:* Swapnil Shah <swapnil.s...@hotwaxsystems.com> *Cc:* dev@ofbiz.apache.org; Vaibhav Jain <vaibhav.j...@hotwaxsystems.com>; arunpati...@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.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 > > >
