General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,320 Topics
- 4,381 Replies
Each month we do an allocation entry where we allocate all of the expenses in our corporate branch to our other branches based off a fixed weighting. The problem is, rather than all of the accounts in our corporate branch being $0 after the allocation, we want the total to be posted to an offset/contra account that would making the overall balance in the corporate branch be $0.Ideally it would look something like this:
Has anybody come across an issue where if you select export to PDF of a form i.e. an invoice and open in Edge the paper size shows incorrectly so should be A4 but the size converts to 288 x 396 mm but if you open the same PDF with Chrome it shows correctly 216 x 297 - causing issues for one of our clients as they send out to customers and their scanning solution doesn’t manage to capture the full data due to the size.
I have a client with 1 Company (With Branches Requiring Balancing) setup in Acumatica and have around 20 Branches in it. The client's new requirement is to establish an additional company and transfer certain branches from the existing company to this newly created one. This is necessary in order to facilitate the submission of Group VAT for specific branches located in the UK. Since these branches have existing transactions, the ability to switch and select a different company on the Branch screen is disabled. Is there a way to reassign the branches to the new company? Regards
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
We are trying to set up our Authorize.net sandbox account as a processing center on our Acumatica sandbox tenant, however we’re getting the below error message. I created a brand new Signature Key and Transaction Key and still when I try to test credentials I get this error.Any ideas how to get around this? I’ve played around with TESTMODE and VALIDATION parameters and that hasn’t helped.
Every invoice that I try to “Recognize” in the Incoming Documents screen generates the error “Discovery Endpoint Address not set”. I am manually dragging and dropping the invoices onto the screen and they do display but that’s all other than the error.
Hello,I’m having an issue where AP did not link the PO to the bill when it was entered. It went through the whole process and was paid.I know it can be reversed if the status is open, but since it was paid and now closed is there any way I can link it to the PO?I don’t understand either.. if it can be reversed, how would you apply the payment again without it thinking it was paid twice? Reverse the bill and payment and then enter it all again?It’s causing a lot of extra work when I’m in the project close out report, the costs are allocated to the project but finding out what costs belong to what PO manually with a ton of bills and PO’s on a job…it’s very time consuming.Not sure if there is a way to do a project transaction like entry where it can hit the PO but not be posted to the GL? but..Any help would be appreciated.
Hello - In one of our tenants, we had an account incorrectly added with an Account Type of “Asset”, and it wasnt caught until transactions had already been processed. Now when attempting to change the account type to Expense, I get an error message stating that I cannot change the account type because transactions already exist. Is there any way around this so that we can change the account to Expense and it populates on the Trial Balance and reporting correctly?Thanks!
Hello, My Consolidated P&L report is eliminated but the consolidated net income under my balance sheet does not match with consolidated income statement. The net income figure that the balance sheet report pulls is a combination of parent and subsidiary without the elimination of interco transactions. It is drawn from the account class NETINCOME from respective entity. I need help on how to make them tie under the report definition. Thank you in advance. Thank you. Regards,Cherlene
Im looking to set up a Business Event to send an Email reminder if the AP Bill → Approver hasn't approved the bill within 2 days. I'm not sure if this is possible through a business event and how to join APInvoice to EPApproval. Has anyone ever done anything like this?
I have report where I note the account and it’s balance on one row, expand by subaccount on the next row set exampleThis is working great for obtaining the subaccount activity that makes up the account balance. However when printing the report, I would like to sort the subaccount string numerically. Currently, segment one is sorting largest to smallest while segment 2 is smallest to largest. Does anyone know of a custom expression for either the column set or row set to be able to sort the string smallest to largest? example of report output (exported to Excel), same behavior in the Acumatica screen and when exporting to PDFThanks for any and all help on this!
Hello Community,I have a query regarding the “ADD PO RECEIPT” button at the Bills Form and whether there's a way to display only the correct receipts.Let me illustrate the scenario: sometimes, a user may create a receipt but inadvertently input incorrect information and then proceed to release it. In such cases, the user needs to create a Return form, reopen the PO Line, and subsequently re-receipt it correctly. This results in the “PO HISTORY” tab of PO containing two receipts - the first one, wrongly released, and the second one, which is the correct receipt. Additionally, there's the entry for the Return form.Now, when we create bill for the receipts through “ADD PO RECEIPT” button, we want to see only the correct receipt (the second one) to choose in the Bills Form. This would help avoid any confusion and ensure accuracy in our billing procedures.I would greatly appreciate it if anyone could provide insights or suggest any methods to achieve this, allowing us to effectively filter
Hi everyone,Does anyone here encountered their automation schedule suddenly stopped processing after a few days? We have the following configured to automate recognition of deferred taxes. It is running but nothing is processed. Any advise? Tried replicating this same configuration on my local instance but gives the same result. Thanks,
I need to know how to close a AP Bill that has already been paid and closed, but reopened due to its Account being reclassified. I have listed the full process the Bill went through below.Billed Entered Approved Released Paid in full by a check, closing the Bill Bill was then reclassed using “Reclassify Bill” functions and specifically the Account was changed during the reclassification.The bill is still linked to the check and it shows that it was paid and the amount paid, but is in open status.The check that it is tied to still shows the full amount as well
Having an issue trying to close a completed production order. When I hit process in the Close Production Orders Module, I receive this error message: “IN Error: Unit conversion EA is missing.”Is this coming from the stock item or the completed production order. The base unit for this stock item is listed as EA. Thanks!!
We are working with Acumatica to get started but are still going there the demos and final questions stage. Today the sales tax rates came up because in Acumatica they are manually entered and updates. We are currently using QuickBooks and those rates automatically get updated. We only sell within California and only file one return. Is there a software that would take care of just automatically updating the rates? Or is there a solution within Acumatica to help with this??Help/advice is greatly appreciated!
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.