Locations

[sprog88]

Hi,

We are trying to get locations onto our delivery notes; so that when the tickets are being picked the guys know where to look in the warehouse.

Is this possible? As we have looked on the report designer and we can't find it in the layout section. I can get a loaction when I print a stock list, but not on the delivery note.

Regards

Jo

[brucedenney]

Yes you can do it.

Yoo need to add the stock table with a "join"
I think this needs to be a "parent_outer" join so that items that are without location eg M S1 S2 etc will print

[sprog88]

Thanks.

would you be able to tell me how to put the join in? As I'm not too sure what I'm doing lol.

[brucedenney]

In the report designer

Data>Joins>


Drag the table you want to use onto the main screen

then drag the field you want to link (join) on in the new table onto the field it links to in the existing table.

Click on the link (the join) between the fields and you can edit it's properties.

[sprog88]

Thank,

I have done what you said, but the locations still dont seem to be appearing when I print out the delivery note. I can see the field when I'm editing the report but when I run a preview it's just blank and I'm not sure what I'm doing wrong?

[brucedenney]

I assume you have put something in the location.

What are the join properties?

[sprog88]

Yeh all of our products are now located.

Well when I go to go back into joins to see the properties I get a message say the joins that are used by the reports cant be represented graphically and then it takes me to the text editor and brings up this:

SALES_ORDER INNER JOIN SOP_ITEM ON SALES_ORDER.ORDER_NUMBER = SOP_ITEM.ORDER_NUMBER CROSS JOIN STOCK STATIC JOIN COMPANY

which doesnt really make much sense to me really lol.

[brucedenney]

The join you have made is incorrect.

You have linked the order number to the stock code.

You need to set it back to

SALES_ORDER INNER JOIN SOP_ITEM ON SALES_ORDER.ORDER_NUMBER = SOP_ITEM.ORDER_NUMBER STATIC JOIN COMPANY

You should then be able to edit it graphically.

You drag the stock_code filed from the order item and drop it on the stock_code filed in the stock table

[sprog88]

Right,

I've set it back to how it should be and it let me in.

I then dragged the stock into the main section and then dragged the location from the stock table over to the sales_order table. Is that right? As when you then double click the join it say it goes from Location to Order_number.

Regards

Jo

[brucedenney]

NO

The stock_code field is the thing that links the two together.

You drag the stock_code filed from the order item table and drop it on the stock_code filed in the stock table

[sprog88]

I think I'm getting myself really confused here

Because I havent got a Location option in the Sales order table to drag over to the Stock Table.

[brucedenney]

I said "drag the stock_code filed from the order item table and drop it on the stock_code filed in the stock table"