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 ByGosh
09 Jun 2020, 13:01
Forum: Sage 50 Report Designer
Topic: Aged Creditors Report - duplicates invoices when using Extra Ref field
Replies: 10
Views: 9833

Re: Aged Creditors Report - duplicates invoices when using Extra Ref field

All sorted now thank you. I wasn't sure whether to change it to Audit_Split but your confirmation has corrected the problem.
by ByGosh
08 Jun 2020, 15:38
Forum: Sage 50 Report Designer
Topic: Aged Creditors Report - duplicates invoices when using Extra Ref field
Replies: 10
Views: 9833

Re: Aged Creditors Report - duplicates invoices when using Extra Ref field

Could both have been wrong before, but one fault was giving the same result as the other? I assumed that as both splits were showing the full invoice total on each line that the total had added the full invoice twice. Now I think that although one split is hidden it is adding the full invoice twice ...
by ByGosh
04 Jun 2020, 15:12
Forum: Sage 50 Report Designer
Topic: Aged Creditors Report - duplicates invoices when using Extra Ref field
Replies: 10
Views: 9833

Re: Aged Creditors Report - duplicates invoices when using Extra Ref field

Although your previous fix seemed to work, it seems to have reverted back to the initial problem. I have downloaded the report file again just to make sure I still had the one that had been corrected. All I have done since downloading the new report is to add a couple of months data and carry out a ...
by ByGosh
01 May 2020, 15:15
Forum: Sage 50 Report Designer
Topic: Aged Creditors Report - duplicates invoices when using Extra Ref field
Replies: 10
Views: 9833

Re: Aged Creditors Report - duplicates invoices when using Extra Ref field

You have summised correctly and your revision to the report works exactly as I was trying to create. I have yet to examine your alterations in the designer and how you have achieved the result. I am very grateful for the work you have done as it has probably saved me a few hours of trying to figure ...
by ByGosh
30 Apr 2020, 16:10
Forum: Sage 50 Report Designer
Topic: Aged Creditors Report - duplicates invoices when using Extra Ref field
Replies: 10
Views: 9833

Re: Aged Creditors Report - duplicates invoices when using Extra Ref field

Thank you for your reply.

You are probably correct as I have compacted the report as much as possible and deleted some of the fields that I thought I wouldn't need.

As suggested I have attached the report.

Many thanks, John
by ByGosh
30 Apr 2020, 15:04
Forum: Sage 50 Report Designer
Topic: Aged Creditors Report - duplicates invoices when using Extra Ref field
Replies: 10
Views: 9833

Aged Creditors Report - duplicates invoices when using Extra Ref field

Hi, I have been trying to adjust the Detailed Aged Creditors report to show a payment date for each invoice. When I enter invoices I type in the date I want the invoice to be paid in the Ex. Ref box, usually in the format 31.10.20, and in the case that some invoices are paid by direct debit I would ...