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 48 matches

by pauljj
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: 3501

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...
by pauljj
01 Jun 2018, 09:06
Forum: Sage 50 Report Designer
Topic: Service Item Lines being Duplicated when Printing
Replies: 12
Views: 12790

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...
by pauljj
22 May 2018, 12:18
Forum: Sage 50 Report Designer
Topic: Service Item Lines being Duplicated when Printing
Replies: 12
Views: 12790

Re: Service Item Lines being Duplicated when Printing

Hi Bruce,
Here is the attached.
INVOICE-CREDIT-WITH SERVCE-PRACTICE.layout
by pauljj
22 May 2018, 12:07
Forum: Sage 50 Report Designer
Topic: Service Item Lines being Duplicated when Printing
Replies: 12
Views: 12790

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...
by pauljj
18 May 2018, 07:46
Forum: Sage 50 UK version General Help
Topic: Customer Statements
Replies: 7
Views: 7621

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...
by pauljj
15 May 2018, 15:14
Forum: Sage 50 UK version General Help
Topic: Customer Statements
Replies: 7
Views: 7621

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...
by pauljj
14 May 2018, 15:24
Forum: Sage 50 Report Designer
Topic: Aged Creditors Extra Ref and duplication
Replies: 6
Views: 5679

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...
by pauljj
14 May 2018, 10:32
Forum: Sage 50 Report Designer
Topic: Aged Creditors Extra Ref and duplication
Replies: 6
Views: 5679

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...
by pauljj
09 May 2018, 11:34
Forum: Sage 50 Report Designer
Topic: Aged Creditors Extra Ref and duplication
Replies: 6
Views: 5679

Re: Aged Creditors Extra Ref and duplication

Should i be looking at the joins too ?
by pauljj
09 May 2018, 11:20
Forum: Sage 50 Report Designer
Topic: Aged Creditors Extra Ref and duplication
Replies: 6
Views: 5679

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...
by pauljj
08 Mar 2018, 12:46
Forum: Sage 50 Report Designer
Topic: Statements O/S to Excel Help
Replies: 3
Views: 3209

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...
by pauljj
08 Mar 2018, 12:38
Forum: Sage 50 Report Designer
Topic: Statements O/S to Excel Help
Replies: 3
Views: 3209

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...
by pauljj
08 Mar 2018, 12:04
Forum: Sage 50 Report Designer
Topic: Statements O/S to Excel Help
Replies: 3
Views: 3209

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...
by pauljj
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: 3938

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...
by pauljj
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: 3938

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 (?)