Financials

Hello - In one of our tenants, we had an account incorrectly added with an Account Type of “Asset”, and it wasnt caught until transactions had already been processed. Now when attempting to change the account type to Expense, I get an error message stating that I cannot change the account type because transactions already exist. Is there any way around this so that we can change the account to Expense and it populates on the Trial Balance and reporting correctly?Thanks!  

Hello, My Consolidated P&L report is eliminated but the consolidated net income under my balance sheet does not match with consolidated income statement. The net income figure that the balance sheet report pulls is a combination of parent and subsidiary without the elimination of interco transactions. It is drawn from the account class NETINCOME from respective entity.  I need help on how to make them tie under the report definition. Thank you in advance. Thank you. Regards,Cherlene

Im looking to set up a Business Event to send an Email reminder if the AP Bill → Approver hasn't approved the bill within 2 days.  I'm not sure if this is possible through a business event and how to join APInvoice to EPApproval. Has anyone ever done anything like this?

I have report where I note the account and it’s balance on one row, expand by subaccount on the next row set exampleThis is working great for obtaining the subaccount activity that makes up the account balance. However when printing the report, I would like to sort the subaccount string numerically. Currently, segment one is sorting largest to smallest while segment 2 is smallest to largest. Does anyone know of a custom expression for either the column set or row set to be able to sort the string smallest to largest? example of report output (exported to Excel), same behavior in the Acumatica screen and when exporting to PDF​​​​​Thanks for any and all help on this!

Hello Community,I have a query regarding the “ADD PO RECEIPT” button at the Bills Form and whether there's a way to display only the correct receipts.Let me illustrate the scenario: sometimes, a user may create a receipt but inadvertently input incorrect information and then proceed to release it. In such cases, the user needs to create a Return form, reopen the PO Line, and subsequently re-receipt it correctly. This results in the “PO HISTORY” tab of PO containing two receipts - the first one, wrongly released, and the second one, which is the correct receipt. Additionally, there's the entry for the Return form.Now, when we create bill for the receipts through “ADD PO RECEIPT” button, we want to see only the correct receipt (the second one) to choose in the Bills Form. This would help avoid any confusion and ensure accuracy in our billing procedures.I would greatly appreciate it if anyone could provide insights or suggest any methods to achieve this, allowing us to effectively filter

I can’t seem to figure out why this balance sheet variance column is blank - any suggestions?Here is row set:Here is snippet from statement: 

Hi AllI am experiencing an issue where Recalculate Account History (GL509900)  is not showing on Finance workspace. It would be grateful if anyone could help on this case.  Thanks 

We are working with Acumatica to get started but are still going there the demos and final questions stage.  Today the sales tax rates came up because in Acumatica they are manually entered and updates.  We are currently using QuickBooks and those rates automatically get updated. We only sell within California and only file one return.  Is there a software that would take care of just automatically updating the rates? Or is there a solution within Acumatica to help with this??Help/advice is greatly appreciated!

Hello,Our Acumatica AR Customer Credit Balances are not correct.  Example:Customer 169523000 - Vis****, has a $3000 credit limit, with a $69.30 Open Orders Balance, but then shows a -$6,260.70 Remaining Credit Limit. It then puts a Credit Hold on the Orders. Screen AR.30.30.00, Financial. Any idea where should I start looking? Workflows? Code? I am clueless.   I also saw this message when just digging around. Not sure if has something to do with anything of this. Please help.  

Can I change terms from N30 to an installment code on an open AP Bill?

hello, Can not close debit adj against credit adj because i have this error? i need to close the ap account because the correct currency is chf not usd  

Our project invoices are printing empty lines for the customer billing address where there are empty fields  (for example, an empty address line 2 in the customer screen will show as empty on the printed form). It is not the customized form that is the issue, as it does the same with the default report. I have also checked our customized form on a Demo site with the same scenario, and it prints correctly.Has anyone had this issue?

what is the actual AP bill due date calculation logic in Acumatica systemThe date was on 11/8, how come the due date was on 13/9? but not 10/9? TERMS OA 30 days The goods were received on 11/8, but the purchase receipt was created on 14/8, and the date was manually changed to match the actual goods receipt date. Does the system use the purchase receipt date to calculate the due date? or can it use the actual goods receipt date instead? 

I have created a consolidated balance sheet which includes the following columns:Column A (Hidden) Column B (Hidden) Column C (Displayed) Company A Company B Company A + Company B  This works, however it prevents column C from being able to click and drill into it since it is a calculated field. Is there anyway for the calculated field to retain ability to drill down and see the make up of it?

Is there a way to assign landed costs to a project and task upon creation? There is a field in the Purchase Receipt screen, but no field for this in the Landed Cost screen.Currently we have to apply landed costs through the regular AP Bill process, but there is no direct link of those costs to the purchase receipt that they apply to. It would be very helpful to have an audit trail of landed costs associated with a purchase receipt while also having the ability to book those landed costs to a project. 

Our customer has segmented subaccount numbers. They wish to do a search on the account details screen with a partial segment that will pull all subaccounts with that partial. Is it possible to use a lookup field for segmented numbers?  See screenshot below. 

Hy GuysThe wrong account was allocated to a prepayment (AP) and this prepayment has been released and reconciled, is there a way to fix this without affecting the cashbook?

Is there a way to create an on demand statement for multiple customers?I am going to send a statement to all customers on an EOM cycle at the end of Sep, but want to also send something before this date that is up to date.Sending a statement for 31/08 would be too out of date

Hi Team,  I logged into the mobile app and found that the time activities tracking feature is not available on the app - only time card. This does not work for my client because they need to be able to skip around on dates.  Is this really missing from the app? Is there a way to add it to the app? Thanks so much :) 

Hi! Is there a GI that we can be created that will show the GL accounts and the associated Sub Account with it for all or specific modules? I know GL account and subaccounts are setup throughout the system but I’m not sure if there is a table out there that contains this data without having to go through every module and joining many tables.

We are used to “reversed” GL where liability and income accounts are shown as a negative and always thought this was normal.  Can anybody tell me if we change to reversed in GL preferences how we will be affected.  We went live on 11/1/2020 and would like to see reversed (normal to us).Thanks in advance Brian

About: We would like to gather your feedback on cross company sales features for our upcoming release.  We held our first focus group in November 2019, but want to dive deeper into re-invoicing expenses and selling goods.Providing services to related companies (launching in 2020 R2 - automatically create a matching AP Document when you create an invoice for related company). Re-invoicing expenses to related companies (focus group topic) Selling goods to related companies (focus group topic) Selling goods from a related company warehouse Transferring goods with a profit marginAudience: Customers and partners who need this feature or have knowledge of workflows and how it can be delivered.Date/Time: Aug 26 @ 9am PDT / 12pm EDTRegistration: https://webinar.ringcentral.com/webinar/register/WN_qMl1oU97S-uBb4vA0j5nAA

Hey everyone, I’m having a difficult time with this one. I broke my brain over it over the holiday weekend. I had this working at some point at the beginning of the project last week and I must have accidentally unclicked something and I can’t figure out what. I’m bringing in Payments for Sales Orders, so I have an import scenario to add a prepayment and then load the sales order. I keep getting this “Missing operator before the Order operand.” issue. Any tips from anyone out there? I’m stumped. 

Hi, I am doing a testing about the Update Sub. on Order Owner Change function at Purchase Order preferences for future used. So, how does it work? is that when I change the owner of the purchase order, then the expense sub will change based on the department setting?  However, when I change the owner to other department, the expenses sub. will not change, can anyone explain to me how this feature works? Thank you.