Financials

Hi, I’ve created an import scenario to import expense receipts using a file format from the bank. Since the employee ID is not in the csv file, is there a way to link the Claimed By field by using the credit card number in the import scenario? The corporate cards are all setup and each card is linked to their respective employee ID.  Thank you,Joey

Looking to understand more about: How does system address having 2 Retained Earnings? I.e. AOCI

What is the best way to add a subcontractor to a service order?  Is there a way through a PO or how do you tie the bill to the service order? 

We tried to reconcile an asset with a transaction.  We clicked on process and then we see the error message “The fixed asset has unreleased reconciliation transactions.” next to the Accrual Balance:There are no Fixed Asset Transactions matching this for us to release.  Where can we find the reconciliation transactions to release?

I am creating a Balance sheet .  Is it possible to show “Sum of all Debit Balance Totals”  in one Row. ?ExampleRow 00341 - Net regulatory deferred assets**formula - listing all Debit Account Balance. Which is correct .But when the Row 00350 is not showing the correct Total Value . It is just showing Total of “Ending Balance of Row 00341 .I need the Sum of each Expanded Account Balance which is showing on the below screen based on Value formula given on Row 00341 ( IIf( (@00341 > 0 ) ,(@00341), 0) )Is it possible in ARM ? 

Has anyone come across this error when trying to set up a bank feed with American Express?    

My manufacturing client is going live shortly, and we are adding their May-Aug fixed assets manually to check the depreciation process etc.  They have a leased asset that they want to put in service for 1/24/2025 and have the Jan-May depreciation all book to May, as they received the invoice in May.  With the 1/24/25 service date, the depreciation is booking to Jan-May.  I cannot close January due to this asset not being depreciated for Jan.  It would not load the asset with the May invoice date with a 1/24/25 in service date, so we used a journal entry with a January date.The other issue is that I changed the 5-year Lease asset class Averaging Convention to Full day from Full period, and it is still calculating full period for this new asset.  Their other 5-year leases (already in service) ‘caught’ the change to the averaging convention and shows the correct monthly depreciation amounts when we run calculate depreciation.  But the new asset does not show the full day averagi

Acumatica has a built in function to “recalculate” various balances such as vendor and inventory.  We have been live for eighteen months and have never run these “recalculate” functions.  Recently, we noticed an error in our inventory and our VAR suggested we run the “recalcuate inventory” function. We ran the fuction and it fixed our error.  My questions is should we run all of these “recalculate” functions regularly such as monthly or quarterly?  Is there any harm in running these recalculate funtions more often?  

Hi,The GL is showing the AR balance in CAD and USD as below, but the actual totals (as per the attached file) differ significantly.Additionally, the balance as of today is showing a large discrepancy and appears in the negative. Could you please advise on the possible reasons for this issue? Please note current CAD balance in GL is negative  

When attempting to map a Cash Account to the same account number in the consolidation company, I am getting an error message: “GL Error: Cash account doesn’t exist for this branch, account and sub account (Branch#, Account#, Subaccount#)”. The way to resolve this was to create another GL account that is not a Cash Account, and map the Cash Account to it. I have many Cash Accounts, so this required adding a new account for each. Is that the only way to resolve this error?

What is the best way to track items issued out of inventory to an internal project for accumulation and capitalization to fixed assets? Here is the scenario I tried to do but received an error when creating a fixed asset.Added the fixed asset clearing account to an asset type account group Created an issue reason code to the fixed asset accrual account Created a PO tagged to a project and task Received the item into inventory (we use items from inventory for external and internal projects so steps 3 and 4 may not always occur) Created in inventory issue transaction to the project Capitalize the project costs to a fixed assetWhen creating the purchasing transaction in fixed assets, I get the following error:Error: Inserting 'GL Transaction' record raised at least one error. Please review the errors. Project is Required but was not specified. Account '14900' used in the GL Transaction is mapped to Project Acc

Hi,I am trying to close financial period, but there was an error stating: GL Error: The 09-2025 financial period cannot be closed in Accounts Payable.I have checked unreleased documents, but I can't find anything unreleased.  

Hi! i am trying to modify the AR invoice form to add a section related to applied payments, however, its not showing up on the invoice properly and i’m not sure where i’m going wrong.  i’m not super familiar with report designer which doesn’t help  ideally, i would like section 1 to refer to the original invoice amounts and section 2 to refer to payments but this is how it’s showing up when i save the report: i am not able to upload the report but if anyone has any ideas, i would really appreciate it! thanks,  Iqra

We recently transitioned to Acumatica and have so issue with ggetting the credit card feed to work. Our company uses Royal Bank Credit Card (Commercial Visa Avion Cards) and we manage these cards thru Visa Spend Clarity Enterprise platform.  We are currently still using Concur Solutions (SAP) because we are unable to connect the credit card feed with Plaid or MX or via SFTP server. Does anyone have experience with Royal Bank and their credit card feed thru Visa Spend Clarity. We have about 50 cards and spend over 250K per month on them so the feed is very important to us. Thanks for your help Bruno

Bad title perhaps; I’m not an accountant, but they’ve asked me why and I don't know.Not sure how to explain this since, but basically they’re saying somehow the transaction was processed with negative GST.  In the Journal it shows the #’s reversed for this 1,149.91 All others look like this (Debit left column, Credit right): There’s hundreds as above, but this one below the values are in the opposite accounts and no one appears to know how this happened (including myself):  Anyone able to please enlighten me on what may have gone wrong? 

Saw this really great video (https://www.youtube.com/watch?v=weBglqXkBpA) from ​@Doug Johnson on Automated AP Bill Approvals with 3-way matching and he had 3 great side panels on the bills and adjustments screen that I would love to replicate. Related purchase orders Related REceipts Unbilled Vendor ReceiptsHe briefly showed the generic inquiries required to make the side panels but didn’t fully show them. I am trying to replicate it but was hoping someone had something similar that I could piggy back off.

Hi Acumatica!In my row sets → data source section, I chose expand code-description for a range of GL codes.How can I remove the spaces between the last digit of the GL code and the dash? The way it currently displays the GL codes looks awkward.selected code-description to expand the GL codes for a range of GLsOutput places 4 spaces between last digit of GL code and first letter of GL Description. I'd like to remove these spaces.Thanks!

We are working on setting up a vendor EDI integration to received AP Bills into Acumatica. from 810 messages. We are running into some challenges surrounding how to do the 3 way matching when we create the AP Bill prior to the PO Receipt mainly surrounding linking the receipt to the bill and handling 3 way matching for Bills that have multiple receipts. We stumbled on this post https://community.acumatica.com/distribution%2D6/hold%2Dap%2Dbill%2Duntil%2Dthree%2Dmatch%2Dcomplete%2D11048 and came up with the following options which I have listed the Pros and Cons for. If anyone have any experience with this I would love to hear how you approached this as we are at an impasse on whether or not there should be a technical solution to all of this or if certain scenarios, mainly multiple receipts against a single bill, will have to just be

I’m working on some testing of the fixed asset module and have come across a scenario that I can’t figure out.We have a handful of assets that we disposed this year and are looking to bring them into Acumatica with its correct disposal information.  When running my import scenario, it does not allow me to modify the disposal date, disposal method and disposal amount.  I have already done GL transactions directly for the disposal of these assets, so I do not want to post again. Has anyone does this before?

There are orders that contain non-stock items that get fulfilled right away before syncing to Acumatica the Shopify connector. These orders get the status of filtered. We would like to sync them to Acumatica using import scenario or API.Is there a way to import archived orders or modify Shopify orders to archive after 7 days? How do we prevent this from happening?

Is there a way to print a check for a customer refund that is not tied to the credit memo process?  The GITHUB package is not an option.

How do you set up Direct Deposit to receive payments from customers?

 I want to extend a new customers from business account, but while i try to extend there is error like this and also I can’t add a the new customer or account class. Can anyone help try to solve this?I really appreciate, thank you

Dear Supporters, I don't know why my set up approval have problem the user approval can't approval on the bill. Please kindly advise and Thanks in advance for support.  

Relatively new to Acumatica--we would like to make a change to the Profit and Loss financial statement to sort by Account Class then by Account Number.  Can this be changed and if so, what is the procedure to do so.  Thank you in advance.