I have experienced 2 situations recently where the cash account balance might not match the GL at a given date. Here is how I reconciled them. Not all GL transactions are in the cash account:This can happen if the cash account was opened after transactions have been posted to a given GL bank account. Unlike other re-balance account screens, the Banking » Processes » Recalculate Account Balance will actually add missing GL transactions to Cash Account that are in the GL but not the cash account. This is not very well explained in Acumatica Open University but I discovered on a recent ticket to Acumatica. To take advantage of this solution, rebalance the cash account as of the oldest financial period available.Transaction dates don’t match Financial period.Acumatica let’s you override the financial period after entering a transaction date. Bank reconciliation runs on transactional date but the GL runs on Financial Period. I had a client post many (read millions of dollars) to the cu
I have what seems to be an interesting challenge; how to calculate commissions based on paid project based invoices. This differs from many other commission based systems based on accrued sales. Commissions at this company are based on payments received on project issued or related invoices.I can see payments coming into table ARPayments based on a calendar date or fiscal period. But when I try to connect those payments to the project that initiated the invoice and payment, that is where my challenge begins. If I am not on the right path, please put forward some alternative suggestions.Some constraints:All payments are initiated by invoices either directly issued through AR (so the project is referenced in the details tab) or through a project generated invoice. So, at least theoretically, a payment should not received unless an invoice, that is in AR, has been issued.If I start a GI or report from the ARPayments table, to capture all payments based on a calendar period, and then
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.