Hello all. I have a question regarding two inputs that I have coming in.
1 is a billable lines input (sales order lines that are ready to be invoiced)
2 is all the sales order lines (sales order lines that are ready to be invoiced or not)
As shown below, only 6/10 billable lines are ready to be invoiced. Is there a way that I can use a tool to show once billable lines equals sales order lines - I can push this out to show its ready to be invoiced ?
Billable lines
All sales order lines
Thank you for any assistance!
Solved! Go to Solution.
Hey @maddoxs,
From what I understand I think you could do this approached:
Just count how many Booking/Sales are in each table and join on the count and that booking. The ones which join are ready the ones which don't are not ready.
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
How does something like this look? I'm not sure if both datasets are much larger/have various different Sales Orders within them but I've built out an example assuming that, showing one where billable != total and another where it does to show the 2 outcomes. The workflow just performs a count of both, grouped by sales order, and if they aren't equal flags them as not ready for invoicing and vice versa if they are equal.