It's really easy to useIt'll be future proofHas links Exchequer Payroll Software and can cost payroll to jobs from timesheetsLabour can be Job Costed without a payroll system link if need be (say if you use a Payroll Beaurea)Purchased items can be costed directly to jobs without entering to stock first if you want toHas Sales Ordering and Purchase Ordering which updates the job costsIt can analyse the job costs using a different structure than the Chart Of Accounts so that the Chart Of Accounts can be as simple or complex as you likePrint Forms can be created so that you don't need to use preprinted stationeryYou can email invoices in PDF format to clients if you want toIt also has an easy to use Visual Report Writer that can help produce any reports neededIt links directly to Excel for another easy to use report writing tool
IMHO I wasn't keen on Quick Books at all from what I've seen of it but I'm not an expert in that system so you'll have to compare for yourself.
Yes, Access can calculate values too. Using the Query Builder GUI from end does allow you to define an Expression.
ExpressionName : [table name].[fieldname] *0.1
This would give you 10% if fieldname is a numeric value. You can do other things like you can in Excel and there's an Expression Builder tool too that helps you create them.
Printing to dotmatrix printers is pretty standard stuff and lots of software suffer from the same issues.
Make sure when you load the paper into the printer that you use the paper loading facility - printers know where the paper has been moved to when you manually move it. If you are unsure then once you have lined up the paper then switch off the printer for a few seconds and then turn it back on again.
Also, you mentioned using 11" (Letter) sized layouts. If this is a setting that is in the form designer of sage then I recommend that you look at the print driver and make sure that the default paper size is set to the correct size - the actual size of a sheet of paper from the continuous papererererererer...
If it's not this then does the print look like it has an empty line inbetween each line?
I used to use Exchequer on 64bit XP with the 64bit Pervasive Engine and it worked like a dream. I think that they also tested Vista 64bit ages ago so that should be good too. Therefore I don't think that the issue is about 64bit but you could always try running the set up utility in Windows Vista \ XP compatibility mode to see what happens and amending the short cuts it creates exactly the same.
Rich
btw IRIS Accounts Office and Exchequer share a lot of technical similarities is where I was going with this.
You could try writing a function specifically for this. I've put a skeleton together but has no error trapping so you need to do this. Basically in the spreadsheet you would enter something like "=GetInvoiceValue(A2:B5, 1)" and it would return the value.
Function GetInvoiceValue(ByRef TheDataTable As Range, ByRef TheInvoiceNumber As Variant)
Dim InvoiceValue As Double
InvoiceValue = 0#
With TheDataTable
With .Rows
For DataRow = 1 To .Count
If .Cells(DataRow, 1).Value = TheInvoiceNumber Then
I'm a little confused about what you actually want to happen. Given that you have for each invoice a Column A value and a Column B value I'm wondering what Column the Invoice Number is in. Can you tell me?
Also, what is meant to be returned? The value in A or B regardless? Is it possible to have a value in A & B and if so what happens then?
If you expand on what you want then I might be able to help.
My answers
Row Column notation
I find this notation really helpful when doing macros. Has anyone with VBA skills been playing with your spreadsheet?
Just a thought!
IRIS Exchequer
Hi
Exchequer is worth a look at.
It's really easy to useIt'll be future proofHas links Exchequer Payroll Software and can cost payroll to jobs from timesheetsLabour can be Job Costed without a payroll system link if need be (say if you use a Payroll Beaurea)Purchased items can be costed directly to jobs without entering to stock first if you want toHas Sales Ordering and Purchase Ordering which updates the job costsIt can analyse the job costs using a different structure than the Chart Of Accounts so that the Chart Of Accounts can be as simple or complex as you likePrint Forms can be created so that you don't need to use preprinted stationeryYou can email invoices in PDF format to clients if you want toIt also has an easy to use Visual Report Writer that can help produce any reports neededIt links directly to Excel for another easy to use report writing tool
IMHO I wasn't keen on Quick Books at all from what I've seen of it but I'm not an expert in that system so you'll have to compare for yourself.
Rich
Formulae in Access
Hi
Yes, Access can calculate values too. Using the Query Builder GUI from end does allow you to define an Expression.
ExpressionName : [table name].[fieldname] *0.1
This would give you 10% if fieldname is a numeric value. You can do other things like you can in Excel and there's an Expression Builder tool too that helps you create them.
http://office.microsoft.com/en-us/access-help/use-the-expression-builder-HA010236949.aspx?CTT=5&origin=HA010254902
Some training sessions on MS website
I assume you're on MS Access 2003
http://office.microsoft.com/en-us/access-help/access-2003-training-courses-HA001118951.aspx
but this is 2010
http://office.microsoft.com/en-us/access-help/CH010372755.aspx
and this is 2007
http://office.microsoft.com/en-us/access-help/CH010224776.aspx
The webiste for this stuff now is really good.
http://office.microsoft.com/en-us/access-help/?CTT=97
Hope some of this helps
Not a Sage Expert but...
Printing to dotmatrix printers is pretty standard stuff and lots of software suffer from the same issues.
Make sure when you load the paper into the printer that you use the paper loading facility - printers know where the paper has been moved to when you manually move it. If you are unsure then once you have lined up the paper then switch off the printer for a few seconds and then turn it back on again.
Also, you mentioned using 11" (Letter) sized layouts. If this is a setting that is in the form designer of sage then I recommend that you look at the print driver and make sure that the default paper size is set to the correct size - the actual size of a sheet of paper from the continuous papererererererer...
If it's not this then does the print look like it has an empty line inbetween each line?
Rich
edhy
Hi
I was doing my best to keep it simple but it seems I missed. Yes, the roundup option to findout what page it is works a treat.
Rich
Use Subtotal
Hi
I'm assuming you mean 31 rows per page
Insert a column to the left of your data and enter "Section" in cell A1 (assuming this all starts at the top)
Enter 1 in cell A2
Enter =IF(MOD(ROW(B3),31)<>0,A2, A2+1) in cell A3
Copy this formula all the way down the page until the data rows finish.
Select A1
Click Data \ Subtotal from the menu
Check all 3 boxes at the bottom and make sure you use "At Each Change in Section"
You should find the page split into sections of 31 with page breaks
Formula explained
ROW (B3) returns the row number
MOD(ROW(B3),31) returns the remainder of the row number divided by 31
If the remainder of the MODulous of the row divided by 31 is zero then this is a new section so add 1 to the section number from the row above.
You then use the section number for the subtotal to do its work.
Rich
64 bit
Hi
I used to use Exchequer on 64bit XP with the 64bit Pervasive Engine and it worked like a dream. I think that they also tested Vista 64bit ages ago so that should be good too. Therefore I don't think that the issue is about 64bit but you could always try running the set up utility in Windows Vista \ XP compatibility mode to see what happens and amending the short cuts it creates exactly the same.
Rich
btw IRIS Accounts Office and Exchequer share a lot of technical similarities is where I was going with this.
SUMIF
Forgot about that one!
VBA Solution
Hi
You could try writing a function specifically for this. I've put a skeleton together but has no error trapping so you need to do this. Basically in the spreadsheet you would enter something like "=GetInvoiceValue(A2:B5, 1)" and it would return the value.
Function GetInvoiceValue(ByRef TheDataTable As Range, ByRef TheInvoiceNumber As Variant)
Dim InvoiceValue As Double
InvoiceValue = 0#
With TheDataTable
With .Rows
For DataRow = 1 To .Count
If .Cells(DataRow, 1).Value = TheInvoiceNumber Then
InvoiceValue = InvoiceValue + CDbl(.Cells(DataRow, 2).Value)
End If
Next DataRow
End With
End With
GetInvoiceValue = InvoiceValue
End Function
Anonymous
Hi
I'm a little confused about what you actually want to happen. Given that you have for each invoice a Column A value and a Column B value I'm wondering what Column the Invoice Number is in. Can you tell me?
Also, what is meant to be returned? The value in A or B regardless? Is it possible to have a value in A & B and if so what happens then?
If you expand on what you want then I might be able to help.
Rich