tag:blogger.com,1999:blog-1489645468065669928.post7757144275397295760..comments2023-07-25T22:44:58.370-07:00Comments on Web based database software at Work: Wanna perfect printed invoice? Let's find the system that can!Anonymoushttp://www.blogger.com/profile/14947737950477226737noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1489645468065669928.post-6863821275055004822009-07-01T01:03:23.174-07:002009-07-01T01:03:23.174-07:00Actually, my goal is to figure out how to get a ni...Actually, my goal is to figure out how to get a nice printed document. This testing is not about how to create the most complex invoice app possible.Citizen Developerhttps://www.blogger.com/profile/14134010068901805872noreply@blogger.comtag:blogger.com,1999:blog-1489645468065669928.post-5179103023239238412009-06-26T09:14:45.424-07:002009-06-26T09:14:45.424-07:00Hi Jane,
To produce an invoice, it is normally n...Hi Jane, <br /><br />To produce an invoice, it is normally necessary to create line items that are about both the product and the invoice, however, contain data unique to the relationship between them.<br /><br />For example, I have an invoice with "x" line items on it. Each line item is about a specific product. Therefore each line item needs to contain information about the product such as product name, and unit price. However, each line item also needs information specific to the relationship between the product and this invoice such as quantity, extended cost, etc.<br /><br />So, to solve this problem, one should first tackle the many-to-many relationship issue, which is substantial. Will you be looking at this issue as well?<br /><br />There is an easier alternative, which is to simply copy data from the product into the line item of the invoice, however, that results in a significant loss of functionality later on in other areas of the system. I don't think this method of generating invoices would be considered realistic by most SMB's.Treff LaPlantehttps://www.blogger.com/profile/14700135299531201653noreply@blogger.com