Hi, hoping someone may be able to help me!
I have converted my V10 SLY layouts to the V14.
They work with the exception of the Statement Layout which gives me this error:
ERROR [42S22] Column Not Found
No errors flag up in the error box when I preview the layout, but the pop up appears with this error.
Any idea where to look?
I have systematically removed all variables one by one until none are left, and removed any filters I can see.
I would prefer to convert the statement layout rather than have to re-create it!
Thanks in advance!
Martin.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
ERROR [42s22] Column Not Found
-
Lectrician
- User
- Posts: 6
- Joined: 03 Mar 2011, 08:19
- Sage Version: v2007 13 UK/Europe/Africa
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: ERROR [42s22] Column Not Found
You did the right things, there is a field of information that the report is asking for that no longer exists in the new version.
If you want to post the layout as an attachment I could have a quick look.
If you want to post the layout as an attachment I could have a quick look.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
Lectrician
- User
- Posts: 6
- Joined: 03 Mar 2011, 08:19
- Sage Version: v2007 13 UK/Europe/Africa
Re: ERROR [42s22] Column Not Found
Thanks for the input.
I have sent you the layout via PM - I think you should have it (shows in my outbox, not sent items.....)
Very greatful for the help!
I have sent you the layout via PM - I think you should have it (shows in my outbox, not sent items.....)
Very greatful for the help!
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: ERROR [42s22] Column Not Found
You have a header section called INVOICE_NUMBER this is not valid in an audit trial context.
If you delete the header it should work.
If you delete the header it should work.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
Lectrician
- User
- Posts: 6
- Joined: 03 Mar 2011, 08:19
- Sage Version: v2007 13 UK/Europe/Africa
Re: ERROR [42s22] Column Not Found
Thanks.
When I removed this header I recieved the below error instead, so assumed it had to stay.....
"No data was returned for this report."
It does this in the preview and when trying to print a statement.
Any ideas what I need to add in place of that header?
When I removed this header I recieved the below error instead, so assumed it had to stay.....
"No data was returned for this report."
It does this in the preview and when trying to print a statement.
Any ideas what I need to add in place of that header?
-
Lectrician
- User
- Posts: 6
- Joined: 03 Mar 2011, 08:19
- Sage Version: v2007 13 UK/Europe/Africa
Re: ERROR [42s22] Column Not Found
Hi, still struggling with this (when I get chance to have a look!).
When I remove the INVOICE_NUMBER header, it also removes the DATE FLAG footer. I assume this is what is casuing the "no data is being returned for this report" error?
I cannot figure out how to replace the DATE_FLAG footer?
Sorry, I don't use Sage very much, and the girl who does our accounts knows how to use it but not how to play with it as such!
Thanks for any info and pointers!
When I remove the INVOICE_NUMBER header, it also removes the DATE FLAG footer. I assume this is what is casuing the "no data is being returned for this report" error?
I cannot figure out how to replace the DATE_FLAG footer?
Sorry, I don't use Sage very much, and the girl who does our accounts knows how to use it but not how to play with it as such!
Thanks for any info and pointers!
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: ERROR [42s22] Column Not Found
Sounds like you are out of your depth, I think you need to go on a training course to use the report designer or hire someone to do it for you.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Semrush [Bot] and 1 guest