Financials

We have many customers set up with term cash discounts such as 1% 10 Net30.  We do not want the 1% calculation to include freight or tax.  The 1% should be on product only.  Is there anyway to accomplish this?

Hi everyone,I'm looking for guidance on two tasks in Acumatica:How can I create a list of vendors that includes their email addresses? How can I generate a report that shows vendors and their associated subaccounts?Any detailed steps or resources would be greatly appreciated.Thank you!

Hi!  We have 3 different translation IDs set up so we can translate our foreign entities (GBP, HKD, and CNY) into our main reporting currency (USD).  We occasionally run into an error when preparing the translations that is intermittent.  Anyone have any thoughts on what’s causing this, especially with it being inconsistent in occurrence? I have confirmed that we have translation loss and gain accounts and subaccounts set for USD within Currency Management > Currencies.One of my employees had this error yesterday when trying to translate our GBP branch into USD, but was able to do the translation this morning.  We’re both now receiving this error when trying to translate our HKD branch into USD.  This doesn’t happen every month when we do this and usually goes away the next day, so it’s not critical since it appears to re

Hi,Is it possible to change the post period for an vendor bill after it has been approved?Thank you.Regards,Raymond 

Hi,I have used bonus option in for the fixed assets which needs to be fully depreciated at purchase in Tax book. Once purchased it is fully depreciated and the net book value is zero .Now I want to change the depreciation method of the tax book to the same depreciation method as actual (Accounting) book. That means the asset needs to be depreciated same as accounting depreciations. I cant remove or edit the bonus field. I did a depreciation adjustment and re-ran the depreciation, but still it depreciates fully because bonus is applicable. Is there any way that I can remove the bonus method and let the asset depreciate over it’s useful life? Thank you,Dulanjana

Hi,i’ve had a few customers ask me if there was a calculation function within acumatica to add things within the amount field.  I wasn’t sure if anyone had seen this before? Thanks!

People are voiding payments that have already been deposited to the bank and it makes for A LOT of unnecessary work when reconciling.  In my eyes, there should be no reason to void any transaction that has already been released in a deposit.  If, for whatever reason, you need to void a transaction; you would need to first void the deposit, do what you have to do and recreate the deposit after.  Once a payment is deposited, it should be locked; period. Even Quickbooks had this capability; it’s very simple because the transaction is posted to the ledger when released in a deposit.  But if this is too much to ask, we should at the very least have the ability to restrict certain users from making changes to released payments, especially if they have been deposited.   Does anybody have any thoughts or workarounds to avoid this from happening?

Hi All, I am trying to copy an arm report from one tenant to another. For some reason I am doing something wrong because I cannot see it on the tenant I imported it to.

Has anyone ever been successful importing the postal codes. I understand Acumatica has the option to upload the postal codes like it does for Journal transactions, but I would like an import scenario to upload the postal codes based on each tax zone. It takes a long time to do it the way Acumatica has it setup. Thaanks

Is there a reason why a PO Status is getting changed to closed when we still have unbilled receipts and the PO is still open? For example - we do a PO for 7 boxes, do receiving for 7 boxes but first invoice from vendor against the PO is only for 6 boxes. When we enter that first invoice, the PO status is getting changed to closed which is very confusing for both our purchasing and AP Team. We are still able to a bill for the remaining 1 item, but it is confusing since from a high level it seems the PO is fully completed and closed.   

SWK (our solutions provider) has mentioned multiple times that Acumatica has the ability to accomplish split payments on Purchase Orders. Example we receive 10 items into inventory. The total for that PO is $14,010.00We have a vendor where we make payments on that particular PO in 3rds.If we received the inventory in July and our first payment due for that order is August 10th in the amount of $4670.00. Next payment will be September 10th $4,670.00 and August $4,670.00 completing the total payment for that invoice.  How do we accomplish this?

Good day, I have a client that asked me to do a Rejection Notification using email, i have created a Business event with the Trigger New Fiel Value Expense Claim status equal Rejected: Using this template (Note, I have removed the clients email from the FROM field):Make several attempts with differnet fields like Expense Total Greatar than zero (Using Operator AND), and diferent Expense Claims emails TO fields.Be advise that the my client has a Expense Claim Approval Mapping and a Notification setup for that on the Time and Expense Preferences. Any help is highly apprecaited.

I am brand new to Acumatica. I entered in our Trial Balances as of 02/29/2024. Our go live date was 03/01/2024. I did not take into account checks written in Acumatica prior to go live. Also, there were some prior year adjustments, which affected my FY beginning balances. My question is: do I post journal entries as of 3/1/2024 or can I enter trial balances for 3/1/2024? If I enter trial balances for 3/1/2024, will this negate all transactions on 3/1/2024? 

Under Customers, after clicked on generate on demand then click on print statement, I tried to click send. But the email template not pop up, pls help:)

Hello I am reconciling my Monthly tax detail report with my GL account 2045 (Sales Tax Payable) and noticed that  5 Invoices with sales tax are not showing on Sales tax payable GL account. All others are showing up.. Any idea why? The invoices are created from appointments if that helps 

I want to record the bank deposit received from Shopify Payments and move the payments from my clearing account to my regular account. However no payments that used Shopify Payments show up when I go to do a bank deposit 

 Would like to have a Column Set that only adds the months up to the “TO” period in the Parameter.  Was using a copy of the Rolling 12 column set but it includes totals for months past the parameter selection.  For example if we run it from 01-2023 to 03-2023 we want it to only include amounts for periods 01 to 03 and nothing beyond that.  

ACU V 24.105.0036 - Sensitive custom ARM reports are showing for a user who’s roles have the reports Revoked. For example, Here is a list of the User’s Roles that should NOT see the highlighted report in the second screenshot.This is what each of the four roles above looks like: This is what comes up for the User with those four roles (and it runs perfectly, allowing access to transactions): This user should not have access to any of the Financial Statements.  Ideas?

Hi,I run the profit and loss statements under “Finance/ Financial Statements”. There is no account number show in the report. May I ask what is the way to show account number in the report? Thank you.Raymond  

So for certain customers we use a non-stock charge item on the SO/Invoice. If this particular case the SO was create that had 10 units of stock item X, and a second line item for the non-stock item for Qty 10. We had to short ship the SO, so only shipped 9 units of stock item X. (As you know non-stock items do not populate on shipment)When we prepare the invoice the stock item comes over correct @ 9 units, but the non-stock item still defaults to the SO qty of 10 and cannot be changed nor deleted. The only way I can see to fix with is to delete the shipment, change the SO qty. We would not want to do this because I want to see the original source of record, the SO and the qty, and what we shipped. I want to see that 10 were order but only 9 were shipped.Is there a config change needed in the non-stock item setup? Seems implausible that I need to delete the shipment and change the SO, but wanted to get the opinions of the group before I did that.  Thank yo

In our test environment, we’ve created a Non-Stock ‘Freight Estimate’ item to add to Sales Orders so we can authorize a credit card payment before the shipment.  The ‘Require Shipment’ box is unchecked and the settings for our Sales Order Preferences, Order Type, Shipping Rule, and Non-Stock Item are identical, but in our Live environment it is left off the Shipment (visually), but is pulled onto the Invoice and shows the Shipment # on the line.  This does NOT happen in testing which is the desired behavior. We have ‘Add zero lines for Items not in Stock’ checked and we give the ‘Freight Estimate’ a quantity of 0.   Does anyone have any info on why a non-stock item that doesn’t ‘Require Shipment’ is being attached on the back end to the shipment..and messing up our invoices? This issues has been driving me and our Partner nuts.  Nobody seems to be able to figure it out, so I’m really hoping someone here can help us out.  I can post a ton of

Hello members,When attempting to split an asset in Acumatica, releasing the created transaction results in an error stating that transactions cannot be posted to a suspended period in Book 'GLPOST'. Does anyone know how to resolve this?Thanks,Catherine

This is just a general question. What is the purpose for Location on the Payments and Applications (AR302000) screen? As far as I can tell it doesn’t do anything. Is there any use cases for Location?  

I am trying to set up a tax calculation for Washington B&O tax which is a gross receipts tax paid by the company and not the customer based on the products sold.  I am unable to find any examples of setting this type of tax calculation.  Any ideas would be greatly appreciated.

Good morning,I am trying to do a refund through a payment received in a closed financial period.How is it possible to do so while keeping the financial period closed?  We are refunding it as of today but the payment will not allow a refund to occur due to the financial period being closed when the payment was received.