FrontAccounting forum — Manual Bulk Import of Items

Re: Manual Bulk Import of Items

null@example.com (apmuthu) — Fri, 05 Dec 2014 04:06:43 +0000

To import opening stock of items we need to make sure how we are going to handle the contra entry in values of the stock.

1. If it is going to a lump sum value in the stock asset account then that account must be treated as the supplier.

2. If each individual supplier is going to be credited with the contra value of the stock, then a transfer of such values in each supplier account should be journal vouchered into the stock asset account.

The latter, though cumbersome, has the added feature of automatically getting in the cost price to the stock table directly.

For the former, the material_cost field in the stock_master table should be entered and the final open stock value computed (adjustments stock qty * material_cost) and put in to the stock asset account.

Re: Manual Bulk Import of Items

null@example.com (MarkAndrew) — Fri, 05 Dec 2014 02:15:50 +0000

Hi Apmuthu
Is there any way of importing the opening inventory quantities also?
At present the only way I know how is manual inventory adjustments line by line - which can take a long time!
Mark

Manual Bulk Import of Items

null@example.com (apmuthu) — Fri, 28 Nov 2014 19:48:47 +0000

The Wiki has been updated with raw SQLs (use after editing for appropriate company # and other specifics) to bulk import Items into FrontAccounting manually.