Customer Record Custom Fields

[C-Tec Belfast]

I am using Sage Line 50 V18 and am trying to build a report for sales rep v sales for that month for commission purposes. I have changed the Customer record custom field to Rep codes but when building a report using the wizard cannot find this field.

[brucedenney]

it is called Analysis1

[C-Tec Belfast]

Thanks Bruce

[cliffox]

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 the sales for Department 0. I have checked the customer and the order and both show the Department as 1 but the report does not separate them...
Any thoughts or suggestions?
I have also looked at analysis codes and thought of using these as the 'geo' code for my analysis BUT it means that the person loading the customer has to enter the geo code each time, meaning errors can be made...
Many thanks,
Cliff

[brucedenney]

I can't find a report called "Product Sales by Customer" where are you finding it? Can you give me the filename?

[brucedenney]

I found it, it is an Invoice report and it doesn't group by department, it lists products in stock code order for each customer.

If you have modified it, could you attach your modified code to a post?

There is a criteria on it for department, perhaps you meant when you ran the report for department 0 some department 1 things appeared rather than things being grouped by department?

[cliffox]

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 that groups sales (net of carriage) by department and similar invoice report...
I would have thought these were pretty normal needs but haven't found anything as yet, hence my delving into creating reports...

[cliffox]

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 and the total is then calculated based on the sum of those (erroneous) values...

Any help would be welcome, I am seeing double already!

[brucedenney]

If you are using the original report, then I would not expect it to work when you use the department criteria.

This is because the department it is reporting on is the department on the item on the invoice. This is typically the department from the product code.

You need to alter the report to use the criteria from the department off the linked customer record to get the result you are expecting.

[cliffox]

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 number is formatted with a comma i.e. 1,234 instead of 1234. Can't seem to find where to format it as text to remove the comma...

[brucedenney]

It is in the properties of the field.

[cliffox]

Struggling to find the properties, sorry!

[cliffox]

found it...