GI Report request - Additional information

Question

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 collectedWe 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?

nickcerri32 · Answer

​@swhitley- This looks like a continuation of your previous posts. You can just reply there instead of creating a new topic.To your questions, the join won’t have an impact on whether or not a credit memo or write-off is displayed - you can filter what’s displayed using the conditions tab. Set it to NOT include Credit memo’s and write-offs.As far as ARPayment being the parent table, it looks like you copied this request from elsewhere and didn’t post the screenshot. If you post, we can probably help.Regarding Join problems - it’s best to join a table with many records to a table with single records (i.e., ARTran to ARInvoice as opposed to ARInvoice to ARTran) to avoid duplicates.

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded