Financials

I would like to reconcile my bank account daily? What are the downsides? 

Why is the QT not picking VAT and SO is coming with VAT.Kindly advice,

Getting this error when trying to update standard cost on a few inventory items...any ideas? 

How can I delete a Journal Entry that has been posted?

I wrote a new P&L in ARM with expense rows coded to show as negative. It works correctly in the report, but when exported to Excel I have the problems below:Amounts appearing as positive in Excel but negative in the formula bar (i.e. Excel treating as negative but appears as positive) Amounts appearing as positive when they are actually negative (opposite of #1) Amount showing as negative in both Acumatica and Excel (correct) but in formula bar it’s actually pulling through as a positive numberBasically the negatives are all wrong in Excel, but not consistently so 🙃 I’ve looked extensively online and in the community but haven’t found a solution. An example of the row format is below:  Appreciate any help! 

I recently moved from using Business Central and in that system we could set up a posting table for sales and cost of sales using BOTH item class and customer group.  I’ve searched but can’t find how to do in Acumatica.This setup is great for groups as it makes it easy to split out intercompany activity for elimination.  Its also useful for segment reporting.Any ideas?  thanks Peter

We have recently made a transition to a new a structure with companies and branches. When I was moving items over I transferred my trial balances for 12-2022. My cash account TB is one amount and my cash account balance on the last reconciliation is off. What would cause this? 

Migrating from Quickbooks online to Acumatica. Attempting to doi the whole process by myself. Is the any step by step  instruction or documentation on this 

Hello,Is there a way to recognize a PDF file that contains two or more invoices? (That is can it create two/more bills from a single PDF)

I am uploading 2020 and 2021 Journal Transactions. Whereas, the 2020 entries were accurate, the 2021 entries do not appear to include opening balances. This is only happening on various Companies and GL Accounts.

All. We recently transitioned to Acumatica and in the banking module the is no Bank feed option or feature. Do i have to manually add this feature and how or is the enabling function i am missing

What causes Discrepancy in AP and GL account?Below Discrepancies with AP and GL Account.Items marked in RED are as a result of Application generating unexpected Gain/Loss Amounts and Adjustments in Accounts Payable.Items marked in GREEN are GL Journals that need to be reversed  Row Labels AP GL Grand Total (blank)   633,263,334.12 633,263,334.12 CHE005 1,385.29 1,026,146.72 1,027,532.01 CRO001   -11,135,600.00 -11,135,600.00 GIL001 3,032,803.84 22,211,198.21 25,244,002.05 JAM001 5,189,640.00 -2,062,640.00 3,127,000.00 NDU001 0.00 -10,795,608.00 -10,795,608.00 (blank)       Grand Total 387,841,130.29 252,889,529.89 640,730,660.18   

What causes Variance in AR and GL account? how can we correct such discrepancies?Below Discrepancies with AR and GL Account.Items marked in RED are as a result of Application generating unexpected Gain/Loss Amounts and Adjustments in Accounts Receivable.Items marked in GREEN are GL Journals that need to be reversedVariance Between AR and GL Customer Customer Name AR GL Grand Total           (blank) (blank)   -287,877.69 -287,877.69 AGA001 (blank)   -39,399,922.38 -39,399,922.38 LAN001 LANCET LABORATORIES TANZANIA 519,130,795.22 -519,398,673.64 -267,878.42 MIL001 (blank)   1,000,000.00 1,000,000.00 Grand Total   7,496,567,071.64 -7,535,522,750.12 -38,955,678.48    

Hello, We have had multiple instances where a credit card payment was captured in Acumatica but returned an error and the payment was stuck in pending processing status. The Processing Center Response Status was “Capture Failed” and the payment could not be voided or recaptured because it was in pending processing. However, the payment somehow made it through to our processing center, authorize.net, and settled successfully. Clicking “Validate Card Payment” on the payments screen in Acumatica only returned the response, “Does not exist”. Is there a way to have Acumatica acknowledge this order as paid? Thanks!

Team,We are having issues with one of our Customization project in the upgraded version 2022 R1.Issue : We have an extension for QuoteMaint in our customization project. public PXDBAction<CRQuote> mAKLSubmit;        [PXUIField(DisplayName = "Submit", MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Update, Visible = true)]        [PXButton()]        public IEnumerable MAKLSubmit(PXAdapter adapter)the click event finally triggers this Base.Approval.Submit(adapter);Base → QuoteMaint, Approval - > [PXViewName("Approval")]        public EPApprovalActionExtensionPersistent<CRQuote, CRQuote.approved, CRQuote.rejected, CRSetup.quoteApprovalMapID, CRSetup.quoteApprovalNotificationID> Approval;Submit → Actionin the current version Submit action is not available anymore also the View Approval has changed to  [PXViewName("Approval")]        public EPApprovalAutomation<CRQuote, CRQuote.approved, CRQuote.rejected, CRQuote.hold, CRSetupQuoteApproval> Approva

Hello Everyone, Just wondering if there is a Fixed Asset training video in the Acumatica OpenUni? Thanks in advance!Kind regards,Mrivera67

A user is trying to “ACTIVATE UPGRADE” for a customer contract and is getting the error “Nullable object must have a value.”   Looking through the trace it doesn’t appear it’s caused by any customizations.  Has anyone else seen this error in the customer contract area?   We’re using 2022 R1. 

Hello Team, Is anyone having issues with Bankfeeds at the moment? It seems like some banks have limited Plaid or MX from being able to sync transactions on a regular basis.Few weeks ago, we were able to sync transactions without any limit, but it looks like some banks have made it only possible at a certain amount of period per day/week.Do we have any alternative to this? Thanks!

How can I make the remittance page print last instead of middle where it voids a check?  

Is there a column set import scenario available for download somewhere that works with 2021 R2? I need to create a rolling 12 month P&L that has 4 columns for each period. Not being able to copy/paste columns and update the needed fields is causing this report to take too long to build out. 

Hi Team,For one of the GI’s in the Customer Portal we are having issues with the navigation. This is happening in the upgraded version of 2022 R1, the same GI navigation was working in the older version. When the row is clicked on the GI, it always redirects to the home page. 

Hello,Does anyone know why you cannot restrict visibility from GL Accounts flagged as Cash Accounts?Thank you

Their product is impressive and CCH has been around for many years.  They are relatively new to Acumatica and I looking to find out what has been the experience in using CCH Sure Tax.

Our Elan contact is saying they do not support Plaid even though Elan comes up on the Plaid website as supported at https://plaid.com/demo/?countryCode=US&language=en&product=transactionsHoping we were just talking to the wrong person at Elan as we would prefer to use Plaid rather than set-up the infrastructure for file transfers and then automation into Acumatica which is what I understand Plaid does for us.