How to generate number of items/boxes processed ?

Document created by anton_serbanescu Employee on Apr 23, 2015Last modified by vreddy on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
There is a requirement where there are a number of boxes coming from NetSuite. Need to calculate the number of boxes that have been processed, for
example, the output expected should be as follows:

 

Box 1 of 30 has been processed or shipped.
Box 2 of 30 has been processed or shipped

 

Current output is ... :

 

Box < > of 30 has been processed.
Box < > of 30 has been processed.

 

or

 

Box 30 of 30 has been processed.
Box 30 of 30 has been processed.

 

What are some of the suggestions that will help generate the correct information ?
1. Either make use of the line increment function and map the box element or item element to the line increment function, inside a user defined function.
2. Use the count function, also in a user defined function, where the boxes root element or the items root element needs to be mapped to the reset value, and the box mapped to the field to be counted.
1 person found this helpful

Attachments

    Outcomes