General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,093 Topics
- 3,639 Replies
Shipping order to a company, but Invoice to the company-owned leasing company
Hi everybody,our customer rents out heavy machinery and it regularly happens that he receives a sales order from a daughter company of a big client. Our client then creates the shipping order and ships out the item to the daughter company.At the end of the billing period, our client has to create the invoice NOT for the daughter company, but to a specified leasing/financial company (also owned by the big client).One way would be to just change the billing address, but that is not what our client wants (for various reasons).Is there any possibility to do that in Acumatica without a customization?Thank you for your help!
My Cash Account doesn't balance to my GL financial period
I have experienced 2 situations recently where the cash account balance might not match the GL at a given date. Here is how I reconciled them. Not all GL transactions are in the cash account:This can happen if the cash account was opened after transactions have been posted to a given GL bank account. Unlike other re-balance account screens, the Banking » Processes » Recalculate Account Balance will actually add missing GL transactions to Cash Account that are in the GL but not the cash account. This is not very well explained in Acumatica Open University but I discovered on a recent ticket to Acumatica. To take advantage of this solution, rebalance the cash account as of the oldest financial period available.Transaction dates don’t match Financial period.Acumatica let’s you override the financial period after entering a transaction date. Bank reconciliation runs on transactional date but the GL runs on Financial Period. I had a client post many (read millions of dollars) to the cu
Trial Balance Report- Bringing in 12th Period of Prior Year
I’ve been trying to build a subreport (basically a copy of the trial balance report) that would pull the 12th period ending balances for each account and pass that value to the standard Trial Balance. I can get the subreport to show values if I run it directly but the value never shows on the original. Am I missing something or is there an inherent problem with trying to get this value into the same report? I’ve attached the report (GL632EMS) and subreport (GL632e99) to this topic. If anyone can point to me what my issue is I much appreciate the assist!
Trouble with Expense Receipt - AP Subaccount Cannot Be Empty
Hello, We are experiencing an issue when attempting to release an expense claim in the system. Everything to me appears to be filled out correctly, but we get the following error when trying to release the claim. Here is a screenshot of the Trace Log that basically just shows the same thing. From the first screenshot, it looks like the Expense account and subaccount are filled in correctly. And I’ve compared this claim to others that have been able to release. Any ideas why this one won’t go through?
Stop previous day changes
I am looking for suggestions on how to prevent previous day postings. I do daily reconciliations of sales and COGS accounts. Everyday I am having to go back and do each day because there are changes and my numbers are no longer balanced. This has become very cumbersome to manage. Is there a setup that we are missing to stop the constant changes?
Toggle between ACH & CC by Customer or Invoice - help!
Hi! We are in the process of setting up our Acumatica account and are stumped with payment processing.We have some customers on 30-60 day terms, and our preference is that they pay at that time with ACH. Avoiding cc fees after floating the money for their company for a few months is ideal for our small biz. In QuickBooks, we can toggle payment preference of ACH or CC at either the customer OR the invoice level.We talked to one provider today and they basically told us that we can’t separate payment preferences by Customer Class (we have one for day-to-day customers and another for those in terms). Is anyone aware of an Acumatica-friendly payment processing service that will allow us this kind of flexibility?
Reversing a Bill with Reclassification postings
Detailed description: Take the scenario where a user creates a Bill and then reclassify the expense to a different expense account later. At this point if that user creates a debit adjustment to this bill and apply the debit adjustment to the bill(which has a batch with reclassification entries), I have noted system is not reversing the entries within the reclassification batch.This reclassification batch is no longer valid since the original document(bill) alone with it’s batch connected is reversed now.Do we need to perform the reversal of reclassification entry for the above scenario manually by navigating to Journal transactions or is there a alternative better way for this?
Changed Valuation Method from Average to Standard
We recently migrated all our SKUs from average to standard costing due to average costs getting all mixed up. We did this by issuing out all of the inventory, updating costing to standard and entering a receipt back in. I am running the inventory valuation report but continuing to see the inventory valued at average cost rather than the new standard cost of the SKU for many items. One example is the following SKU:L175:Standard Cost - $42QTY on Hand - 425Expected Cost - $17,850 Cost per Valuation ReportAverage Cost - $235QTY on Hand - 425Cost on Inventory Valuation Report - $99,875 This appears to be an issue for all SKUs with an INCost ValMethod of “A”.Any reason why this INCost ValMethod would remain as average despite the SKU having been changed to Standard Cost?
Bank Deposit Error - $3767 payment shows $0 Deposit Amount
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?
How to handle process requirement of capturing credit card prior to email and release of invoice
Hello! A client just upgraded to 21 R1 from 20 R1, and it seems there is a slight process change that I’m looking for insight on how best to handle in the new version.Previously the client would Prepare Invoice and then on the Process Invoices and Memos screen, they would click Create and Capture, then Email Invoice, then Release. In this new version, the invoice does not show on the create and capture process list because it’s pending email first and not in balanced status. They like to create and capture prior to emailing because their form marks the invoice as paid. Also, they do not want to release prior to emailing the invoice and have the setting specified to not allow release until email.So, they are now stuck with how best to work through the steps in this new version. Anyone have any thoughts on how to handle?
AP Document Recognition
Benefits of AP Document RecognitionAP Document Recognition streamlines processing of vendor bills that you receive in PDF format. AP Clerks spend less time re-typing data so they can focus on higher value tasks. Worker productivity: spend less time entering documents Accuracy: reduce data entry errors which may result in incorrect vendor payments Approvals: integrate with existing approval and workflow processes AI/ML: extracted data accuracy (vendor ID field) improves after manual correctionWho can use AP Document Recognition?Prior to April 1, 2023 Acumatica offered a promotion for up to 1,000 pages/month for free. After the first year, customers could purchase the feature.Starting April 1, 2023 all new and existing Acumatica subscription customers (does not include perpetual licenses - PCP) get 50 free pages so they can try the feature. Customers who already paid for the service get an additional 50 free pages. A vendor bill with a front and a back counts towards 2 of your 50 monthly
Credit card transaction items Goods Receipt- how to post goods receipt already paid for 0 value?
Good afternoon, My team is new to Acumatica and my question here being is, for credit card purchase transactions already pre paid for. How would I post goods receipts without accounting for the cost(s) already paid for. would this be posted at cost or zero cost - i’m curious if received in any manner how would it effect it and what is the correct way to complete this action.
Asset Addition - Transfer from Inventory/Production JOB
Customer wants to build a prototype product using Production Job. Once all the cost accumulated on the Job, what is the best way to transfer it to Fixed Asset? is there any way to transfer Inventory Items to asset register/module?any better way i.e using Project to build the Prototype and Moving to asset register?
Bank auto-match to create customer receipt using transaction description
We are using MYOB Advance (NZ and Australia version of Acumatica). We are a B2B business so our customers pay us for dozens of invoices at one time. This means matching to an invoice is not possible.In other systems you can create a matching rule based on the transaction description that appears on the bank statement. We have asked our support company but they don’t know how to set this up. Does anybody know how you can create a customer receipt entry based on the bank statement transaction description match? thanks from NZ
Already have an account? Login
Social LoginLogin with your Acumatica account
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.