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

by Flimsykitty
16 Mar 2015, 17:53
Forum: Sage 50 Report Designer
Topic: Days Overdue
Replies: 9
Views: 7038

Re: Days Overdue

I've got the first payment letter working now, other than it won't show the invoice details on print preview but it does print :-/

However, is there a way of Sage inputting the date that the first letter was sent in to the second letter? I can see that it will as I can't see that it records when ...
by Flimsykitty
16 Mar 2015, 16:54
Forum: Sage 50 UK version General Help
Topic: Allocating Stock
Replies: 5
Views: 3962

Re: Allocating Stock

How I get around this on our system is create sales orders that will give you the option of allocating the stock but doesn't create the invoice until you tell Sage that you have despatched the order.

Not sure if this is something that could help you?
by Flimsykitty
06 Mar 2015, 10:59
Forum: Sage 50 Report Designer
Topic: Days Overdue
Replies: 9
Views: 7038

Re: Days Overdue

Yes sorry it was a .letter file but I had to change it to a .report to attach it.

Thank you for the attached .letter file. That works great and I'm quite happy to show the days overdue per invoice but it is showing in a minus figure, is there a way this be changed to a positive number?
by Flimsykitty
02 Mar 2015, 17:17
Forum: Sage 50 Report Designer
Topic: Days Overdue
Replies: 9
Views: 7038

Re: Days Overdue

Is this what your after?
by Flimsykitty
02 Mar 2015, 10:15
Forum: Sage 50 Report Designer
Topic: Days Overdue
Replies: 9
Views: 7038

Re: Days Overdue

I've attached pictures of the report in designer view and then when it previews for a customer. I just used a standard letter from Sage and have amended it with data and text fields.

If there are fields that aren't needed or not correct please excuse this as I am new to report designer and learning ...
by Flimsykitty
27 Feb 2015, 14:50
Forum: Sage 50 Report Designer
Topic: Days Overdue
Replies: 9
Views: 7038

Days Overdue

Hi I'm a newbie to the forum but I have been looking through previous posts to get some help with overdue letters that I want to send out to customers as part of our credit control.

I have used the expression REPORT.DATE-AUDIT_HEADER.DUE_DATE to calculate how many days overdue an account is but it ...