Financials

Good afternoon. Not sure why the “prepare tax report” is not working for Quebec, Sask, Manitoba. Pls. let me know what are the steps we need to do. thank you 

is it possible to do a roiling trial balance ?

Just tossing out an idea for Pre-Sales professionals.  When you need to demonstrate interbranch/intercompany transactions, demonstrate a new AP Bill with multiple line items.  Each line can be for a different branch or company.  When the transaction posts to the GL, it will automatically create the correct journal entries.  Drill into the GL batch to show results.

Hi AllI am thinking to add the link -Accumatica Financial Report - BS and PL into the dashboard.So that we can get the financial statement BS and PL after click the URL link from dashboard directly instead go in to financial module to look for the financial statement - BS and PL? Anyone can help and advise on this matter?Thank you

A customer wants to know how an overpayment on a check issued to us was applied, but customer cannot provide check number, date of check or amount of check. Is there a way to find a customer’s check that had a unapplied amount for some period of time?

Hello, I’m in the middle of a Shopify implementation right now and have two options: Document Level or Line Level discounts. Line level discounts don’t show up on the journal transaction UNLESS Post Line Discounts Separately is selected. However, then it shows the Gross Sales as the Net Sales on the journal transaction, and then on another line credits the discount amount to the Gross sales account and debits the discount account.  The big issue here is that the item discount lines are not associated with the Inventory ID. This makes it hard to report on discounts given at the item level. Also, this would be showing the net sales for the items in our Gross Sales account. Is there a way to map the Inventory ID for each line to these Item Discount transactions? 

Client has several branches.  Trial Balance is out of balance due to the report not picking up all branches.  For example:Branch “0” is assigned to company:Any posting to this branch is not included in the Trial Balance report for the company.  (in orange are missing)Any suggestions?

Hi,I try to close a finance period in the system but received an error message. It said “GL Error: The financial period cannot be closed in Accounts Payable, Accounts Receivable”. I am not sure what goes wrong. Can anyone help.Thank you.Regards,​​​​​​​Raymond​​​​​​​

Hello,  When attempting to release a transfer for a Fixed asset, we are receiving this error: Any ideas on what this error could mean, or how to fix it?  Thanks!

I have just modified a Row Set for Financial Report but the value it returns when running the report is zero. It is also not printing Code, Description, just Description.I think the account is restricted but I need to be able to overcome this. Any ideas?Does anybody have any ideas please?Thanks in advance.Barbara

Is there a way to reclassify expenses/ AP bill to a different project and or task?  For instance, we have an AP that was booked to Project ABC task 123 and need to move it task 456 or perhaps to Project DEF task 123.Seems as the only option is to reverse the bill then reenter :( 

Does anyone know why the Default Offset Account Branch is shown as a column but cannot be edited.  The Help just indicate “The branch to which the default offset account belongs.”.It makes sense to have a default branch when creating an entry type that belongs to one branch only.  Currently, the user have to remember to change the branch on the line entry.Is there any way to have an entry type defaulting to a specific branch? 

How do I see the year-end closing entry?  My balance sheet is off in January 2024 and I think the closing entry is the issue.   Thank you! 

Hi, A client is having trouble in the ‘Release IN Documents’ screen as they receive shown below when trying to Release a document. I have found a couple of similar questions in this forum but haven’t been able to access some of the articles mentioned in some of the answers as I seem to be denied access at the moment. For example, I am unable to access the link below which had some debugging information for this exact issue: https://community.acumatica.com/troubleshooting-242/troubleshooting-another-process-has-updated-the-inreceiptstatus-record-error-on-release-of-inventory-transactions-3774 I have also followed the steps from the question linked below related to updating the ‘Quantity Decimal Places’ field to allow for extra decimal places when releasing these documents, but that didn’t resolve the issue either.  Is it possible for me to have access to the first article linked above? If not, could you please provide some steps on how to debug this error to find what is causing the iss

Does a vendor bill need to be approved before it is released?

Hello, I am trying to reverse the I/C entries on this entry: When I try to book the reversing entry, the I/C automatically reverses it, as shown below: I understand this is working as it should, but we have a one-off event we need to account for in this manner.  Does anyone have any ideas on how I can get this reversed without triggering the balancing entries? Thanks,Sarah

Does anyone know if there is a way to create payment plans for customers on Acumatica? I have a customer who has not been paying their open invoices, so they requested to begin a monthly payment plan for a set amount (ex. $1000) to pay off their open invoices. Can we create a invoice for the set amount that the customer will pay every month and then once we receive payment we apply the money to the open invoices accordingly? Thank you!

Released Invoie lines details editing possible??

While reconciling deduction transaction, the system doubled the amount and now my fixed asset clearing account has a balance and no way to relieve it.  Below if a screen shot of the Reconciliation History by Assets report with the transaction marked.  Can anyone help me fix this issue? 

There is a transaction in GL in an unposted status.Finance - > Post Transactions , I posted the entry and it posted just fine. I do not want this transaction to update the GL , so when I tried to reverse , I received the error ,  “Error: An error occurred during processing of the field Inventory ID value ________IN Error : Th Inventory Item is Inactive” My question is Why does the system let me post it once but then not allow me to reverse it ?

Hello,We are trying to understand how best to proceed if we closed down one branch in our larger company of 33 branches in 2023, but still would like to see historical data without it impacting our 2024 reporting. The branch only has equity and retained earnings on the books.Regards, Brandon McIlhargey

Good afternoon!Do any of you know why the Export to Excel feature is not on the Process Bank Transactions Screen (ScreenId=CA306000)?   Thanks, Kay Howe

My client doesn’t have the asset purchase date/receipt in date without trolling through invoices. Is there a way around this by simply entering a dummy date and what implications will this have? thanks.

They seems to have the same result from what I have read.

Our acumatica system has open periods all the way back to 2015 , I have been successfully able to close periods from 2015-2019.However , When I get to 2020 I can close the submodules but there are two transactions in GL in an unposted status which are preventing me from closing the period.My inclination is to delete the transaction but the “trash can” symbol is grayed out . Is this related to access rights ?. But the bigger question is (1) If I delete transactions is that going to change the sub-module balance thus causing a need to make a G/L entry to being it back in sync with one another ? (2) If I delete an entry in GL which is coming from AR, for example , does the AR module need to b re-opened before the system will allow me to delete it ? May be that’s why the trash can is grayed out ? The weird thing is I was able to close the AR module even through the G/L has an unposted entry from that sub-module.