Financials

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

Hi everyone,I am looking for some input from anyone else who has to pay sales tax prior to the end of the month. We are in Massachusetts, which requires certain businesses to make an advance payment before the related tax return is due.Due dates:Advance payment of tax collected through and including 21st day of month due on 25th of monthly filing period Payment of remaining amount due with return on 30th day after end of monthly filing period.So due dates would be as follows:June 1 – June 21: due June 25June 22 – June 30: due July 30July 1 – July 21: due July 25July 22 – July 31: due August 30August 1 – August 21: due August 25August 22 – August 31: due September 30 We do currently have a process, but it requires a lot of manual intervention which introduces opportunity for error. As there are many states who require advance sales tax payments to be made, I am interested in how other businesses calculate advance sales tax payments so that I do not have to reinvent the wheel.We are usin

Hi! Can you run a different schedule for a different item on that is on the same contract? Without having to create a new deferral code for every new transaction, is it possible to update the deferral schedule if the customer decides to postpone a service for a later date?For example, I can change the Rec. Date in the transaction section, but when clicking on GENERATE TRANSACTIONS, the date goes back to what it was.  Based on testing, answers to both questions would be no, but we would like to confirm there is no other ways. Open to any suggestions, thank you in advance for your help! 

If I have a stock item that I purchase and sell in the same form, the purchase of that item is tax exempt but is taxable when I sell it. How do I set up a stock item so that sales tax isn’t added onto the purchase order but is taxed when its on a sales order?

We are utilizing the expense receipt and expense claim process to capture our corporate credit card expenses.  We have noticed after releasing the claim at the time when expense receipts are converted into cash purchases that each receipt generates a cash purchase which matches the date and description of the claim not the date and expense of each receipt associated with the claim.  Why?  And can this be changed?  This causes a claim containing 30 different receipts to contain the exact same date and exact same description and little way of distinguishing them when looking at them from the cash purchase inquiries.  It also makes it very difficult during credit card reconciliation because the date of the expense does not match the date listed on the receipt.  Is there a setting that we need to change?  Or is this how it is intended to work?

When sending email statements from the Print Statement screen, AR503500, the process fails and shows the error:“There is no active notification source to process the operation.”The form AR641500 has the statement notification specified in the mailing settings. It does include a condition: If it is branch ;X’ , use XStatement notification, else StatementNotificationThe two email templates for the statement emails are set up correctly with the correct screen AR503500The customer mailing and printing settings include the Statement mailing ID. 

Good morning, I’ve got an issue with the Print/Email AR Documents.  When we go to process emails, we got the error There is no active notification source to process the operation.  It looks like this is due to not having a email template set up for this function.  But, we have a modified email that gets sent when we process a email directly from Print Invoices Report.  Where would this information be stored if I don’t have a template set up?