Financials

Hi Acumatica Community,May I ask if there is a way to change the Void Bank Deposit Date?Here’s my scenario.Deposit Date When I click Void. The Deposit Date is not editable.Is there a way to make it editable?Thank you!

Has anyone been able to get a Project Name/Description in an ARM report of the PM type?I’ve tried a few different things using @StartProject in the column set, but so far, I haven’t had any success.

In AP Bills and Adjustments, the AP Viewer default Role does not have the ability to reassign the Approver if the Approval Map is designed to allow for it. AP Clerk can do this. I reviewed the Security but can’t determine what allows the field to be modified. Currently, the AP Viewer gets the pop up window for the approval but can’t select a New Approver. I gave AP Viewer Edit access to Bills and Adjustments>>Approvals. I also played with some of the Approver ID fields in different sections.Appreciate any help, Chris

When attempting to release a group of project transactions I get a “IN Error: Unit conversion is missing” error. In this particular group of transaction there are about 30 transactions. I’ve looked at the UOM and Conversion rules where applicable and don’t see anything out of the ordinary. When I look at the trace I see what is shown below. Is there a way to track this error to a particular inventory item?    Error 2025-06-13 01:04:22 UTC    Category: Trace  Message: IN Error: Unit conversion is missing.  Stack Trace: PX.Objects.IN.PXUnitConversionException: IN Error: Unit conversion is missing. at PX.Objects.IN.INUnitAttribute.Convert(PXCache sender, Nullable`1 InventoryID, String FromUnit, Decimal value, Nullable`1 baseValue, INPrecision prec, Boolean ViceVersa) at PX.Objects.IN.INUnitAttribute.Convert(PXCache sender, Nullable`1 InventoryID, String FromUnit, Decimal value, INPrecision prec, Boolean ViceVersa) at PX.Objects.

I believe that the base product of 24R2 can do this already, I just need to figure out the menu path to get to this. Thank you. 

 I am currently working through Lesson 3.1: Setting Up Intercompany Sales from the F300 Intercompany Transactions (2025 R1) course. According to the training materials, when configuring Accounts Payable Preferences, I should be able to select "Vendor Location" in the Use Intercompany Expense Account From field.However, in the system, this option does not appear. Instead, I only see "Vendor" and "Inventory Item" as available selections.Could you please clarify whether the documentation needs to be updated or if there are additional settings required to enable the "Vendor Location" option?Thank you for your guidance and support. 

When reversing an AP Bill/Invoice with pay by line NOT flaggedReverse Invoice, Creates a Debit Adj Release Debit Adj and select apply Opens Checks and Payments screen with Debit Adj as type Add Documents to Apply (the invoice reversed) ReleaseBUT when Pay by Line is flagged for the AP Bill/InvoiceReverse Invoice, Creates a Debit Adj Release Debit Adj and select apply Opens Checks and Payments Screen with Payment as type All the lines of the Debit Adjustment are displayed Then we need to add all the individual lines of the Invoice to apply to each line of the Debit Adj. The document is processed as a zero payment (automatically flagged as closed when process payment)The issue is that it shows as payment and if the invoice has many lines to apply to the offsetting Debit adj this can take additional time and possibly lead to incomplete application.Need the ability to reverse and apply the entire document in total (apply documents), even if pay by line is the Vendor/Document option by defa

Hi CommunityIs there a specific command to use when creating an export scenario for one period only instead of all records. Thanks in advanceBarbara

Is it possible to create a prepayment for a PO without having to tie it to a specific item/quantity within that PO?  It’s very common for our international vendors to change their PO’s and that messes with any prepayments that may have been applied to those changed quantities. My question:  How can I apply a prepayment to a purchase order in total without having to attach it to any specific item/quantity/percentage etc? The same way on the receivables side where you can apply a prepayment to an invoice as a whole.  Example:  Customer owes $10,000 and pays $1,000 towards it.  System shows balance of $9,000 without having to apply that prepayment to any specific item within the invoice. Any help would be greatly appreciated!

Hi,Is there a way to have this in a Arm report? 

We are trying to upload historical Bills and link with PO or Sub Contract.  Linking with PO is working .But system is not linking with Sub Contract . Any ideas or thoughts ?  This is the import scenario used  

Is it possible to do a Historical Data upload for AP module ( Bills , Payments ) in Migration mode ? Bill and Adjustment with Migration mode is working fine ,But when I am Trying to Release the “Check and Payment “ in migration mode (with Document Apply reference to Bills ) getting below Error .   any thoughts ?

Hi Acumatica Team,What is the option to reverse a specific Depreciation in FA module?Our customer needs to dispose a lot of FA with date 31/12/24, but they depreciated January and February 2025, and they need to reverse these depreciation in the FA module to dispose the fixed asset with date 31/12/24.Thank you for your help.

How to resolve the ''Cash Account' cannot be found in the system. Please verify whether you have proper access rights to this object.' error I gave this new user the same access as an existing user and still she’s getting the above error. Any suggestion about what I am doing wrong.

I am trying to scroll down the list of record types in the recently viewed transactions and I just cannot find a way to scroll down the Record Types. I have to zoom out the browser to view the other record types. Anyone has any ideas how to scroll down to view other record types.

In printing a check, I want to add the attention field of the person receiving the check. I completed the override in the remittance tab of Checks and Payments screen and the payment tab of Vendor prolife. However the attention field does not print on the check. What am I doing wrong? Please help. Thank you. 

We are trying to create automatic invoices for customers that are on a subscription service and automatically charge them. I know there are ways in Acumatica to create recurring invoices and release them on a schedule but is there a way to automatically authorize and capture customer credit cards against those invoices in Acumatica?

In version 24R2, I am trying to figure out the menu chain to create reports showing sales taxes collected. Any help would be very much appreciated. 

We are looking for a credit card solution that integrates with Acumatica for a client in the Bahamas.  Ideas?

Hi everyone,I have a situation where I created a Purchase Order with a prepayment, but the vendor wasn't marked with "Allow AP Bill Before Receipt" at the time.As a result, all the PO lines were automatically set to "Billing Based On: Receipt" instead of "Order."I need to change the billing basis to "Order" so I can create the AP bill before receiving the goods.Is there any way to do this without undoing everything?

Hi Team,Regarding the financial reports, I noticed that not all accounts are visible on the following reports. Is it possible to ensure that all accounts listed in the chart of accounts are appropriately included in both the Profit & Loss statement and the balance sheet?  Can we make it if a new account is added it will automatically added to the reports? See highlighted reports that need to be correctedThank you

Hi Community,I have a scenario where there is a external software for invoicing and payment collection. We need to import all invoices and payments created against them in the external software. We have created import scenarios to import data for both invoices and payment receipts.Then we need to apply the invoices against the payments we created. But the issues is the numbering sequences are different in Acumatica and external system making us unable to make sure which payment is to be matched with which invoice in Acumatica. and we need to do the applying via the import scenario not doing it manually. We track the external system invoice number in Acumatica invoice and payment using a custom field. Do you see any options to import and match receipt data with the correct invoice using an import scenarios?

Hi everyone!Has anyone encountered this error when processing prepayment requests?Error Message: “Cannot save document. Withholding tax exists in prepayment request.”This typically occurs when the system detects withholding tax (WHT) settings conflicting with prepayment rules.One way to resolve this issue is by deleting the withholding tax applied to the transaction, which allows the document to be saved and released successfully. However, if withholding tax is mandatory and needs to be recognized, is there a way to bypass this error or adjust the system settings to accommodate WHT in prepayments? Alternatively, can the system automatically remove the withholding tax since it is not supported? Any insights or workarounds would be greatly appreciated!  

Action Name: Action@GenerateOnDemandStatementHello, I am trying to give a role access to generate a statement on demand. This is using the Actions dropdown on a customer record.I’ve given the user’s role permissions to generate statements, etc, and they can get to the main generate statement menu, but they do not see the “Generate Statement on Demand” selection in Actions.I was able to find what I think is the exact permissions, but the user already has (inherited) delete rights to Receivables: Customers: Customer: Generate Statement on DemandHow do I determine which rights are needed for dropdown actions? Thanks for reading! My admin user can see itUser doesn’t see it 

Is anyone else doing a Export of Financial Reports to different subfolders on a network share in PDF form? We have done exports of GI’s to specific folders from Acumatica. (backlog, or production orders) we do on a regular basis but I have not had the request to have certain “Reports” exported.These reports and sub reports would go to different folders are some of ours are for different companies/locations on a specific day of the month for a specific accounting period.  Is this doable? I see where reports can be emailed or exported to PDF but was unsure about reports. I tried to comb through some old topics but was not finding what i was looking for.