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

Search found 4590 matches

by brucedenney
21 Mar 2024, 15:34
Forum: Sage 50 Report Designer
Topic: Invoice dynamic template if paid versus outstanding
Replies: 5
Views: 44

Re: Invoice dynamic template if paid versus outstanding

Bank feeds are available for all sorts of bank accounts, personal credit cards... they are a generic solution to all sage products, not just Sage 50

You will, however, need to check if your bank is supported.
by brucedenney
21 Mar 2024, 12:04
Forum: Sage 50 Report Designer
Topic: Invoice dynamic template if paid versus outstanding
Replies: 5
Views: 44

Re: Invoice dynamic template if paid versus outstanding

Merchant Services accounts are typically set up as separate bank accounts, so you instantly receive the money to the merchant services account then everyday a single transaction happens between the merchant services account and the main bank account transferring the value of a bunch of transaction f...
by brucedenney
19 Mar 2024, 15:22
Forum: Sage 50 Report Designer
Topic: Invoice dynamic template if paid versus outstanding
Replies: 5
Views: 44

Re: Invoice dynamic template if paid versus outstanding

If you are using the payment tab on the invoice to record receipt then yes, as all the data you need is the AMOUNT_PAID and you have that. Otherwise it is linking to the SI header, where you can access the OUTSTANDING amount You need to think about edge cases like part payment and how to deal with t...
by brucedenney
19 Mar 2024, 15:18
Forum: Sage 50 Report Designer
Topic: Drill downs on statement to access corresponding Invoice
Replies: 2
Views: 28

Re: Drill downs on statement to access corresponding Invoice

The way I have done this in the past was with the help of a web developer. I set up the invoices so when they were emailed a copy got sent to the website and put on the webserver. I could then create a link to open the web page with the pdf. There are issues with this, there is no security unless yo...
by brucedenney
19 Mar 2024, 12:26
Forum: Sage 50 Report Designer
Topic: Picking note totalling overall weight
Replies: 9
Views: 3119

Re: Picking note totalling overall weight

It is complex, but you can break it down into smaller steps and do it yourself. You need 3 bits The Weight according to the StockCode (only relevant where there is no BOM) The sum of of all the weights of all the BOM items (only relevant when there is a BOM) The BOM items will be the "details&q...
by brucedenney
18 Mar 2024, 10:40
Forum: Sage 50 UK version General Help
Topic: Using ODBC sage 50 project activity report
Replies: 6
Views: 108

Re: Using ODBC sage 50 project activity report

Screenshot 2024-03-18 104009.jpg
Project Activity PJACT.report
by brucedenney
18 Mar 2024, 10:38
Forum: Sage 50 Report Designer
Topic: If Blank Then
Replies: 1
Views: 23

Re: If Blank Then

I think you need to add the else option and tell it what to use if the condition is false.

Code: Select all

Condition?TrueValue:FalseValue
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?
by brucedenney
15 Mar 2024, 10:42
Forum: Sage 50 UK version General Help
Topic: Using ODBC sage 50 project activity report
Replies: 6
Views: 108

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
Project Joins.png
by brucedenney
13 Mar 2024, 11:09
Forum: Sage 50 Report Designer
Topic: Which Data Table Holds Customer Receipt Transactions
Replies: 1
Views: 18

Re: Which Data Table Holds Customer Receipt Transactions

it is the AUDIT_HEADER table, look for transactions of Type SA or SR
by brucedenney
13 Mar 2024, 11:08
Forum: Sage 50 UK version General Help
Topic: Using ODBC sage 50 project activity report
Replies: 6
Views: 108

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
by brucedenney
05 Jan 2024, 14:13
Forum: Bookkeeping and Management Accounting
Topic: Bookkeeping tool
Replies: 4
Views: 26987

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 ...
by brucedenney
29 Nov 2023, 12:25
Forum: Sage 50 UK version General Help
Topic: Supressed Printing BOMs
Replies: 2
Views: 4438

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.
by brucedenney
24 Nov 2023, 16:31
Forum: Sage 50 UK version General Help
Topic: Sage Line 50 and LibreOffice Base
Replies: 1
Views: 4145

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...
by brucedenney
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: 4234

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...
by brucedenney
23 Oct 2023, 13:38
Forum: Sage 50 UK version General Help
Topic: v16 installation Issues
Replies: 5
Views: 5049

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...