<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — importing Product Data]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5198&amp;type=atom" />
	<updated>2014-09-24T14:49:13Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5198</id>
		<entry>
			<title type="html"><![CDATA[importing Product Data]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=20966#p20966" />
			<content type="html"><![CDATA[<p>Hi,</p><p>I have imported customers and customer-branches, that is OK now.<br />I have figured out that for importing products you need to fill 6 tables (or 7)<br />in a coherent way.</p><p>stock_master<br />item_codes<br />purch_data<br />prices<br />stock_moves<br />loc_stock</p><p>Now if I want 1000 pieces of a product in stock I must put that in stock_moves.</p><p>I am not sure that I have to put something in gl_trans</p><p>since there is no connection to the productnumber there, with wat is it connected then<br />and am I obliged to put a -1000 and +1000 line in there?</p><p>Kind regards,<br />Jan</p>]]></content>
			<author>
				<name><![CDATA[janvl]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=17053</uri>
			</author>
			<updated>2014-09-24T14:49:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=20966#p20966</id>
		</entry>
</feed>
