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

by OLDandPR0UD
12 Oct 2015, 09:55
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

When I do this it only calculates the last line under the NETT amount.......
by OLDandPR0UD
08 Oct 2015, 11:26
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

Hi Bruce, think i may be getting mixed up....I have attached the relevant layout & a pdf version Showing whats required.
by OLDandPR0UD
07 Oct 2015, 18:20
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

I have tried that and the nett total at the bottom is still showing a discounted amount......I also got this using SOP_ITEM.FULL_NET_AMOUNT.
by OLDandPR0UD
06 Oct 2015, 18:47
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

Basically I quote 100.00 for a job, my customer passes the price onto his customer at 100.00 & then says that's my cost mate, I need to add a further 5% for my trouble. the customer see's he is only charging 5% & thinks that's a reasonable margin & places the order.

However if the quote said 100.00 ...
by OLDandPR0UD
01 Oct 2015, 09:57
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

Hi Bruce

Sorry my post should have said discounted total.

If you input line 1 with 3 x 10.00 with a 10% discount the line total shows 30.00 which is correct however in the footer details the Net value will show as 27.00, what I need is to either.

A: Have the footer total showing without discount ...
by OLDandPR0UD
01 Oct 2015, 08:07
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

Morning Bruce, I have just noticed that after I changed the quote so it doesn't show the discount on each line the total net at the bottom shows the discount total...just noticed this after sending out numerous quotes :(
by OLDandPR0UD
24 Sep 2015, 08:50
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

Thanks Bruce, that's exactly want I wanted :P

On another note is there a way to have the net price shown without the discount i.e. qty x Unit price, this way my customers discount is hidden off the quote but still shows on my sales order.

EDIT: Managed to work out how to show price without ...
by OLDandPR0UD
22 Sep 2015, 16:25
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Re: Separator lines in Sage Line 50 quotation

Hi brucedenney, I have had a look at the Sections tab & when I add a group section it opens an Expression editor...I have attached the layout but would love to work it out as I have a few changes in the pipeline so to speak.

On another note is there a way to have the net price shown without the ...
by OLDandPR0UD
22 Sep 2015, 09:27
Forum: Sage 50 Report Designer
Topic: Separator lines in Sage Line 50 quotation
Replies: 16
Views: 12724

Separator lines in Sage Line 50 quotation

Hi Guys, I'm new to this forum but not a total newbie so know the standard forum etiquette.

I currently own Sage Line 50 V13.02 for standard sales order processing & a separate quotation package, however I am now looking into the built in quotation part to save multiple typing...I have created my ...