Forum Discussion
Connect Work orders to Invoices based on date proximity
Hello. I need to connect work orders in table 1 to their corresponding Invoices in table 2 based on the date proximity from Work order submission and Invoice creation. The only thing they cave in co...
sayaliredij
Solution Sage
Solution SageHI FOZZY
Is there any relation for Item Name? in Invoice and work order? Should it have the same name ?
eg. First Row from the combined data - it says that row belongs to NOCHG but if i check the work order - 2002 it says its LABOR?
Thanks,
Sayali
My apologies for the late response. No. The only connecting item is the customer ID. Unless you can think of another way tod o this, is there a measure that I can write to somehow organize the WO's and INV's based on the closeness of dates on each?