We have a customer who would like the ability to enter Sales Tax information for Customers and Locations in Acumatica, including an uploaded certificate image, and have that same information populated in AvaTax’s Certificate Management database without having to manually enter it. We’re aware of a library of APIs Avalara provides, and we’re wondering if anyone has developed scripts to accomplish this? The overarching goal is to enter the data once rather than having to add the info in both Avalara and Acumatica. The other driving factor is that customer exemption information entered in Avalara is not visible in Acumatica and requires users to log in to Avalara to determine if a customer already has an exemption certificate on file.
Hi, I have this error someone change the password on my account on sql, and i have this error.I already change the password and try to Log in on the Tenant Maintenance with this password and Acumatica let me pass straight to other steps.I have the tenant on the same version 23.108.0020 and idk the error says can't get the version.
Customers are being alerted by FedEx that the development for the FedEx Web Services (SOAP) integration has been discontinued in preparation for its retirement. FedEx is suggesting to modernize the integration by using the FedEx API (REST) solution. Does Acumatica have a schedule for the conversion of the FedEx plugin to use the FedEx Rest API services?
Received this error when trying to calculate depreciation for this asset.
Hi,My final target is to create a Business Event in order if Regular Time is Over 40H and is submitted, to put a timecard on hold, and send a SMS to the employee to notify him to correct it. So my target is to have the total Regular Hour for a given timecard. My problem is i don’t find bounded field with this total. I see bounded fields like Total, total of overtime, total billable, but no total of Regular.It’s acheivable to do a grouping in the GI or a calulation, but theses two things aren’t compatible with the business event!Other option could be to customize and put the warning as an error, but I dislike it because that prevent saving the timecard, and the person could loss is data.Thanks
Hi,A client is having an issue where the Owner field in the Purchase Orders screen is always empty.I found the existing question below about this issue, but the selected answer didn't work for me.Is there a different way that this Owner field should be populated now? If so, what is the best way to added options for this field?Let me know if I can provide any other information.Kind regards,Andrew Purchase Order owner | Community (acumatica.com)
The Variable Labor OH by Qty / Cost is calculated when an operation moves. The prerequisite is that the actual labor cost must be posted against the operation prior to the operation being moved. This makes sense conceptually. However, for clients that use clock entry and approve clock entry process, the actual labor does not get posted until the next day (or later). The move happens in real time as an operation is completed. The issue is that since the operation is already moved / completed, the variable labor overhead does not get calculated when the labor is posted. This is a timing issue, and causes the production order to not incorporate the variable labor overheads. I am curious how other members of the community may have solved for this? Thanks!
Hi Community, AI and especially ChatGPT have been the number one topic of conversation for months. Have you already used ChatGPT with Acumatica in any way?For edge users, I have included BingChat as a SidePanel for a faster lead qualification (https://www.bing.com/search?form=MY02AE&OCID=MY02AE&pl=launch&q=AcctCD&showconv=1&showconv=1 inserted as a link). But this is also only a small possibility and unfortunately without automatic data transfer. Have you already found possibilities for this?
I wanted to check best practice about Custom Fields. If you add a field to the Customization Project, publish the Customization Project, remove the field, and then publish again, then I think the field is deleted from the database. What happens if you unpublish the customization project, does the field get deleted too? Does the project check if any values are in the column being deleted from the database? Do I need to Export and Import to make sure I don’t loose the custom field data.I know that you have to unpublish customizations before upgrading versions so I don’t want to lose custom field data. Also, as this is a SaaS environment, who does the unpublish/publish when the upgrade is done automatically? If you have a number of tenants and the customization project is on an old tenant that then gets deleted, can you load the Customization Project to the current tenant so you can manage the Custom Field, and should you do this before or after the other tenant is deleted? Is it ok to ha
I am adding various custom fields to Acumatica. All seem to work ok, except on one screen. I have done a test on a sales demo instance. Adding a field to Sales Orders screen works and the field updates and persists when saving and the reloading the record. Putting a field on the Kit Assembly screen allows you to edit it, but it doesn’t save. When you reload the screen the field value is gone. I guess I am missing something that I need to add but that the other screens don’t need, or I have done something wrong somewhere. Here are my screenshots of what I have changed showing one that works and one that doesn’t.
The report itself is rather simple. It’s a profitability analysis report where I have to show how much item we have sold to a customer, filtered by date. The formula for my Qty field right now is:=sum(IIf( [ARTran.TranType] <> 'CRM' AND [ARTran.CuryTranAmt] >= 0, [ARTran.Qty], 0 )) - sum(IIf( [ARTran.TranType] = 'CRM', [ARTran.Qty], 0 ))which lists the items we sold to the customer for a cost. Now, we also give out free stuff to our customer, and for that, I use this formula:=sum(IIf( [ARTran.TranType] <> 'CRM' AND [ARTran.CuryTranAmt] > 0, [ARTran.Qty], 0 )) - sum(IIf( [ARTran.TranType] = 'CRM', [ARTran.Qty], 0 ))I was using VisibileExpr field under properties > behavior to switch between formulas from a parameter where user selects if the report has any free items or not. Is there any way to do it without using VisibleExpr? I was looking for a way to do the same thing I’m doing right now, but simpler.. Maybe using just one field for Qty rather than using 2 and re
Hello Acumatica Community,I'm curious to know if there's a way to link an image uploaded within Acumatica to a notification template without the system sending the image both as an embedded item and as an attachment in the same email.I've been encountering difficulties trying to achieve this functionality. Despite successfully displaying the image in the HTML where it's intended to appear, it's also being attached when the email is sent out. Interestingly, when I check the Email Activity at CR306015, it doesn't seem to be added as an attachment, yet it arrives in that manner.Any insights or assistance on resolving this matter would be greatly appreciated
Hello. I am looking for an idea or a solution to a problem. We have noticed a bug that is triggered when there are too many panels in the detail section, or when there is a section with "PrintOnEveryPage" in the middle of the report without the "PrintAtBottom" attribute. Under these circumstances, the actual footer moves up and down instead of staying where it should be. Is there another way to circumvent this problem other than not using panels in detail sections or working without "PrintOnEveryPage"?
I’m getting this error despite all my addresses being US addresses. Carrier Service returned error. DHL Express:This DHL account is owned by EasyPost and does not support non-US origin shipments. Please link your DHL Express account to continue with the shipment
Hi Team, I added two custom fields, one on the project screen and one on the quote screen. I want to transfer values when a project is created from a quote. The fields are using the DACs 'PMSiteAddress' and 'CRAddress'. For the 'PMSiteAddress', I've created an extension class 'CRAddressExt' to add a custom field 'usrCounty'. Similarly, for the 'PMAddress', I've created an extension class 'PMAddressExt' with the same custom field 'usrCounty' public class CRAddressExt : PXCacheExtension<PX.Objects.CR.CRAddress>{#region UsrCounty[PXDBString(155)] [PXUIField(DisplayName = "County")]public virtual string UsrCounty { get; set; }public abstract class usrCounty : PX.Data.BQL.BqlString.Field<usrCounty> { }#endregion}for project public class PMAddressExt : PXCacheExtension<PX.Objects.PM.PMAddress> { #region UsrCounty [PXDBString(155)] [PXUIField(DisplayName = "County")] public virtual string UsrCounty { get; set; } public abstract class usrCounty : PX.Data.
Hello all,I have been trying to select the week field. When I checked in Production, the system allows me to select a particular value under the week field but it is not allowing me in the Sandbox. What can I do?From SandboxFrom Live
We’ve had a push notification which has been working for quite some time, and then a couple of months ago, it simply stopped firing/triggering push notifications.After some investigation, it appears that when you make use of a custom field in the conditions tab of the GI that’s being monitored, it simply doesn’t trigger. To test my theory, I set up a super basic GI and managed to get push notifications to go through to https://webhook.site/. However, as soon as I add a custom field into the condition tab of the same GI, the push notifications no longer trigger. Based on this test, it looks like custom fields are no longer supported. We recently upgraded to the version 23.112.0032. Is anyone else aware of this change, and what options do I have to trigger push notifications based on a custom field on the SOOrder changing?
Get Started HERE and be sure toIntroduce Yourself
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.