Screenshot 2024-03-18 104009.jpg
Project Activity PJACT.reportNeed 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
Search found 4585 matches
- Yesterday, 10:40
- Forum: Sage 50 UK version General Help
- Topic: Using ODBC sage 50 project activity report
- Replies: 6
- Views: 22
Re: Using ODBC sage 50 project activity report
Project Activity PJACT.report
- Yesterday, 10:38
- Forum: Sage 50 Report Designer
- Topic: If Blank Then
- Replies: 1
- Views: 9
Re: If Blank Then
I think you need to add the else option and tell it what to use if the condition is false.
I am not sure what SPLIT.STMT_TEXT is supposed to be as there is no table called SPLIT
What is SPLIT.STMT_TEXT ?
Perhaps you could attach the layout/report to your post?
Code: Select all
Condition?TrueValue:FalseValue
What is SPLIT.STMT_TEXT ?
Perhaps you could attach the layout/report to your post?
- 15 Mar 2024, 10:42
- Forum: Sage 50 UK version General Help
- Topic: Using ODBC sage 50 project activity report
- Replies: 6
- Views: 22
Re: Using ODBC sage 50 project activity report
The trouble with linking in all the tables is that is get very slow, so if you can skip some you can speed it up.
The relationships can be found by editing one of the project reports
The relationships can be found by editing one of the project reports
- 13 Mar 2024, 11:09
- Forum: Sage 50 Report Designer
- Topic: Which Data Table Holds Customer Receipt Transactions
- Replies: 1
- Views: 8
Re: Which Data Table Holds Customer Receipt Transactions
it is the AUDIT_HEADER table, look for transactions of Type SA or SR
- 13 Mar 2024, 11:08
- Forum: Sage 50 UK version General Help
- Topic: Using ODBC sage 50 project activity report
- Replies: 6
- Views: 22
Re: Using ODBC sage 50 project activity report
I am not sure, you select the field you want, I don't know what field you want.
If you are trying to find the names of fields, then there is a tool here to help you do that.
https://my.sage.co.uk/public/ask/images ... 8.html?v=2
If you are trying to find the names of fields, then there is a tool here to help you do that.
https://my.sage.co.uk/public/ask/images ... 8.html?v=2
- 05 Jan 2024, 14:13
- Forum: Bookkeeping and Management Accounting
- Topic: Bookkeeping tool
- Replies: 4
- Views: 26527
Re: Bookkeeping tool
There are lots of accounting packages out there, whilst reading reviews and demos may help, the only way to see if an accounting package meets your needs is to test it out. Don't burn bridges, if your new system does not meet expectations you need something to go back to. With any software the help ...
- 29 Nov 2023, 12:25
- Forum: Sage 50 UK version General Help
- Topic: Supressed Printing BOMs
- Replies: 2
- Views: 3902
Re: Supressed Printing BOMs
Suppressing the print will leave a blank line.
Hopefully you have a section that is being used, in which case instead of using an expression to suppress the line, use the same expression to filter the section.
If you still have issues attach your attempt to your replay and I will take a look.
Hopefully you have a section that is being used, in which case instead of using an expression to suppress the line, use the same expression to filter the section.
If you still have issues attach your attempt to your replay and I will take a look.
- 24 Nov 2023, 16:31
- Forum: Sage 50 UK version General Help
- Topic: Sage Line 50 and LibreOffice Base
- Replies: 1
- Views: 3620
Re: Sage Line 50 and LibreOffice Base
I seem to remember the Data Pilot didn't work, this is because Sage uses a delimiter in the ODBC driver that makes the SQL ambiguous. What I found was that you could do the query, in MSQuery with Excel, then copy the SQL and it works fine. I have not used LibreOffice for a long time so I can't comme...
- 09 Nov 2023, 11:54
- Forum: Sage 50 Report Designer
- Topic: How to omit a specific product from appearing on Sales order layout?
- Replies: 1
- Views: 3524
Re: How to omit a specific product from appearing on Sales order layout?
Hi It is a little unclear what you are trying to do. The first section ITEM_NUMBER Header is typically there just to help line things up. If you click on it's heading you should see it has a filter on it set to false to prevent it ever printing. The next 2 sections have filters so that one print whe...
- 23 Oct 2023, 13:38
- Forum: Sage 50 UK version General Help
- Topic: v16 installation Issues
- Replies: 5
- Views: 4517
Re: v16 installation Issues
That suggests that your Sage is of an age that it doesn't care about the version watermarks, perhaps you can just use it as is, without the bother of reinstalling. The difference in version numbers seems pretty insignificant. Getting old programs to install is a right PITA there are no warranties or...
- 23 Oct 2023, 09:45
- Forum: Sage 50 UK version General Help
- Topic: v16 installation Issues
- Replies: 5
- Views: 4517
Re: v16 installation Issues
In my installation, I am on version 16.0.14.147
You must have got an update that none of us have anymore.
The only thing I can suggest is uninstalling all the version 16.0.17.0158 installs and reinstalling them all as 16.0.14.147
You must have got an update that none of us have anymore.
The only thing I can suggest is uninstalling all the version 16.0.17.0158 installs and reinstalling them all as 16.0.14.147
- 19 Oct 2023, 09:42
- Forum: Sage 50 Report Designer
- Topic: Struggling to find Field Data / PDF formatting issue
- Replies: 3
- Views: 2702
Re: Struggling to find Field Data / PDF formatting issue
See your detail section
It has a huge white area between it and the report footer.
Drag the bottom of the details section (top of the footer section) up so it is tight to the fields and this will resolve the gap.
It has a huge white area between it and the report footer.
Drag the bottom of the details section (top of the footer section) up so it is tight to the fields and this will resolve the gap.
- 18 Oct 2023, 11:32
- Forum: Sage 50 Report Designer
- Topic: Struggling to find Field Data / PDF formatting issue
- Replies: 3
- Views: 2702
Re: Struggling to find Field Data / PDF formatting issue
The huge gaps are probably a large section, just move everything up close and it should be good. There is no annual salary in payroll, the amount a person is paid can vary form week to week or month to month. You could approximate an annual salary by multiplying the period salary by 52 (or maybe 53 ...
- 02 Oct 2023, 09:52
- Forum: Sage 50 UK version General Help
- Topic: Password rejected.
- Replies: 4
- Views: 3905
Re: Password rejected.
If you want to install legacy app onto Win 10/11 then the secret is to install them somewhere other than the Program Files or Program Files (x86) folder. I typically create a fold called ProgramFilesXP. Windows introduced extra restrictions on the Program Files folder that legacy applications do not...
- 25 Sep 2023, 15:11
- Forum: Sage 50 UK version General Help
- Topic: Password rejected.
- Replies: 4
- Views: 3905
Re: Password rejected.
Version 10 was a long long time ago so not so easy to help.
Can you access the demo data?
If not then I suspect that sage was installed by a different user, deleting the RSA crypto keys might resolve it.
In windows 11 they are in C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys
Can you access the demo data?
If not then I suspect that sage was installed by a different user, deleting the RSA crypto keys might resolve it.
In windows 11 they are in C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys