Financials

Please kindly advise, How can I change invoice from 156.54$ to 158.26$ ? and I am using cross rate. Thanks in advance  

Good day.I am not sure what the problem is for the Row Set (ALLACCOUNTS).  I have three accounts that are not showing on the TB and TB Roll ARM Reports.Accounts: 85425/85450/85475.  I thought if I fixed Code 00135 with the Value =@00135*-1. It fix the issue.  No luck.  Any suggests.  I would to not have to fix this when Accounting adds new accounts.   

We have a large number of refunds to write off, the refunds are coming from Shopify→ Acumatica, Is there is a Best process to handle this scenario? I have seen a below article but Looking for additional suggestions. Currently I have created a credit memo for 0.01 and applied to refund to close the document.  

Dear Acumatica Community,We’re connected to Shopify via the connector and using Shopify Payments for website CC processing. We also accept PayPal payments online. However, when we try to add our website payments to our general ledger, the Payment Method displays as “SHOPIFYCC” for all website payments, even the PayPal payments!We want the Payment Method to display as ‘PayPal’ so we can isolate those payments for reconciliation purposes. Does anyone have a fix for this if you are using Shopify Payments online?    

Hi,Is it possible to override release action in Fixed Asset Transaction screen? For now, the standard is can release if Transaction Amt >0 , but now i want to change the function so that it can release even though Transaction Amount = 0. Is it will effect others transaction? 

Hello all,Can any one let me know if its possible to create an auto-debit/automatic withdrawal as a payment method where the vendor can automatically withdraw funds from the bank account?I believe we can implement this via direct deposit → ACH.After setting them up how can we setup the whole scenario?Thanks. 

I have query related to having multiple company calendars with varying period start and end dates.  Centralized period management is disabled, multiple calendar support feature is enabled.  It is 2024 R1. There is 1 tenant with 2 companies. Both companies use USD as their base currency and require intercompany transactions and consolidations. Company A follows Jan-Dec. 12 periods but have period type as user defined periods as start date and end dates varies. Period 1: 1/1/2024 - 2/4/2024Period 2: 2/5/2024 - 3/3/2024And so on…Period 9: 9/2/2024 - 9/29/2024 Company B follows Sep-Aug 12 periods with period type as Month. Period 1: 9/1/2024 - 9/30/2024Period 2: 10/1/2024 - 10/31/2024And so, onPeriod 9: 5/1/2025 - 5/31/2025 I setup Financial Year as Jan-Dec.  I was able to generate Company Calendar for the first company.  But with Second company, unable to change the start and end dates as it is looking at the existing Master Calendar generated as required for company A.  How can I setup a

Customer has an AP Approver role set up - ap approvers can view AP transactions. All approval maps are set with the Reason for Rejection is required.  When an AP Approver rejects the transaction the dialog box opens but the approver cannot make a comment.  How can I set the access rights so that the approver can enter a reason? thanks,Coleen

Hi. Does anyone knows how to bulk delete all items existing in Sales Prices? Thank you.

We have Acumatica set up the capture GST & PST (here in British Columbia).  It’s nice that it (usually) calculates both taxes correctly.  But, we’re not a PST collector, only a payer so we do not need to track PST, nor do we need to submit it to any tax authority.The problem comes whenever I analyze an expense account where we’ve paid PST on invoices.  Every line in the ledger has a second amount and the detail on that line just says “PST”.  Here is an example where this becomes a huge problem.We have about a dozen software licenses and many are billed monthly.  At the end of the year I get asked the question; “how much did we spend on each piece of software”.  Normally I’d just run a ledger inquiry and then total based on something in the description.  But instead I have to add additional information and “code” all of the PST lines so I can group them with each piece of software.Is there a way we can configure Acumatica to add the PST to the expense line as it posts to the journal

Hello!I need to add a branch to a GL account, but I can’t find the place to do that. Can you help me?Thanks a lot 

How should we set up the Group/Sort Section to sort the report by Customer Account Name vs BAccountID?I went into the Build Schema, Looked at Sorting and Grouping, and tried to change the groupCustomer to CustomerMaster.AcctName Ascending vs CustomerMaster.BAccountID but I get the wonderful “We’re Sorry!” error... Edition: ConstructionVersion: 2022R2Thank you for your help in advance

How can we void payment without the voiding the payment in EBIZ or any impact to ebiz?  Any workaround here? Thank you in advance. 

One of our team has entered a prepayment into the Receivables Payments and Applications area.This was done in error, as no prepayment was received, so the entire transaction needs to be voided/deleted.If we simply VOID the entry/transaction. Will this eliminate from the customer Aging, as well as the General Ledger?  Our concern is what it might do to the customer history and aging.Thanks!

The Require Single Document per Document checkbox is not checked in AP Preferences.  I also cannot find any customization or business event that would populate the Project field on the header of an AP Bill.We have added the Project field (APInvoice.ProjectID) to the Bills and Adjustments primary list and here is an example of what we see:These four records happen to be for the same vendor and there are additional records with company WESTMIN that show Project X.The Detail line for both of the LPC bills has an active Project.  We are on version 23.210.0017.If anyone has an idea why or how the Project in the header is being updated, please respond.

Hello,One of our people posted an AR payment in the wrong amount (I surprised the system didn’t give a warning that the payment amount entered did not match the AR invoices loaded). Then he did a payment void but did that to the wrong period. So I am looking on how I can fix that so the GL matches the subledger. I can’t reclasify the batch because that does not correct the AR subledger. I can reverse the Journal transaction but again that only address GL and does not correct the AR Subledger. This is the second type of mistake that has been made that I have essentially been told “sorry once its released it can’t be fixed” which does not seem correct. So thought I would reach out to the community.  Thanks

I am needing to clear our entire AP subledger. I am testing the most efficient way to do this and initially thought I would create a new Cash Account (Clearing Account) and Payment Method for this purpose. My goal was to issue a mass (dummy) payment against all invoices which would get posted to the new cash clearing account, as it is not a real payment. I have everything set up but when I open Prepare Payments, the cash accounts do not appear in the dropdown once I have selected my Payment Method.You can see that these cash accounts appear under this payment method:The payment methods also appear under the Cash accounts - example below:Any idea why these don’t show up in drop down? Is there a different approach I should be taking for clearing out the AP subledger then doing dummy mass payment?

So we have balances on the AR that were for additional Retainage (HOLD BACK, RETENTION, etc) taken.  Most popular is that on the initial invoice of $50,000 there was no Retainage billed as per our sales department, so viola 45-60 days later the customer pays the invoice minus the 10% of $5000 (plus HST).  Now we have the short payment on the AR, and its aging away.Is there a way to do a credit memo that will take the $5000.00 out of the AR and put it in the Retainage held and it can be released with the others when they are paying it? 

Dear ALL,How to process a "Purchase with immediate payment" transaction without posting to the "Accounts Payable" account? Best Regards,NNT  

Hi everyone , I’m seeking help for this issue to balance our Profit and loss Report In our Inventory Preference their is one Reason code only for Return and issue including the transfer so every time we do a transaction for  ( return , issue , transfer  ) only one GL account  is allocated for this transaction , so the Debit and Credit keeps up when call the ending balance in our report  The problem is we can set only one GL Account in Inventory Preference  for Issue / Return / TransferHow to de we fix this ? Thank you Acumatica Family 

I’m having a problem getting the Accrual Sub on my PO Lines - When PO lines are added using the “Add Items” action the Accrual Sub is populated, when the same item is added using the “+” the Accrual Sub is missing…  

Context: We are in the export business and use a system called ACu to manage Blanket Orders, which include multiple Child Orders, each representing a full ocean container load. We ship these containers together and prefer to consolidate all Child Orders into a single invoice for each shipment.Current Practice: We receive deposits for Blanket Orders before knowing exactly how many containers will be shipped together. To keep our invoices consolidated, we wait to apply these payments until after the invoices are generated.Issue: We want to start applying these payments to Child Orders earlier to better manage our financial records. However, when we apply payments in advance using ACU, it automatically creates separate invoices for each Child Order instead of one collective invoice.Query: Is there a setting or an alternative method within ACU that allows us to apply payments to Child Orders before invoicing, while still ensuring that all these orders are billed on one consolidated invoice

Hello,Is there a way to set the “Export” button on screen AP305000 to only work one time? Long story short, we accidentally sent duplicate ACH files from our system because that button was clicked again after the ACH file had gone out. I have a feeling it can be done with a customization project, but wanted to check in with the community first.Thank you,Justin Long

Hi everyone, We paid overpaid a vendor for an invoice.  The vendor sent us a check to refund the duplicate payment, and the check has been deposited in our bank account.  How do I enter this check in AR so it will be included in and match the daily deposit amount on our bank statement when reconciling the deposits in Acumatica?  

Is it possible to reverse a voided check in AR