Financials

We are raising invoices from projects module or from AR module and want to be able to make the customer order field mandatory.In payables there is a data entry setting to require a supplier reference but doesn’t seem to be any equivalent for a customer reference (PO number).It would also be great if we could also amend the customer reference number for corrections after the invoice has been released without having to reverse and re-raise.Sorry rookie question!

Good da CommunityI am battling with a report I have been working on for ages. It was originally written by someone else but has never wired correctly. I have at last managed to get the columns to have the correct data, but some of the totals are duplicating, i.e. Aquisition Cost, Closing Cost & Depreciation.I suspect that the joins between tabes are the problem. I would appreciate it if one of you experts would check these joins and advise.These are the formulae that are incorrect:Acquisition Cost - by Class - =$BeginningAmount; Total Report - =$TotalBeginningAmountClosing Cost - by Class - =$ClosingCost; Total Report - =$TotalClosingCostDepreciation for the Period detail - =Sum(iif([FAHistoryByPeriod.FinPeriodID] = [FAHistoryByPeriod.LastActivityPeriod], [HistoryLast.PtdDepreciated], 0)) - this formula worked in a previous version before FABookBalance table was added.Any advise you could give regardug the table jjoins would be greatly appreciated.RegardsBarbara  

Is there any risks or negative impacts on subledger/GL or other accounts if a Retainage Bill that is still on Hold is deleted? We have over 20 that have been released by accident and would like to delete rather than create any reverse entries  

I have a long list of Employee Time Activities that need to be released. I received the following error when I hit release. The top suggestion was to make sure that the Labor Rates Date is set far enough back to cover the time punch for the Project. I tried changing the date multiple times including setting it back to the Acumatica default of 01/01/1900.No change.Any Suggestions? 

Hello,  In the GI is there a way to add the open qty section per PO receipt number and in Acumatica report designer?  Thank you. 

According to Acumatica’s documentation, the Final IN Ext. Cost should match the Estimated IN Ext. Cost. However, we’re seeing a significant discrepancy between these two columns.In our case: The Bill did not generate any PPV amount. The Unit Cost and Quantity are identical on both the Bill and the Purchase Receipt. In this workflow, the Bill was created before the Receipt. Given these details, what else could be causing this difference in the Final IN Ext. Cost? Because of this discrepancy, the item's unit cost upon receiving is different from the unit cost on the Purchase Receipt and Bill.

I am having an issue with project reporting.  Project WIP shows cost in excess of billings of $4,816 and billings to period of $29,669.  The difference is the cost of labor on the $0 invoices.  There are 3 invoices – one for the total revenue of $35,485, 2 for $0 revenue (costs only).  The total billings should be $34,485. Please advise.  Thanks!   

Hi Everyone, I noticed a difference in how document amounts are displayed across different screens in Acumatica:  On the Invoices and Memos AR3010PL, both Invoices and Credit Memos display the Amount as a positive number, where the document type determines whether it increases or decreases the balance. However, on the Landed Cost PO3030PL screen, negative values are displayed directly for cost reductions or adjustments. Could someone help clarify why Acumatica designed this differently? Is AR3010PL relying on the DocType to determine the balance impact, while Landed Cost needs negative/signed values to run its allocation logic? Thanks in advance for your insights!

Is a customer able to customize a template in AP doc recognition to make it specific to a particular vendor?

I’m looking for a report that identifies how a customer's pay history has changed over time. Do any of the canned ACU reports provide this? I’ve been poking around but have not discovered one.Example: average days to pay for a two-year date range shows that a customer went from 30-day to 40-days and now has slipped to 60-days. If the answer is no, I wonder if one of the existing reports could be filtered in such a way as to provide this information. 

Hi Partner,I want to ask. how to change the Chart of account currency from IDR to non-IDR? Our customer wants all the chart of account contain all currency (IDR, USD, etc). But how to setting in Acumatica? Because as I know we must choose one currency in chart of acacount for connect to cash account Will be grateful for your solution. Thank you 

Any idea about this error when creating a Purchase Return from a Purchase Receipt and how do I resolve this? Item is serialized, so I ran Inventory Lot/Serial History and don’t see the item going out of warehouse location. See snippet below with only one transaction happened in that serial number.This is the POR with Line Type ‘Goods for MFG’ but when I tick each line and create a return, line type is ‘Goods for IN’ and unable to change. 

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?

Is it possible to merge duplicate Vendor accounts into one?

AP Check Form - Anyone already have a template with check in middle and remittances at top and bottom?Please see attachment sampleThanks.John

Hello everyone, I want to ask about module fixed asset. So our customer want to know if in Acumatica we can see a journal preview before we process “Depreciation” in menu Calculate Depreciation. Do you guys have any suggestion for this? or in Acumatica have menu to accommodate our customer request?I really appreciate your help. Thank you.  

Hello everyone,  so our customer request to custom Asset ID. So, the Asset ID can be more specific from their asset class.Here is the example of their customized Asset ID:FA-EQ-01 FA-VHC-01For now we set the Asset ID using Asset Numbering Sequence. Do we need to use customization Project to create the UDF or etc? Do you guys have any suggestion? if we need to use customization Project please share the step that we can implied to our database. I really appreciate your help.Thank you. 

Hello, We’re evaluating our end of month financials and noticed that labor hours booked without pieces/yield the burden isn’t booked. We’re using variable by labor hours overheard type. We’ve looked over the existing documentation and are still unsure what overhead would be appropriate for booking the burdened rate with labor hours and no pieces. 

Dear All,  How to display two currencies in a single report, such as the BS (Balance Sheet) and PL (Profit & Loss)? How to set up a Chart of account so that it can accommodate all currencies? and how to configure it if a specific currency is required for the Chart of account linked to a cash account?

Hi all! I’m new to Acumatica; we just converted on 12/1 from Quickbooks.  How can I show an invoice marked as paid for my customers?  They ask for a paid invoice all the time for their records.  We sell high end products that many people need this for insurance purposes. Sometimes a customer will make a partial payment.  Example, a customer has an invoice for $100,000 worth of goods for which he paid $80,000.  I need the invoice to show: Total:  $100,000Amount Paid: $80,000Balance Due: $20,000 Or if it’s paid in full, it would be marked as such and balance due would be zero.  How can I do this?

Hello Everyone, so I want to release the Translation Worksheet and there is an error“Inserting 'GL Transaction' record raised at least one error. Please review the errors. The currency assigned to the denominated GL account (112001) is different from the transaction currency”. I know the error because I set the currency on Chart of Account (COA) because the COA was uses to set up Cash Account. The Chart of Accounts (COA) entry we configured for the Cash Account requires a currency setting; is there a way to set up a cash account without specifying a currency?So we can remove the currency in the COA?Please help me to solve this, I have been explored and try to create use AMR for the reporting, but it doesn’t work because when entering the formula, I can't directly pull the rate from Currencies Rate.Our Base Currency is IDR and we want to Conversion to USD.If you guys have any suggestion or advice, that would be very useful, I really appreciate you kindness. Thank you. 

The fiscal year starts in June, set up correctly in the Master Financial Calendar. But @YearStart in GI/dashboard filters still resolves to 01/01, not the fiscal year start  it seems tied to calendar year, not the Master Financial Calendar.@PeriodStart/@QuarterStart seem to respect the fiscal calendar fine  just no fiscal-year equivalent.Is there a supported macro for this, or is filtering on GLTran.FinPeriodID (e.g. Period 01 of current FY) the recommended workaround?

Hello,We recently encountered an issue where production order variances are being attributed to the incorrect branch. Our current set up is a two tenant, two branch instance.Our production orders for both sites are manually closed by a site admin, who has a profile at one branch but not both. In this case, the work order variances are being attributed to the branch the site admin’s profile belongs to. I’ve checked the warehouse profile and there are no GL accounts populated at all throughout the list. I guess the question is, will the user’s profile who is manually closing the orders play a role in determining what branch the variances are posted to? Especially if the warehouse profile GL accounts aren’t set up. 

Wrapping up Chart-of-Accounts design on a 2026 R1 build (clean-slate migration off a legacy ERP whose chart had grown past 400 accounts) and would like outside eyes on the overall shape before we lock the sub-account segment layout — that part is effectively set-once (segments can be appended later but not removed, reordered, or shortened). Company profile: single CAD legal entity, USD as a meaningful secondary transaction currency, ~15–20 ERP users, business mix of distribution + light assembly + full manufacturing across roughly 7–8 product families. Chart: 55 GL accounts total (roughly 14 Asset / 9 Liability / 4 Equity / 2 Revenue / 10 COGS / 8 Operating Expense / 7 Other Income-Expense / 1 Income Tax). Design philosophy throughout: push repeatable detail into a sub-account dimension or the relevant sub-ledger module rather than adding GL accounts — e.g. Fixed Asset CCA classes live in the FA module per-asset rather than as separate GL lines; product-family detail on COGS/Revenue li

Hi All,Has anyone here every used acumatica to track a rebate program with a customer and be able to generate a quarterly report to track it?  I want to track all their sales for a certain time period then calculate it in total and be able to use that rebate as a "credit" on future purchases by that customer.  Also it will be a fixed percentage of all sales