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

Hi Bruce,
Thank you for the feedback and I have to confess that I'm surprised at the complexity involved to get, what I would consider to be, essential information. One key question our salesmen ask is 'when do we have free stock of xyz...'
Am I looking at this the wrong way as I would have thought ...

found it...

Struggling to find the properties, sorry!

I want to produce a report that shows:
Stock item No..... Qty in stock
PO No...Due in date
Sales Order....Due out date
Sales Order...Due out date
PO No....Due in.
Po No..... Due in
etc,
Free Stock after all activities

showing the expected due in/out activities in date order so we can see expected ...

Many thanks Bruce!
..and apologies ref the new topic!
Didn't see a due date option per line item but will look again tomorrow, thanks again!

Another question that has popped up is how Sage handles POP due in dates. We have multi-line orders and often the supplier will confirm different dates for each item but at present, we can only have a due date for the whole order. Is there any way of having due date by line item, other than ...

Thanks Bruce, I managed to create a new report pulling the department from the Sales Ledger data for the customer and also pulling the Invoice_Line data to give me the total value of each line and then summing it at the bottom so all OK now.
One little niggle that I didn't solve is that the Job ...

Have created a custom report that includes:
Invoice Date
Invoice No
Department No
Net Value
Name
Currency Symbol

The strange thing is that for 1 line orders you get one line of report for that order showing the Net Value BUT for 3 or 4 line item orders, I get 3 or 4 lines each showing the same data ...

Hi Bruce, thank you for the feedback, interesting... I haven't changed the report,
If I ask it for only department 0 info it still includes customers that are department 1 though?
I have started creating a report from scratch but it's proving messy (for me). What I want is a monthly sales report ...

Hi all, first post so be kind...
Have all our customers on our new Sage system and have used 'Department' as a geographical (geo code) analysis of the client as a way of analysing sales BUT when I run "Product Sales by Customer" it groups the sales for a customer who is flagged as Department 1 with ...