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

On a side note... invoices moving over to multiple pages throws up some random challenges!

This is all now happy, following some testing... I had to add a calculation into the QTY field in order for it to show up on the second page, without that it just refused to display.

I haven't enjoyed great ...

Hi Bruce

You are very helpful kind sir, I got methodical on it, and appear to have cracked it.

Now to learn how to drive the if statements to have items showing based on quantities in stock. Wish me luck!

Right, so...

Moved the products I want to show to:

ITEM_NUMBER header rather than a Page Header. Things seem better now!

Hi Bruce

Thank you again for that - my problems all appears solved when I made that switch! This week has been crazy so I have only just got to look at it.

I thought I should do some testing before pressing this report into action, and all was going nicely with my single line order and various BOM ...

Hi Bruce

I went back to basics, and have it doing what I would like for it to do, which is pretty nice!

My final snag that I can see is that rather than list off the whole selection of assembly items, the invoice re-lists the parent product again for each line of the BOM, making for a very ...

Hi Bruce

This still has me scratching my head somewhat - thank you for your suggestions to date!

I have succeeded in showing the locations, QTY and Stock Code for the assembly items on the invoice / pick note I am using to experiment with!

Harrah! I thought to myself...

So I set about a bit of ...

Hi Bruce

I think I had been editing that file and saving over the top of the one I uploaded without realising.

I have tried joins as attached, but I haven't been able to get the data on the component parts to show up, all I seem to win is the parent component attributes displaying.

I have joined ...

Thank you Mr. Bruce - much appreciated!

I hope sunny Somerset is treating you well

Hi Bruce

I thought I had attached it last time, but it didn't appear on here. Hopefully it's worked this time...

I spent some more time monkeying with it, but still haven't got a handle on it.

I have found that when I add what I think should be the BOM location the quantities multiply by 34, and ...

Hi Bruce

It feels like it's close to springing to life, but any combination of links I do either brings up an error of no data for this report or some other variation on not working. I haven't yet managed to see something I recognise, which is quite frustrating!

Thanks for any suggestions, I feel ...

Hi Bruce! Hope you're well and keeping nice and busy?

I am doing battle with report designer, and trying to create some products with BOMs, where each component shows the quantity required, the part number and the stock location.

The problem is have come up against is that location isn't isn't an ...