Financials

Need a solution for the prepayment with inventory with 5% discount if paid in curtain time plus shipping.Out company created a shipping cost  PO invoice separately from inventory. This helps us to understand what PO received/not received.I need to prepay inventory plus shipping cost. I cant add the shipping cost as an additional line to the inventory prepayment because we dont get discount on the shipping cost. What would be the best solution in this case?  I hope I am clear with my problem :)

Client wants to know if they do something like remodel a building can they extend the useful life of that building asset?  The Useful Life is grayed out.  Wondering how one might go about changing the life (extending the life) of a fixed asset.  

Hi,  From Version 2023R1 and onwards, where can I change the term Cash Purchase? I tried to find in Translation Dictionaries (SM200540) but seems like it is not in any Source Value. Previous version term is Quick Cheque which can be changed to another term (Quick Payment) via this screen    Thanks!

I am not in any way knowledgable on how to setup tax zones for a Canadian client.  Are there detailed instructions on how to setup tax zones for an Acumatica tenant that does have Canadian Localization turned on?For example : I want two tax zones setup for British ColombiaCADBC with GST 5% and PST 7% (GST GL# 2510, sub 00009.900)(PST GL# 2510, sub 00100.900)CADBCSR with only GST 5% (GST to GL# 2510, sub 00009.900)What are the steps I need to perform to do this?And then be able to assign those tax zones to Employees, which I know how to do.(BTW, these will exclusively be used for Expense receipts)

Hi CommunityI am trying to set up to depreciate Low Value Assets 100% in month of purchase but not having any success. Can anyone help with this calculation please?  

Does anyone have any ideas for a solution for the following scenario:A company reselling Software licenses. Tracking the license activation expiry using contracts.Question:Is there a way to link the purchase of the Software licenses to the contract, so that we can report on the contract profitability. Or is there any other way to perhaps track the costs/expenses.I’ve found an old idea that seems to be asking for the same: Any help/advice much appreciated.Many thanks,​​​​​​​

Hi! Is there a way to automatically release AP check payments as soon as the check is printed? The goal is to prevent fraud. My client is concerned anyone can just reprint checks because Acumatica gives you this ability on the Release Payments screen. I’m wondering if there is dedicated functionality for this. I’m aware you can use access rights and business events but I just wanted to double check.

We are seeing the below error message with our Sales Tax (Prepare) issue and we don't see any tax reporting at all. This is the first time we run Sales tax reporting as the customer went live in Acumatica in April 2024During testing we were able to run sales tax reporting. What issues can I review to fix this?  

Is it possible to reclassify the line item description on an AP invoice?

I need to add the Qty available to the Inventory Valuation report, however the entire report seems to be based off Qty on hand in the INTranCost table. We need to know how much of a given product is available and the total cost of everything sitting on the shelf unsold.  Has anyone else tried adding this field to the report in report designer?

How to use cash account details to find discrepancy in between Bank Rec & Trial Balance Summary ending balance. My Bank Rec cash account balance & Trial Balance Summary ending balance have not been matching for a couple of months and can not seems to find the discrepancy, I saw a article saying the cash account details can help but I’m not sure how or what i should be looking for.any help would be appreciated!Thank you, 

We have run into a costly issue of “ghost” PO’s being sent that none of our buyers claim ever sending. Is there a way of removing the “email purchase order” option from users (picture below)?  I have tried revoking access right to “Print/Email Purchase Orders” from the role but users are still able to accidently use the “Email Purchase Order” option.  

How do I update Customer Credit Limit for groups of customers with different values? We have appx. 1000 customer Credit Limit changes/updates to make (out of our 2500 total customers) with multiple different $$$ value limits. We prefer not to do these manually. Thank you.  

Hi, Could someone please provide insight into determining the appropriate block size field for a custom ACH data provider?How would we determine the correct block size for the custom bank pay file ?  Thanks :-)

Hi,I am trying to change an existing Company in the system from Without Branches to With Branches Not Requiring Balancing, but I get the error shown below whenever I try saving.Is there another screen I need to be looking at or updating to ensure this existing Company can be changed?Let me know if I can provide any further information.Kind regards,Andrew 

Can subaccounts be turned on in the Enable/Disable screen after GL transactions have been released/posted?

Hi all,We’re getting to the point of closing out the financial periods after they’re reconciled so no changes can be made to them after the fact, but we’re not there yet.  Having that said, every month I reconcile the bank accounts and release the reconciled statements.  I’ve been doing this for many months now with no issue.  This month I am off (my bank balance in trial GL balance is off).  I back-tracked a few months and found a discrepancy started 2 months back and prior to that. My question is, how can I easily identify any changes to transactions after they’ve already been released in the reconciliation statement?  Likewise, how do I easily identify any “new” transactions posted to the account for that financial period after it has already been reconciled for the month? Is there any easy way to view unreconciled transactions to a specific cash account?  Or ones that were once reconciled and now say are deleted? To summarize:

I just discovered that in a Multi branch company “without balancing configuration” that the TB import feature does not provide the Branch as a column in the mapping so that the P&L can be imported by the appropriate Branch, GL Account, and Subaccount. This TB feature assumes that all branches will balance when imported individually when it will not balance. The sum of all Branches Trial Balances being imported for Balance Sheet and P&L will balance but not a given branch. How do I import TB for this multi branch not requiring balancing scenario?

Importing into BOM Attributes and I am stuck with error “The system failed to commit the BOMAttributes row”.Can’t seem to resolve this … Attributes I am looking to populate:Error message: 

Sales order work space not appearing on the mobile App, what could the problem be? 

Hello,I’m wondering if it’s possible to get a report that has GL activity for the month of April at the transaction level for the purpose of splitting the activity into two sections 4/1-4/25 and 4/26-4/30?It would most likely be trying to open up the Account Details Inquiry to allow for more than one GL account. Open to any other ideas  might have to get that data.Thanks.

Has anyone implemented this as an alternative to Acumatica Bank Feeds, any advice for implementing it?  I discussed this approach today with a financial institution that can deliver the transactions in Visa Commercial Format (VCF) via sftp.  Bank feeds aren't available for this issuer using Plaid or MX.

We have a test environment that we regularly copy data into from our live company. However, each time we do copy this data, it pulls over the bank feed connections and then creates a System Constraint error for exceeding the number of bank feeds allowed by our license. Ideally, we could just delete these bank feeds in the test environment but when I attempt to do that, I get the following error: The bank feed service (path: 0/plaid/item/remove) returned the following server error: BadRequest ​​I have gone as far as deleting the feeds in the live database before copying it to the test environment, but the issue that this causes is reconnecting them in the live database- transactions start to get duplicated and it becomes a hassle when matching/processing bank transactions.  Has anyone run into this issue and have a solution?

I need to add a column to the grid of Master Financial Calendar.I managed to add it but it doesn’t update even if I save it.   I checked the table FinPeriod in the database and confirmed that the value is not saved. I already created an Extension Class for both FinPeriod and MasterFinPeriod.namespace PX.Objects.GL.FinPeriods.TableDefinition{ // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public sealed class FinPeriodExt : PXCacheExtension<PX.Objects.GL.FinPeriods.TableDefinition.FinPeriod> { #region UsrIsFiscalYear [PXDBBool] [PXUIField(DisplayName = "Is Fiscal Year")] [PXDefault(false, PersistingCheck = PXPersisti