Hi,
any news on this

Item in the sales order is entered colour wise. We need to print in the Packing slip and Invoice item codes without the colour for the same unit price and line discount.

In Sales Order item are entered as
1. IFHHBU001BK 10.50 100
2. IFHHBU001RD 10.50 100

We need in Packing slip / Invoice like this
IFHHBU001 10.50 200

If the length of your item code or your colour code is always uniform and the position is always at the end of the item code the you can use the substring or trim function to print the item code on the invoice without the colour code

If the length of your item code or your colour code is always uniform and the position is always at the end of the item code the you can use the substring or trim function to print the item code on the invoice without the colour code


No the item code length keeps varying. Anyway I have done it by editing the report script. Item codes without the colour code was determined by sorting and then 1st position of the similar items was stored in an array. Using this array at the detail layout the other lines were suppressed and the qty and amount was stored in my variables for same items and these variables were printed in the report session.