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