<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Import Multiple Journal Entries]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8895&amp;type=atom" />
	<updated>2020-07-31T12:18:43Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=8895</id>
		<entry>
			<title type="html"><![CDATA[Import Multiple Journal Entries]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37885#p37885" />
			<content type="html"><![CDATA[<p>Hi Everybody,</p><p>Last week I downloaded the frontaccounting-2.4.8.zip, </p><p>Enabled this function, enabled for the user. Inserted around 300 COA records in Chart table using mysql- phpmyadmin tool. I am able to see COA in Journal Entry screen. This is good.</p><p>INSERT INTO `0_chart_master` VALUES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />(&#039;1010000&#039;, &#039;&#039;, &#039;CASH - BOK FINANCIAL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#039;, &#039;1&#039;, &#039;0&#039;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />(&#039;1011000&#039;, &#039;&#039;, &#039;CASH - AZ BIZ BANK - MM&nbsp; &nbsp; &nbsp; &nbsp;&#039;, &#039;1&#039;, &#039;0&#039;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />(&#039;1015000&#039;, &#039;&#039;, &#039;CASH - PACIFIC PREMIER&nbsp; &nbsp; &nbsp; &nbsp; &#039;, &#039;1&#039;, &#039;0&#039;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />(&#039;1020000&#039;, &#039;&#039;, &#039;CASH - DEPOSIT ACCOUNT&nbsp; &nbsp; &nbsp; &nbsp; &#039;, &#039;1&#039;, &#039;0&#039;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />(&#039;1021000&#039;, &#039;&#039;, &#039;CASH - DEPOSIT IN TRANSIT&nbsp; &nbsp; &nbsp;&#039;, &#039;1&#039;, &#039;0&#039;)....................</p><p>Created the following csv format for journal entries, <br />entryid,date,reference,accountcode,dimension1,dimension2,amount,memo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />000001,07/15/2020,JV000001,2000000,,,-15970.00,&quot;0000000033 I VEND L21140 &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />000001,07/15/2020,JV000001,8550010,,, 15970.00,&quot;0000000033 I VEND L21140 &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />000002,07/09/2020,JV000002,2000000,,,-06305.00,&quot;0000000393 I VEND A19250 &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />000002,07/09/2020,JV000002,8600000,,, 06305.00,&quot;0000000393 I VEND A19250 &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />000003,07/04/2020,JV000003,2000000,,,-01900.00,&quot;0000000526 I VEND K05225 &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />000003,07/04/2020,JV000003,8660000,,, 01900.00,&quot;0000000526 I VEND K05225 &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />000004,07/10/2020,JV000004,2000000,,,-01550.00,&quot;0000000527 I VEND K05225 &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />000004,07/10/2020,JV000004,8660000,,, 01550.00,&quot;0000000527 I VEND K05225 &quot; </p><p>It is not showing any errors or message and the records are not posted in Ledger accounts.</p><p>Please help on this.</p><p>Thanks</p>]]></content>
			<author>
				<name><![CDATA[prasadkvsh]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45605</uri>
			</author>
			<updated>2020-07-31T12:18:43Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37885#p37885</id>
		</entry>
</feed>
