Topic: Import Multiple Journal Entries

Hi Everybody,

Last week I downloaded the frontaccounting-2.4.8.zip,

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.

INSERT INTO `0_chart_master` VALUES                                                                 
('1010000', '', 'CASH - BOK FINANCIAL          ', '1', '0'),                                       
('1011000', '', 'CASH - AZ BIZ BANK - MM       ', '1', '0'),                                       
('1015000', '', 'CASH - PACIFIC PREMIER        ', '1', '0'),                                       
('1020000', '', 'CASH - DEPOSIT ACCOUNT        ', '1', '0'),                                       
('1021000', '', 'CASH - DEPOSIT IN TRANSIT     ', '1', '0')....................

Created the following csv format for journal entries,
entryid,date,reference,accountcode,dimension1,dimension2,amount,memo                               
000001,07/15/2020,JV000001,2000000,,,-15970.00,"0000000033 I VEND L21140 "                 
000001,07/15/2020,JV000001,8550010,,, 15970.00,"0000000033 I VEND L21140 "                 
000002,07/09/2020,JV000002,2000000,,,-06305.00,"0000000393 I VEND A19250 "                 
000002,07/09/2020,JV000002,8600000,,, 06305.00,"0000000393 I VEND A19250 "                 
000003,07/04/2020,JV000003,2000000,,,-01900.00,"0000000526 I VEND K05225 "                 
000003,07/04/2020,JV000003,8660000,,, 01900.00,"0000000526 I VEND K05225 "                 
000004,07/10/2020,JV000004,2000000,,,-01550.00,"0000000527 I VEND K05225 "                 
000004,07/10/2020,JV000004,8660000,,, 01550.00,"0000000527 I VEND K05225 "

It is not showing any errors or message and the records are not posted in Ledger accounts.

Please help on this.

Thanks