I have a situation and I am hoping someone can help me!

I am trying to include payee, bills and receipts, and expense detail to include categories, subcategories, and amounts. Then I need to get combined category total for bill and receipt categories together. And the same for sub category total.

ONE Payee can have MANY bills and/or MANY receipts. BillF and ReceiptF contain SHARED DetailSubF. (Like Invoice & Invoice Details, but the DetailSubF can be used for either a bill or a receipt. DetailSubF contains DetailID, BillID, ReceiptID, and line item information including Category, SubCategory, Quantity, UnitPrice, GST. A DetailQ includes all fields on DetailT, plus the calculations for ExtPrice, SalesTax, and LineTotal.

Example:
Mortgage entered as a bill with details on DetailSubF on BillF. Walmart entered as a receipt with details on DetailSubF on ReceiptF. Each line detail contains a category, subcategory, and the amounts.

Any help would be appreciated!

---

Reply from Alex Hedley:

Have you seen the outline for the Payables Seminar?

/site/courselist/seminars/access-payables/