Financials

Hey, team - looking for some advice on Write-Off best practices used in conjunction with automation schedules.  I’ve got a client who has 3 specific customers whom they will consistently write off small amounts for.  There are instances when they have many invoices applied to a payment and we’ve instructed them to simply manually enter the Balance amount in the Write-Off Amount field.This isn’t a big deal, but I’m interested in automating it since it’s a literally just them copying one field (Balance) into another (Write-Off Amount.)  However, there may be invoices where the Invoice Amount is less than the Write-Off.  We would NOT want these to be automatically written off.  

Hi,I’m working on an ARM P&L Monthly report. My Column Set currently uses fixed Data Source periods (01, 02, 03 … 12).I want to add StartPeriod and EndPeriod parameters and make the column values (not just headers) adjust dynamically based on the selected period range.Example:If StartPeriod = 2025-03 and EndPeriod = 2025-06, the report should only calculate/show Mar–Jun.What is the correct way to achieve this in ARM?Should I modify the Data Source, use Visible Formula, or handle it in the Report Definition?Thanks in advance!

First of all, I would like to thank you in advance for your support. I am currently experiencing an issue where I am unable to use the Reopen and Unlock Period functions.Could you please kindly advise on how to resolve this?

Hello, I work for a company that has many employees that work on projects at various points of the project timeline. We have a date where we start to capitalize cost which is called the Cap Date. Any work done before that Cap Date is considered Work In Progress (WIP). We also have an internal project that we bill when we are not working on an actual project. Those cost need to hit Allocated WIP. With Acumatica’s current structure, you can only assign a labor item to one of these accounts which makes it tough because our employees then need to be aware of the Cap Date when billing. Is there a way to automate the reclassification of these labor items from COGS to WIP or vice versa based on the Cap Date and Project Status? Do Project task have the ability to define how labor gets posted? 

Hi!I noticed that the General Subaccount on the Branch Locations preferences screen is not a required field, we are able to save this with no issues: The reason for us leaving it blank is to force users to specify the subaccount (division in the client’s case) on the service order, i.e. roofing, painting, etc. depending on the type of service order is.Fast forward to the create AP bill functionality on the Service Order details tab.this functionality only brings in the related svc. doc type and related svc. doc. number but it appears to have a connection to the branch location general subaccount field because upon filling in the details, we get this error which on the service doesn’t seem correct because the subaccount is in fact NOT blank: 

Anyone else seen/have this issue on their efile where your compnay headers are printing this A 1234568ABCDEF info instead of the correct info needed to correctly efile? The IRS is obviously rejecting it  

Can anyone explain me apply to order calculation. I know the highlight amount is for next reserve order but how to it calculate it.

PrompTax is an electronic filing and payment program that's mandatory for certain businesses in the state of New York. One condition is if the tax liability for the June 1 through May 31 period immediately preceding the previous June 1 through May 31 is more than $500,000.  A taxpayer must pay in sales tax no later than 3 business days after the 22nd day of each month.  Sales tax is paid in for the 1st – 22nd of the current month, and for the 23rd – end of the previous month. Here’s the problem: The Tax Periods can only be configured as Half Month, Month, Two Months, Quarter, Half a Year, Year, Financial Period. There is no way to create a tax report for 23rd month 1 through 22nd month 2. Anyone else face this and solve it?

Is is possible to link SO to an already existing PO? if so then what’s the process

Hello,  I am receiving cash from customers as bank transfers and at that point, I am unable to identify the customer who made the payment. I am required to record the payment for the reconciliation purposes on the same period and on a later date or period, I am required to allocate that payment against the correct customer. Is there any way that I can handle this scenario with Acumatica by maintaining the original payment, allocation and same payment reference?Thank You

Hi all,We have an SO type RP (Return from Projects) that should only increase quantity and have zero cost. However, one SO (completed 1 year ago) was posted with inventory cost by mistake.Our items use the Average Cost method and are still in stock.What is the safest way to fix the wrong cost impact from this SO without affecting inventory valuation or accounting incorrectly?Thank you!

When will the Multiple Base Currency feature support all modules?I was quite excited to see multiple base currency support in 2021 R2, as this solves the single biggest pain point we have with Acumatica.Currently, we have a Canadian sister company that does a lot of interco transactions with the US company, and because of that company’s base currency being in CAD, we have to use a separate tenant.This creates a lot of manual re-entry of documents PO / SO / shipping docs etc and tends to be an error prone process, especially due to exchange rates etc.Now in reading through the details on this feature, I see to my dismay that there is a whole list of other  modules that are not supported by this feature. Meaning you can’t use multiple base currencies feature and these other modules. The modules that we use are in yellow: 

We are a multi branch company and we bill our cost to projects (COGS, WIP, etc.). One problem that we are noticing is that the Branch that the project belongs to is not pulling through whenever a time activity is released. Is there a way to fix this without customization. For example Employee A works on ABC company but does his timecard through XYZ company. How do I make sure that the COGS is recognized on ABC company’s books and not XYZ company’s books?  

Is it possible to process and enter expense receipts automatically in Acumatica by emailing receipt photos to an Acumatica email account, similar to AP document recognition, instead of doing it in the Acumatica mobile app?

We just implemented Acumatica and I’m beginning to prepare for using FIRE to electronically file 1099s for tax year 2025. When signing up for a FIRE with the IRS account it says that essentially tax year 2025 will be the last year that the FIRE system is available after which everyone will be forced to use the IRIS system to file electronically (which is available now). I know that Acumatica did not support IRIS for tax year 2024 but will they for tax year 2025? I would rather just sign up and use one system than use FIRE for one year only to change next year. 

I am creating a GI where I want to show GL account wise period wise and branch wise ending balance and turnover amount .Column A     |  Column B  | Column C |   Column D           | Column FGL Account  |  Period       | Branch      | Ending Balance    | Turnover amount   In the above GI (also attached the XML file ) , the ending balance and turnover amount for each GL account is not showing the correct data when compared with the Account Details screen.  

Hi,i am just wondering how can i set properly the workflow for approving credit memos, so that Sales Manager will always be the first to confirm new credit memo. Right now our AR map for credit notes is the Sales manager on the top and then the local controller, but in reality is other way around. The first the crontorller is getting the memos and then sales manager. Do you know maybe what is causing this flow?Thank you,Andreja Špindler

Hello!I am required to calculate sales tax on Invoices, but the tax should not get reported on the invoice but only when receiving the payment. Is there any way that I can do this?Thanks

Hi, I am doing an import bank transactions manually by uploading a CSV file. I have stated the beginning and ending balance, but when I create a new import bank transaction record for the same cash account, Acumatica doesn’t automatically set the beginning balance as the ending balance of the last statement. Could someone please explain clearly how this works? I would assume the system should’ve automatically detected last ending balance as the beginning balance for the current statement.

Hi,We frequently have customer invoices that are overpaid, and we handle the overpayment through a credit write-off, recognizing it as income.However, when we process the credit write-off for the overpaid amounts, the journal entry does not include the associated tax.Typically, the journal entry only debits Accounts Receivable (AR) and credits the income account. How should we handle this situation if we need the tax to be properly accounted for as part of the credit write-off?

Deposited payments are showing in Undeposited Payments reported. Can some one help me how to resolve this? 

Long-time Sage 100/Aatrix user attempting to file my first Acumatica-based 941.  Acumatica downloads the data, but on Verifying Data I receive the following error: The EIN in the AUF does not match the specified EIN for the user.  I have verified with Aatrix our EIN is correct (logged in and verified on the Aatrix website and verified with an Aatrix tech).Acumatica is passing either the wrong EIN or possibly a masked EIN (e.g., dash after the second digit as is common) or possibly a blank.  I have searched high and low and found no instances of errors or blanks in Acumatica setup.Anyone encountered this error and have a fix?

In the Chart of Accounts Screen. How can we add a fifth ‘Type’ as ‘Equity’ ?  

This Invoice has a payment linked to it so the balance should decrease by the paid amount.  When i was trying to create a payment for the remaining amount the below error arise;  Is this something to do with that bad debt reason code, but there is no write off amount.  I tried to reverse the payment done as well but it wont allow me to do it. same error occurs.  Could you please help if you’ve experienced same issue. 

How can I get the QR code with a customer payment link onto the printed form of the statement?