Default entry into analysis field

[scotrodg]

Hi All

I'm looking to have a default entry applied to every sales order we enter into one of the analysis fields on the Order tab of a sales order.

The reason for this is that we do an export of every order dispatched into our courier's system (DPD) and they need an input on how many parcels we are sending on a consignment. Whilst the majority of our consignments are just single parcels, we do have one or two each day which will have more than one.
If we have a field we can add to our exported CSV which has 1 entered by default we would only have to do an additional input if we are sending more than one parcel, it's all about LEAN!

I have attached a screenshot of what I am looking for. The number 1 is entered in the analysis 1 box in the custom fields, this is what I would ideally like so that the warehouse team have to input only when required.

Cheers

Rodger

[brucedenney]

There is no easy way to do a default value.

However...

What you could do is to use a report to generate the CSV file for DPD. In the report you could have an expression that says if the value in this field is no a number then use 1 otherwise use the number in the field.

Code: Select all

INVOICE.ANALYSIS_1=""?"1":INVOICE.ANALYSIS_1

[scotrodg]

Cheers Bruce...again!

We already generate the CSV for DPD from a report I created myself, I'll try adding that line into the relevant field and see how we go.

Thanks again

Rodger