|
Current Problem
We store whole pallets for a client and each pallet is set up as its own product. The client needs a daily stock report showing which end customer each pallet belongs to and the date it was received. We have set up UDF1 as “Customer”, but UDF fields can’t be selected in the Custom Reports Builder, and there is no Date Received field either. As a workaround we are typing the customer and date into the product Description so it shows on the scheduled report, which is messy and can’t be sorted or filtered properly. Our client’s previous provider gave them this information as standard, so it’s a gap for us. |
|
| Idea to resolve Problem | Add UDF1–UDF10 and Date Received (the date stock was booked in against the ASN) as selectable fields in the Custom Reports Builder for the Product and ProductInLocation export types, so they can be included in scheduled reports. |