Hi everyone, I hope to make my question as understandable as possible,
I´m trying to do a sales report that gives a summary of transactions and values based from every invoice (table 1), which gets it´s products from Inventory (table X) and then I´ve another table with a layout that substracts every return (table 2) from inventory. I´m having trouble joining the invoices table with the returns table and putting them at the same time and only substract from the total all returns.
In the image Sales Report, I´m trying to add the invoices and the returns, but no luck in sorting by date and substracting.
I´m willing to send the original Filemaker file by private message/email if anyone can help me.
Thanks for all the help