Our client has a Sales Invoice being created from multiple Sales Orders as designed.
However, for some reason, the corresponding field size is too short as seen below:
Obviously, this field’s design is not future proof. As a rule of thumb, when you have such a connected data relation, either you make it a child table, connect via a script to use on a report, print or future reference or cater for large data. I see that this field is meant to accommodate Sales Invoices which do not have any Sales Order reference but that does not solve this error condition. More obvious is that the Customer’s Purchase Order Date is not meant to handle orders of different dates.
What would you do?