Hi all,
I have the following issue:
- typical SalesOrders / SalesOrderDetails scenario (a detail is something like Product 1, quantity: 5, unit price: 100
- Invoice / InvoiceDetails (when a SalesOrderDetail gets invoiced, it gets assigned the InvoiceDetailID, so I can see that this item has already been invoiced - at least I think this is a good way).
But the problem is, that sometimes I need to divide the Sales Order Detail into multiple Invoices. Let's say that there are 5 units in the order, but I only have 3 on stock. So I invoice those and when I receive the 2, I invoice the rest. This is a problem for the design mentioned above.
The desired result is that I will look at the sales order and I will see - Okay there are 5 units in this order and 3 have been invoiced already - so the entire order will be marked as "Partially Invoiced".
Can you recommend me the best way to do this? Thank you.
Tomas