Financials

StepsCreate the purchase order for the non stock item created for FA purchases. Enter the PO receipt Create the AP bill Convert purchases to Fixed Assets Assign the PO to the already created FA Release FA transactionsI followed above steps to do the FA purchase and to convert the Purchase to an existing Fixed Asset. But even after releasing the transactions, the PO details, receipt details, bill details are not getting automatically updated in the designated fields. Has anyone faced the same issue? Is there a way to get the above issue sorted?  

In the Time and Expenses in Acumatica.  Can this field used to keep track of if a expense was tied to a customer? We are not wanting to bill the customer for that expense. “I would think that is where the billable checkbox comes into play” but if we put a customer in that field I imagine we could build a report around how much  expense reports are associated with a particular customer. Am i correct? 

Using the ACH plug-in and it has worked fine for payments to vendor checking accounts. Now they are attempting payment to an employee savings account. When NACHA file is uploaded to bank, it becomes a 0.00 prenote to checking account. I’m communicating with the bank, but they’ve not been able to resolve. Anyone have an idea of why this would happen? 

Which date and time (created by- or modified by- ) will indicate when and by whom the batch was released?In some cases a batch has user X as created-by and user Y as last modified-by. Will it always be the last modified by that indicates the user and date and time of the release of the batch?

Does any one know how to reverse a Landed Cost? We had an entry with a clerical error and the amount was incorrect. Now inventory is overvalued and we have the amount sitting in the accrual account. The AP bill should address the accrual balance but will create a credit on the P&L variance account. Not sure how you address the inventory valuation. So looking for ways to edit, delete or otherwise correct the LC transaction. 

I have an invoice from a supplier that was shipped in multiple pieces.  Consequently they charged our credit card with multiple charges.  But, we only have a single invoice entered in AP.When trying to clear the bank transaction I can select “match to multiple invoices”, enter the vendor’s name into the “business name” and I see the single invoice.  If I select that invoice it correctly shows me an “unmatched amount” but I can’t figure out how to them match this to the second credit card charge.This doesn’t feel like an unusual practice so I’m assuming that I’m doing something wrong. 

Hi everyone,Testing bank feeds for the first time. Connected to a real bank account with years of history. After running Retrieve Bank Feed Transactions, it only goes one month back from current date. Does anyone know if possible to go back further?The Import Transactions From field was originally 1/1/2024. It updates every time process is run.   

We have matched all our bank feeds in Banking > Process Bank Transactions.However, when we process the Reconciliation Report, the clear date on the transaction does not match with the date of the bank feed transaction line item that it was matched to.  Also, once reconciled, the reconciled transactions are still appearing in the bank feed. Is this a bug, or is there a step that has been missed? 

HI, Having successfully sync imported some balances for a period, it is now possible to import balances from a prior period? Getting “There are no records to process.” error.  

On a project drop-ship PO, the Account Name on the shipping tab is showing as the Vendor's name. Is one able to change this to default to the Branch name?I see there is a customization for the setting of the shipping address on a purchase order. Would such a customization be possible for the Account Name on the PO?

Is it possible to exclude a non-stock item like Freight on the line of an AP Bill from inclusion in the cash discount calculation?

How do I clear out the voided payments still sitting in the bank reconciliation screen.

When invoices are dragged and dropped in the “Incoming Documents” screen in the Payables module, sometimes they turn sideways. It appears to be happening when the invoice itself is created in Landscape orientation so Acumatica is attempting to align the image so it’s in Portrait orientation even if that turns it sideways.  Is it possible to have Acumatica align invoices so the verbiage is horizontal regardless of how the paper is turned?

Hello All,Does anyone know how Acumatica differenciate if an attachment is uploaded from "Files" or "Image" section of the Expense Receipt?If we upload a jpg from “Upload Image” of the Expense Receipt Screen, the platform shows the “Image Preview” but if we attach the same file from the “Files” on top of the screen it is not previewed.I checked UploadFile, UploadFileRevision and NoteDoc and both of the records are Identical except to their FileID that of course should be a Unique Indentifier anyways.I also checked the EPExpenseClaimDetails and couldn’t find a possible reference to the File which is uploaded using the “Upload Image”. All I can find in the graph, its extensions or the page is a “PXImageUploader” in the page nothing else.Any help is appreciated.

If we have purchased the asset, but will be put to use (placed-in service) in some future date, then how can we record it it Acumatica FA module? As Placed-in service date is a mandatory requirement in Acumatica.

We are using Expense Management, we are not using the bank feed to create receipts. When I attempt to match the bank feed to receipts that have already been submitted, they do not appear. I can see the transaction in the bank feed, i can see the transaction in Expense Management, how do I get all available expense receipts to populate so I can match them?

Hello,Does anyone know how to add an entry type for a fee to an existing payment processing center? We have created several entry types, and unfortunately none of them are showing up in the list.  Here is one of the Entry Types 

Hello,Is there any report form in Acumatica to generate trade references for customers? We are new to Acumatica, and our old ERP had a prebuilt report for trade references. 

Hello, Would like to know how to handle these issues. #1 I Prepared a November sales tax and release too early. how can i reverse? or do i need to…#2 October was not showing up to release yet. So i have Transactions for November but no transactions for October…

I want to update the Posting class on about 3000 parts. Many have open Sales Orders. When completing these orders i want them to post to the new accounts. Do I need to recreate those lines? or will it roll up at the time of invoicing? 

Hello all! I'm looking to limit viewing of commissions between our sales people. For example, I don't want john seeing Jodi's commissions and vice versa. However, I want them to see their own commissions. This is mainly on Sales Orders. Has anyone encountered this and how was it remedied? ThanksBrent

We are facing a scenario where a user needs to process a credit note while the customer's status is on Credit Hold. With EDI integration and automated warehouse processes in place, it is not feasible for the user to temporarily remove the customer from Credit Hold, process the credit note, and then place the customer back on hold.Are there any workaround for this situation?

Hi Team,Any thoughts on how Acumatica handles the scenario for Importing transactions for Bank Feeds when the transaction currency is different from Cash Account currency.   

 Hello,We are experiencing an issue in Acumatica (Batch Number Sequence), and I’ve attached a screenshot for reference. Can you please help us address this?  

Hi,We have a cash account that needs to be reconciled. It has been sitting on hold since 1/31. When clicking on it in Reconciliation Statements it times out and won’t load the transactions. I checked theCAReconEntry.CATranExt table and there are over 7400 unreconciled transactions. Is there a max number it can reconcile?Also, there is a clearing account tied to the cash account. Could this be causing an issue? The clearing account does not have reconciliation required checked but the cash account does. Only one of the two charges methods in the clearing account are listed in the cash account also. Could this be causing the issue?Last question, the periods are closed since the last reconciliation date was 1/31. Do we need to reopen the periods in AR to get these reconciled? Could this be the issue? Thanks so much! Your wisdom is appreciated!