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
Search found 4593 matches
- Yesterday, 17:06
- Forum: Sage 50 UK version General Help
- Topic: For Ex Revaluation Transactions
- Replies: 4
- Views: 17
Re: For Ex Revaluation Transactions
"So when an Aged Creditors Report is run to 31/12/2023 it will so that there is still an outstanding amount rather than showing as completely cleared." When the transactions get matched, they are no longer outstanding so there is nothing to show on the aged report. If you have not matched ...
- Yesterday, 12:57
- Forum: Sage 50 Report Designer
- Topic: Drill downs on statement to access corresponding Invoice
- Replies: 3
- Views: 38
Re: Drill downs on statement to access corresponding Invoice
Yes anyone with the url can see it.
You can take steps to obfuscate it, but it is a poor solution.
You can take steps to obfuscate it, but it is a poor solution.
- Yesterday, 12:54
- Forum: Sage 50 UK version General Help
- Topic: For Ex Revaluation Transactions
- Replies: 4
- Views: 17
Re: For Ex Revaluation Transactions
The profit or loss on exchange happens when the bank transaction happens. So if you sel1 100EUR in Jan and pet paid 100EUR in Feb then the profit and loss transaction will happen in Feb, it can not happen on any other date. As the transaction is paid, it will have no impact on Aged Debtors/Creditors...
- 21 Mar 2024, 15:34
- Forum: Sage 50 Report Designer
- Topic: Invoice dynamic template if paid versus outstanding
- Replies: 5
- Views: 52
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.
You will, however, need to check if your bank is supported.
- 21 Mar 2024, 12:04
- Forum: Sage 50 Report Designer
- Topic: Invoice dynamic template if paid versus outstanding
- Replies: 5
- Views: 52
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...
- 19 Mar 2024, 15:22
- Forum: Sage 50 Report Designer
- Topic: Invoice dynamic template if paid versus outstanding
- Replies: 5
- Views: 52
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...
- 19 Mar 2024, 15:18
- Forum: Sage 50 Report Designer
- Topic: Drill downs on statement to access corresponding Invoice
- Replies: 3
- Views: 38
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...
- 19 Mar 2024, 12:26
- Forum: Sage 50 Report Designer
- Topic: Picking note totalling overall weight
- Replies: 9
- Views: 3369
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...
- 18 Mar 2024, 10:40
- Forum: Sage 50 UK version General Help
- Topic: Using ODBC sage 50 project activity report
- Replies: 6
- Views: 118
Re: Using ODBC sage 50 project activity report
Project Activity PJACT.report
- 18 Mar 2024, 10:38
- Forum: Sage 50 Report Designer
- Topic: If Blank Then
- Replies: 1
- Views: 26
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: 118
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: 23
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: 118
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: 27344
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: 4831
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.