I am trying to create a calculated field for a RM Sales Invoice for a recurring batch to decrease the overall length of the invoice number in recurring batches. right now, our invoice numbers look like this D-12345600000000001. I want to create a calculated field to display the leftmost 8 and rightmost 4. I started by trying to create only the leftmost of the field, so I created the following calculated field:
Result Type: String
Expression Type: Calculated
LFT_STR(RM_OPEN_TEMP.Document Number 8)
The 8 I inserted as a constant integer
When I go to print the invoice, I am getting a message that there is an error in the calculated field. I'm not sure what I am doing wrong. Any assistance would be greatly appreciated.
Thanks!
Kim
*This post is locked for comments