Hi,
We have a need to use an Excel Migration job to create multiple quote lines within a Sales Quotation, some of our quotes run to around 600 lines long. Meaning that manual keying in is particularly cumbersome and not very productive.
Therefore, an Excel migration job was setup to look to see if we could speed this process up significantly. However, we’ve hit an issue whereby the Unit Of Measure is a mandatory field within the migration job, but we wouldn’t always know off hand what that value was. Again this would mean having to look up potentially hundreds of parts whilst keying the lines in, is there a way to force IFS to do this lookup for the unit of measure when executing the job?
We’re currenlty on IFS Cloud 23R1
Any help on this issue would be greatly appreciated!
Thanks