Topics started by rebeckamckinney53
We have some instances where a client entered an invoice for a vendor. Let’s say it is $50. But the amount that ended up being paid was $60. In the process bank transactions window, this amount that shows is the $60. The invoice is still only for $50. We would like to match to the invoice and then just create a cash transaction for the remaining $10. Would anyone know how to do this? Or if there is a better process?
We have a P&L report in Acumatica where we have a column that calculates the percent of budget used. This column works for all lines except totals that add/subtract more than one line. The only reason I could suspect this is happening is because the system runs the line calculation after the column? I’m not entirely sure. I have tried creating an additional line that points at the total line but unfortunately it still does not calculate. Any thoughts?
One of our clients wishes to mass create different versions of the same report in Acumatica, and then have those versions saved in pdf format on their local machine. For example, under Bank Rec, they would like the Reconciliation Statement report to be able to generate the last reconciliation statement for each bank account and then have that file saved to a pdf to their workstation. I did some review and I’m not sure if this is possible without some type of customization. The automation schedules seem to be more focused towards posting transactions than creating reports. Any ideas or 3rd parties that anyone knows that could do this?
Our client has a few cash receipts every month that need revenue deferred until the next month. Would the deferred revenue module be over kill for this? I looked into the module and it mainly deals with schedules so I am not sure if it would be the best solution for them. Example:They receive the payment is September for $10K. DR - CashCR - Deferred Revenue They receive the $10k invoice in October and apply the payment:DR - Accounts ReceivableCR - RevenueDR - Deferred RevenueCR - Accounts Receivable I was able to create a few work arounds for them but they haven’t been completely happy with them.The first was that they enter the receipt of cash through the banking module when they import the bank transactions. Then, the next month, they enter the invoice and reverse with a credit memo but change the revenue account when they create the CR. They didn’t care for this because it is not a true representation of what is being done which is paying it. The other resolution is to create a prep
I think this may be a bug in the system so I wanted to throw it out there in case anyone ever runs across it. We have had it happen to a client twice and I finally figured out what it is. The transaction itself will be set to a certain period, but the detail lines of the transaction get posted to a different period. How I have seen this happen:The client has “Restrict Access to Closed Periods” selected The previous periods are closed Client enters a transaction for a previous period and gets the warning message In our case, they were fixing a transaction so they reversed a transaction We go in and Uncheck “Restrict Access to Closed Periods” and open the periods The client posts the transaction they createdWe realized there was an issue when they ran financials and the changes were not appearing in the historical month and instead appeared in the first open period. I went back to the transaction. The Date, and Period ID were set correctly. In the Details section, I added the Period ID
I am working on the ACH Payment export and keep getting a few errors. From what I can tell, this is probably because the default export scenario uses some older table names. I went through and fixed a few that I saw but the others I am not sure how to correct since the fields aren’t available in the internal fields list. Below are some of the main errors I am seeing. Does anyone have any thoughts?
I am using the round formula in a generic inquiry window but it is not working.I want to round the results of an equation to 2 decimal points. It runs the equation but it won’t round it. Both of the fields I am calculating are decimal fields (Debit amount - credit amount). I’m not sure if the equation field itself is also a decimal type so maybe that is the problem? Not sure how to fix that. Round EquationResults
Hi everyone, I feel like this probably has an easy answer but I cannot find it anywhere. I have looked through the screens and the help files. Our customer is importing GL transactions through the GL file. This last one they sent failed. We realized it is because, on the import file, the transactions are not ordered by the transaction ID anymore. When the import scenario goes to import, it fails because it is only seeing part of the transaction (since the other part is farther down in the file). Is there any way to set in the import scenario that when the file is prepared, it rearranges the order of lines by the transaction ID number assigned to it?
Does anyone have an equation that can turn a negative to a positive amount in integrations. Our client integrates several thousand transactions and a handful (maybe a hundred) sometimes have a negative amount in the Debit and Credit field. This is happening because of how they are entered in the originating system. I have tried a few equations but keep getting errors. =IIf( [Debit Amount]>0, [Debit Amount], [Debit Amount]*-1)Cannot perform the ‘*’ Operation on System.String and System.Int32. I have tried double and decimal formats and still get this error. =ABS([Credit Amount])An error has occurred while the Abs(Identifier(Debit Amount)) function was being executed: ‘Type mismatch in the argument 1 of the Abs() function: Expected on of the Integer types.’ I have tried the Int32, double, and string types. I use this in excel. Not sure if the function actually works in Acumatica but thought I’d give it a try.
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.