Hi All,
I have created a report about the RH Open order (Sales) in which I have added the Item name and it fetches without adding the space after the parent item and before the child item name like this :
CUSHION NI:732301MTC
But when I open and check the same item in the Sales Order it has the spacing like this :
CUSHION NI : 732301MTC
How to maintain the same format of the Item name in both the Sales order and the report.
Things tried so far:
- Tried to add the formula but didn't have the feasibility to add the substr, concatenate and other functions in the saved report.
2. Have tried to remove the space in the SO but it's not happening
Facing this issue because when I have to update a few data fields in the SO then the Item name has to match(Will export the data from this report).
Would be grateful for any suggestions on the issue or any ideas to approach the issue.
Thanks in advance