Financials

There’s many times I need to do an entry to hit a direct customer’s account in AR or vendor’s account in AP.  How can I do this in Acumatica?  Here’s a screenshot of an example how I used to do it in Quickbooks: 

Just wondering if anyone might know the answer on the Customer Contract (CT301000) you can set an Expiration Date. There is also a Status of Expired but i cannot see any Action/Process that will set the Contract to Expired as the Contract will stay active. If i change the Date to be in the Past it does not update the Status 

We have several customers who are paying through a Credit Card portal that is integrated into our Acumatica. Our main location is Atlanta, but we have customers paying from Orlando and Nashville using the portal.Acumatica will process the payments and the funds will be received. However, the funds will only go into our Atlanta Bank account and not the company for which the transaction took place. This then leaves the transaction as pending processing or balanced (unable to release or close). This is creating many Inter-branch Acumatica Issues. See screen shot below: My questions,1. will activating the Inter-branch Transaction feature in Acumatica release these transactions and show as paid? 2. If activating the Inter-branch feature, will this cause any other issues within Acumatica? Is this a viable solution?Thank you for your time.

Hi Acumatica!How can I make the following pivot table display periods ascending chronologically, and sort the GL accounts by name?The constraints of this task are that the GL account displayed on the pivot table is a concatenation of the account CD and the account name, and the financial period displayed is a concatenation of the last 2 and first 4 digits of the Fin period ID.In this example, I was able to sort the columns chronologically only after including the Fin Period ID on the pivot table, but I would like to hide it for readability.Thank You!!! 

Hello, I would like to see a report that shows a list of our customers and the average amount of days it takes for each customer to pay their AR invoice. Does this currently exist in Acumatica or is there a way to quickly create it or add it? Any help that you all can provide would be greatly appreciated. Not looking for an integration. 

Hello,I’m reviewing the AR Aging report and it seems that I have a discrepancy between a payment and subsequent invoice. Is there a way that I can zero these both out and remove them from the AR Aging report?  Thanks,Brandon McIlhargey

Do any UK users have experience of setting up Acumatia to support collection of Direct Debits ?This involves sending an XML file every month to a bank with details of the Direct Debit payments being requested from customers i.e. customers bank details, an amount to be collected, a collection date etc.

Good day,I have two Cash Entry transactions that show they were cleared.  Since they are cleared they don’t show on the bank reconciliation; however, the bank rec is out of balance for the exact amount.  The CA Account is correct; the COA is correct and don’t see any issues with the transaction.  The clear date is in the same month as our Bank Rec.  I could not find where it was cleared.  The transaction was entered directly in the CA module.We are at a standstill.  We can process the July Bank Rec and suggestions?  Ideas?  Do we reverse the transaction and then reentered?  How could this happen?  Same period.  It happened on two transactions entered on the same date for the same Cash Account.Anyone have a corrective solution?Evan  

I have a prepayment that was applied to a SO. For some reason the correct amount of money was not transferred to an invoice, and I had to manually apply part of the prepayment to the invoice document. But now the “transferred to invoice” total does not equal the same amounts of all invoices (that are paid via that prepayment) Below are some screenshotsPrepayment:Application History: As you can tell there is a remaining balance and applied to order but the sales order still has an awaiting payment status.

Hi Team,’I am getting this error when I try to select an inventory item in journal transaction entries.  Never got it before; I am the administrator so makes no sense, and I cannot address on own. Cannot accrue and have Inventory IDs listed on accrual entries and therefore cannot bill (again…) the xxxx project until this is corrected.  Please advise.

Hello, I cannot find the Prepayment to apply for my bill. Can some help me with it ?  

I made a mistake when applying the wrong prepayment to the bill.I want to reverse the check and payments then it move me to create Debit Adjustment. After creating a mess, i totally lost now.Can someone help me to solve this issue ?  

Hi, one of the employees got the wrong Warehouse in the Sales order. What are the remedy for this? Is there a way to change the Warehouse ID on Shipments or somewhere in Sales Order?

Acumatica only supports 1099 NEC and MISC filing natively. Why are the others still excluded?  When will the other options be available. This is another instance where Acumatica does not satisfy the year end filing requirements for my client base. Client’s do not understand why some 1099 filing options are not supported (I do not either) 

When I add manual document discount to Po Order ,discount amount don't reduce automatically. I want to auto reduce at AP bill . Is this possible ? How solve?

As Payment method and Cash account not required in Credit memo. If added that, its crating Payment record.   

I am working with Acumatica 2024 R2 in Reconciliation Statements screen. I need to add totals of receipts and disbursement in detail section as a footer. I am supposed to make those updates in the detail grid of the Customization Project Editor, but there is no detail grid available. I am new to this kind of configuration. Please show me a detailed method.  Regards,Nisha

Is there a way to set Retained Earnings to close to one singular subaccount instead of each one individually? And, if not, what is the workaround most people would recommend? Make a journal entry? The only issue I could see with that is that it will have to be done for any transactions that need back-posted to the previous year after closing. 

       Currently, in the liability section of our balance sheet, "Purchase Accrual" and "Accounts Payable" are displayed separately. Our company’s accountant has requested that the values of these two items be combined and shown as a single line item on the balance sheet.After checking, I noticed that it seems I could simply change the account class of "Purchase Accrual" from "othcurliab" to "AP" to achieve this. However, would this cause any issues? Is this the most recommended approach? Are there any better alternative solutions?

When entering a new customer and linking to the Parent ID, it is still necessary to populate the Bill To Info on the Child record. Is there a setting to automatically pull the parent info into the child account?

Hi All,I need to correct an invoice, removing tax and updating bill-to data. (I updated the customer profile to prevent recurrence for future orders).Steps taken to resolve:To avoid reprocessing the shipment (which has already gone out), I followed steps for invoice correction, which generated a correction invoice document that meets my requirements, but when I try to release, I get the error message: The tax amount calculated by the external tax provider cannot be applied to the document. AR Error: Total application amount cannot exceed document amount.For the ARError, I expect this is because my original invoice $ DocBalance is more that the correction invoice (tax amount = $0.00 in the correction document). I saw a solution in another community post for a similar situation where a credit memo equal to the tax amount is applied to the original document, allowing the correcting document to be released. However, when I try, Acumatica doesn’t let me apply my credit memo to the original

Hi ,I have a requirement to depreciate fixed assets 100% at the purchase. Does anyone have an idea how to set up a depreciation method to depreciate the asset 100% at the purchase period?Best Regards,Dulanjana

In the settings of the Statement Cycle, there is an option not to print empty statements.In our understanding, these are customers with 0 or negative balance. However, when we unselect it our Print Statement screen still show the Customers with 0 or negative balance.  Another thing is that, in the screen Prepare Dunning Letter there is an option to exclude Credit Memos. Is there a way to do this for Statements without doing customization? Thank you.  

I have created a Sales Order and linked all the items in the Sales Order to Create a Purchase Order.Now I have modified the Sales order to add in an additional line. I cannot seem to link it to the existing Purchase Order. Mark for PO is ticked on the SO line. If I use Create Purchase Order it will create an entirely new Purchase Order If I go to the existing Purchase Order, the line type will change to Goods for Inventory instead of Goods for SO which enables me to link back from PO to SO.How do you link the items from the SO to an existing PO? Surely this is a common issue. 

Is Acumatica planning to upgrade the Report Designer? I am not a professional, but sometimes the report designer feels worse than Excel, which has more features.In one window, it shows that the expressions you created are valid, but in another window, it shows an error.When you preview, it shows "XML not well-formed," but if you save it to the server and run it from the system, there are no issues.There is no option to preview based on a reference document. It shows some documents randomly, which does not help to find the changes/results. To check, the only option is to save back to the server and test.The formatting features are very limited. Viewing in grid format is possible, but there is no option to zoom in or out.These are just a couple of issues from many.Acumatica overall has many options and features. However, to be honest, when doing quality testing, there are many options whose workflows and explanations are not clear. Even when we try to research it, it is hard to get clear