Financials

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:Issue: Somewhere along the way changes were made to prio

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 = PXPersistingCheck.Nothing)] public bool? UsrIsFiscalYear { get; set; } public abstract class usrIsFiscalYear : PX.Data.BQL.BqlBool.Field<usrIsFiscalYear> { } #endregion #region UsrQuarter [PXDBInt()] [PXUIField(DisplayName = "Quarter"

Hello!We had credits in Fixed Asset Clearing and duplicated Fixed Assets for these credits. (Fixed Assets created in Feb 2024, and the credits posted to Fixed Asset Clearing in April 2024).How do we fix these errors?We were wondering if we should reverse the duplicated Fixed Assets to offset the credits in the Fixed Assets Clearing Account. We just want to make sure it happens in the current month, not affect the prior Financial months that we booked. Thank you so much for your help!

Hello Dear community, We have found our WO order type is required to print invoice or email invoice before we can release the order at the end of the sales order invoicing process. These are not invoices we want to email to the customer, can we make them always print invoice on paper or not email or print invoice but will allow us to release in the sales order invoice process I was wondering what options are available  so we can process WO sales order types, just not email invoices to customers? Thanks in advance for any help.  If we mark these 2 options, will this do the trick?  

Hello everyone,Trying to figure out which Access Right by Screen setting will allow a user to add (the plus sign on Details) rows to any of the other modules besides GL.  It’s greyed out for all of them except GL. 

I’m new to 1099 reporting in Acumatica. I processed a payment, which shows on 1099 Vendor History report (screenshot 1), but the 1099-NEC (also MISC) just shows me a white page. The 1099 box is checked for the Company. Is there something else I need to do?   

We just had our first year end on March 31/23.  The starting balance does not match my YE amount, even after allowing for;At year end, the ending balance in Retained Earnings + the ending balance in YTD Net Income = beginning balance for Retained Earnings for the next year.The new FY is overstated by a significant amount.Has anyone experienced this ?

Our customer banks with CIBC (Canada). We were successful at adding MX and landing on the login screen that asks for card no. and password. There is also a link to the institution’s website. The issue at hand is 1) the customer uses an account no., a personal PIN no., and a token that updates once a minute, and 2) the customer uses a business portal that is different from the mapped institution’s website. What should we do with their setup?  

Hi,I am still struggling to find the right report in the system to show the project information. What I need is a report that show the budget amount and the actual amount by project task. I look through the report section in Project but nothing fit. What I am doing now is to copy the information from the revenue budget tab and cost budget tab under “Project” to Excel and create a report myself. Not sure I miss anything. Thank you.Regards,Raymond

I am trying to create a report showing Payment applied against Each Invoices along with Cost and Margin of Each invoice amount i did following  which give me all payments and the invoices it Applied to and i tried to add AR tran table to bring in cost but seems am wrong can anyone  help 

Hi,Although we grant full access to Manage Financial Periods screen to the user role, the unposted transactions cannot be viewed by the relevant role. This issue was come after the upgrade. Is there any solution to resolve this ?Thank you

Hi all. Does anyone know how to reclassify transactions using an import scenario? Your help will be much appreciated, thank you. Regards.

Hi, Could someone provide insight or assistance with the following scenario?I'm trying to split a single AR payment into two different customer transactions (one for a prepayment for Customer A and another for a cash sale customer) through the bank transaction process. Currently, I'm unable to find any option to handle this scenario within the process bank transaction feature. Thanks 

Hello, I just went through a painful process of manually creating ~230 lines in a custom row set to go along with 14 columns created in a column set to effectively create a matrixed P&L. The client wanted to have everything on one report and have everything above ‘Gross Profit’ broken down between their divisions (they have 4) as well as showing a total column, and repeat this to show a monthly set and a year to date set on the same page. The rows needed to show all of the correct header column data in a single row and the merge worked pretty well. This was my novice approach at this task but how would you have created something like this? 

How do I close future periods and only keep the current period open?

We are 2 years in with this software.  I’m hoping someone can help me with this.  While running Run Appointment Billing, we have never checked the “Ignore Time Frame” box.  We noticed some items weren’t getting billed but appt is closed and SO is closed.  Evidently, we are to hit the Ignore Time Frame button to get them to show up.  Something about the cutoff date not being set.  Therefore a lot of closed service orders are not showing up to be billed.  Has anyone else noticed this issue?  All of the appointments that had no cut off dates were within the past two months. We do not see any setting on service order or appointment where cut off date is even showing.