Financials

Open the report that you need to modify in the Report Designer (see more about the report designer here https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/) Open File → Build Schema… menu and make sure the CCPayLink table is added to the report   Go to Relationships Tab and Left Join CCPayLink to ARInvoice or SOOrder based on PayLinkID   Add new Picture Box control to the report and configure it the following way: VisibleExpr: =[CCPayLink.Url]<>null BarcodeType: QRCode Source: Barcode Value: =[CCPayLink.Url]   Configure the size and position of the barcode. Add a new textbox and configure it the following way:Value “Click Here To Pay!” or any other label Navigate Url: =[CCPayLink.Url] Visible Expr: =[CCPayLink.Url]<>nullSave the report back to the server!Done! You now have a report with a barcode and a link that navigates customer to the pay link!  Troubleshooting:If you’ve configured the code and it still does not show up (or rather show up as

Apologies if this is already covered, I did search and could not find what I am looking for. Our five/six year old MYOB environment has a massive Audit history logs and I can’t find a way to delete on logs based on date and time?  Also, is this recorded for individual Tenants? Can the Audit log cleaning be done via UI or I need some special access to Database?  We have a cloud implementation, is it possible to get access to the database directly?

I am setting a P&L that shows month over prior month.  I would like to add a column that shows the amount variance and % variance.  What is the syntax needed in the calculation formula to do the math to subtract one column from another?  

Issue: A Purchase Order (PO) has many items. One item can have multiple Purchase Receipts.For example: Item A is received in 3 receipts: POR1, POR2, and POR3. I created an AP Bill from the POR3 screen. However, when I released the bill, the system matched it with POR1 (the first receipt) instead of POR3.Questions: Is this normal system behavior, or did we make a mistake? How can we make the bill match only with POR3 when we enter an AP Bill from the POR3 screen?

Can anyone tell me what the formula $AdditionsInPeriod or $DisposalInPeriod in a FA report means? I assume it means the total additions or disposals for the period but I am not familiar with the prefix $.The report I am working on seems fine but the totals do not balance. I am trying to understand the field content so I can correct the totals.Many thanks in advance. 

We are newly using 2025R2 AP incoming document recognition.  Am curious from other users if/when it learns the repeat invoice(s)?  We are finding it is not learning at all.  Each time you are having to map the missing fields.  We are likely going to abandon soon.

My FA team report the different about sub account of Credit Memo and Oriinal Invoice.they using Invoice Correction to generate that Memo. i have  try to identify, and i found that subaccount for the Memo same with  SO Subaccount  for the Original invoice.Is there any configuration that needs to be done so that the Credit memo subaccount is the same as the Original Invoice subaccount? thanks for helping me.

hello,I am using Resource owner password flow to get Acumatica token.I am encountering an intermittent issue across all environments, including Production.When we receive an application for processing, we call the Acumatica Get Customer endpoint using a valid authentication token. Occasionally (approximately once a day or every other day), the request fails because the response cannot be deserialized. Our application expects a JSON response, but instead receives an HTML page, as shown below. We cache the authentication token and validate it each time it is retrieved from the cache. Token validation is based on the Date header returned in the token generation response to ensure the token has not expired. Could you help us determine why the API is intermittently returning HTML instead of the expected JSON response, despite the token being valid?Tokens:return html response : LqGoqJP-MvG2Q44kKI_QEq0PqziBlrWXnInucaZS9w0return Json (Valid): IPLN2zlT8ui3GzGoySRC2M5nyz0Xa-StJ3cup25MAncif (resp

Hello,  I have a scenario where my company is based on UK and I have warehouses in Netherlands and Spain (Also in few other countries) Also, I have an EU customer whom I shall deliver goods from either Netherlands or Spain.On a sales order when I select the warehouse considering the country of it (If the country can be taken from branch that is also an option), and country of the customer, it should update the correct Tax Zone. In simple terms, my tax zone needs to be updated not solely based on the customer country but also considering the order origin country.  Is there a way to get this done?

Does anybody know how I can have Acumatica prevent one from Posting an AP Bill against a Purchase Order if the Amount of the AP Bill is greater than the Unbilled Amount of the PO? There is a setting in the Purchase Order Preferences screen where you can choose between No Validation or Validate with Warning but the Validate with Warning still allows you to do it. Our client wants this to be prohibited. I thought of using an Approval Flow to require approval if the AP Bill Total Amount is greater than the PO's Unbilled Amount, but I don't see how to do that. Is there another way?

I am stuck. I setup a Sales Order Invoice approval map so that Certain People can do the approval, but they cannot do their own. When I test myself it works and catches on the NOT Norman with a reject. When I test it with Lana, it catches on NOT Lana, BUT IT APPROVES! but NOT Lana is setup the exact same as mine.I am at a loss

Client has different companies in their tenant.  They would like when downloading the financial reports (balance sheet, Income Statement, etc.)  it exports the file name as Balance Sheet - <Company ID> - 01.31.2026.pdf (the financial period pulled through on the selection page.  Right now it downloads as Balance Sheet (2026-03-19).pdf which is the day the report was ran even though they only pulled as of January 31, 2026.Is there a way to change this?  I know we can change via Report Designer for non ARM reports. 

I prepared statements for the date of 10/31/2025 and successfully sent those statements, however Acumatica is still showing the “Last Statement Date” of 4/30/2025. Why is this date not showing as 10/31/2025 since that was in fact the most recent date statements were generated?

Our CFO wanted to test out some AI Capabilities and started with a question.“Can we use AI and Acumatica to establish patterns and predict when payments for invoices will be made?”I fired up codex and threw in a prompt for Plan Mode. Codex asked me 9 questionsIn total, it took roughly 10-15 minutes for the plan to generate. After user approval to implement the plan, success was almost won! (1 hour and 22 minutes) After having Codex publish and test as a user, it noticed that it forgot to add the site map and enable permissions. Once it cleaned all that up, it alerted me that it was ready for human review.There’s also a tab for each individual invoice, the justification of data, who won’t be paying inside their payment terms, and a few other bonus tabs. Values omitted. Back to the question, can it? It would appear so.

According to the documentation Purchase Receipts , when we create a Receipt, the system recalculates the Unit Cost instead of using the exact Unit Cost entered in the PO, right?Why does the system recalculate the Receipt Unit Cost from the PO instead of using the exact Unit Cost we enter on the PO? Is there any way to change this configuration so that the system keeps the exact Unit Cost entered in the Purchase Order instead of recalculating it? 

Hi! Has anyone implemented vendor consignment before? I’m trying to setup a vendor consignment warehouse at $0 because we don’t want there to be a financial impact until the inventory is used. I’ve looked at Doug’s article below but was wondering whether this can be done without having to setup a different branch/company. Any ideas?https://www.acumatica.com/blog/how-to-implement-consigned-inventory-part-2/

Publishing works correctly on the Customization Projects List page,but an error occurs on the Customization Project Detail page. 

Hello, I am required to initiate an approval process for Cash Transactions.However, I do not want the approval process to apply when the Cash Transaction originates from the Process Bank Transactions form, as those transactions are released by default without manual intervention.Is there a way to identify the origin of a Cash Transaction and bypass the approval process when it has been created through the Process Bank Transactions form?Thank YouAmanda 

How to change exported excel file name financial statement ( report generated with report definition )? i want to change excel document name to description + ( YYYY-MM-DD) thank you 

Hello,Our Acumatica on version 25.200.001. After creating credit memo invoice and Releasing the invoiceby calling Invoice/ReleaseInvoice then I try to get the status of releasing invoice Invoice/ReleaseInvoice/status. First time call to get the status it fails and get 500 internal service errorseconde time Succeeded and I can status no content 204.Why it is failing always first time. I tried to but delay after release but same thing.

Hi all,Has anyone ever seen a situation where an Invoice is Oh Hold or in the Balanced status, yet it has a Batch Number connected to it as it has been posted to the General Ledger?-RJ

Good afternoon,Our company currently has it set up for all sales orders entered to go on an initial “On hold” status...but once thats removed, it moves over to “awaiting payment” status for payment collection.Is it necessary to have both of these set up or does it seem redundant?We have the parameters already set up for credit holds and everything as well...so orders wouldnt move past “awaiting payment” unless manually altered.

What method does everyone use for prepayments on SOs when customer requires a prepayment invoice? Sometimes we will have customers who do not accept SOs with prepayment options. They will not pay on that. Our current fix is to utilize a user-defined field that generates a document which says prepayment invoice but still has the SO number on there. When payment comes through, I apply to the SO so that it will deduct from the balance once we invoice. One issue that arises is that the SO will still show as unbilled given that no invoice is actually generated. Just curious if there is built in functionality that we are not using which handles this situation better. 

We want to recognize COGS at the same percentage that we recognize project revenue.For example, if 10% of the contract value is billed to the customer, then 10% of the total cost of the parts (stock items) should be  posted to COGS. This ensures that revenue and the associated costs are recognized in the same accounting period, rather than expensing all material costs upfront when they are issued to the project. Note: We have Field service and Project integration- The service order type was created for Project transactions.Has anyone implemented this type of workflow in Acumatica using standard functionality, without a customization? 

Hello all,I have been working on ARM reports where I have defined my start and end fin period as the param, has YTD & PTD as columns.So if I run for a periodic range of Jan-26 till May-26 both the columns show the same values. I am unable to understand if I’m missing something in here?   Any ideas?