General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,320 Topics
- 4,381 Replies
Hi Everyone.I recently had a question posed to me and I am still researching possible options. For inventory adjustment, the subaccount can only be specified through the reason code. Is it possoble to specify the subaccount outsdie of the reason code (directly on the adjustent)? Thanks
I applied a 100% discount to the purchase order, but the discount didn't appear in the Journal Transactions. However, this issue doesn't occur with the Sales order, as the Sales order cash discount is properly reflected in the Journal Transactions.please check the screenshot belowPurchase Order Sales Order
Is there a way or method in Acumatica that can prevent people from backdating documents? I know closing periods prevents posting in past periods, but our Controller wants to prevent the dates from changing. He does daily reconciliation and it’s messing him up. For example, in AP. AP created a check on August 8. They did not process the check until August 14. When the controller runs the ending cash account balances on the 8th that check isn’t in there. Then it throws off his numbers when she posted it on the 14th.
In the use case of customers or suppliers having open on account or prepayment amounts it would save time and help keep customer accounts more tidy if these payments/prepayments could be allocated with a payment.For instance:Customer pays a deposit or stage payments prior to being invoiced eg $500Customer invoice is raised for products or services rendered eg $5000Customer payment to settle invoices is received for $4500 - It would help to be able to select both the above transactions during the application process leaving all transactions in a closed status. Currently I don’t think payment or prepayments are available on the Doc. Type drop down list.I hope this makes sense.
I try to file the 1st sales tax in Acumatica, but it always auto-updated with future tax period while the old period is still open. Ie: I tried to close HST return period from Mar 01-May 31 2023, but system always give me the HST period for Aug 2023. I tried reset the tax period. It didn’t work. Could you advise how should I do to proceed the May HST report. Thank you.
We are in the process of switching from authorize.net to PayFabric’s integration for credit card processing and AR automation in Acumatica. Our main reasons for changing are to simplify the payment process for counter sales since their credit card reader will feed directly into Acumatica and to hopefully improve AR collections with their ‘click to pay’ links on invoices and automated sending of past due reminders.Looking for feedback from anyone who has used or is currently using them.
Good day!I just wanted to ask about this kind of unusual error upon processing Master Financial Calendar. The table shows that the data for the 12 months of 2024, from January to December, was aggregated into a single financial period which is 01-2024 while having a start date and end date of 1/1/2024 and 12/31/2024, respectively. May I know any workarounds or what should I do to correct this? Would love to hear your opinions on this matter. Thank you.
Hello, we recently upgraded to 2023 R1 from 2021 R1 or R2. Our third-party support company did the bank feeds migration and we have set up all our cards, but it is still not working. I have been told that there is data missing from what our bank is sending through Plaid to Acumatica. I can import the bank transactions, but it is not auto creating expense receipts due to the missing data. Is there a manual work around to create expense receipts? We are going over 3 weeks without expense receipts hitting our books/project costs. We need to get those costs into Acumatica. I don’t even see a way to manually import a file into Acumatica to get it to create expense receipts.Our third-party software provider has submitted a Case to Acumatica, but that was two weeks ago. I am hoping someone on here has a workaround that would work for us.Our bank is Wells Fargo. We have one main control account and then several sub accounts. Each sub account does have its own account number. In the previous ve
Where can I get amonthly GL expense and revenue report. I need it in the following format Account Subaccount Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 4000 100-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 100 5000 125-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 500
Selected an invoice for payment. Created an ACH Batch. Decided not to pay that item.Deleted the item from the Batch. Processed remaining items in the batch and uploaded to the Bank.The invoice is now stuck in Pending Payment status and I’d like to remove that status so the item returns to Open Status. Cannot find a way to do that. Suggestions anyone?Mike
Currently bank recs are completed within Acumatica by a staff member and then reviewed by myself.We have a separate checklist where the staff member notes when it was completed, and then when I review it. I’m looking for an efficiency gain……………Is it possible to either set up an approval flow or possibly utilize the Task feature to accomplish a similar result?
I have a user uploading an Excel file into the journal transaction screen. If a subaccount in the file is inactive in Acumatica, it automatically changes to the subaccount of previous line. No warning or anything. I tried recreating in my local test environment, and instead I get an error that subaccount is inactive. I don’t see any relevant differences in the settings. Anyone seen this or have an idea how to solve? Unfortunately upgrade was delayed so I can’t submit case with Acumatica.
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.