Financials

I have a client with multiple companies in one tenant.  While you can pull an ARM report for Company A while you are in Company B, the header information displayed is still for Company B.  What is the correct formula to display the selected Company Id instead of the current Company you are in?  The default formula is:=Report.GetDefUI('RowCompanyBAccount.AcctName') 

I followed the instructions from this Acumatica help page: Access to Budget Nodes: Implementation Activity A client of ours uses their subaccounts for their departments and I’ve configured a budget node for each subaccount. Each node contains leaves for each Account-Subaccount combination they budget for. I then created a restriction group (Group Type A) for each subaccount and added the respective budget node to each restriction group. I then added the 2 users for the 1000 subaccount/budget node to the restriction group. When I sign in as other users, I’m still able to view the 1000 subaccount/budget node and edit it. It was my understanding that adding users on the GL Budget Access screen would make it so that only those users would be able to view that budget node. Do some roles override restriction groups? I don’t understand what’s going wrong, any help would be greatly appreciated!

Hello,I am working on my first sales tax report and i can’t get the report the way I need it. We are on 2022R2 with fast track implementation.We are setup to have zones that pay multiple rates.  Base MN 6.875 plus county of .25%.  On the report the tax amount due is correct, but the taxable amount is doubled up and broke into multiple groups..  I need to report the taxable amount for each group.  8k to state @6.87% and 8k@.25% to the counties. and the state website calculates the tax amount due (which it should match) I have tried multiple settings and groups, but can’t get the settings quite right.  Thanks,Jeremy

When I import the data, the first row value is inserted into the ARInvoice and Tran tables. other values 2 twos not inserted. but processed status success 

Scenario: Occasionally there are invoices that contain confidential matters e.g. legal invoices. There is  read only security set for department type security roles on the Bills screen so users have visibility to the invoice details.  But this also gives them access to view attachments.Is there a way to keep invoice attachments on AP bills and restrict access to the attachments?

Please add the “Department” field to the Dispose Assets window as s column. The Department field is a required field on a fixed asset and it would be very helpful to be able to search and select multiple assets for a mass disposal based on the department.

I had a prospect ask this question about percentage complete. Any thoughts anyone if this is achievable? “In one of our recent meetings, we discussed being able to have a “percentage of completion” shown for our projects in the software and you said you would look into it. Is this something that we are going to be able to do? I’m creating processes and accounts in preparation for beginning the software implementation process and I keep coming back to needing some easy way to see percentage of completion. I’ll need it to do the reclasses for WIP materials to COGS to align with where we are in the contract but I’ll also need it to compare our revenue billed with what we’ve completed to make sure we haven’t over/underbilled. When I’m reclassing the WIP materials to COGS at EOM, it will essentially be an estimate. But if there is some sort of field for the PMs to be able to include their estimation of progress, that would greatly help me since I’m not the one out on site.”Thanks for Yall’s

In the Chart of Accounts, the account does not have a specific currency assigned, but transactions are being posted to it in different currencies. I would like to display these different currencies on the account — is there a solution for that?

I have a generic inquiry “Bills and Adjustments.” I would like to add the GL code that was used during the input of that bill. My end goal is to be able to export the B&A report and sort by vendor and gl code.

Analytical reports already have automatic page breaks with repeating header. But how can I make it insert the break so that sections remain whole. By “section”, I’m referring to Assets, Liabilities, and the subsections within such as Fixed Assets or Long Term Liabilities. Our sections are represented simply with a row inserted using line type “caption”. Then there is “total” row at the bottom of each section.I know a precise break location can be set but that’s not what I want. We have multiple branches. Some are very active with lots of subaccounts, while others are nearly dormant and use almost no subaccounts. I don’t want to see the same page break location for all of them. Those dormant branches won’t need a page break at all. I’m hoping there’s a way to make Acumatica dynamically insert a page break based on the row type. If all rows between “caption” rows can’t be displayed, then it would insert a break and begin page 2 on the next caption row.   

Hi Everyone,I am having problems when trying to do a Funds Transfer. My Journal transaction for the Cash In Transit Offset is coming with the wrong subaccount (20-000) instead of using the branch the user is currently on (10-000). It is using the default preference from the Cash Management Preferences, because it is currently a required field, however I would like it to just pick the correct subaccount based on the branch. Would someone be able to help?  Regards,Clauber

How can I create a GI for AP Tran with all of the data fields without manually having to select them all in results grid. 

I have a customer who would like to create commission periods - 1st through 15th of month and 16th through the end of the month (aligning with payroll periods).  I am not finding anywhere to define the commission periods. Any help is appreciated. Thank you.

Hey everyone,I am wondering if anyone has a way or process, I have not set up yet that allows me to manually enter in the tax amounts for each line when creating an entry in the “Bills & Adjustments”. From the cabinet I find a header for “Tax Amount” but no value can be placed inside of it. Currently, the taxes auto calculate based on the rate set for the vendor & the tax category that is entered. Is there any way that instead of auto calculating it off the total amount, I could manually enter in the tax amount for each line? Thanks!

Visa Spend Clarity was able to be selected previously, trying to connect now and it is not available.  Does anyone have any success connecting?

Hello, I’m looking to determine how this report calculates margin by item and if there is a better report that could be run. I’m told it pulls the weighted average cost of the item but the margin seems off. When you break down the bom costs the margin is positive but in the report the calculation is negative. 

Hey all,I’m still wrapping my head around control accounts and I think I have a good understanding as to what they are and their purpose, but I’m confused as to why Acumatica wants me to designate a control account to any of the GL Accounts on the stock items page. Because as far as I can tell this is then causing all transactions to be posted to that control account (instead of it being a summary of the subledgers)For examples our inventory accounts right now areInventory (control account)Inventory - Goods (subledger)Inventory - Supplies (subledger)I want the individual transactions in regards to the sales of goods to be recorded in the Inventory - Goods subledger but when I try to change it to that account Acumatica gives me a soft error that it needs to be a control account. Should I just ignore this? And if so how do we get the summaries to post to the control account?Thanks!

I have a unit set setup where I am specifying start and ending accounts and subaccounts.  If you run the report and click on each individual unit set, the data shows correctly, but the high-level rollup shows additional accounts that should not be there.  This is a screenshot of the example of how the unit sets look.If you view 18CompEV, 19Family, 20Prem and 21AGED the correct accounts shows, but if you look at the DEPT or the Root level there are additional accounts that are showing.  In the first 3 groups they report all income and expense accounts in specific subaccount, the last group only includes two specific accounts in a specific subaccount, but when you look at the upper level DEPT rollup it includes additional accounts from the sub account starting with ‘21’ even though the 21AGED shows just the two accounts specified and the start and end accounts are just those individual accounts not a range.  Both the start and end accounts and subaccounts are specified on each of the gro

Good day CommunityMy client needs to add a different group or class to their COA in order to be able to report to their Head Office, who have a very different structure to their reporting. I considered adding the group as an attribute but I don’t see how this is possible for COA so I could then add to the TB or another report.Here is a small example. The additional grouping is COGNOSAccount Class Cognos Type Description 11111 CASH BANK Cash_bank Asset Bank Account - Current 11150 CASH BANK CashFloats Asset Petty Cash 11201 ACCREC OTH Prepay_Other2 Asset Prepayments

We are trying to get the number of days an invoice is outstanding.  I am trying to use  =(([ARInvoice.DRSchedCntr]) - Today()) to get the numbers of days, but I get an error.  What would be a better formula?

A Customer sent a check and we recorded the payment for $200. The check was deposited to the bank and a Bank Deposit in Acumatica which included the $200 check was created. A few days later the bank came back with a correction stating the check was written for $20 not $200. We voided the $200 payment then created a $20 payment and created a corresponding Bank Deposit. Is there a step we are missing? The original deposit with the $200 payment is still equal to the original deposit we created so our bank rec is off by $180. Please help me identify what step is missing

Hi Acumatica,May I link a document and line notes in a generic inquiry?Thanks!

Edit Branch in Bills and Adjustment.  How can I edit the option for branch in Bills and Adjustment? 

We want to be able to use Projects to document activities for Research and Development (R&D) tax credits.  I expect that the labor expenses will be the largest component of the R&D credit, with materials and prototyping materials the next largest component.   With the R&D Tax credit Solid documentation is required, but we need to be able to keep it simple as well for the engineers. Need to keep the tasks down to a minimum otherwise the engineers will not properly record their time.  Has anyone setup an internal R&D Project using the projects module?  Are there any tips to share, especially when generating the cost for auditors.

I’ve found several entries here for this, but haven’t found a solution yet.Requirement:Enter Start and End Period (can be anything up to 12 periods and can cross fiscal years/calendars) The data in each period’s column display just the turnover for that period (not the ending balance at that period)I have found good formulas to suppress printing periods not in the parameter selection. However, I cannot figure out how to get just the turnover for that period when I use a start and ending period in the parameter. Thank you in advance!