<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Manual Bulk Import of Items]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5351&amp;type=atom" />
	<updated>2014-12-05T04:06:43Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5351</id>
		<entry>
			<title type="html"><![CDATA[Re: Manual Bulk Import of Items]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=21654#p21654" />
			<content type="html"><![CDATA[<p>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. </p><p>1. If it is going to a lump sum value in the stock asset account then that account must be treated as the supplier. </p><p>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. </p><p>The latter, though cumbersome, has the added feature of automatically getting in the cost price to the stock table directly. </p><p>For the former, the <strong>material_cost</strong> field in the <strong>stock_master</strong> table should be entered and the final open stock value computed (adjustments stock qty * material_cost) and put in to the stock asset account.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2014-12-05T04:06:43Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=21654#p21654</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Manual Bulk Import of Items]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=21651#p21651" />
			<content type="html"><![CDATA[<p>Hi Apmuthu<br />Is there any way of importing the opening inventory quantities also?<br />At present the only way I know how is manual inventory adjustments line by line - which can take a long time!<br />Mark</p>]]></content>
			<author>
				<name><![CDATA[MarkAndrew]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=17490</uri>
			</author>
			<updated>2014-12-05T02:15:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=21651#p21651</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Manual Bulk Import of Items]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=21594#p21594" />
			<content type="html"><![CDATA[<p>The <a href="https://frontaccounting.com/fawiki/index.php?n=Help.ManualItemsImportIntoFA">Wiki</a> has been updated with raw SQLs (use after editing for appropriate company # and other specifics) to bulk import Items into FrontAccounting manually.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2014-11-28T19:48:47Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=21594#p21594</id>
		</entry>
</feed>
