General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,460 Topics
- 4,847 Replies
Hi,I am trying to configure an approval map for journal transactions, where the approver is the supervisor (reports to on the employee profile) of the user that entered the transaction. Here is the conditions tab On the Rules Action tabI have tried drilling into the owner option, but nothing is working. I have the reports to field populated on the employee profile.Any help is appreciated.
Our company uses LIFO accounting, which is generally only used in the United States, however it is GAAP compliant.I am just curious if there is any interest out there for a LIFO accounting module in Acumatica? We will probably write some software to calculate the LIFO reserve for our own purposes. We use dollar value LIFO. Thanks, Jonathan
Business case: Get multiple invoices from same vendor with same dollar amounts. Approver has to click into each invoice to see invoice number. If you click into the invoice, it then reverts the invoices you marked as approved back to blank. Very tedious and time consuming. The vendor invoice number field is NOT available to select in the Column Configuration screen.
Hello, For our company, we have two employees with the same roles in Acumatica that need to be able to edit expense claims before they get approved. To do this, they put them on hold first, which I believe to be the correct process. However, one of the employees has the on Hold button available while the other does not. Does anyone know where/how to set up the users to have the same options available for expense claims? Thank you!
Hello there I am trying to run the TB without suppressing zero balances so that I can make an excel sheet mapping to all my accounts (regardless of the balance) to build my own P&L and Balance Sheet. I have never managed to get this done within the application and don’t like the look of it anyway.So I have done this for the first month of our accounting year and have unticked suppress zero balances and yet accounts which have no entries are actually suppressed. What is going on I feel as if Acumatica is always trying to trick me! Is it only the Balance Sheet that this tick box responds to…? Best Regards All
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!
Team, I am struggling to explain Unposted Journal Transactions. I know there are some issues and some scenarios explained, but for normal people, why there is unposted transactions on the system? They are random, and can have a good explanation for my client, every now and then, when closing the month, there will be uposted journal transactions, and there will be no good answer for those. I have put a schedule to post every night unposted transactions to see if the problem goes away, but still want to have a good answer for them. Thank you.
Correct me if I’m wrong, but in AR payments and applications, after you selected the line items and put in the payment amount, when you would go to release it, it would automatically delete the other line items that you didn’t use. It doesn’t seem to be doing that now. Any thoughts? We’re using 2022 R2.
Hi Sir I have set a recurring transaction , start date is 1 Nov , run at every month and end of the day.However , i did not see any recurring transaction generate on 30 Dec 2020 for the below, does it mean i need to go recurring transaction to “ RUN NOW” instead system can run it for us?
There is an old video on the topic of Customer Refunds where the user goes through about five or six steps to issue a refund to a customer. And it works great! However, there were too many steps and Acumatica appears to have simplified the process in subsequent releases.So now, in my 2021 R2 demo database, when the credit memo is on the screen, there is an option on the ...More menu to REFUND the amount to the customer. I’ve done that and I see a JE that shows AR was debited and Cash was credited but I don’t see where a check was actually issued to the customer. I can’t find a pending payment in payables but the JE looks like is was processed as a check.The whole point of this exercise is to issue a refund check to the customer and I’m just not seeing it. What am I missing here?
Hi. We have a client requiring setting up of approval maps for 156 branches for 12 modules 2 tier (preparer → reviewer) 3-tier (preparer → reviewer → approver)with conditions and rule actions. We believed we can expedite by either using import scenario or, worst case scenario,do a direct SQL.Anyone encounter such experience before? Thanks in advance.
When a GL account is assigned to an account group, the GL account will be required to have a project associated with it. Some forms do not allow for project number input which prevents use of that form. For instance, attempting to utilize the create adjustment tab in the reconciliation statements is not possible because the quick transaction screen does not allow the user to input a project number (there is no project field available.) Other areas where this is a problem for companies that utilize projects is in the fixed assets module and in the allocator process.
Hello, I am writing a report to customers and would like to show the AR line amt and line taxamt.however, The ARTran.TaxAmt is empty, and also the ARTax.TaxAmt is empty. We do have TaxAmt on TaxTran, but is is not single line, it is the whole AR document. Can somebody tell me where I can get the line TaxAmt directly? Or I have to calculate it by myself?
Several customers have requested Financial Reports (P&L, etc.) by week. In some cases they would like to look historically to compare a week in the current period to a historical period for trend analysis. In other cases they budget by week and revise their budget for next week based on last week. A good example is a hotel chain where they look at room nights to determine staffing and supply requirements. We are looking at Velixo and Power BI but would prefer to have an easy solution that is more out of the box and built with standard Acumatica tools. Has anyone tackled this and can share their experience? Anyone else need this functionality?
About: We would like to gather your feedback on cross company sales features for our upcoming release. We held our first focus group in November 2019, but want to dive deeper into re-invoicing expenses and selling goods.Providing services to related companies (launching in 2020 R2 - automatically create a matching AP Document when you create an invoice for related company). Re-invoicing expenses to related companies (focus group topic) Selling goods to related companies (focus group topic) Selling goods from a related company warehouse Transferring goods with a profit marginAudience: Customers and partners who need this feature or have knowledge of workflows and how it can be delivered.Date/Time: Aug 26 @ 9am PDT / 12pm EDTRegistration: https://webinar.ringcentral.com/webinar/register/WN_qMl1oU97S-uBb4vA0j5nAA
Historical Inventory Valuation : How to adjust out the inventory without do the adjustment transacation
Hi SirWe have encountered a problem about the inventory , we make mistake do receipt in a part # where that should be use existing 5 parts to do kit assembly into one part # . Currently , our system have extra 5k in inventory history valuation but in financial inventory account is correct . We cannot do adjustment transaction as it concern about double entry where it will affected financial account figure.May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure? Hope to hear from you soon.Thank you
My client recently began using AP Approvals. Specifically, they added an AP Approval Map to the AP Preferences form under the Approval tab and activated it. Since doing so, when an AP Bill is entered and saved and taken off hold, it moves to a Balanced status as normal. However, we’ve noticed that they are no longer able to add new lines to the Bill, change dates or vendor locations, etc….all things that can normally be done for a Balanced AP Bill.If we deactivate the approval map on AP Preferences, we can go back to the same Bill whose fields were greyed out and no lines could be added or changed or deleted, put it on hold, then take it back off hold, and now all those fields are available for editing again and new lines can be added, etc.If we reactivate the approval map and do the same thing - put the Bill on hold and then take it off hold again - we are back to the fields being greyed out and no lines changes are allowed.If it matters, this Bill is not subject to the approval map
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.