General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,468 Topics
- 4,869 Replies
Hi everyone, I have an ARM reporting scenario that I'm looking for some insight on: The Unit set has multiple levels. Below the consolidated level are two units: 1. "Divisions" unit that contains all divisions, each of which is a subaccount (basically a rollup of subaccounts), and 2. An "Executive" unit that is itself a single subaccount. At the Consolidated level I need the report to show Divisions and Executive for each row, but not all the subacounts within Division. I know how to expand by account or subaccount, but in this scenario I need a rollup of subaccounts + 1 separate subaccount, or an "Expand by Unit" option (which doesn't seem to exist). If I simply Expand by Sub it will show all the subaccounts under the Divisions umbrella, which they don't want. Below is an example in demo (didn't want to post actual unit set). Thanks in advance for any help!
Hello Community,I am stuck in an issue, where my company, in Acumatica, has the base currency of EUR and the payments recorded under this company’s cash account is in SGD. So here I have the Bills and Invoices in multiple currencies (AUD, MYR, INR etc). I have been migrating the data from Xero to Acumatica, so all the previous payments that have been recorded in Xero has the company been created with base currency of SGD, and also the cash accounts in SGD. Can you please suggest me how can I now make this in an easy work around in Acumatica for recording the payments?
Hi, I am doing a testing about the Update Sub. on Order Owner Change function at Purchase Order preferences for future used. So, how does it work? is that when I change the owner of the purchase order, then the expense sub will change based on the department setting? However, when I change the owner to other department, the expenses sub. will not change, can anyone explain to me how this feature works? Thank you.
I have migrated approximately 460 fixed assets that now need to have their Purchasing+ transactions released while still in initialization mode. Using the ‘Release Fixed Asset Transactions’ screen requires that the ‘Update GL’ box be selected, however, since these are migrated transactions we do NOT want the GL to be updated.I am able to release the transactions one-by-one while in initialization mode. Is there a way to mass release these transactions while remaining in initialization mode?
Good morning,Our customer works with authorized.net.Their customers call in ahead of a sales and give them their credit card to be stored in Acumatica.So, our clients needs to be able to store multiple credit cards per customer ahead of the orderWhere would these credit cards be added and stored?Thank you!Monika
I have a scenario where when a purchase invoice is received and matched against the purchase order I want the purchase invoice to be approved by the owner of the purchase order.I have tried different options using the employee from list option on the approvers tab but cannot get this approval working.The only way I can get this working is if I specify a rule per user listing the user on the condition tab and again as an employee on the approver tab. With more than 100 users entering purchase orders this well not be easy to maintain.Anyone came across using the employee from list for this purpose and could advise
See the attached screenshots. As you can see, the undeposited funds report shows Prepayment 009665 Ck#1389 with the amount of $3767, but when I add this payment to a deposit, it shows the deposit amount as $0.00. The reason I have a voided payment on there as well is that we tried just voiding this and reentering the payment to resolve. Unfortunately, the voided payment shows up as ($3767.00) causing my correction deposit to be negative. I have been using Acumatica for almost a year and have not seen this error before. Can someone tell me why this happened and how to resolve it?
Hello - We have an AP payment that was erroneously applied with a date of 06/29/2028 in the post period 06/2023. I know there is an option under the Payment Methods screen to allow “default void date to document date” for AR, but what would the solution be for AP?
We create service orders and sales orders (type of SO), which then get invoiced from there. We also create RC Sales Orders for Credit Memos, which are created in the SO workspace. The invoices, once released, go into Receivables, but they bypass the Receivables approval process.We need approvals on all invoices and credit memos, not just the ones that are created directly in the Receivables workspace, and approvals are not available for SO invoices and CM’s. Is there a way to put this in place?
Hello, For ARBalance, we have a table/DAC named “ARBalance”, it already sum the result group by customer and branch. However, for APbalance, it seems we don’t have a talbe/DAC like that. We have a DAC called “VendorSumary”, but it sum the vendor balance up regardless the branches. Do we have a DAC like “ARBalance” which I can use directly. Or I have to count per every open AP doc?
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.