1

(5 replies, posted in Setup)

The PHP Version is 8.1.27   and  FA Version 2.4.17 Build 16.08.2024.  It is using  MariaDB version is 10.11.8   offers the same fundamental functionality as MySQL.    Were are using a newly installed  FA Version 2.4.17 Build 16.08.2024 using  MariaDB version is 10.11.8   and it works well.   Only during this migration issue that we encounter problem in attachments

apmuthu wrote:

What is your MySQL and PHP versions and which platform version are you on and which build version of FA v2.4 are you using?

2

(5 replies, posted in Setup)

Yes, I copied the second company that is why i placed it to company/1/attachments



kvvaradha wrote:

If you are checking in the first company than you must copied it to company/0/attachments

If you copied for the second company that's right. So you can try further by enabling debugging mode

3

(5 replies, posted in Setup)

We successfully upgraded FA from version 2.3 to 2.4, however the attached file cannot view and when we download it in FA system it has 0 file size.  We successfully uploaded the attached files in  /company/1/attachments  and it has -rw-r--r-- access   and each respective files have corresponding file size.

Is there any way to fix this

Rafat -Appreciate your information.   

Doing this will remove the  "Delayed" payment option in direct purchase invoice. We have other payment option set like bank account or Petty Cash account. We want to remain the  "Delayed" as an option  but we want the Petty Cash account as the default account when opening up the direct purchase invoice.

Looking forward for any reply... Thanks

rafat wrote:

@Marc
It is possible to do what you asked but you need to change the core a little bit.
in .../purchasing/po_entry_items.php around line 485 remove _('Delayed') so its like this:

 if ($_SESSION['PO']->trans_type == ST_SUPPINVOICE) {
    cash_accounts_list_row(_("Payment:"), 'cash_account', null, false,);
}

This will give you the list of your cash accounts with the default the first one in alphabetical order if you have more than one.
Beware the debit of the account is immediate and there is no need to go to Supplier Payment screen to pay your Suppliers.

Test it first and then use it if it serves your need.

Our inventory item in Inventory Valuation report have negative Unit Cost resulting to negative Total Value.

Any idea what makes it negative and how can we rectify to make the unit cost turn into positive

Hello, anyone who can assist me how to resolve this issue.  Thanks

A) Our first transaction is created in Sales - Direct Invoice- Direct Sales Invoice
    Payment set is -Cash Only
    Cash account set is -Bank account
    We have a direct cash revenue collection amounting to 100

After we placed the invoice, below are the generated journal entries when looking into the General Ledger Inquiry of our bank account

1) Sales Invoice journal entry (OK)
         
                 Bank account (debit) 100
                             Revenue (credit) 100     
                   
2) Customer Payment journal entry (take note below of the same debit and credit bank account created that is Unnecessary)
             Bank account (debit) 100     
                  Bank account (credit) 100


B)Our second transaction  is created in Purchases-  Direct Supplier Invoice - Direct Purchase Invoice Entry

Payment set is – Bank account and not Delayed
We have a direct cash payment purchase transaction amounting to 200

After we placed the invoice, below are the generated journal entries when looking into the General Ledger Inquiry of our bank account

1) Supplier Invoice journal entry (OK)
            Expense account (debit) 200     
                  Bank account (credit) 200
             
                   
2) Supplier Payment journal entry (take note below of the same debit and credit bank account created that is Unnecessary )
             Bank account (debit) 200     
                  Bank account (credit) 200

We notice that both journal entry marked as 2) that was created using separate transaction in Direct Sales Invoice Direct Purchase Invoice Entry  have the same debit and credit bank account which is unnecessary and will create only an additional file.   How can we make the system not to create the said unnecessary payment entry 2) for each separate transaction in  Direct Sales Invoice and Direct Purchase Invoice. Thanks

Hello rafat,

Thanks, its working, I also consider the PHP version

Hello rafat,

Below is the line 483   and they do that in FA ver 2.4.11

-----------------------------------------------
display_po_items($_SESSION['PO']);

start_table(TABLESTYLE2);


if ($_SESSION['PO']->trans_type == ST_SUPPINVOICE) {
    cash_accounts_list_row(_("Payment:"), 'cash_account', null, _false,);
}

textarea_row(_("Memo:"), 'Comments', null, 70, 4

Hello Rafat,

I try to do that but it result to an error below

Parse error: syntax error, unexpected ') in  /xxxx/purchasing/po_entry_items.php on line 483

In Direct Purchase Invoice Entry  the default payment is "Delayed", how we can change such default to our desired bank account for payment.

The reason why we want to change is that the default payment is "Delayed" and we do not want to always change it to our bank account every time we do processing the Direct Purchase Invoice Entry.

Hello,

We are looking for a developer who can customize  General Ledger Reports.

Provide you contact details or contact me if your are interested.

Thanks

How to edit the "Prices contain tax included:" from Yes to No under  Purchases -Supplier .  Once you have entered one transaction to a particular supplier  you cannot edit it anymore.

During the processing of Purchase Order Entry  it shows the tax rate I previously set up in  Setup-Tax Type-the Default Rate %.
Is there a way for me to hide the tax rate that shows during the processing of Purchase Order Entry.

Please let me know what file I need to edit in coding.

Thanks

I made a quick entries and during its payment in Bank Account Payment Entry the error appear "Cannot post to GL account used by more than one tax type"

How can I bypass this, the reality is that I indeed and need to post to GL account used by more than one tax type.

Please help what file I need to modify.

After adding various PO  and delivery  we click the Enter Invoice,  No changes or the supplier invoice is not created.

We are using ver 2.4.4 

Php ver 5.3

We changed the php.ini become Max_Input_Var to 999999.
The supplier GNR over than 100.

Please assist, any advice

This is a  Company  who used for the first time this software and without previous year will carry forward

The home currency is Euro, and still the same problem


apmuthu wrote:

What is the home currency?

I have 2 bank accounts (Euro and dollar accounts).  In setting up bank account in maintenance section i put Euro account as default bank account, however in making payment in Bank Account Payment Entry what keeps on appearing for the initial opening as default bank is the dollar account. 

However in purchases and payment to supplier it work, whatever I place as default bank will appear as the initial bank, but in Bank Account Payment Entry it never work.

Please help.

Need help,

How to set up supplier beginning balance for the start of the year in the supplier/purchases  module  without creating a journal entry.

As a new company we created a summary of journal entries with the balance sheet beginning balance for prior year. If we put a supplier invoices beginning supplier/purchases  module and if this will create a journal entry then it will double our payable since we have already that record in the beginning of the year summary of journal entries.

Where can I locate the save transaction in mysql database of frontaccounting.  It seems that I cannot locate the journal entries and its debit credit value.

Please help

Hi Joe,

I follow your instruction in detail by going to  Purchase Order Inquiry, select the PO for editing and  cancel the PO but another error message below appears

'This item cannot be deleted because some of it has already been received'

Any help?

Hello Janusz,

The PO that I will void is already received and not merely a PO.
I go to SETUP choose the PURCHASE ORDER DELIVERY and then select the PO number that i want to delete error message appears again ""cant be found or it has been voided"

Please help

I am using the latest 2.3.16 version and the same error appears"cant be found or it has been voided"  when voiding a received items or purchase order delivery, likewise inventory adjustment has no effect.

The main question is if I entered and received a purchased items like for example 10 units at the price of 100 each and found latter that its actually not received or erroneously encoded, where and how we can adjust and delete them  so that it will not be a part of any inventory reports when we do the pdf view or printing, and remove that erroneous  transaction in the  database system.

The Automatic Revaluation Currency Accounts is disabled (without check) in  the Company Setup before the execution of the said transaction but still the FOREIGN EXCHANGE GAIN OR LOSS accounts in general ledger transactions appears.