Skip to main content

front accounting errors messages

DATABASE ERROR : The customer details could not be retrieved
error code : 1054
error message : Unknown column 'trans.type' in 'field list'
sql that failed was : SELECT 0_debtors_master.name,

0_debtors_master.curr_code, 0_payment_terms.terms,

0_debtors_master.credit_limit, 0_credit_status.dissallow_invoices,

0_credit_status.reason_description,

Sum(IFNULL(IFNULL(IF(trans.type=11 OR trans.type=12 OR

trans.type=2, -1, 1) * (trans.ov_amount + trans.ov_gst +

trans.ov_freight + trans.ov_freight_tax +

trans.ov_discount),0),0)) AS Balance, Sum(IF

((TO_DAYS('2011-09-18') - TO_DAYS(IF (trans.type=10,

trans.due_date, trans.tran_date))) >= 0,IFNULL(IF(trans.type=11 OR

trans.type=12 OR trans.type=2, -1, 1) * (trans.ov_amount +

trans.ov_gst + trans.ov_freight + trans.ov_freight_tax +

trans.ov_discount),0),0)) AS Due, Sum(IF ((TO_DAYS('2011-09-18') -

TO_DAYS(IF (trans.type=10, trans.due_date, trans.tran_date))) >=

30,IFNULL(IF(trans.type=11 OR trans.type=12 OR trans.type=2, -1,

1) * (trans.ov_amount + trans.ov_gst + trans.ov_freight +

trans.ov_freight_tax + trans.ov_discount),0),0)) AS Overdue1,

Sum(IF ((TO_DAYS('2011-09-18') - TO_DAYS(IF (trans.type=10,

trans.due_date, trans.tran_date))) >= 60,IFNULL(IF(trans.type=11

OR trans.type=12 OR trans.type=2, -1, 1) * (trans.ov_amount +

trans.ov_gst + trans.ov_freight + trans.ov_freight_tax +

trans.ov_discount),0),0)) AS Overdue2 FROM 0_debtors_master LEFT

JOIN 0_debtor_trans trans ON trans.tran_date <= '2011-09-18' AND 0_debtors_master.debtor_no = trans.debtor_no AND trans.type <> 13

, 0_payment_terms, 0_credit_status WHERE

0_debtors_master.payment_terms = 0_payment_terms.terms_indicator

AND 0_debtors_master.credit_status = 0_credit_status.id AND

0_debtors_master.debtor_no = '' GROUP BY 0_debtors_master.name,

0_payment_terms.terms, 0_payment_terms.days_before_due,

0_payment_terms.day_in_following_month,

0_debtors_master.credit_limit, 0_credit_status.dissallow_invoices,

0_credit_status.reason_description


Seems that system upgrade to version 2.1 has been performed for

this company already.
If something has gone wrong and you want to retry upgrade process

you MUST perform database restore from last backup file

first.Database upgrade to version 2.1 failed for company

'Windrolinx'.
You should restore company database from latest backup fileSQL

script execution failed in line 54: Table 'acc2.0_company' doesn't

existDatabase upgrade to version 2.3 failed for company

'Windrolinx'.
You should restore company database from latest backup file

SQL script execution failed in line 54: Table 'acc2.0_company'

doesn't existDatabase upgrade to version 2.3 failed for company

'Windrolinx'.
You should restore company database from latest backup file


System is blocked after source upgrade until database is updated

on System/Software Upgrade page

Popular posts from this blog

BSNL Broadband error

Dear Sir/Madam
As you are a premium Broadband user of BSNL,We would like to inform that you have exhausted your mandated broadband speed (as per plan chosen by you).
We want you to continue browsing at higher speed.
Please click on "Upgrade" option as per your convenience.

BSNL Broadband error code

Dear Sir/MadamAs you are a premium Broadband user of BSNL,We would like to inform that you have exhausted your mandated broadband speed (as per plan chosen by you).
We want you to continue browsing at higher speed.
Please click on "Upgrade" option as per your convenience. Dear Sir/Madam Sorry we could not process your request right now Please try after some time Reference Error Code: "1003" Please visithttp://www.bsnl.co.infor tariff details.
Kind regards
BSNL Broadband This page contains HTTP resources which may cause mixed content affecting security and user experience if blog is viewed over HTTPS. Fix Dismiss Learn more

tnpds - GOVERNMENT WEBSITE ERROR

Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback.
Sat Oct 22 19:03:39 IST 2016 There was an unexpected error (type=Not Found, status=404). /pages/registeracard/home.xhtml Not Found in ExternalContext as a Resource https://tnpds.com/pages/registeracard/