General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,340 Topics
- 4,443 Replies
How to remove employee credit cards from the bank feed? We have several credit cards that have been disabled and do not have transactions for at least 45 days because employee no longer works for us. Our bank does not have it listed as an account either because as soon as employee leaves the company, we disable and delete that corporate card. Thanks in advance.
Prevent AP Bill from Posting to Purchase Order when AP Bill Total is greater than PO Unbilled Amount
Does anybody know how I can have Acumatica prevent one from Posting an AP Bill against a Purchase Order if the Amount of the AP Bill is greater than the Unbilled Amount of the PO? There is a setting in the Purchase Order Preferences screen where you can choose between No Validation or Validate with Warning but the Validate with Warning still allows you to do it. Our client wants this to be prohibited. I thought of using an Approval Flow to require approval if the AP Bill Total Amount is greater than the PO's Unbilled Amount, but I don't see how to do that. Is there another way?
Hi everyone,Several of our main large volume invoice vendors are paid once a month (i.e. 10th of month, 15th of month, end of month). The problem is, they are all paid on the second following month (i.e. Any invoice in January is due March 10th, March 15th, March 31). Any suggestions on how to best handle this in Acumatica which only has options for day of next month but nothing for second month.
I created 4 donut widgets showing sales mix between locations. However, some locations dont have all the types of sales that other locations do so the colors don’t align between the widgets. How do I have each donut widget show all the sales types so that the colors align? Thank you!!
Are you using Acumatica to perform financial planning for upcoming projects?Do you find Acumatica has sufficient tools to adequately perform scenario planning? Do the existing forecasting tools need additional functionality to fulfill these use cases?Our team is interested in learning how other partners perform financial and scenario planning in the Acumatica environment, and whether the existing functionality is generally considered sufficient.
Hi! We are currently migrating form Sage 300 CRE to Acumatica. We are wondering how can we best translate to Acumatica our Sage 300 CRE Account definition. In Sage 300 CRE, we use a suffix for example: 31000.001 The first 5 digits (31000) - Account The last 3 digits (001) - is our suffix (department, company, project, etc)
I’ve been updating the user access to the GL Accounts tabs (view-only) on the Customers, Customers Classes, Stock/Non-stock item, etc. I was able to find most of the GL Accounts and Subaccounts fields on most screens except for the Customers screen.Under the Access Right By Screen > Receivables > Customers > Customers, I can only find the Cash Discount and Prepayment fields listed. Where can I find the rest of the fields? Thank you,
HI, I’m trying to create an approval map where a manager will need to approve the AP bill for POs enter only by certain users. It doesn't look to be working. However if I uncheck the active box for the 2 employees in the conditions tab, the approval does work. I only need it for these 2 employees though. Any Thoughts?
We use Incoming Documents extensively (6000-7000 docs/month) for creating AP Bills. When a document is saved and processed into an AP Bill, that file attachment gets linked to the AP Bill as expected. The problem we are encountering is that normally on file attachments to a document, if you try to REMOVE LINK from the files page, it will not let you if that entity is the one and only entity the file is linked to. However, in the case of Incoming Documents → AP Bills, technically that file is linked to an Incoming Document Entity as well as the AP Bill entity. Because of this the link to the file can be removed from the AP Bill. Imagine scenario where maybe one user is processing Incoming Documents and then a team of AP staff do further processing of the AP Bill. If a user inadvertently clicks REMOVE LINK, the file is gone (I know not really deleted) and they have no idea which file was related to that Bill. Although this doesn’t happen much - this is sort of a potential problem.
Can you report on operations expense at a warehouse level or does it need to be a branch in order to meet the requirement. I am referring to capturing and reporting non product cost, like your payroll, building maintenance etc. We are trying not to have move sub accounts to keep it simple on the number of accounts and activities to be configured.
Hi! May I ask anyone on how to release payment using Pettycash Fund? Petty Cash account is already setup. I just do not know what module to use in releasing payment. Also, is releasing payment using Petty Cash fund affect the GL entries?Thank you in advance!
We are being tasked to create a Purchase Order for Landed Costs. The customer has to call in subcontractor to use a crane. They would like to able to track those costs to the items them are pulling off the truck and would like to make sure that the subcontractor is following the PO
Hello Community,I have a scenario where I would be importing some invoices of the year 2019. Initially, I had defined 2020 as the first financial year in the system. So, now to import these invoices, I have shifted the first financial year to 2019, created periods, but i am not able to Generate Calendar nor even open the periods of the same year. Is there anything i am missing out here? Thanks in Advance.
I am using the financial report writer to build a project P&L for my client. I am having trouble getting the project name to appear in the title since there does not seem to be a parameter available.In my column set, I have added:=@StartProject + ' - ' + THIS IS WHERE I WANT THE PROJECT DESCRIPTIONThe project code is an auto-numbered ID and without the name makes it difficult to identify the reports.Thank you in advance.
Bank Feeds - Transactions came in once or twice and now nothing comes in even though Acumatica shows successful
We have a client who is on 2022 R2. They have 9 Branches and over 25 bank accounts. They purchased the additional license for the 25 bank accounts. All branches use the same bank - Bulldog. We setup one bank feed called “Bulldog”, connected with Plaid and all bank accounts across all branches came in. We then mapped all the bank accounts to the respective Acumatica Cash Accounts. We manually ran Retrieve Bank Feed Transactions on 4/7 and transactions from 4/1 to 4/7 came in but not for all the bank accounts setup for each branch. It seemed to only bring in transactions for the first Cash Account associated with the branch . We put the Retrieve Bank Feed process on an automation schedule on 4/8 and since it is has been on the schedule hardly anything has come in. Automation History shows successful but last transaction that came in was from 4/13 and that was only on one Bank Account for one Branch. Nothing came in to any of the 25 other bank accounts. Cash accounts are restri
How to print Billing and Bookings Amount in ARM Report?Below is the screenshot for reference: The Billings I manually grab the total sales from the P&L report. To only provide the weekly number of billings or sales. The report would look like this : Start Date: 7/1/2023End Date : 7/8/2023 Bookings : $598,477.13Billings: $476,910.84 The Next week it would look like: Start Date: 7/9/2023End Date : 7/16/2023 Bookings : $488,263.00Billings: $517,963.02
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.