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

by SomeGuy
14 Nov 2022, 08:02
Forum: Sage 50 UK version General Help
Topic: Order Picking Report with stock Location
Replies: 5
Views: 4150

Re: Order Picking Report with stock Location

Sorting from groups always applies first so in your case the order will be by invoice number, item number and then location. To have it ordered by location first you'd need to restructure your report to either remove existing groupings, or to add a grouping on location. Hard to say from a screen sho...
by SomeGuy
20 Dec 2021, 08:00
Forum: Sage 50 UK version General Help
Topic: Page 1 of .....
Replies: 6
Views: 7565

Re: Page 1 of .....

I have played around with this kind of thing in the past and, whilst it is possible to get it to work, it is not simple/pretty so not something I would personally recommend. If you did want to try it you would have to add additional group header/footer sections to your label in Report Designer - You...
by SomeGuy
05 Oct 2021, 07:05
Forum: Sage 50 Report Designer
Topic: Expression with text string "\"
Replies: 8
Views: 10114

Re: Expression with text string "\"

I suspect your problem is not to do with the number extraction as such. Testing a simple expression like this one works fine: StringToFloat("10,000") One possible cause of the problem is with your Kgage expression: PROJECT.REFERENCE <> "" ?Remove(AUDIT_SPLIT.DETAILS,Length(AUDIT_...
by SomeGuy
26 Aug 2021, 06:19
Forum: Sage 50 UK version General Help
Topic: Page 1 of .....
Replies: 6
Views: 7565

Re: Page 1 of .....

REPORT.PAGES might be the expression you are looking for. This returns the total number of pages in the report. But as per Bruce's question it will depend somewhat on how the '10' is being determined as to whether it would be suitable or not.
by SomeGuy
10 Mar 2021, 06:59
Forum: Sage 50 Report Designer
Topic: Commercial Invoice
Replies: 8
Views: 8370

Re: Commercial Invoice

Auto grow would allow you to expand the section and add extra whitespace to accommodate the fields Exactly. The section was only a single line in height by default but through auto grow I had it expanding as needed. There was no whitespace to be removed. As I say I can't find the report I did this ...
by SomeGuy
09 Mar 2021, 07:21
Forum: Sage 50 Report Designer
Topic: Commercial Invoice
Replies: 8
Views: 8370

Re: Commercial Invoice

Could swear I have done this before but typically can't lay my hands on the layout I was thinking of now that I want it. From what I recall it was something using conditional formatting to modify the auto grow and padding, and allowing sections to overlap. Don't recall the exact detail, and from a b...
by SomeGuy
09 Mar 2021, 06:48
Forum: Sage 50 UK version General Help
Topic: Sage 50 - Global Nominal Code default?
Replies: 5
Views: 8025

Re: Sage 50 - Global Nominal Code default?

Ah, you mean when actually posting the invoice. I meant with the invoice artefact itself.
by SomeGuy
08 Mar 2021, 07:16
Forum: Sage 50 Report Designer
Topic: Commercial Invoice
Replies: 8
Views: 8370

Re: Commercial Invoice

brucedenney wrote: 04 Mar 2021, 10:41 The disadvantage of that approach is that the large whitespace will not be removed.
True. You'd need to get creative with conditional formatting to stop that
by SomeGuy
08 Mar 2021, 07:03
Forum: Sage 50 UK version General Help
Topic: Sage 50 - Global Nominal Code default?
Replies: 5
Views: 8025

Re: Sage 50 - Global Nominal Code default?

Oh I didn't know that the global nominal code saves space on the database. I know it creates issues on our reports when it is missing. Using a global nominal or not makes no difference to the space used in the database. There's no way to set a default global nominal within the software (thanks for ...
by SomeGuy
04 Mar 2021, 06:58
Forum: Sage 50 Report Designer
Topic: Commercial Invoice
Replies: 8
Views: 8370

Re: Commercial Invoice

An alternative approach for hiding the commodity code and weight would be to use conditional formatting on the expressions to suppress printing on them when the stock code is equal to "M"
by SomeGuy
15 Feb 2021, 07:57
Forum: Sage 50 UK version General Help
Topic: read/write version of ODBC driver
Replies: 10
Views: 10702

Re: read/write version of ODBC driver

One of the daftest things about the ODBC driver is that you can specify the delimiter. Sage chose the comma, which makes things like SQL Queries ambiguous in some contexts. Hence the not officially supported. Can't believe I find myself defending Sage here but you can't specify the delimiter charac...
by SomeGuy
15 Feb 2021, 07:04
Forum: Sage 50 UK version General Help
Topic: Sage50 OBDC - Frequency of querying Sage?
Replies: 10
Views: 10675

Re: Sage50 OBDC - Frequency of querying Sage?

I think I can curb it to 30 minutes update, that sounds sufficient? Sounds OK to me but it depends on how soon after entering a new invoice you need it to be visible in the warehouse. Obviously a delay could be anywhere from 0-30 minutes depending on the exact timings of the data entry and the sync...
by SomeGuy
11 Feb 2021, 08:04
Forum: Sage 50 UK version General Help
Topic: Sage50 OBDC - Frequency of querying Sage?
Replies: 10
Views: 10675

Re: Sage50 OBDC - Frequency of querying Sage?

Every 2 mins seems very frequent to me. I' agree with this every 2 minutes seems a tad excessive but it depends on how frequently the data is changing and the specifics of your use case. I worked on a project a few years ago where we extracted the data from Sage in to SQL Server and had created CRM...
by SomeGuy
11 Feb 2021, 07:43
Forum: Sage 50 UK version General Help
Topic: read/write version of ODBC driver
Replies: 10
Views: 10702

Re: read/write version of ODBC driver

Sage is not online, it is not always available so a restful api is not going to happen. Sounds like a lot of work as well. You don't have to be online to have a restful API. Sage has support for Sdata baked in to it and this works locally - https://sage.github.io/SData-2.0/pages/core/0100/. From wh...
by SomeGuy
28 Jan 2021, 08:57
Forum: Sage 50 UK version General Help
Topic: Inactive stock flag ODBC
Replies: 9
Views: 7685

Re: Inactive stock flag ODBC

There is no difference in the fields that are exposed between the 32 bit and 64 bit ODBC drivers as far as I am aware, and the problem cannot be data related. I believe that the problem you're hitting is that Access limits the number of fields in a linked table to 255 but the STOCK table in Sage has...