Financials

HI, We have a client that wants to create a column that always stays at December 31, depending on the year the Balance Sheet or P&L is run and have the first column of the report change based on current YTD or prior YTD information. Example a comparitive B/S is generated as of 3/31/24 in the first column but the second column will always be 12/31/23 Prior YTD or a report is run as of 4/30/22 and the Prior YTD column is 12/31/22. I know how to update the data source but having issues creating the date format to alawys pull as of 12/31/xx. Here is a copy of my formula what am I doing wrong? =Format( '{0: MMMM yyyy}',Report.GetPeriodEndDate(Report.FormatPeriod(@StartPeriod, -1, 0)))This formula should always state 12/31/XX but it does not. Here is my data source setting for the column set: If I can get any guidance on how to set tht date format to reflect 12/31/xx that would be great.   

Is there a way in Acumatica to update all SO’s and Invoices already created when information for a customer gets updated?

I am looking for an AR Aging based upon financial period that would include the unreleased retainage in it as well. This should be pretty standard to have but the out of the box “AR Aging Period Sensitive Report” does not have retainage available in it. How can we get something or is there another report that I am missing.

Entering a Payment Type “Payment” but wanting to leave it open to be applied later produces the following error and will NOT allow the Payment to be released.  (Prepayment works fine. Starting with an Existing APBill and clicking “PAY” works fine.) The error happens when the RELEASE button is clicked.Screenshot of Error:Error message that does not allow the transaction to be release.More Notes: This payment has not been reversed.  It is a new entry.The error happens on any Vendor. There is no approval map getting in the way. This particular site is customized but I’ve also tried it on a “vanilla” site and get the same error.The “Known Issues” list includes the same error but for a payment that has been reversed.  This one has not been reversed.

We have 1 tenant, 2 branches.  All expenses get recorded in 1 branch.  I would like to allocate certain warehouse and fixed costs to both branches based upon completed Sales Orders every month.  I am looking at the help allocation screen & allocation method and not sure how to get this set up.Does anyone know the way to set this up or if this is even possible to allocate expenses that way? 

I can’t seem to choose a different payment remit for a Vendor that has several different Remit addresses, it keeps printing checks to the default Remit.  

I created an expense item for mileage. Populated Pending Cost and Pending Cost Date fields as shown below. When I go to Update Standard Costs screen, this item does not appear for me to process (see second screenshot). Not sure if I’m doing this wrong for expenses, haven’t found much documentation on it. Thoughts anyone?   

I am trying to process a bank feed and it will process just fine in test mode, but when going to retrieve bank transactions, I get the error “Currency cannot be empty” They do not have multi-currency. I have never seen this error before. Can someone help.Thanks

HI @CommunityWhen I am Releasing the invoice the following error has occurred Error: The required configuration data is not entered on the IN Setup form.Regards, Reddy.

i want to update the Yellow highlighted field to James as jonathan is no more serving the company 

Hi EveryoneCurrently , we have create a generic inquiry to combine table invoice and memo  and table payment and check  in order to get the column for “ due date “ and “ payment date”   If we would like to get system to calculate the day of over due , which mean “due date” minus “ payment date” in order to get the day of over due.  May i know how to do this in generic inquiry?  Hope to hear from you soon. 

We are having problem with reports not loading.  The spinning wheel just spins.  If the report finally pops up it take over 3 minutes.  Most of the time the report never loads.  This issue is effecting financial statements and generating AR invoices.  My IT department has restarted the server and that does not help.  We can run Acumatica directly from the server and the reports work just fine, it appear to be only effecting the workstations.  We have reached out to our Acumatica partner as well.  If anyone has ran into this and can point us in the right direct, it would be greatly appreciated. 

I want to allocate this amount over the months. Does anyone have any ideas on how to write a function to divide the total allocated amount?I used the formula =SUM(iif(left([FAHistoryByPeriod.FinPeriodID],2)='01'and right([FAHistoryByPeriod.FinPeriodID],2)=right([@PeriodTo],2),[FADetails.AcquisitionCost]/(12[FixedAsset.UsefulLife]),0) ) but the report is not showing correctly.*The correct value is 6 months with 6 equal values but it only shows 3 months, or 1 month.  

Where can I list our account number in the vendor information. Very often when I contact a vendor, I am asked to provide our account number.  Where would I be able to enter our account number?

We have a situation where we need to apply the outstanding balance of the debtor to the outstanding balance of the creditor. Is there an existing offsetting functionality or third party solution that can be used?

Hello Community,I have been looking out if we have any GI or Report where,I would like to know all the payments that have been provided for a given time period. Further, I would like to know, for each of the payment:1. What invoices and sales orders are associated to it2. Who the creators are of the sales ordersIf not then by which table can we create a GI where I can display all these elements?Thanks in advance.

A credit memo was applied to an invoice and now we realize this was a mistake.Can it be unapplied? If so, please advise how?

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