<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Import Multiple Journal Entries]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=8895</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8895&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Import Multiple Journal Entries.]]></description>
		<lastBuildDate>Fri, 31 Jul 2020 12:18:43 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Import Multiple Journal Entries]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37885#p37885</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (prasadkvsh)]]></author>
			<pubDate>Fri, 31 Jul 2020 12:18:43 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37885#p37885</guid>
		</item>
	</channel>
</rss>
