First off, I assume there is no flag on the OrderHed table to indicate when the order has been billed complete…
At first I thought I could use the OpenOrder field, but that only indicates that all demand has been fulfilled.
So I’ve added an extended UD field to the OrdeHed table to hold a Boolean to indicate that the order has been billed complete. This will be set by the person doing AR Invoice entry, relying on the fact that the InvcHead.OrderNum ties back to OrderHed.OrderNum.
The lazy way to implement this would be to put a checkbox on the AR Invoice Entry form (Header sheet), and the user would have to check that box to set the OrderHead.BillingComplet_c field.
How can I bind that checkbox to OrderHed.BillingComplete_c field WHERE OrdeHed.OrderNum = InvcHead.OrderNum ??
The fancier way would be to have a BPM that is triggered when the invoice group is posted. The BPM would then loop through the Invoices in the group, Display a dialog with info (like: Customer name, Invoice Number, Order Number, Total billed against the order number, etc…) and prompt the user if this Order should be marked “Billing Complete” - which would then set the OrderHed.BillingComplete_c field.
But from the thread “Use MessageBox.Show in BPM “Execute Custom Code” block”, it seems that a YES/NO dialog box initiated from within custom code, would be the wrong way to go.
Thoughts?