1 Topic by Rdugert

(1 replies, posted in Report Bugs here)

On a fresh install (or on a recent one when restoring), i get this message error while trying to update any journal, bank, etc transaction:
ex here: journal.
DATABASE ERROR : Cannot update audit gl_seq
error code : 1048

error message : Column 'fiscal_year' cannot be null
sql that failed was : UPDATE 0_audit_trail audit LEFT JOIN 0_fiscal_year year ON year.begin<='2021-02-11' AND year.end>='2021-02-11' SET audit.gl_seq = IF(audit.id=41, 0, NULL),audit.fiscal_year=year.id WHERE type='0' AND trans_no='2'



Why?
Vps ubuntu 18.04, php 7.4, FA 2.4.9 and 2.4.8

Go to forum: Report Bugs here

2 Reply by Rdugert

(11 replies, posted in Banking and General Ledger)

Raddison thanks for this nice plugin, an essential one actually.
Regarding Bank Statements, the only time consuming thing about the process is to have csv's broken in 2 parts, for deposits and payments.
Would be cool if we had a way to import bank statements in one shot.
It this doable?
Tx!

Go to forum: Banking and General Ledger

3 Topic by Rdugert

(0 replies, posted in Banking and General Ledger)

when transfering funds from a euro bank account to a usd bank account (belonging to my company) in FA, some fees might apply to the "from" (outgoing) bank in eur.
Today I am only proposed to add bank fees to the receiving USD bank.
I am missing something ? Could we add a field there ?
Otherwise posting another withdrawal or journal after each transfer seems like an extra step i would like to avoid...
thanks for you reply

Go to forum: Banking and General Ledger

4 Reply by Rdugert

(154 replies, posted in Modules Add-on's)

Hello  when will this extension support multicurrency as in 2.4? ex : account in AED, expenses in USD?
Today, there is no currency translation depending on source account...

Go to forum: Modules Add-on's

5 Topic by Rdugert

(1 replies, posted in Modules Add-on's)

I am trying to import a journal csv file using frontaccounting 2.4.7 with extension (2.4.0-3) of Import Multiple Journal Entries

The file looks like this:

entryid,date,reference,accountcode,dimension1,dimension2,amount,memo
3,30/06/2019,3,11020002,,,975,June 2019 / PSP PSP1 RM Deposits
3,30/06/2019,3,11020015,,,0,June 2019 / PSP PSP2 RM Deposits
3,30/06/2019,3,11020010,,,757,June 2019 / PSP PSP3 RM Deposits
3,30/06/2019,3,11050001,,,97.50,June 2019 / PSP PSP1 Rolling Reserve
3,30/06/2019,3,11050015,,,0.00,June 2019 / PSP PSP2 Rolling Reserve
3,30/06/2019,3,11050010,,,75.70,June 2019 / PSP PSP3 Rolling Reserve
3,30/06/2019,3,51014001,,,78.00,June 2019 / PSP PSP1 processing Exp
3,30/06/2019,3,51014001,,,0.00,June 2019 / PSP PSP2 processing Exp
3,30/06/2019,3,51014001,,,98.12,June 2019 / PSP PSP3 processing Exp
3,30/06/2019,3,11020002,,,-78.00,June 2019 / PSP PSP1 processing Exp
3,30/06/2019,3,11020015,,,0.00,June 2019 / PSP PSP2 processing Exp
3,30/06/2019,3,11020010,,,-98.12,June 2019 / PSP PSP3 processing Exp
3,30/06/2019,3,11020002,,,-97.50,June 2019 / PSP PSP1 Rol. Res. Deduction
3,30/06/2019,3,11020015,,,0.00,June 2019 / PSP PSP2 Rol. Res. Deduction
3,30/06/2019,3,11020010,,,-75.70,June 2019 / PSP PSP3 Rol. Res. Deduction
3,30/06/2019,3,11010005,,,-975,June 2019 / PSP PSP1 RM Deposits onto  accounts
3,30/06/2019,3,11010005,,,0,June 2019 / PSP PSP2 RM Deposits onto  accounts
3,30/06/2019,3,11010005,,,-757,June 2019 / PSP PSP3 RM Deposits onto  accounts

after choosing file I do not get any error message, just a white screen like that one

https://ibb.co/68s1Vyj

Please kindly indicate if my configuration is compatible knowing i use php 7 on my VPS

Go to forum: Modules Add-on's

6 Topic by Rdugert

(1 replies, posted in Jobs wanted/offered, non-free offers)

Hello
We need a specific p&l report on front accounting for our company.
- p&l shall be freely and simply deigned and  customized by user, by group  with accounts  drag and drop, and shall include intermediary Grouping totals and %
- p&l shall show months dynamically according to user chosen range, 1 column per month, and add a total, Total for y-1 (same months range), variance year vs y-1, budget, variance budget vs year (same chosen months range)
- max range shall be 12 months
- a nice feature equivalent to current p&l in standard front accounting would be to be able to have a drill down when clicking on account.
- report can be exported to pdf or excel

we are of course wanting to pay for this job. Please send any questions and your offer.
Thanks!

Go to forum: Jobs wanted/offered, non-free offers