Thank you for the follow-ups!
To help clarify the issues we are facing, We are running Acumatica 2025 R1 Build 25.101.0153.9.
We are a construction company building a weekly cash position report by project. For Cash Received we want to include: 1. Payments applied to invoices (progress billing collections) 2. Unapplied payments such as owner deposits and advance payments 3. Retainage releases when collected
We do NOT want credit memos or write-offs — only actual cash receipts.
Based on this, should we use Inner or Left join between ARPayment and ARAdjust? And should ARPayment be the parent table as shown by Dipak?
Also — we previously had a fan trap problem where amounts were multiplying incorrectly across joins. Is there anything in the join structure we should watch for to prevent duplicate amounts?