Generate Invoice Report On Date Range
Currently have the following table relationship:
Here are my invoice table fields:
I need to generate a report based on "ask user" input of "Start Date" and "End Date" range to inclu...
Forum Discussion
Since your Invoices table is a child to the Project, you can have each Invoice be an individual record (and actually should do this), rather than having a single Invoice record with multiple dates, amounts, etc.
I would suggest changing your Invoice table to have just the following fields:
Once you do this, you can use the Invoice Date field to build your report.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
I would suggest changing your Invoice table to have just the following fields:
- Invoice Date
- Invoice #
- Invoice Amount
Once you do this, you can use the Invoice Date field to build your report.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Blake,
Great idea, do you have a suggestion on how i can effectively migrate the values already in my multiple invdate, inv# and invamount into the newly created fields you suggested?
------------------------------
Philip Hall
------------------------------
Great idea, do you have a suggestion on how i can effectively migrate the values already in my multiple invdate, inv# and invamount into the newly created fields you suggested?
------------------------------
Philip Hall
------------------------------