Financials

Hello,I am looking for clarity on the Process Bank Transactions > Match to Expense Receipts workflowSubmit (but not claim) expense receipts.  Import bank transactions Process Bank Transactions > Auto-Match System found a match Process Bank Transactions > Process Nothing happened to the matched expense receipt. Ie. Same status and not claimedIs this how it is supposed to work? Do I need to manually claim the expense receipt?

We run a few automated process overnight, confirm shipments, prepare invoices, release invoices.Occasionally there are errors in this process, where a shipment or invoice is held back from being processed for some reason.Is there a way to set up within Acumatica, where these error message are emailed to a specified email address?This is to with the aim to be more efficient, rather than going into that process, to see if there are any errors.Thanks,

Hi,We’ve recently adopted Acumatica for our business and currently in the implementation phase.I am trying to add the PO owner who is ultimately the purchase invoice approver to the Invoices and Adjustments GI but am failing miserably on the relations from adding data tables. I’ve added employees, users, and EPApproval, but either get random approvers, blank, or invoices duplicating.Ultimately, I am trying to create a widget on a dashboard so our PM’s can see that they have an invoice to approve.Any ideas?Thanks!

 Hello!I’ve been trying my own to figure this out but couldn’tI saw there is two ways for doing this, one is creating a unit set and the other one, that I prefer, is create a column set.As you can see I was able to create two columns but I can’t call the branch I want, instead, the two of them are called together printing the same calc in two different columns.Can you help me? I need to enter a value somewhere to get the branches separatelyThis is my column set Thank you!

Hi,I customized a ARM Balance Sheet Report to reflect 6 different branches at a time. What formula can I use in each column to pull the branch name automatically versus having to input manually for each colums? Here is a snapshot of the column set and highlighted fields.   Thanks,Frances   

Hi All,Our company is currently in the implementation phase and go live with Acumatica in the next couple of weeks.We are a UK based construction company and have been back and forth with the implementation team to see what we can do with applying retentions to invoices rather than creating a separate retention invoice.I’ve seen on here, about a year ago, that a development request had been submitted but unsure if there is an update or solution?As a construction company, we do not request our subcontractors to send a separate release of retention invoice at the end of a project, nor do we send one to our clients; they are combined on the last invoice at practical completion.The retention module currently acts independently to produce the retention invoices but is there a way to manually override? Not ideal as I believe this will disable the retention module along with us not being able to use the AIA report.We have noticed that the PO determines how many item lines can be processed for

Scenario: Issuing a Bill with a 5-Step Approval Flow A company, prepare bill to customer and needs approval before processing the payment.🔹 Approval Steps:1️⃣ Step 1: Accountant Review – Checks bill details and submits for approval.2️⃣ Step 2: Finance Manager Approval – Verifies bill accuracy and compliance.3️⃣ Step 3: Department Head Approval – Confirms budget availability.4️⃣ Step 4: General Manager Approval – Ensures approval for major expenses.5️⃣ Step 5: CEO Final Approval – Authorizes high-value payments before processing. Thanks in Advance  

For example, M &T Bank as bank name is rejected when entering data.  A developer can change the regular expression to “fix” this but will this cause issues with banks?

Could anyone provide a screenshot of a Row Set Import Scenario for ARM Reports? I am just a little confused on how the Data Source portion works. We normally just setup the reports manually, but this is our first customer who has several hundred lines per report so we would much rather import the bulk. The Data Sources will be “Start Account”, “End Account”, “Start Sub”, and “End Sub”. 

What do I do with outstanding deposits in ACU?  I don’t see it addressed in the cash mgmt pdf’s.

Hello dear community,I was wondering if someone knows how to fix this error.  "Object reference not set to an instance of an object" Error happens when processing Order Type SC in Sales Orders. This is just in one of our tenants.    

Good evening,Curious if there is a good report in Acumatica that would generate an AR report of aged invoices based on sales person...or would that be more of a customization request?

We have customers with multiple locations that are all setup as separate accounts.  There is a “parent” account that all invoices are sent to.  Each location has different contacts and the parent company wants bills with each locations name because they have checks with each location’s name and address.Our problem is how to apply a company wide credit limit so that when it is calculated it considers all the “child” accounts also.Thank you for any insights

I’m hoping someone can point me in the right direction; I’m guessing there’s probably even some stuff in the standard help that covers this but I’m striking out.If I run one of the stock AP or AR reports (I’ll use “AP Balance by GL Account” as my example), they all have a date or period parameter.  What I’m being asked for is to run these reports as of a specific date, like running the AP Balance as of the previous month end, so that we can then tie to the appropriate GL accounts.The issue with As-Of reporting in every ERP I’ve ever worked with is that, for subledger reports like AR and AP, the transactions are always changing.  GL is easy to run “as of”, because you never close or delete a GL transaction (worst case, you create a new transaction in the same period to reverse it).  It’s very possible on an AP subledger report that I may come in on February 3 and need to post an bill with a posting date of January 31.  I may also, on the same day, pay and close a January 10 bill.  I can

My customer wants to require that their customer puts a down payment for items they are ordering.  The system will allow them to enter the payment when it comes in (as a prepayment).  They want to however to send an Invoice for the down payment. I am not seeing a way to do this.I found this article that implies you can do it, but it requires creating a shipment.  This is a manufacturer and they cannot create the shipment because they haven’t made the inventory yet.https://www.acumatica.com/blog/technical-tuesday-creating-installment-payments-using-payment-terms/Anybody have any ideas or am I not finding the documentation on how to do this?

Does anyone have a way to apply the depreciation cap for luxury passenger autos?  The IRS has guidelines they release each year with the annual limits for the depreciation deductions.  I do not see a provide method for this nor do I see a way to set a series of max annual deduction amounts in the method even if we created a new method.  Thank you,  

Acumatica ERP supports Multi-Organization Setup, Consolidation Hub, and Intercompany Transactions through its Financial Management module. Below is an overview of where each of these features is configured and managed in Acumatica:1. Multi-Organization Setup (Multi-Company / Multi-Branch)Acumatica allows you to configure multiple legal entities or branches within the same tenant.Where to Set It Up?Navigate to Configuration → Organization → Companies (CS101500) to create multiple companies. Go to Configuration → Organization → Branches (CS102000) to create multiple branches under a company.Key Features:✔ Supports multiple legal entities within the same tenant.✔ Each company can have separate financials and chart of accounts (optional).✔ User-based security roles restrict access to specific companies or branches.✔ Shared master data (customers, vendors, employees) is optional.2. Consolidation Hub (Financial Consolidation)Acumatica provides financial consolidation for organizations with m

Hello experts,A user gets “undefined: cannot set properties of null ( setting 'lastCompany')” error message when they try to drill down into the details of the monthly P&L. We are unable to replicate it even when you sign in as the user. They only get it when they sign into Acumatica with their profile. This happening to one user and report is a custom oneAny ideas?

Is there anyway we can put customer on Credit hold, but still process all materials to FG, but NOT ship product until credit is released?  We have very long leadtimes, and want a CREDIT HOLD FOR SHIPMENT ONLY - 

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.