Financials

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. 

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. 

Is there a report that will show the payments in source currency?   We need this to balance the inter company - reconciliation in source currency.  

Hello Community,I have been trying to release AR invoices but the system triggers the following error:  Have created this invoice by using manual numbering. So once, the invoice was saved i disabled the manual numbering option but still not able to release it. Can anyone let me know why is this error getting triggered?Thanks in advance. 

We use AP Bills to track and pay employee expenses.   We use an approval rule to route the expense to the appropriate approver based on the detail provided in the AP Bill Transaction line.  We have found that on occasion Sr. Managers are asked, through our approval process, to approve their own expense reports. Could someone please provide me with an approval routing rule so that an employee (vendor) cannot approve their own expense report.Thanks!

Hi,We would like acumatica to display the first date of a week. For instance: Today it should show 08/28/2023. How can we achieve this?We tried : DateAdd(Today(),'w',-3) and it displays Tuesday’s Date 08/29/23 and not 08/28/23.What would be the best way to do this? I have this formula working in SQL :DATEADD(WEEK,DATEDIFF(WEEK,0,GETDATE())-1,0) but cannot figure out how to replicate in acumatica.  @lauraj46 - Hi Laura, could you please help when you have a chance?

How does one delete unreleased budget lines.Example: I imported $1 per month for a specific accountI release it.I now update the $1 to $2 per month. I realised I made a mistake, and want to delete this $2 upload. How do I do that? Currently the system errors , because there was a previous released article. I can't Upload zero, because it also wants to be released and then I zero out everything, which I don't want.

Hello community,I have come up with a scenario, where I would like to record a security deposit along with prepayments.So for eg: if I have an equipment to rent with rental price of 100$. And I want the customer to prepay (200%) of the complete rental price along with the security deposit. So Rental price = 100$ and Deposit = 100%. But I dont want the security deposit to be recorded into books as I would then be refunding the deposit completely. How can we achieve this in Acumatica?Thanks in advance.

We are working on a process where we are seeking to take a part already in inventory in Acumatica and move it out of the system to ship to a vendor for rework. Upon the rework the part will be modified by the vendor and assume alternate part number nomenclature. We are attempting to move move for instance part 12345 out of inventory to the vendor and receive part 678910 back as the new modified part. We can easily enter a PO line referencing the new inventory ID which will be received in upon modification but are struggling with withdrawing the current part from inventory. I attempted entering a PO for qty. "negative value" to show the withdrawal of the part but the system is not allowing me to do so. What is the Acumatica advised practice for sending parts out to rework which are already in inventory and need to be withdrawn?

Hi, Is there an option or setting to restrict partial payments on invoices and only accept the full amount? Thank you!