I'm working on developing a report for cash flow and finance planning.
Report requirements gather details of all known current cash demands:
- List all Open POs (PO with some portion of items not received or billed)
- List all unpaid bills
- List all item receipts
Strange behaviors when I put in those filters into a custom transaction report:
- When I add the filter for "Received = No" a handful of my unpaid bills disappear. I haven't been able to find the commonality amongst these bills. Hoping someone else may have seen this behavior and can tell me.
- When I add the filter for "Paid Status Open" AND "Received = No" all my item receipts go away. Just one of these or the other by itself does not make item receipts go away.
Other customizations on the report include:
- posting status = either
- manual selected transaction types of Item Receipt, Purchase Order, and Bill
- Some custom fields, sorting and such
I could query this in the database via the ODBC driver or via the SDK but I'm hoping there's a trick to this before I go down either of those routes...
