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
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by Marc
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
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.
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
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
________________________________________________________________
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
_____________________
FrontAccounting forum → Posts by Marc
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.