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 48 matches
- 11 Jul 2018, 12:58
- Forum: Sage 50 Report Designer
- Topic: Remittances Extra Ref-Batch Invoice(showing) vs Update Ledger(not showing)
- Replies: 1
- Views: 4065
Remittances Extra Ref-Batch Invoice(showing) vs Update Ledger(not showing)
Hi Bruce, Since working with the Extra Ref field we gave our remittance templates a makeover to suit our visual needs. Nothing changed in the joins etc. Part of this work was to bring the Extra Ref field in from the Remittances table, so we could see our purchase order number and the suppliers invoi...
- 01 Jun 2018, 09:06
- Forum: Sage 50 Report Designer
- Topic: Service Item Lines being Duplicated when Printing
- Replies: 12
- Views: 17392
Re: Service Item Lines being Duplicated when Printing
Bruce you genius!! I was just about to write to you as i'd remembered a difference between an invoice template that we use based on raising invoices from new, where the sales order information is not built in on the Order Tab, where it works no problem and this one we are looking at which is an invo...
- 22 May 2018, 12:18
- Forum: Sage 50 Report Designer
- Topic: Service Item Lines being Duplicated when Printing
- Replies: 12
- Views: 17392
Re: Service Item Lines being Duplicated when Printing
Hi Bruce,
Here is the attached.
Here is the attached.
- 22 May 2018, 12:07
- Forum: Sage 50 Report Designer
- Topic: Service Item Lines being Duplicated when Printing
- Replies: 12
- Views: 17392
Re: Service Item Lines being Duplicated when Printing
Hi Bruce, Just reading through this as i'm having a similar issue on the service lines printing multiple time, and i think for myself it's because I've included the GDN table which you helped me with a while back. I've managed to pull this expression in for the service line INVOICE.ITEM.TEXT field a...
- 18 May 2018, 07:46
- Forum: Sage 50 UK version General Help
- Topic: Customer Statements
- Replies: 7
- Views: 8466
Re: Customer Statements
Morning Bruce, That's perfect thank you!!! I had tried that account ref reset as that was making sense with what you've been educating me with over all my posts :) It was the Is cumulative function i was missing. I know i had been looking at it, reading it and then totally ignoring it, the answer wa...
- 15 May 2018, 15:14
- Forum: Sage 50 UK version General Help
- Topic: Customer Statements
- Replies: 7
- Views: 8466
Re: Customer Statements
Hi Bruce, i had the same issue initially, in the Header Number Footer section, my AUDIT_SPLIT.FOREIGN_AGED_BALANCE is reset to HEADER_NUMBER footer, as is the same for the debit and credit fields. However, when running multiple statements, while the total on each statement for each customer is corre...
- 14 May 2018, 15:24
- Forum: Sage 50 Report Designer
- Topic: Aged Creditors Extra Ref and duplication
- Replies: 6
- Views: 7763
Re: Aged Creditors Extra Ref and duplication
Hi bruce, I've tried every option of reset on the AUDIT_SPLIT.FOREIGN_AGED_BALANCE field but just can't quite figure out why i can't get it to work? am i looking a the correct field ? 15/05/18-hi Bruce, i think i may have confused my last couple of posts on the Age Creditors you help me fix and beca...
- 14 May 2018, 10:32
- Forum: Sage 50 Report Designer
- Topic: Aged Creditors Extra Ref and duplication
- Replies: 6
- Views: 7763
Re: Aged Creditors Extra Ref and duplication
Hi Bruce, thanks for this - i just knew it was something like that, i am getting there bit by bit so thank you for working this, it works great for this part. so, what I've noticed is now if i run more than one customer through the statement or indeed select multiple customers from the module and ru...
- 09 May 2018, 11:34
- Forum: Sage 50 Report Designer
- Topic: Aged Creditors Extra Ref and duplication
- Replies: 6
- Views: 7763
Re: Aged Creditors Extra Ref and duplication
Should i be looking at the joins too ?
- 09 May 2018, 11:20
- Forum: Sage 50 Report Designer
- Topic: Aged Creditors Extra Ref and duplication
- Replies: 6
- Views: 7763
Aged Creditors Extra Ref and duplication
Hi Bruce, I've read a few of the posts about the Extra Ref not showing on reports etc, that's not exactly my isssue. I have turned on the Sage setting to allow the splits to be shown. The issue is the duplication from the Audit Splits and the subsequent totalling. I've been trying to follow the Sage...
- 08 Mar 2018, 12:46
- Forum: Sage 50 Report Designer
- Topic: Statements O/S to Excel Help
- Replies: 3
- Views: 3627
Re: Statements O/S to Excel Help
Actually, forgot to ask, does anyone know how to re-order the fx fields in the report explorer? a bit like defining a tab order in say access reports ? this should then export the columns in order to excel, as they aren't at the moment. And also , how to have an expression field export aswell ? Than...
- 08 Mar 2018, 12:38
- Forum: Sage 50 Report Designer
- Topic: Statements O/S to Excel Help
- Replies: 3
- Views: 3627
Re: Statements O/S to Excel Help
Think i have sorted it, i pulled out Audit Splits headers and footers , and changed the report filter expression from AUDIT_SPLIT to AUDIT_HEADER AUDIT_HEADER.FOREIGN_AGED_BALANCE <> 0 AND AUDIT_HEADER.INV_REF NOT LIKE "REVAL" So after removing some hidden headers and footers , i created a...
- 08 Mar 2018, 12:04
- Forum: Sage 50 Report Designer
- Topic: Statements O/S to Excel Help
- Replies: 3
- Views: 3627
Statements O/S to Excel Help
Hi Bruce, Sage v24 When i export a basic customer Outstanding Statement via the Data To Excel function, i see each itemised line on the invoice with it's price. what i am attempting to do is to produce an excel sheet that will show the Invoice/Credit number, Customer name, customer PO ref and the gr...
- 16 Feb 2018, 13:44
- Forum: Sage 50 Report Designer
- Topic: Pick Lists How can i omit Non-Stock items from showing
- Replies: 4
- Views: 4704
Re: Pick Lists How can i omit Non-Stock items from showing
Hi Bruce, TYPE Type Description 0 Stock 1 Non Stock 2 Service So, should i include the IGNORE_STK_LVL_FLAG as a field in the report itself? I added it into the Details section to see what numbers would be returned, which shows like the above table. I added the filter into the LOCATION field and trie...
- 15 Feb 2018, 13:30
- Forum: Sage 50 Report Designer
- Topic: Pick Lists How can i omit Non-Stock items from showing
- Replies: 4
- Views: 4704
Re: Pick Lists How can i omit Non-Stock items from showing
Not sure what is happening with the 3 jpg's i attached but they appear to either have some missing or they are repeating for some reason (?)