1 Reply by albertolima

(6 replies, posted in Announcements)

Congratulations team! Great job!

Go to forum: Announcements

2 Reply by albertolima

(3 replies, posted in Banking and General Ledger)

This seems related to this post

https://frontaccounting.com/punbb/viewt … 587#p40587

It looks like if you are using php8, it makes FA not being able to edit journal transactions. Check what php version you are using and if it is v8, try to downgrade to v7.4

Go to forum: Banking and General Ledger

3 Reply by albertolima

(20 replies, posted in Banking and General Ledger)

Confirmed, yes. Switching back to php7.4 enables journals edition
I am using Ubuntu Server v20.04, Apache2 and php8.1

Go to forum: Banking and General Ledger

4 Reply by albertolima

(3 replies, posted in Banking and General Ledger)

Strange ... I recently installed version 2.4.11 and I am facing the same issue. It looks like something has changed recently (?) ... I have to recheck permissions, but I have administrator with all permissions checked ... still no access to edit transactions in same fiscal year

Go to forum: Banking and General Ledger

5 Reply by albertolima

(11 replies, posted in Banking and General Ledger)

I have been able to reproduce the same situation on another installation of FA2.4.7 too.
I never run into this because on corporations, I never needed to have a foreign currency account. Until now.

I've tried to check the code, but I am not able to pinpoint it, probably need a longer session or more expertise.

Go to forum: Banking and General Ledger

6 Reply by albertolima

(11 replies, posted in Banking and General Ledger)

The bank account must be in foreign currency
Then create a journal entry onto that bank account related gl account, in local currency
Then, go to bank inquiry, and that journal entry is not there

I shall check with a different installation tonight and revert back with a video link if the issue is not a corrupted setup

Go to forum: Banking and General Ledger

7 Reply by albertolima

(11 replies, posted in Banking and General Ledger)

I still see a missed entry when I do BANK_INQUIRY
Journal Entry    110    086/2021    05/07/2021    10.00        -40.00        TEST-Journal entry in EUR

This is the same bank account from GENERAL LEDGER INQUIRY
Journal Entry    110    086/2021    05/07/2021             6,559.57        551,615.82    TEST-Journal entry in EUR
Journal Entry    111    087/2021    05/07/2021             6,560.00        558,175.82    TEST-Journal entry in XAF


Journal entry #111 is missing from Bank Account inquiry.
It was entered in XAF, and converted using the dropdown currency converter, but the data is not saved into the bank_trans database, therefore the gl account and the bank account balances do not match.

I believe the intention is to have them match both ways: if you enter it through banking, it must show on GL; if you enter the journal from GL, it should show on banking. Am I getting it wrong?

Go to forum: Banking and General Ledger

8 Reply by albertolima

(11 replies, posted in Banking and General Ledger)

Not sure if it is the same issue, but what I am seeing is that journal entries that have been entered using the dropdown currency converter are not taken into consideration when obtaining the balance in the bank account inquiry.

Scenario:
1-My main currency is XAF, and I have a foreign bank account in EUR
2-I enter a JOURNAL ENTRY into this foreign account, in my local currency XAF, selecting the currency from the dropdown combobox (we may now do it in FA). Then I go to Bank Inquiry to look for that journal entry, and it does_not show up.
3-I repeat the same operation, but I do select EUR directly from the JOURNAL ENTRY, and I enter the journal in EUR. In this situation, I may see the journal entry when I check in BANK INQUIRY.

This makes GENERAL LEDGER balance not match with BANK INQUIRY balance.

Is this an expected behavior? Is FA expecting all bank movements to be entered directly as Bank deposits/withdraws?

GL INQUIRY view
BANK INQUIRY view

Go to forum: Banking and General Ledger

9 Reply by albertolima

(1 replies, posted in Reporting)

Hi.
Maybe if you share a bit more, we may clarify what is wrong.
Where do you enter data?
What data do you enter?
What do you expect to happen?
What actually happens?

Go to forum: Reporting

10 Reply by albertolima

(2 replies, posted in Setup)

Check this topic, it might help  https://frontaccounting.com/punbb/viewtopic.php?pid=19097#p19097

Check code at function preventHijacking()

Do not forget to share with us any findings. Thks.

Go to forum: Setup

11 Reply by albertolima

(2 replies, posted in Items and Inventory)

I am not sure you search that way. There is a little magnifier in item description that pops up the search window where you may enter some item description letters and search, then select to add to invoice.

Go to forum: Items and Inventory

12 Reply by albertolima

(2 replies, posted in Installation)

Solved. Thanks.
I searched around the word authentication, and was yielding inaccurate solutions.
The mentioned topic solved it.
Thanks.

Go to forum: Installation

13 Topic by albertolima

(2 replies, posted in Installation)

Hi team,

I am trying to setup a FA server behind Cloudlfare, through a standard plan, and I am having some issues with the session. FA keeps asking for authentication every now and then.

It works fine when I disable Cloudflare protection.

I've worked through different php.ini tweaks, tried several Cloudflare options... the issue is still there.
It seems the session expires/changes and then forces FA to request authentication.

My setup:
Digitalocean VPS running Ubuntu Server v18.04
FA v2.4.6
Cloudflare standard plan

**Any hints?

Thanks.

Go to forum: Installation

14 Reply by albertolima

(3 replies, posted in Installation)

I have been trying that one too, kind of complex to pick up the exact reason due to the amount of parameters.
I keep trying though, but in the meantime, would accept more suggestions.
Thanks @poncho1234.

Go to forum: Installation

15 Topic by albertolima

(3 replies, posted in Installation)

Hi team,

For some reason, I am not able to display any dashboard graphics on FA installations that I perform on my own VPS.
Installing on a shared hosting server (i.e., Dreamhost) it works well, graphics showing.

Tried today again with FA v2.4.6
PHP version on the VPS is 7.2.19-0ubuntu0.18.04.1.
PHP version on the shared hosting server: I have tried 7.1, 7.2 and 7.3 and all three work on the shared server.
So PHP is not the issue.

I am probably missing a component install on my VPS (or a config).

**Anyone may provide a hint??

Graphic showing fine on shared hosting
Graphic not displayed on VPS Ubuntu server

Go to forum: Installation

16 Reply by albertolima

(1 replies, posted in Items and Inventory)

From the Setup Tab, System and General Ledger Setup, you would see the option "Print Item Image on Quote:"

You may also take some minutes to go through the existing Wiki https://frontaccounting.com/fawiki/index.php?n=Help.SystemAndGeneralGLSetup&ctxhelp=1&lang=C

Go to forum: Items and Inventory

17 Reply by albertolima

(10 replies, posted in Setup)

Did you try to create a new transaction reference and set as default for the type Invoice?

Go to forum: Setup

18 Reply by albertolima

(2 replies, posted in Setup)

Maybe it would easier to either change provider or rent a VPS and deploy a clean Ubuntu based server.

Go to forum: Setup

19 Reply by albertolima

(3 replies, posted in Report Bugs here)

Thanks Apmuthu. Well noted.

Go to forum: Report Bugs here

20 Topic by albertolima

(3 replies, posted in Report Bugs here)

Hi all,
Just saw this vulnerability announced on the US National Vulnerability Database.
https://nvd.nist.gov/vuln/detail/CVE-2018-7176

It says:
Cross Site Request Forgery- Front Accounting ERP 2.4.3
FrontAccounting 2.4.3 suffers from a CSRF flaw, which leads to adding a user account via admin/users.php (aka the "add user" feature of the User Permissions page).

Do we have any security expert in the forum that could look into this?

CVE Dictionary Entry: CVE-2018-7176
Original release date: 02/15/2018
Last revised: 02/18/2018
Source: US-CERT/NIST

This vulnerability is currently awaiting analysis.
CVE-2018-7176 Detail: AWAITING ANALYSIS

Go to forum: Report Bugs here

21 Reply by albertolima

(27 replies, posted in Banking and General Ledger)

You probably divided instead of multiplying (or viceversa). As stated by @Dynamic, we would need to know your home currency, your rates, the foreign currency... so that we may provide some help by looking into it.

Go to forum: Banking and General Ledger

22 Reply by albertolima

(1 replies, posted in Banking and General Ledger)

@xodaix... From business perspective, for me as manager, it is somehow important to know if a transaction was edited or not. I should be able to print a list of all edited transactions too if needed. I believe from the technical point of view, it is easier and less complicated to create a new number than to change the old one.

Go to forum: Banking and General Ledger

23 Reply by albertolima

(1 replies, posted in Wish List)

General ledger reports - Audit trails

Also, if you do a journal search, you have the username on each line.

Go to forum: Wish List

24 Reply by albertolima

(2 replies, posted in Banking and General Ledger)

Hi. It should show under Banking Reports.

Go to forum: Banking and General Ledger

25 Reply by albertolima

(7 replies, posted in Items and Inventory)

Locking the price textbox is implemented here, but not in a clean FA way.

/includes/ui/ui_input.inc
Modified functions in order to account for an additional variable to lock the price textbox.
function amount_cells
function amount_cells_ex

/includes/ui/ui_lists.inc
Modified to disallow users to change the payment terms
function sale_payment_list

/sales/includes/ui/sales_credit_ui.inc
added line 287 to lock price textbox on credit notes

/sales/includes/ui/sales_order_ui.inc
added line 539 to lock price textbox on sales invoices and quotations

This is not at all a standard FA modification, but it does the job for me at the moment, while I/we find time to implement it cleanly. A good clean modification should disallow the salesman from the FA access menu, in a standard manner.
The files on the attached zip FA-LockCells.zip contain the modifications.

You may try on a test environment unzipping on the FA root folder and see if it fits your need.
These files attached here are for a v2.3.25 setup. I have done the same for v2.4rc.

This is a snapshot of the sales quotation form once implemented.

Go to forum: Items and Inventory