Financials

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

We discovered this process screen from the developer at our VAR; it wasn’t brought up during training.  I don’t have to use it too often, but if I wind up with an invoice that is out of balance it does the trick.  We currently run some other recalculate screens (like recalculate inventory) weekly--should Recalculate Customer Balances be set to run regularly as well?

I am trying to build a line graph widget to show opportunities by month year over year:Lines by year (2022, 2023) x-axis of each month - Jan, Feb, Mar, etc.  y-axis quantity of opportunities I can’t get it to show generic months and have all years on the 12 months vs actual month 1-2022, 2-2022, etc.Please let me know if you have a solution.Thanks!  

When running the 12-Month P&L Rolling ARM report in Acumatica based on the Budget Ledger, the report still displays values from the Actual Ledger. The Column Set or Row Set in the report is not specific to any ledger.Has anyone experienced this issue before? Could it be related to the report configuration or a missing setting in the ARM definition? Any insights or guidance on resolving this would be greatly appreciated!

I want to lock, not allowing further updates, to my forecast. 

The out of the box system does not let you specify any other type of account for a Vendor on an ACH (NACHA) export from AP. Follow these steps to fix:Go to Banking → Preferences → Payment Methods Select the Payment Method ID of the profile that you want to update, mine is ACH Click the “SETTINGS FOR USE IN AP” tab Click the + to add a new line ID Description Entry Mask Validation Exp 5 Account Type (Chk=22, Sav=32) 00 ^\d{2,2}$   Save  Go to Integration → Profiles → Export Scenarios Select “Export AP Payment to ACH” or which ever one you use Click the + to add (3) new lines Field Values Source Object Field/Action Name Target Field/Value vendorPaymentSettings @VendorPaymentMethodDetail.detailID ='5' vendorPaymentSettings DetailValue CCD_TransactionCode vendorPaymentSettings =IIF([CCD_TransactionCode]=null,'22',[CCD_TransactionCode]) CCD_Transact

Hello all,I would like to know the steps to following after we setup the fiscal year, import the balances in the Journal transactions.Thanks in advance.

I had complete Invoice transaction AR then I need to release Tax, but I don't know why it didn't have transaction to process. Thank so much for your sharing and helping