Financials

When applying a foreign partial payment to an invoice, how do we ensure the correct balance shows on the invoice?  Do we have to do the cross rate calculation for this like we do for a fully paid foreign invoice? Thanks 

Hello! When I try to create a journal transaction using a subaccount which is exist in the system and shows me on the subaccount list, it gives me the error message ‘Subaccount cannot be found in the system’. We have segmented the subaccount. Sometimes it works if I enter the subaccount on the subaccounts form and save. Anyone knows why this happens?Amanda 

I have a client that has multiple companies in a single tenant. There are 6 companies in total, 3 with branches and 3 without branches. There are 3 variations of the financial calendar across the 6 companies which looks like this: Company 1 (with branches): 13 periods, 28 days in each period (Variation 1)Company 2 (without branches): 12 periods, calendar based, October to September (Variation 2)Company 3 (without branches): 13 periods, 28 days in each period (Variation 1)Company 4 (without branches): 12 periods, calendar based, January to December (Variation 3)Company 5 (with branches): 13 periods, 28 days in each period (Variation 1)Company 6 (with branches): 13 periods, 28 days in each period (Variation 1) The problem I am having is the different number of periods in each company. Is the scenario above possible? If so, how do I go about setting this up, starting with Financial Year, moving onto Master Financial Calendar and then finally Company Financial Calendar.I don’t think it mat

Has anyone successfully connected to BMO for business? There is a connector in Acumatica using MX, but BMO keeps returning invalid credentials messages when we attempt to connect and their tech support seems to have no idea what MX or an account aggregator is.

For other prepayments, I can still apply prepayment for the previous period, why can't I post this prepayment, the system is forced to choose January 2024 or later? 

We implemented Acumatica mid-year and I was told that I could simply upload the information once I gathered the vendor number, name and amount paid in the previous system.  It starts with creating a separate account and designating it to take on balances for 1099s, but I am not finding any instructions on that, does anyone have the steps to do that? 

Received this error when trying to calculate depreciation for this asset.  

Hoping for some guidance.  I am not an accountant so take pity.  Much thanks to any advice for helping a newbie.  My AP clerk is running the Purchase Accrual By Period on the Purchase Accrual Account.  She is also running the Account Details for the Purchase Accrual Account.  If they are run over the same period lest say June of 2023, would the accounts tie out and balance or is there always going to be a variance.    They have said in the past these tied/balanced but lately it its been off some periods more than others.  So should they balance/tie out?  If not, why wouldn’t they balance 

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!