In projects we have a business flow where the client receives money in and then pays a portion of that out. The difference is the Actual Income on the Project. For a few reasons we didn’t want to show to AP payment in the Actual Expense. We created an Account Group of the Income Type and added the 2 GL Codes, the Income type GL code for the Income and the Expense type GL Code for the portion of the Income that is paid out. That means that the Revenue Cost Transactions always have an AR Invoice EG $20’000 and a AP Bill EG $5000 and in versions up to 2023.1 the Actual Income calculation calculates the income as $15’000. (AR-AP)
Lovely solution and everyone was happy… then Version2024.1 and in Acumatica 2025.R1 with the new calculation to include the taxes, the Actual Income calculation ADDS the AP Bill to the AR Invoice rather than subtracts as it did previously.
This effects all new transactions, and creates an incorrect actual income if an existing project is recalculated.
Does anyone have any ideas on if we have used a gap in the software that we shouldn’t have with having and Expense type GL code associated with an Income Type Account Group?
Is it a bug/known issue? Any ideas on how to workaround this - is it a good idea to potentially customise the Actual income calculation?
Many thanks
