Financials

Hello Everyone,Is there a way to reverse an entire FA depreciation batch? Let’s say there are 100+ fixed assets on the batch, is there a way to reverse the entire batch?  I do not see any options here. Thanks

Our system generate credit memos that are not valid how do I get rid of them in Acumatica?

Currently when viewing the Trial Balance (detailed) you can only view one financial period at a time.It would be beter as accountant that I should be able to select start period and end period. So I could e.g. Say show the the Trial Balance and movement from 1 March 2020 to say 31 May 2020. The trail balance should therefore show the Opening balance as at 1 March 2020, the accumulated Debits and Credits for the period (3 months), and then the final closing balance as at 31 May 2020.Currently we are limited to only obtaining a trial balance for one financial period at a time. It make analysis of financial results cumbersome to work with, and each financial period needs to be exported and then summed and grouped in excel… very time consuming unnecessarily so. 

I have added AR Invoices to a recurring schedule.  Will they always show in GI “Invoices and Memos” as scheduled as long as those invoices are on that schedule?  Thank you!

Anyone tried creating approval for Blanket PO, I tried creating with a condition:But its not working. 

I have a client that has disposed of fixed assets however they still appear on the FA Balance and FA Balance by GL account Report.  Since these assets are not longer in use, I am not sure why they would still be showing on the reports. When the client reconciles their fixed assets to the GL using the FA Balance by GL Account report, they are out of balance by the amount of this disposals. I know I can build a filter to remove them from the report but I don’t think they should be there. What am I missing?Thank you in advance.

Hello,We are getting this error when adding price to a new customer. I am very new to this, but to my understanding the price is unique with customer number, inventory code, start date and end date if one exists.  This combination can not be in any other customer because the customer numbers are different.Can you guys please point me in the right direction?  

When processing non stock item the following error has occured Error:String was not recognized as a valid DateTim 

We are trying to set up our Authorize.net sandbox account as a processing center on our Acumatica sandbox tenant, however we’re getting the below error message. I created a brand new Signature Key and Transaction Key and still when I try to test credentials I get this error.Any ideas how to get around this? I’ve played around with TESTMODE and VALIDATION parameters and that hasn’t helped. 

Has anybody else integrated Acumatica with Paymode-X. I know that there are others doing electronic AP payments with Acumatica but we are looking to use a specific vendor. (AvidXchange) was one listed.https://sourceforge.net/software/compare/AvidXchange-vs-Bottomline-Paymode-X/ I see that Paymode-X does integration with a few other ERPs.  Sage, NetSuite but says it has a open API intergration with any ERP. Just wanted to see if others have used it and solicit and feedback.  

Good dayI have a customization that I am working on in Acumatica and was wondering if anyone might help me or cab just to tell me if something like this is possibleOn the employee timecard screen I am trying to add a label in a row just beneath the days to so that day's current date. Can be a label or any field but just to display the date of the current day that they are entering.And then with that I would like to add at the bottom either as a column or a label to display the total of hours that has been added to the specific day as the user enters them.Does any of that sound possible?Please see my screen shot  

Each month we do an allocation entry where we allocate all of the expenses in our corporate branch to our other branches based off a fixed weighting. The problem is, rather than all of the accounts in our corporate branch being $0 after the allocation, we want the total to be posted to an offset/contra account that would making the overall balance in the corporate branch be $0.Ideally it would look something like this: 

Hi, I have met an issue when creating a discount in a sales order invoice, how can I avoid the discount automatically rounding? I setup the discount with 2%, but the system automatically rounding the discount to 2.077922%770 * 0.02 = 15.4 / 770*0.0277922 = 16  

How do I create a location ID?

Every invoice that I try to “Recognize” in the Incoming Documents screen generates the error “Discovery Endpoint Address not set”.  I am manually dragging and dropping the invoices onto the screen and they do display but that’s all other than the error.

Hi, is there a way to include unposted transaction in Customer Statement ? or creating a alternate customer statement which include unposted transaction?

Hello,I’m having an issue where AP did not link the PO to the bill when it was entered. It went through the whole process and was paid.I know it can be reversed if the status is open, but since it was paid and now closed is there any way I can link it to the PO?I don’t understand either.. if it can be reversed, how would you apply the payment again without it thinking it was paid twice? Reverse the bill and payment and then enter it all again?It’s causing a lot of extra work when I’m in the project close out report, the costs are allocated to the project but finding out what costs belong to what PO manually with a ton of bills and PO’s on a job…it’s very time consuming.Not sure if there is a way to do a project transaction like entry where it can hit the PO but not be posted to the GL? but..Any help would be appreciated.

How do get the amount paid to vendor over time (YTD or over 12 month period) including the expense GLs used for that vendor for each payment

Hello - In one of our tenants, we had an account incorrectly added with an Account Type of “Asset”, and it wasnt caught until transactions had already been processed. Now when attempting to change the account type to Expense, I get an error message stating that I cannot change the account type because transactions already exist. Is there any way around this so that we can change the account to Expense and it populates on the Trial Balance and reporting correctly?Thanks!  

Hello, My Consolidated P&L report is eliminated but the consolidated net income under my balance sheet does not match with consolidated income statement. The net income figure that the balance sheet report pulls is a combination of parent and subsidiary without the elimination of interco transactions. It is drawn from the account class NETINCOME from respective entity.  I need help on how to make them tie under the report definition. Thank you in advance. Thank you. Regards,Cherlene

Im looking to set up a Business Event to send an Email reminder if the AP Bill → Approver hasn't approved the bill within 2 days.  I'm not sure if this is possible through a business event and how to join APInvoice to EPApproval. Has anyone ever done anything like this?

I have report where I note the account and it’s balance on one row, expand by subaccount on the next row set exampleThis is working great for obtaining the subaccount activity that makes up the account balance. However when printing the report, I would like to sort the subaccount string numerically. Currently, segment one is sorting largest to smallest while segment 2 is smallest to largest. Does anyone know of a custom expression for either the column set or row set to be able to sort the string smallest to largest? example of report output (exported to Excel), same behavior in the Acumatica screen and when exporting to PDF​​​​​Thanks for any and all help on this!

Hello Community,I have a query regarding the “ADD PO RECEIPT” button at the Bills Form and whether there's a way to display only the correct receipts.Let me illustrate the scenario: sometimes, a user may create a receipt but inadvertently input incorrect information and then proceed to release it. In such cases, the user needs to create a Return form, reopen the PO Line, and subsequently re-receipt it correctly. This results in the “PO HISTORY” tab of PO containing two receipts - the first one, wrongly released, and the second one, which is the correct receipt. Additionally, there's the entry for the Return form.Now, when we create bill for the receipts through “ADD PO RECEIPT” button, we want to see only the correct receipt (the second one) to choose in the Bills Form. This would help avoid any confusion and ensure accuracy in our billing procedures.I would greatly appreciate it if anyone could provide insights or suggest any methods to achieve this, allowing us to effectively filter

I can’t seem to figure out why this balance sheet variance column is blank - any suggestions?Here is row set:Here is snippet from statement: 

Hi AllI am experiencing an issue where Recalculate Account History (GL509900)  is not showing on Finance workspace. It would be grateful if anyone could help on this case.  Thanks