Financials

Does anyone know where there is a list oif the expressions needed to setup payment methods validation in the “Validation Reg. Exp” field  I am trying to work out what expression to use but i can't find a list of the available options and format needed thanks 

We have an issue where we are seeing a drastic limited number of invoices in Avalara then Acumatica.  Has anyone seen this before?  Is there a way to manually sync the missing Acumatica invoices to Avalara?

Migrating to ACM, currently on 2024R1, heading to UAT.I have a working Expense Claim approval map that routes claims to supervisors, emails them they have approvals to do and emails users who get their claims rejected….all good.I’m trying to replicate a policy we have in our current ERP system which prevents employees from claiming expenses earlier than 21 days in the past. There’s no “expense policy management” per se in ACM, so was thinking of making it the first step in my approval map, with an empty workgroup as the approver so it’ll get rejected automatically.I was considering using the actual claim line detail date but the Condition does not allow something like “@Today-21”. It only has the Date picker option: First, is this a relative value if I put in a Value and Value 2, like in an automation schedule (where it’ll advance on its own)?Second, if not (and it doesn’t look like that), does anyone have an idea on how I can implement this policy, either here in a map or some other m

Does anyone know if there is a side effect in ARM to have all balance sheet and income statement accounts in a single Row Set. I am not sure why all out of box samples have different row sets for balance sheet and income statement accounts. I created one all inclusive and doesn’t seem to have any obvious issue but I would appreciate if you can share your experience about the potential side effects.

We generally close our invoicing for a month by the second business day of a month and would ideally like to have Acumatica automatically generate the customer statement on the third business day and send them out. Not sure the best way to handle this. Seem to be able to set up the automation schedule to email the statements on the third business day, but the statement cycles screen that generates the statement only gives the option of selecting a fixed day of the month. The issue with this is that the 1st of a month can start on a weekend and could result in our statements being generated on the 1st business day of the month while we are still finishing our invoicing for the month.   

I am cancelling an invoice on screen AR302000, then I release it and I get the following error:please, Can you help me?

I am getting this error message when I am trying to Release a Bill.  The date of the bill is 11/18/2024, the post date is 12-2024.  I know we have been able to do this in the past. This Bill has some  Prepayments applied to it.  Could the error be the next prepayment has a post date of 8-2024, so they are not connected?

Hi I would like to create the system auto notification to appover when submitted the expenses claim.Not sure anyone know how  to do the setting? Hope to hear from you soon.Thank you

Hi SirNot sure if anyone know how to create the approval flow in the Expenses Claim?It would be good if you can give me a guide/step to create the approval flow.Reefe to below, there is not able to “ add” in the approval details. 

Hi,A client of our, accidentally create a Void Payment (in receipts and application) and released against a receipt payment.Is there any way to ‘unvoid’ the void payment? Or anyone encountered this situation and has a solution?

Good day all, We are trying to print an invoice from the invoices/memos screen but it comes out blank. but it is not always doing it. What can be the problem 

I’m not sure where to start troubleshooting this. Our system is set up so that when a shipment is confirmed an invoice is automatically created and released. But I am finding that a lot of the invoices are being put on a credit hold because (and this is an assumption) the invoices have different totals than the sales orders.We do have a big tax customization that may be the cause of this but I’m not sure where to dig to confirm or deny that.When I look into the DAC for the tax total field on the invoice and sales order it seems that the infromation is coming from the same place Sales Order element properties: DAC for SOOrder and CuryTaxTotal field Invoice element properties:  DAC for ARInvoice and CuryTaxTotal field This is as deep as my knowledge goes for troubleshooting this and was wondering if someone could give me my next steps? I’m not familiar with Business Logic and was thinking maybe that was the next step.

The Financial user has access to user role Financial Supervisor. This allow the user to post transaction to closed periods.  This however does not apply to closed Project and Project Task, i.e. Project Task with a closed status.Is it possible to allow a super user access to post to closed projects?The error when a Journal transaction to a closed period that is allocated to a project & project task as follow:“An error occurred during processing of the field Project value 4102 PM Error: You have no permission to use project tasks with the Completed, Canceled, or In Planning status for data entry. “

Trying to release an invoice and it keeps firing back the same error. We checked stock and all and cannot seem to find the root of the issue. Any assistance would be great! 

Hello,Payments off our website are processed by Woo Commerce, and they take a fee!Its like 1.75% + $0.30 How do I add that fee to the SO or invoice? 

Dear All,The Withholding Tax transaction update the financial year at the time of applied Bill and Payment. Is it the setting which we can adjust somewhere?I have a Bill applied Withholding Tax as image. At the time this Bill was released, Withholding Tax doesnt update the financial period yetThe transaction of Withholding was created at the time of applied to payment.Due to the law, the Withholding Tax transaction should be record to financial period at the time of the bill, instead of the applied period.Is it the setting which we can adjust somewhere?Thanks in advance,Yên Chi

Hi! Is there a way to restrict payment methods between companies? Where users who only has access to one company can only use the payment method created for that company? Thanks!

Do we have function that can release all payment received from different customers? 

BackgroundThe Customer Statement only prints adjustments if the customer’s statement type is Balance Brought Forward. The ARStatementAdjust table is not populated if the customer’s statement type is Open Item.Business CaseCustomers with statement type of Open Item have requested their (monthly) statements to include lines that show adjusting document(s) which explain the difference between Orig. Amount and Balance statement-columns.   Note: We are aware of AR Balance by Customer that can show these details.QuestionsIs there an easy customization to make to populate the ARStatementAdjust table for statement type Open Item? Has anyone modified the Customer Statement report to use other AR adjust tables? If so, how did you handle ARStatementAdjust fields that drive critical calculations in the Customer Statement report, that do not exist in the other adjust tables? Are there any other options?Thanks,Dan

We are getting this type of error on almost everything that needs to be processed. Users try for many times receiving the same error and eventually it goes thru and process. Sometimes it processes right away sometimes it takes several tries. Any idea what can be casing this behavior?Sample screenshot:   

HiIs there anyone know how to add in a new Tax ID?Currently , we need one more new Tax ID , not sure where can we add in ? Is there any effect that we add in one more Tax ID?Thank you 

Hello! We are just starting to use the Advance SO Invoices for our Sales Orders and we are coming to an impasse when we go to release these SO Invoices. Receiving the error message “Object reference not set to an instance of an object” and we are unsure how to proceed.When I view the trace I see this error:Does anyone know how to get around this error?Thank you!

I am using multi base currency and it enforce restrict visibility to specific companies or group of companies, Is it possible to create a supplier or customer without this restriction being enforced. I extended the companies on the tenant as customer and vendors and the system does not force this restrict visibility rather it create a tab for balances with multiple currencies. Standard Vendor Extended Company as Vendor, the restrict visibility no longer has the asterisk  

Hi all,We have some timing issues in some European countries where we need to report VAT and Acumatica is using the Invoice date to make the reports, so we end up “sending” some late invoices to the next period. We are wondering if we can configure Acumatica to prepare Tax Reports based on the Invoice Posting Period instead of Doc Date?Thank you,a.

Hi, we are trying to delete a Tax Zone but encountering an error that it is related to a tax transaction that I cannot seem to find. Is there a way to deactivate it instead? Thank you so much in advance. tax