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.

We set up the home currency and all the related currency in the local settings using Peso account (PHP)

Under Purchases - Suppliers invoice, every time that we encode transactions on this part for payment and view its corresponding general ledger transactions details an account FOREIGN EXCHANGE GAIN OR LOSS is always appearing.

We are making a Peso to Peso transactions and payment, without using other currency, so there should be no FOREIGN EXCHANGE GAIN OR LOSS

How we can make not to automatically appear the FOREIGN EXCHANGE GAIN OR LOSS in general ledger transactions.

23

(1 replies, posted in Report Bugs here)

I was able to solve the file loading problem by switching javascipt off of my browser.
But is annoying to switch off and on my browser javascript when im using another applications.

Is there any other solution to solve the file loading in Front Accounting without resorting to
switching javascipt off in  browser?

Thanks

24

(1 replies, posted in Report Bugs here)

The warning below limits the file size that i attached. Please help of to fix this error

_______________________________________________________________
PHP Warning:  Unknown: POST Content-Length of 224 bytes exceeds the limit of -201326592 bytes in Unknown on line 0
________________________________________________________________

25

(6 replies, posted in Report Bugs here)

Hi Samar,

I followed your procedure below, but still i cannot attached a large file around 700kb.
Looking forward for any further help!

________________
Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

and then restart your server & mysql
_____________________