AnsweredAssumed Answered

Sales report from invoices and returns

Question asked by pabloprat on Dec 11, 2017
Latest reply on Dec 13, 2017 by philmodjunk

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

Outcomes