I have created a query FMS and assigned to freetxt field of the delivery order. Using the FMS, I expect that I can display batch no. of iem in the delivery order row line. Either one or more than one batch number but it is pooled together in the field/column.
E.g. item A, delivered with quantity 30 pieces and batch no. WQ120 to WQ 122, one batch no. = 10 pieces.
So, in the field, there will be WQ120, WQ121, WQ122. Is it possible to do that using FMS ? pls give advice
Jimmy Michael replied
I am not sure that B1 can generate a report containing batch and non batch item together. I mean you won't have a report that can display batch no. of batch item and non batch item. It exists especially in the B1 2005A but 2007A can solve this issue.