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

by gazmoz17
21 Mar 2024, 14:48
Forum: Sage 50 Report Designer
Topic: Invoice dynamic template if paid versus outstanding
Replies: 5
Views: 45

Re: Invoice dynamic template if paid versus outstanding

Thanks Bruce. So is the bank feed on merchant account a standard sage bank feed feature?

Can you email me details/prices for the the tool for sending emails please:


Thanks
by gazmoz17
21 Mar 2024, 10:55
Forum: Sage 50 Report Designer
Topic: Drill downs on statement to access corresponding Invoice
Replies: 3
Views: 30

Re: Drill downs on statement to access corresponding Invoice

Hi, thanks Bruce. Yeah thought this was maybe beyond me I didnt know if was possible to make a dyamic external link, I'm guessing thats what the web developer is...there hosting the invs? Whats the security issue?... the fact anyone can access the invoice if they have the link "www.hostwebsiteu...
by gazmoz17
21 Mar 2024, 10:43
Forum: Sage 50 Report Designer
Topic: Invoice dynamic template if paid versus outstanding
Replies: 5
Views: 45

Re: Invoice dynamic template if paid versus outstanding

Hi, thanks for this Bruce. No I havent really noticed the payment tab on invoices 🤦‍♂️ but we dont use it and I dont think we will. So I think it will be the SI header per your recommendation. Sort of linked to this, we have never setup bank feeds. Can see how this is huge time saver for allocating ...
by gazmoz17
19 Mar 2024, 13:45
Forum: Sage 50 Report Designer
Topic: Picking note totalling overall weight
Replies: 9
Views: 3188

Re: Picking note totalling overall weight

I was very close 😂...getting alright at variables, functions and the expression syntax in between (IF statements etc) but i still hate/dont get sections and their interdependence 🤦‍♂️
by gazmoz17
19 Mar 2024, 13:33
Forum: Sage 50 Report Designer
Topic: Drill downs on statement to access corresponding Invoice
Replies: 3
Views: 30

Drill downs on statement to access corresponding Invoice

Hi, Im new to drill downs but recently managed to parse the Delivery Postcode and a delivery tracking number (we insert into sage analysis 2 every day) to create a live tracking link. I've included these links to a dropshipping customer, we send him a daily statement with these links (alonside itemi...
by gazmoz17
19 Mar 2024, 13:08
Forum: Sage 50 Report Designer
Topic: Invoice dynamic template if paid versus outstanding
Replies: 5
Views: 45

Invoice dynamic template if paid versus outstanding

Hi Bruce, I was wondering if this is possible...or if there is a default invoice layout for this? User case: We post the daily sales invoices and then email them all at the end of play (4.15pm) each day. We semi often get a customer reply upon reciept of their daily email that this has already been ...
by gazmoz17
19 Mar 2024, 11:35
Forum: Sage 50 Report Designer
Topic: Picking note totalling overall weight
Replies: 9
Views: 3188

Re: Picking note totalling overall weight

Hi,

Yeah, due to complexity Bruce was able to do it for me as a custom report. Maybe worthwhile contacting him directly.

Take care.
by gazmoz17
28 Jun 2023, 10:31
Forum: Sage 50 Report Designer
Topic: Picking note totalling overall weight
Replies: 9
Views: 3188

Re: Picking note totalling overall weight

Everything is working how I require but i just can't sum these weights. When item contains a "KIT" I wish it to sum the indivi componemts of the kit rather than pull through that Kits SKU weight. The yellow highlighted are none kits just SKU's which contain a BOM and their showing indiv we...
by gazmoz17
28 Jun 2023, 08:01
Forum: Sage 50 Report Designer
Topic: Picking note totalling overall weight
Replies: 9
Views: 3188

Re: Picking note totalling overall weight

"You need to filter out the unwanted weights, one way would be to create a "Weight" Expression in the footer of the stock item, then add up the Weight expression to get your total."

Is this section the "footer of the stock item"?
Footer of stock item..PNG
Thanks
by gazmoz17
28 Jun 2023, 07:28
Forum: Sage 50 Report Designer
Topic: Picking note totalling overall weight
Replies: 9
Views: 3188

Re: Picking note totalling overall weight

Hi,

Thanks for this Bruce. Sorry didnt have time to get back to you yesterday....I jumped straight to trying to get it to work...unsuuccessfully 🤣 prob done it wrong per what youve advised.
I'll screen grab later at work what Ive done.

Thanks
by gazmoz17
27 Jun 2023, 14:40
Forum: Sage 50 Report Designer
Topic: Picking note totalling overall weight
Replies: 9
Views: 3188

Picking note totalling overall weight

Hi Bruce, This is a picking note template Ive started (well you helped me with section 5. ages ago) & I wish to sum the total weight at the bottom so we can quickly input onto our transport portal (currently manually calc weight from all the indiv item lines). This overall layout is prob only 30...
by gazmoz17
26 Oct 2022, 15:23
Forum: Sage 50 Report Designer
Topic: Invoice item field for cost price rather than last cost price (stock field)
Replies: 3
Views: 18764

Re: Invoice item field for cost price rather than last cost price (stock field)

Hi Bruce, Thanks for the reply, makes complete sense what you've said and would be a good way to do it. However, we dont use stock at all, we dont record it at all in sage or any system for that matter....I know dont ask 🙄out of my hands. Stock.PNG I didnt know if there was a work around, not for hi...
by gazmoz17
21 Oct 2022, 14:15
Forum: Sage 50 Report Designer
Topic: Invoice item field for cost price rather than last cost price (stock field)
Replies: 3
Views: 18764

Invoice item field for cost price rather than last cost price (stock field)

Hi, Is there such a field. E.g. cost price equivalent of these sales price fields. INVOICE_ITEM.FOREIGN_UNIT_PRICE INVOICE_ITEM.FOREIGN_NET_AMOUNT So that I can run historical Inv profit reports and profit is correct,as its referencing the inv cost price at the time of inv (as does for fields above ...
by gazmoz17
13 Oct 2022, 07:08
Forum: Sage 50 Report Designer
Topic: Invocie summary report (Total qty via web cat 1)
Replies: 4
Views: 20319

Re: Invocie summary report (Total qty via web cat 1)

Apologies, I had given it a lot of attempts before asking for help orig!...but think Ive cracked it (in wrong section and needs to have a reset section. Juts dont get tehse parts of report designer need to re-red the material instead of guessing stuff. Thanks
by gazmoz17
12 Oct 2022, 14:55
Forum: Sage 50 Report Designer
Topic: Invocie summary report (Total qty via web cat 1)
Replies: 4
Views: 20319

Re: Invocie summary report (Total qty via web cat 1)

Hi Bruce, I've just tried calling you (left a voice mail) it's regarding my last post here. Just so you can make sense of my rambling voice mail 😂. Might be easier just going off the excels at first. Columns F:O are summing certain component weights. Report works correctly when ran on individual SKU...