Financials

My company implemented with Acumatica in the middle of 2016.  At the time a default currency of “US” was chosen.  All of our accounts and cash accounts default to the currency id of ‘US’. I assume that since that time more currencies have been added, and the US Dollar currency is now traditional labeled ‘USD’.  Now we are trying to utilize the bank feed capabilities and I am getting errors preventing me from setting up the bank feed stating “Select a Cash Account in the USD currency”.  I don’t see a way to change any of these existing accounts from the currency of US to USD.  How do we fix this problem of US instead of USD?

Customer is wondering if there is a way to pull mileage information automatically from Google Maps from a customer address to pull onto an expense report.Acumatica Support is not aware of a way to do this but suggested I post here in case anyone created something to do this.Customer came from Concur where this was possible.

Does anyone know of a way to have the AP Bills automatically Release when collecting the final approval? Our AP currently has to take an additional step to release all documents since they all just go into the Balanced status rather than Open when all approvals are complete.

Our company uses LIFO accounting, which is generally only used in the United States, however it is GAAP compliant.I am just curious if there is any interest out there for a LIFO accounting module in Acumatica? We will probably write some software to calculate the LIFO reserve for our own purposes. We use dollar value LIFO. Thanks, Jonathan

Hello. I would like the below report formatted like the one below it. The last picture is an export of the aged report modified in excel which requires some effort. If we can have the original report look like it then from the get-go, then that would be a great help.Basically, all accounts are listed under one heading instead of the heading being repeated for each customer. Modified report in Excel.  

We maintain nearly all of our pricing at the customer level  (very few at Base level and none at a Customer Price Class level) and the inventory ID has all of our customer cross-references.  When we setup the sales price profile for a customer/inventory ID combination the Alternate ID does not populate if we create the line and enter using the inventory ID.  But if we enter the Alt ID in the inventory ID field, it will replace the Alt ID with the proper inventory ID and populate the Alt ID with the correct Alt ID (b/c we have the box checked to do so on the Accounts Receivable preferences tab.)  Is this a bug that the alt  ID is not populated when using the inventory ID or is the Alt ID only serve functionally to allow you to load pricing using the alt ID rather than a stock item?   Thanks for any help.  

i am trying to setup Total row in ARM, after set formula in column. How do I display the total that I have created in the row set? I was asked to create a Trial Balance with an ending balance of Debit and Credit, as a result the column uses a fairly long formula. My guess is that because of the formula, the total row set cannot display the sum. or maybe because I am using a subaccount Row Set the total row set cannot display the sum. Thank you,Jefri

Please kindly advise, How can I change invoice from 156.54$ to 158.26$ ? and I am using cross rate. Thanks in advance  

Good day.I am not sure what the problem is for the Row Set (ALLACCOUNTS).  I have three accounts that are not showing on the TB and TB Roll ARM Reports.Accounts: 85425/85450/85475.  I thought if I fixed Code 00135 with the Value =@00135*-1. It fix the issue.  No luck.  Any suggests.  I would to not have to fix this when Accounting adds new accounts.   

We have a large number of refunds to write off, the refunds are coming from Shopify→ Acumatica, Is there is a Best process to handle this scenario? I have seen a below article but Looking for additional suggestions. Currently I have created a credit memo for 0.01 and applied to refund to close the document.  

Dear Acumatica Community,We’re connected to Shopify via the connector and using Shopify Payments for website CC processing. We also accept PayPal payments online. However, when we try to add our website payments to our general ledger, the Payment Method displays as “SHOPIFYCC” for all website payments, even the PayPal payments!We want the Payment Method to display as ‘PayPal’ so we can isolate those payments for reconciliation purposes. Does anyone have a fix for this if you are using Shopify Payments online?    

Hi,Is it possible to override release action in Fixed Asset Transaction screen? For now, the standard is can release if Transaction Amt >0 , but now i want to change the function so that it can release even though Transaction Amount = 0. Is it will effect others transaction? 

Hello all,Can any one let me know if its possible to create an auto-debit/automatic withdrawal as a payment method where the vendor can automatically withdraw funds from the bank account?I believe we can implement this via direct deposit → ACH.After setting them up how can we setup the whole scenario?Thanks. 

I have query related to having multiple company calendars with varying period start and end dates.  Centralized period management is disabled, multiple calendar support feature is enabled.  It is 2024 R1. There is 1 tenant with 2 companies. Both companies use USD as their base currency and require intercompany transactions and consolidations. Company A follows Jan-Dec. 12 periods but have period type as user defined periods as start date and end dates varies. Period 1: 1/1/2024 - 2/4/2024Period 2: 2/5/2024 - 3/3/2024And so on…Period 9: 9/2/2024 - 9/29/2024 Company B follows Sep-Aug 12 periods with period type as Month. Period 1: 9/1/2024 - 9/30/2024Period 2: 10/1/2024 - 10/31/2024And so, onPeriod 9: 5/1/2025 - 5/31/2025 I setup Financial Year as Jan-Dec.  I was able to generate Company Calendar for the first company.  But with Second company, unable to change

Customer has an AP Approver role set up - ap approvers can view AP transactions. All approval maps are set with the Reason for Rejection is required.  When an AP Approver rejects the transaction the dialog box opens but the approver cannot make a comment.  How can I set the access rights so that the approver can enter a reason? thanks,Coleen

Hi. Does anyone knows how to bulk delete all items existing in Sales Prices? Thank you.

We have Acumatica set up the capture GST & PST (here in British Columbia).  It’s nice that it (usually) calculates both taxes correctly.  But, we’re not a PST collector, only a payer so we do not need to track PST, nor do we need to submit it to any tax authority.The problem comes whenever I analyze an expense account where we’ve paid PST on invoices.  Every line in the ledger has a second amount and the detail on that line just says “PST”.  Here is an example where this becomes a huge problem.We have about a dozen software licenses and many are billed monthly.  At the end of the year I get asked the question; “how much did we spend on each piece of software”.  Normally I’d just run a ledger inquiry and then total based on something in the description.  But instead I have to add additional information and “code” all of the PST lines so I can group them with each piece of software.Is there a way we can configure Acumatica to add the PST to the expense line as

Hello!I need to add a branch to a GL account, but I can’t find the place to do that. Can you help me?Thanks a lot 

How should we set up the Group/Sort Section to sort the report by Customer Account Name vs BAccountID?I went into the Build Schema, Looked at Sorting and Grouping, and tried to change the groupCustomer to CustomerMaster.AcctName Ascending vs CustomerMaster.BAccountID but I get the wonderful “We’re Sorry!” error... Edition: ConstructionVersion: 2022R2Thank you for your help in advance

How can we void payment without the voiding the payment in EBIZ or any impact to ebiz?  Any workaround here? Thank you in advance. 

One of our team has entered a prepayment into the Receivables Payments and Applications area.This was done in error, as no prepayment was received, so the entire transaction needs to be voided/deleted.If we simply VOID the entry/transaction. Will this eliminate from the customer Aging, as well as the General Ledger?  Our concern is what it might do to the customer history and aging.Thanks!

The Require Single Document per Document checkbox is not checked in AP Preferences.  I also cannot find any customization or business event that would populate the Project field on the header of an AP Bill.We have added the Project field (APInvoice.ProjectID) to the Bills and Adjustments primary list and here is an example of what we see:These four records happen to be for the same vendor and there are additional records with company WESTMIN that show Project X.The Detail line for both of the LPC bills has an active Project.  We are on version 23.210.0017.If anyone has an idea why or how the Project in the header is being updated, please respond.

Hello,One of our people posted an AR payment in the wrong amount (I surprised the system didn’t give a warning that the payment amount entered did not match the AR invoices loaded). Then he did a payment void but did that to the wrong period. So I am looking on how I can fix that so the GL matches the subledger. I can’t reclasify the batch because that does not correct the AR subledger. I can reverse the Journal transaction but again that only address GL and does not correct the AR Subledger. This is the second type of mistake that has been made that I have essentially been told “sorry once its released it can’t be fixed” which does not seem correct. So thought I would reach out to the community.  Thanks

I am needing to clear our entire AP subledger. I am testing the most efficient way to do this and initially thought I would create a new Cash Account (Clearing Account) and Payment Method for this purpose. My goal was to issue a mass (dummy) payment against all invoices which would get posted to the new cash clearing account, as it is not a real payment. I have everything set up but when I open Prepare Payments, the cash accounts do not appear in the dropdown once I have selected my Payment Method.You can see that these cash accounts appear under this payment method:The payment methods also appear under the Cash accounts - example below:

So we have balances on the AR that were for additional Retainage (HOLD BACK, RETENTION, etc) taken.  Most popular is that on the initial invoice of $50,000 there was no Retainage billed as per our sales department, so viola 45-60 days later the customer pays the invoice minus the 10% of $5000 (plus HST).  Now we have the short payment on the AR, and its aging away.Is there a way to do a credit memo that will take the $5000.00 out of the AR and put it in the Retainage held and it can be released with the others when they are paying it?