Financials

I receive the below error when I try to release the below check. The check will need to be voided. GL Error: The application cannot be released, because the documents are related to different branches and the Inter-Branch Transactions feature is disabled 

Hi All,We have enabled multiple base currencies & customer and vendor visibility restriction in enable disable features form. After that it seems we cannot assign a already created cash account in the vendor’s form & cash account dropdown list is not appearing.   Enable Disable Form Created Cash Account Cash account assign in vendor form 

Hi,When exporting a batch payment, I am getting the error shown below and I am not sure what exactly is causing it to occur.Can you think of anything that might be causing this error?Kind regards,Andrew  

Hello, So our client has sent us this issue and I am trying to think of the best way to process. They are out today so I do not have all of the details, but my understanding is that they have multiple bank accounts involved with a vendor payments. So they will create a payment and the amount flows through Cash Account #1 to Cash Account #2 and then the vendor is paid. They need the payment to hit each account so that they can reconcile at the end of each month. The only way I could currently think to do this would be to have Cash Account #1 pay the vendor and then create a manual entry for Cash account #2 to show the amount flowed in and out. I checked the clearing account in Acumatica but the notes said that is only for AR. I am not sure if I am missing a feature or if anyone else has implemented a better solution for this?Any ideas?

Hi everyone, I see that the reverse sign of Trial balance  don't apply to ARM Report so the formula Asset+Expense+Liabilities+Income not equal to 0I want to create a trial balance report filter by period in arm report but i dont know how set up row sets or column sets to achieve this. 

We’re wanting to set up an automatic charge that goes to invoices that are past due 30 days.  I’ve worked in the “Overdue Charges”, the “Customer Class” and “Calculate Overdue Charges” but somewhere I’m missing something. 

Hi,A client is having trouble exporting a Batch Payment as they get the error shown below. I am not completely sure what the error is referring to.What would you recommend I check to resolve this issue?Kind regards,Andrew 

I need help importing overdue AR balances into the system. I have the template to use but for some reason i cannot get the balance to link to the details total without adding any inventory.we are switching from Quickbooks to the System and the export from QB only gave me the balance and not the line items.so is there a better way to import this information?

I am working with a client who is beginning to utilize the deferred revenue module for deferred expenses\amortizations. When a schedule is created using a flex code, the transaction amounts just seem random. Here is an example of a three-month deferral: Is there a setting we are missing somewhere to balance these or is it just a manual process?Thanks, Adam

Is there a way to create some kind of alias/attribute/etc. to group certain subaccounts (which we use for departments) together, without fundamentally changing the naming/numbering convention of the subaccounts?For example,000000 Main; 000100 General Corporate; 000200 Sales; 000300 ITFor this example, I would want to pull Subs 000000-000300, but not count 000200 (e.g., Corporate Overhead reporting).Aside from creating a hidden row that sums 000000-000300 and subtracting a hidden row that only contains 000200, is there a way to create some kind of alias (e.g., CO) to assign to 000000, 000100, and 000300, which I can then use in financial reporting?

All:Should we be able to process with the payment methods and credit cards that are found in the 21R2 Sales Demo?I created an invoice for WIDETCC customer and VISATOK payment method and I get the following errors with CAPTURE action on the payment screen Processing of the 166 transaction failed. See the transaction description for details. E00040: Customer Profile ID or Customer Payment Profile ID not found.. Am I missing something in the sale demo config?  

Hi all. I have a tenant with no transactions therein. I have a GL account and 1 subaccount with 5 fixed segments therein. These obviously appear in all profiles. I need to reduce these 5 segments to four. Is there a simple way to do this (auto update) without deleting 200 posting classes and so forth

Hi,How do I filter “AP Register” by subaccount number? I don’t see any subaccount options.

Is there a way to sort the reports on the finance tab under the financial statement header?    

Hey everyone, I’m looking to clean up a new client’s account classes. They want to clean up the canned ones and ones that were previously made, but I’m coming across this error:‘GL Error: Account Class CAPITAL is used in Analitycal Report Manager.’  Any ideas on where I can change a setting to allow deletion?  

Hello!Does anyone know if Acumatica supports the AP Check format - 3 checks to one page?  Has anyone ever used or configured that format before? Thanks,Coleen

Hi,I am trying to configure an approval map for journal transactions, where the approver is the supervisor (reports to on the employee profile) of the user that entered the transaction.  Here is the conditions tab On the Rules Action tabI have tried drilling into the owner option, but nothing is working.  I have the reports to field populated on the employee profile.Any help is appreciated.

I'm currently having issues setting up a mileage rate within our non-stock items (for our employees to use when submitting expense receipts) so it will automatically calculate for the employee. Currently, every time I enter the rate of .655 and try to save it, it defaults to zeros. I have tried many times and cannot get it to save what I have entered. I have created non-stock items before so I don't believe this is an access issue. Any guidance on how to remedy this is appreciated!

Hi Team,Seeking your assistance to identify the character limit of document and line notes in every transaction screen in acumatica. It seems this information is not available in DAC Schema Browser for inquiry.Thank you

I’ve been trying to build a subreport (basically a copy of the trial balance report) that would pull the 12th period ending balances for each account and pass that value to the standard Trial Balance. I can get the subreport to show values if I run it directly but the value never shows on the original. Am I missing something or is there an inherent problem with trying to get this value into the same report? I’ve attached the report (GL632EMS) and subreport (GL632e99) to this topic. If anyone can point to me what my issue is I much appreciate the assist!

Hello :) Does anyone have a good video/advice when applying invoices to a subcontract/commitment from a vendors subcontract total?? 

HelloMy client voided a Payment in Payments and Applications screen (AR302000) using the VOID button.A Voided Payment document was generated and it was released. Payment and Voided documents showed an open balance of 0.00- user assumed it was all ok. When Statements (AR641500) were generated and sent out, payment and voided payment showed up with an amount due.The Amount due was the “Available Balance” the Payment was left with.Client’s Acumatica’s version is: Acumatica Cloud ERP 2021 R1Build 21.126.0013Tested scenario with Testing SB and Live Acumatica inhouse- Acumatica Cloud ERP 2022 R1Build 22.110.0018 +These are screen shots from the SB where the same thing happened:Payment, applied to 2 Invoices and left Available Balance of $211.50 This is the Voided Payment that was then released:This is the statement- customer’s statement setup is not to show payments, these 2 should not show. Others that have no “Available Balance” are OK, they do not print Payments or Voided Payments.   Is t

Hi All,I’ve been browsing through the forums trying to figure out how to pull P&L figures into an inquiry that shows a P&L by accountID and subaccount and create a dashboard but the data that shows up in view inquiry is wrong. Several of the expense and revenue lines are missing from the data output and the subaccounts are wrong. Also the numbers pulled in are way higher than they should be. I did used to have ledger and subledger tables in the inquiry but they made no change to the data. We also only have one branch so dont need that. Here are some screenshots. 

Hi @everyone. I would like to map my stock item’s Pending cost to the BigCommerce Inventory cost.  But I can’t find the right source field for it.   Thank you.-Bernadeth

Has anyone had success importing expense receipts via import scenario? Here is my import and the system will process like it is working but then it doesn’t import. Any suggestions?