SageForum for UK versions of Sage 50- Help and support.

Ahjhhh, i see the 'Page Break Before - True' property on the ACCOUNT_REF header now, makes perfect sense.

Fabulous, works a treat, thanks very much. It's a flippin' minefield this reporting lark!

Hi, I have a report that outputs the contents of a customers custom price list, all nicely formatted, with their terms and what not in the footer. Upon running it, I am offered a criteria popup asking which list I want to report, and it allows 'between', so i select (for example) between A and B. Pr...

Ahhh so simple, thanks. I didn't make the connection that 'default nominal code' and 'default nominal ..... nominal ledger account' were the same thing, and I guess we never had this problem before because the old version had probably already had a global customer default set.

Many thanks.

Sam

Oh, I forgot, we've updated since last time i imported, but we haven't changed anything. (We keep up with updates, currently

Ver 21.4.7.159
SBD Ver 12.1.369.0
Updates SDO Update 1, SP3, SP4, SP5

Hi. I am trying to bulk import a 4 digit number into the 'Analysis 2' field of the customer records. I've done all kinds of imports before, so I am comfortable doing it, however for the first time i've hit an error and I can't see where to go. I'm using just two columns, the A/C reference and the An...

Ahhhhh yes, I also now see the selection button under tools - options - environment. I spent aaaaages looking for that last week!

Thanks.

Hi, we have a user who's been working on sage for years. s of Tuesday, when he clicks more than one customer/SO/invoice/Product, it no longer multi selects, it clears the previous one and only the last clicked item is selected. If we hold shift, then it allows multi select.but how come just this one...

Hi, yea I use the category A-C fields on the Web tab for renaming products for two of our other customers, but since they have a a very specific set of products they take from us (thirty or so each) it's easy. The main customer, however, takes all our products (2000+) so in their case it's easier to...

Multiple Nested If loops. We're a manufacturer, and we have one customer in particular who likes to re-brand our products with their own name on their invoices and delivery notes etc. For years we've been editing the description manually every order, so I thought i'd automate it, using nested if / r...

ahhhh, and there's the list of the 10 allocation/despatch codes. Brilliant, thanks.

Hi, yea, pre-filtering the list is what I mentioned didn't work in my update, , , in that when i do filter - where - order allocated status - is not equal to - the next field is a dropdown with only blank lines in it. (see image) I would expect it to say 'full, part, cancelled' etc. but it doesn't, ...

Hi, my boss likes to run the 'SO_LIST' report of the months sales orders by product, and he wants me to remove any cancelled orders so that they don't show up on the report to head office. We already zero the cancelled orders, so that the balance doesn't count, but he'd like them not to show at all....