The last requirement that we want to work on is to allow the user to add comments. We can allow the users to enter comments directly to the lines area. For simplicity, we can leave it at that. However, doing that will clump the item data with comments. The users may have to differentiate what's a comment and what's an item if it's a long complaint log.
It's fine if you don't care about messy data. However, as we all know, creating reports based on messy data is not good. We're more professional than that; the comments should be in a specific section for the users to type in. The user can still enter brief comments on the line if they wish, but there's an area for the users to enter whatever drama they've encountered to their heart's content.
Using the existing Sales Order structure in Dynamics NAV as our basis, the table we want to model for the comments is the Sales Comment Line table. The table ID is 44.
Similar to the Complaint Line table, the user needs...