• From: Vietnam, Da Nang
  • Registered: 02/06/2023
  • Posts: 1

Topic: Download the frontaccounting-2.4.8.zip

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

  • Registered: 10/31/2013
  • Posts: 21

Re: Download the frontaccounting-2.4.8.zip

sorry, I dunno
just wondering why you are using an old version?

  • From: USA, Raleigh, North Carolina
  • Registered: 01/07/2021
  • Posts: 69

Re: Download the frontaccounting-2.4.8.zip

If they aren't visible in the GL, then I doubt if they're in the proper table.  It's just a read after all (select * from XX where YY = ZZ;) 

aletheamartinez wrote:

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Download the frontaccounting-2.4.8.zip

Why would anyone want to download FA v2.4.8 when v2.4.14+ is out now other than PHP/MySQL version availability and no such requirements have changed in the meanwhile.

apmuthu's Website