Financials

Does anyone know why journal transactions from the AR Module wouldn’t automatically post to the GL if it’s set up to do so?  We have noticed that 3,666 transactions from a one week period in December have not posted to the GL. I’m relatively new to the position and at a loss as to why this would have happened.  Any help is greatly appreciated!  

We created a new subaccount to have sales orders split out into a new bucket for additional analysis.  Everything is flowing correctly going forward, but I would like to go back and reclass existing transactions (sales and materials) to get to the proper subaccount for historical comparison.  I can get to the sales numbers by running the sales order report and filtering to what is needed.  The part I am struggling with is how do I get to the materials cost to complete my bulk reclass entry?  I am not finding a way the 2 are connected by a reference number or some way I can get the data into a spreadsheet to identify the entry needed.  I would love if anyone has an idea of how I can make this happen!

Can someone help me to restrict the access of user to see only debit memos / debit memo but not to see payments under bills and adjustment??

Does anyone know of a way to extend a customer to a vendor if that vendor already exists? I know you can do it if they do not, but what if the vendor exists? Same for vendors to customers? 

Hi,I need to void a customer payment received back in few months ago. There is a field “Card/Account Nbr” which is empty and the system said it can not be blank. I try to enter something into it but can’t. Not sure what to do. Please help. Thank you. Raymond

I have a user uploading an Excel file into the journal transaction screen. If a subaccount in the file is inactive in Acumatica, it automatically changes to the subaccount of previous line. No warning or anything.  I tried recreating in my local test environment, and instead I get an error that subaccount is inactive. I don’t see any relevant differences in the settings. Anyone seen this or have an idea how to solve? Unfortunately upgrade was delayed so I can’t submit case with Acumatica. 

Hi Team,Good Day!As a practice our company used to print the payment voucher from the checks print process. (Kindly refer the following image 01)Image 01In that process one check is only allowed to print at only once. So if we have any issues with the print we are not able to reprint it also we are unable to track the issues.So my concern is, is there any other way to get the print of the payment voucher from the system ? (Without using the check printing process) Thanks & Regards / Yashodha

Our customer would like to apply payments by using a process for pay/release A/R invoices.For credit card there is “auto-apply payments” but this is not available for any other payment method.What do you suggest?

I have the expense claim below in the screenshot.  There is MAJOR issue here where I cannot figure out why the Expense Claim Total equals 1,043.86 but when I add up the line item totals it ONLY amounts to 929.56!  Why is there a 114.30 difference??  Note that 114.30 is exactly the same amount if you add line items of 24.30 and 90.00 together.  It looks like Acumatica is DOUBLING those two line items.  But why??   

I have a client that wants their report titles to include the following verbiage:“For the X Months Ending DATE”Where X equals the number of months (in words, not number) the report represents, and DATE is the period end date (in standard MMMM d, YYYY format). What is the best formula/format to attain this outcome?Thank you in advance.

Hello - We have a pretty basic PO Approval process set up. Anything over $XXXXXX. This works well. I would like to add a step that sends a notification to the PO Creator that it was approved. Below is our rule as it sits today.   

Hello, is there a way to create a cost centre? for example creating “workshop centre” where all related sales and expenses are tracked etc? 

Hi,If I want to create an invoice for a customer, what is the different between the two methods below? Receivables/ Invoices and Memos/ New record Projects/ Run project billingThank you. Raymond

Please see the screenshot below of what we see when we try to login to Acumatica.  Please note that the browser in the screenshot above is not Chrome, but Mozilla Firefox. The same error shows up in both Chrome and Microsoft Edge. Because of this issue, when we log in, we are unable to access any part of the system as the icon keeps rolling but never opens up a page. See screenshot below;  We need this resolved immediately as it is impacting our year end closure processes. Expecting your prompt response. Thank you

I am aware that Acumatica allows 1099 reporting.  Is there a particular 1099 form number that is best formatted to work with Acumatica?

Hello Everyone, Recently we have upgraded to 22 R1 version but General Ledger Details report is crashed.When we are trying to navigate the report from Profit & Loss report to General Ledger getting this error.Can anyone help me on this?CC: @Irina  

When running depreciation I first received the message, “Object reference not set to an instance of an object” when switching screens to select more assets for depreciation. Because of this error, I selected the assets on the first screen and ran depreciation then selected the assets still remaining and received this error message:Can someone please help me with this issue?

Happy New Year!!An incorrect AP invoice (status: closed) was posted in September but I tried reversing it with a debit adjustment (status: closed) posted in October.  I now try to reverse the incorrect debit adjustment with a credit adjustment (status: open).  Any ideas on how to close the credit adjustment, correct the AP invoice in September and correct the debit adjustment in October?Any help is greatly appreciated!Thank you!

prepare customer statement to as at date?

Hello Acumatica users,Happy New Year! As it relates to AP data entry (and using the new features of Acumatica to read and prefill invoices), can Acumatica automatically grab documents from a dedicated email inbox for invoices?  And, if so, can it decipher a branch based on the inbox?  ie we have a dedicated email per branch.  ABCIncapbills@Stockmeister.com and DEFIncapbills@Stockmeister.com.  Can Acumatica Put ABCInc’s PDF’s in the ABC branch and DEFInc’s PDF’s int the DEF branch? 

We are new to using Acumatica and unfortunately, we are having difficulty setting up the bank feeds to pull in correctly.  Our initial direction was to pull them in BEFORE rules were set up to identify the card users, so they all pulled in under one user.  We have not been able to obtain clear step-by-step instructions for the proper set up of credit cards.  We have fully utilized all of the on-line tools within Acumatica and Acumatica University, but they are lacking the details we need to get the system set up properly.  We would like to delete all of the bank feed transactions and re-pull them now that we have rules set up for pulling the credit card users. So, first question is, does anyone know how to do that?  Second question: does anyone have a step-by-step set up guide they would be willing to share to help us get this set up?

In my G/L I have three intercompany accounts for each related entity: AR receivableAP payableGL pay/recIs it possible to use a dummy bank account in Acumatica to net all these payments to just the G/L interco account?

Hello,  Could someone please explain the relevance/importance of GL #24900 Suspense Clearing Account. I see it when I run my reports and I would like to know how it is calculated and its importance.  Thank you!

Hi Guys,We had a situation. We mass processed 9 checks at a time and printed those all at same time. But the physical print went wrong due to some reason and we are not able to reprint those with the same check numbers. Acumatica doesn't allow to use the same check number again and this situation client will be facing multiple times. So, need a solution that can help reprint the checks with same pay ref number or maybe with the ones those are already used.  Thank you for help.

We’ve found that for companies that have the “Allow AP Bill before Receipt” option enabled for their vendors, the Purchase Accrual GL account and the Purchase Accrual Summary report in the Purchases module don’t match. This is because the Purchase Accrual Summary report is based upon PO Receipts. Companies that allow AP Bill before receipt cannot then easily reconcile their Purchase Accrual account. We can create a different GI or report for this, but before we do, I thought I’d ask -- has anyone else run across this and if so, how did you resolve?