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

by brucedenney
18 Oct 2024, 14:52
Forum: Sage 50 UK version General Help
Topic: Price Calculation Method
Replies: 3
Views: 914

Re: Price Calculation Method

If you want to keep things as they are then do nothing.

I thought you wanted to change it.
by brucedenney
18 Oct 2024, 13:09
Forum: Sage 50 UK version General Help
Topic: Price Calculation Method
Replies: 3
Views: 914

Re: Price Calculation Method

Is this in Price Lists? If so, you can import them. If you need to do a lot of changes, then using something like ImportPlus you can import the pricelists. There are a number of price lists tools other than vanilla imports, e.g. a tool that creates price lists when discounts are given to give the ...
by brucedenney
04 Oct 2024, 11:05
Forum: Sage 50 UK version General Help
Topic: Sage 50 Accounts Professional - Stock Lead times
Replies: 3
Views: 702

Re: Sage 50 Accounts Professional - Stock Lead times

The date on the purchase order is an 2 places.

There is one on the order and then multiple ones for each item.

Which you use depends on when the goods will be delivered. The whole order or in parts.

Note there are DUE_DATE and an DELIVERY_DATE which are easy to confuse.
by brucedenney
04 Oct 2024, 09:36
Forum: Sage 50 UK version General Help
Topic: Sage 50 Accounts Professional - Stock Lead times
Replies: 3
Views: 702

Re: Sage 50 Accounts Professional - Stock Lead times

You could work out the lead times by looking for GI transactions in Stock_Tran and comparing the date they were received to the date they were ordered on the PO. Not sure what you would then do with that. If you are building a model of stock requirements then, that is very dependant on the business ...
by brucedenney
26 Sep 2024, 09:38
Forum: Sage 50 Report Designer
Topic: Converting templates when turning on sales orders
Replies: 1
Views: 1388

Re: Converting templates when turning on sales orders

You can't convert reports, they refer to different variables in different tables.

You can use templates to apply a look and feel to all reports.
by brucedenney
19 Sep 2024, 09:52
Forum: Sage 50 UK version General Help
Topic: ODBC connection fail
Replies: 1
Views: 1806

Re: ODBC connection fail

Please attach the SageDB dsn
by brucedenney
17 Sep 2024, 09:46
Forum: Sage 50 Report Designer
Topic: Report designer page break when selecting a few invoices
Replies: 3
Views: 4102

Re: Report designer page break when selecting a few invoices

Put a page break after on the invoice footer section.
by brucedenney
16 Sep 2024, 09:58
Forum: Sage 50 Report Designer
Topic: Report designer page break when selecting a few invoices
Replies: 3
Views: 4102

Re: Report designer page break when selecting a few invoices

You need to add a section for the invoice number so it can split, see this.
Invoice pick list by location new.REPORT
by brucedenney
06 Sep 2024, 10:34
Forum: Sage 50 UK version General Help
Topic: Sage V29 invoice Update
Replies: 1
Views: 3729

Re: Sage V29 invoice Update

There are a number of things that can cause this.

Do some file maintenance. A reindex and compress and see if that helps.
by brucedenney
28 Jun 2024, 10:54
Forum: Sage 50 UK version General Help
Topic: BOM
Replies: 2
Views: 10173

Re: BOM

The stock transfer is set up using a BOM Create your sample product code, go to the BOM tab and enter the recipe to make it, add the source product and in the Qty enter 0.1 if you get 10 samples or 0.833 if you get 12. Once setup, you can do a stock transfer enter the product you want to make and ...
by brucedenney
11 Jun 2024, 09:34
Forum: Sage 50 Report Designer
Topic: Conditional format....limitations?
Replies: 5
Views: 14619

Re: Conditional format....limitations?

So just select grey and the job is done.
by brucedenney
07 Jun 2024, 11:30
Forum: Sage 50 Report Designer
Topic: Conditional format....limitations?
Replies: 5
Views: 14619

Re: Conditional format....limitations?

No You can use all the attributes exposed eg suppress print. Background colour is one of the options, not sure what your issue is? I thought you were wanting a border setting. ive guessed the synatx to add the border colour condition: The way to do that is to draw a box around the item set it as ...
by brucedenney
07 Jun 2024, 11:02
Forum: Sage 50 Report Designer
Topic: Conditional format....limitations?
Replies: 5
Views: 14619

Re: Conditional format....limitations?

The border is not an option.

The available options are shown in the wizard.
Untitled.png
However, you could add a text box around the subject and then suppress printing with a conditional format to get the result you are looking for.
by brucedenney
07 Jun 2024, 09:43
Forum: Sage 50 UK version General Help
Topic: Sage 50 UK ODBC driver for data imports by .net desktop application
Replies: 3
Views: 7399

Re: Sage 50 UK ODBC driver for data imports by .net desktop application

I don't use the SDK it is expensive, I use a 3rd party tool to write my integrations for others. The ODBC drivers are slow, they use a comma as a separator or something like that, which makes some SQL ambiguous. It is what the report designer uses and is functional for many if not most purposes. You ...
by brucedenney
06 Jun 2024, 10:02
Forum: Sage 50 UK version General Help
Topic: Sage 50 UK ODBC driver for data imports by .net desktop application
Replies: 3
Views: 7399

Re: Sage 50 UK ODBC driver for data imports by .net desktop application

Your mileage may vary.

It depends on what you are doing, how big the database is and so on.

You should try it an see.

ODBC is slow.