Financials

Trying to create cash basis P&L in Acumatica.  Has any one been able to do this without using a 3rd party add on? 

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 - does anyone know of a way to only produce month end AR statements that include invoices that are 30+ days old? If everything for a customer is current, don't even produce a statement. And/Or if there are invoices past due, leave off anything that is current. Thanks

In Finance → Manage Financial Periods, can I close month one of the new fiscal year if month 13 of the prior year is still open?

I am trying to close financial periods in Finance → Manage Financial Periods.  I am unable to close September due to an open A/R credit.  Is there any way to process the closing of this month prior to the credit being used/applied?

I have an bill that has an unreleased retainage. When you look at this original bill the rounding diff is 0. Once I release the retainage which creates a new bill it now shows up with a rounding diff. The problem here is that although I can execute payment, the retainage bill stays open because of this rounding diff. And consequently by having the retainage bill open the original bill also stays open even though the full amount has been paid. How can I work around this? Retainage BillOriginal BillOriginal Bill

How do you adjust total accumulated depreciation for an existing asset.  Our tax auditors are constantly changing the depreciation method at year end.  We get a depreciation schedule for the next year.

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.