General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,320 Topics
- 4,381 Replies
Apparently you can Void an AP or Quick Check that has already been marked as cleared and/or reconciled in the system. I put a ticket in with the Acumatica support and was advised to put in an idea for product change. Has anyone else found this and addressed this issue?
How do I import the attachment with an import scenario? The AP Document has an file attachment. I am creating the AR Document based on the document lines in the AP Document. I can get the attachment file in an generic inquiry - On the APInvoice it is the NoteIdWith the import scenario I have the option to update the Note Text field but do not find the option to update the Files.
Our company has an ongoing problem of customers paying twice for invoices that they pre-payed on because the invoice doesn’t show payments applied to that invoice. I have added a subreport to show an invoice’s payments. Now, I need a way to use the payment total on the main report, which I know can’t be passed from the subreport to the main report. I ask about this on StackOverflow before I knew this community existed and someone there suggested a DAC extension, which I’ve never done before. I’ve read through the 2019 R1 Customization guide and have a weak grasp on how DAC Extensions work. The problem is that all of the examples are shown for user entry fields and all of the examples I’ve found on StackOverflow are for user entry fields, too. I need a extension field that is calculated for the report and I haven’t found an example for that, yet. I’m waiting to get approval from the finance department to contact our third-party Acumatica support company, but in hope of getting it done a
Is there way to create a TB starting balance update? We have already uploaded a starting TB and need to change a few accounts. From what I see, even when I only populate the Trial Balance screen with my desired GLs once I release and the Journal Transaction is created it includes every GL and assumes the GLs I did not populate I want set to zero and the corresponding journal tran is populated with that assumption. I am unable to delete any of the lines for GL I do not want to touch. Other than just posing a manual journal can this be done through Trial Balance?
Hello,One of our people posted an AR payment in the wrong amount (I surprised the system didn’t give a warning that the payment amount entered did not match the AR invoices loaded). Then he did a payment void but did that to the wrong period. So I am looking on how I can fix that so the GL matches the subledger. I can’t reclasify the batch because that does not correct the AR subledger. I can reverse the Journal transaction but again that only address GL and does not correct the AR Subledger. This is the second type of mistake that has been made that I have essentially been told “sorry once its released it can’t be fixed” which does not seem correct. So thought I would reach out to the community. Thanks
What is the best method to Convert Multiple Purchases over to Single Fixed Asset.A customer buys multiple laptops (Qty 8, similar Class, similar useful life) each at $1,000 on different dates or the same date. What is the best method to convert to an Asset.Fixed Asset thresh hold to capitalize is $5,000.Do you setup an Asset with zero value and convert the 8 purchases as components to one Fixed Asset? Or would you setup an Asset with summary amount of $8,000 and then convert purchases as components to this Asset #? Or do you setup a Parent Asset then add each converted purchase line amount to an Asset associated with the Parent Asset?
How can I use Customer Invoice to pay for a Vendor Bill?I saw the option to "Extend as Vendor" on customer screen and "Extend as Customer" on vendor screen but I didn't find how do I apply a vendor bill to a customer invoice...I would appreciate any suggestion.Thanks
Hello, Our company is a 2020R2 users. In the course of our financial workflow, we would like to create AP Checks and Payments (AP.30.20.00) first and then link them to open AP Bills and Adjustments (AP.30.10.00) later. This would be done because i would like to match AP Checks to bank transactions as soon as possible, and then book the proper AP bill. I played with it in our system, but it seems that Acumatica’s workflow is only to create AP bill first, then create a full or partial AP Check and Payment. The “Receivables” module allows for AR Checks and Payments to be created separately from AR Invoices, but not the “Payables” mode. Is there a reason why i cannot create AP Check separately as unlinked from AP Bills? Thanks,Kirill
HI, When user enter the payable bill, need to distribute the invoice lines according to pre-defined ratios. Ex. Following AP Invoice header total is 10000.But in line level user need to segregate automatically according to pre define ratio.User expectation is when select the supplier and total amount in header level, line level should be created base on header amount.Avoid the data entry mistakes user need this. RegardsNethupul
When entering a AP bill for a on inventory stock item (enter an invoice for Public Water Co. that is $1,000.00) we have to enter;Quantity 1, UOM each, UNIT Cost $1000.00, to get the Ext Cost Is there a setting we need to change to be able to just enter the bill total??
Yesterday our client informed me that there is an issue with using Gmail for sending large volume email-based communications from Acumatica. They were trying to send some 4500 statement emails when they encountered the following Gmail error: Too many login attempts. Please try again later. From my reading up, this error is possibly caused by each statement email sent creating a login attempt to the Gmail account. 2 questions on this:Does Accumatica have a config SMTPKeepAlive, which will allow the already created SMTP connection to be reused (without having to re-login each time)? If it does, is this configuration switched on? Is this an issue you have encountered before with Accumatica, and if so how was it resolved?
Version: 21.106.0024We use “No Rounding” for rounding and “#,##0” as formatting to display whole dollar amount on the report and but need 2 decimal when export to Excel for analysis. This works fine in 20R1 version, but 21R1, only whole number got exported to Excel, seems formatting actually truncated the decimals.
Do we have ? or can we have a option to see the GL posting effect (Dr/Cr) before releasing a transaction. Now we have to post the transaction to see the GL posting and if any mistake we either need to reverse or do adjustment entries.
Hello, I have a released AR invoice that had the incorrect date entered. I have tried to correct the invoice date, which moved from July into June period, and when trying to release the corrected invoice I get an error;“Inserting 'Applications' record raised at least one error. Please review the errors. Unable to apply the document because the application period precedes the financial period of the document.”So it appears it is due to crossing to a prior period. How can I correct this AR invoice and get it in the correct financial period?
Hello, One of our clients has imported and then posted several hundred bank transactions (they imported twice). As far as I know, the best way to void them out would be to create an import that reverses the transactions. If anyone knows a better way, please let me know. I have created the integration but keep getting an error that it cannot save or release the transaction. I have followed the steps exactly in Acumatica and I can manually perform them, but the integration seems to be having an issue. All I am trying to do is import a list of the transactions that need voided and tell the system to reverse them. Maybe because it is creating a new transaction by reversing?Any thoughts or ideas would be help. Thank you!
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.