Search options (Page 3 of 5)

Didn't get any PM from you.

why don't you post here for everyone .

Hello @apmuthu hope this finds you well.

I have alter my payment table to add 2 extra column, check_no, source_ref to process my bank payments as all my bank payment require a checks, and cash payment voucher(source_ref). Now when I want to process a payment I get this error below:

What I understand is that the number of data being sent in the database does not correspond to the field required. Would you please tell me where I should add the 2 columns from UI?  I also wanted to put validation to check if a check no is already inserted to refuse duplicates.

Great Thanks!

array_combine(): Both parameters should have an equal number of elements in file: /var/www/html/fms/gl/includes/db/gl_db_banking.inc at line 394DATABASE ERROR : Cannot insert a source bank transaction
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for computer services, 1, '2021-01-07', '-10500', '0', 'Cedrick ')' at line 2
sql that failed was : INSERT INTO bank_trans (type, trans_no, bank_act, ref,check_no, source_ref, trans_date, amount, person_type_id, person_id) VALUES (1, 130, '3', '001/2021', payment for computer services, 1, '2021-01-07', '-10500', '0', 'Cedrick ')

@apmuthu I have followed all steps, I have even set the fiscal year to the same year of the depreciation beginning date, nothing still.
same message. I am using a straight line depreciation methods.

Sorry what do you mean by depreciation entries?

I follow the procedures:

1. create fixed asset class
2. create fixed asset category
3. fixed asset location
4. Create Fixed Asset Item with straight line depreciation
5. chose depreciation beginning date, then purchased Asset

But when I click depreciation i get that message

@kvvaradha millions thanks.

When I checked my database even though I didn't make any changes to the database I downloaded from the Official Repo,
In the table stock_category , category_id was not set to auto-increment.
I have just amended that, now I can create fixed asset category.

If I change the field trans_date to null and remove the default As define format 0000-00-00, I can ALTER the table, but It wont allow me to redefine the format to 0000-00-00

Same error again #Invalid format will appear

/gl/view/gl_payment_view.php?trans_no=3

Field Pay To is empty

Also in Bank statement Person/Item not showing

Is it happening for everyone?

@scendraw of course database field are Auto-incremental, especially if the field is a primary key. It doesn't matter whether you delete a record or not, the space is already taken, the next record will be auto-increment. So what you can do is update the structure of your table.

Syntax:
ALTER TABLE table_name AUTO_INCREMENT = start_value;

For Example:

ALTER TABLE Company AUTO_INCREMENT = 50;

Hope this help

@joe You're 100% right, actually the FA trial balance has no problem at all.

But a filter could be added to reduce the long list of all accounts, imagine if you have 2000 asset accounts, 1000 liabilities, Income and Expenses,
I doubt you will be able to read and understand your own trial balance. a filter can be added just like No Zero Balance and Balance Only check-boxes. Usually this is solved with subsidiary Ledger which I think is also missing in FA.

A subsidiary ledger contains the details to support a general ledger control account. For instance, the subsidiary ledger for accounts receivable contains the information for each of the company's credit sales to customers, each customer's remittance, return of merchandise, discounts, and so on. With these details in the subsidiary ledger, the Accounts Receivable account in the general ledger can report summary amounts for the accounts receivable activity.

This make it easy to read a trial balance. By the way it is there in FA for Balance Sheet & Profit Loss report. But not for Trial Balance if you noticed. @apmuthu