Discussion Forums

we upgraded the version from 22r2 to 23r2. after rebuild the solution while try to open in browser for login page getting the following error.  

Hi there, I am trying to override the address line 1 on Shipment screen by defaulting it to the User Defined Field selection (pointing to Customer table). However, when I got this error when I try to test it: Below is my DAC as well as code for your reference:DAC:using System;using PX.Data;using PX.Data.BQL;using PX.Objects.SO;namespace PX.Objects.SO{ [Serializable] [PXCacheName("SOShipmentKvExt")] public class SOShipmentKvExt : IBqlTable { public abstract class recordID : BqlGuid.Field<recordID> { } [PXDBGuid(IsKey = true)] public Guid? RecordID { get; set; } public abstract class fieldName : BqlString.Field<fieldName> { } [PXDBString(50,IsKey = true)] [PXUIField(DisplayName ="Name")] public string FieldName { get; set; } public abstract class valueNumeric : BqlDecimal.Field<valueNumeric> { } [PXDBDecimal(8)] [PXUIField(DisplayName = "Value Numeric")] public decimal? ValueNumeric { get; set; } public abstract class valueDate :

Hi All, I have this error. What is the problem and how do I rectify itthxDries

Is there a way in which one can use Route Management capablitlies for the delivery of items from sales orders?One can create a service order from the sales order for goods and installation and then create appointments for employees, however, this is for staff and we need it for vehicles in which the routes and appointments can be managed.

Currently we are experiencing an issue in Acumatica - Power BI Integration for a Single tenant of a multi tenant instance. The issue is as follows. Please check the below screenshot.There are 2 tenants in this instance as  Test and Company. The connection for both tenants worked fine until recently. Now only for the Company tenant this above error is getting appeared. I examined all the GIs that have exposed via OData. In every GI there was no any field named DateCreated. There are no any significant difference in between these two tenants.  So can i know what's wrong with this Company tenant that cause this error.    

I am trying to make a generic inquiry of appointments for the current month and past months so I can add a widget to my dashboard of a bar graph on how many hours are being used with each of our customers. I still struggle with making GIs...

I have a client that is testing 2022 R2 and on the appointments screen of field services, they are getting the message that Tax is not up to date however tax is recalculating. This message does not disappear when saving the appointment but when this message appears on the service order, it disappears with a save. I did not see a known issue for this but could have missed it. Anyone know why this is happening?  

I’ve been working learning the Project Accounting module and need some help with setup. I’ve reached out to our partner but also wanted to see if there were any experienced users that would be willing to help me out.My main issue right now is figuring out how to get Project Transactions (labor, material, charges) to post correctly when billed from an Appointment. Service Order Type only allows one Account Group to be assigned and when the Project Transaction is created everything gets tagged to that group. I don’t know if the Allocation Rules would fix the issue because I can’t seem to get it to work like I think it’s supposed to. Thoughts? I really need to get this setup as it would be a big game changer for us.

Hello!I’m creating a service order from a sales order. And to create the service order, I select the require appointment check box for the stock item and to the service. The items entered in the sales order will be shipped from the sales order shipment.But when I create the service order, it shows the stock item line status as require scheduling and ask me to do another item issue when completing the service order as well. But the documents say we are only requiring shipping the items which are newly added to the appointment.If there’s any step or information I have missed? Best Regards Amanda

Why don't line item notes appear when I print the Service Appointment? We would like the Service Tech to be able to see the line item notes. We also would like somewhere in the Appointment to capture all the service Tech notes about the service provided. The Notes on the mobile app print at the bottom of the Invoice, but there aren’t enough lines for the full descripton of the work. Where do others capture this info?

Hello fellow Acumatica users.  Do you know if it’s possible to enter an AP Bill to a Service Order without using a Purchase Order? Thanks!

Hi Team,I am working with 23R2 (Build 23.209.0023) Shopify connector. I have a custom table and a custom screen. I want to create a new Entity similar to the Stock Item and sync the data from custom table to Shopify as stock items. I tried to create a new graph using SPProductProcessor but getting error while inheriting from this class. Then I used ProductProcessorBase, using which I am able to get the data in Sync History but during sync objects are getting null and further processes are failing.Can anyone suggest the best possible way to achieve it.Thank you in advance !

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. Megan Friesen - Acumatica Community Featured Member for July 2024Meet Megan Friesen our Acumatica Community Featured Member for July 2024. It’s great to have you as part of the Acumatica Community @meganfriesen37! Hot Tips, Known Issues and BlogsKnown issue: On the Close Production Orders form, in some cases, the system di

Had a question come up recently and not sure how to answer.  Has anyone had this issue before? In using the AP Document Recognition, we have experienced Acumatica bypassing the needed invoice on page 1 and instead grabbing header data from page 2 of the pdf document which is usually a supporting sub-invoice to the actual invoice that should be addressed on page 1. This does not seem to improve with machine learning after several invoices from the same vendor. We are using version Acumatica 23.111.0019. Have your customers reported this and do you know if it has been improved in subsequent Acumatica versions.

I’m trying to make certain acvtivities billable in the Employee Time Acvtivites screen.My import scenario is throwing the error that the employee is not found.   Any advice would be welcome

I added 3 custom fields in a tenant. A snapshot from another tenant was then restored. The package is no longer available, but the 3 fields still show on the screen. I need to get rid of them. I tried hiding in access rights, but they are not visible there. See fields on screen: I started a new customization package for the screen to see if the custom fields are there. I see them, but they’re not in the column shown above, nor any column. How do I remove them from the screen at this point?  

If you’re like me, you don’t enjoy typing out long BQL queries, or writing all the boiler plate code for a new DAC, with all its properties, abstract classes, and attributes.Here’s a little tip I’ve discovered to save me a lot of time there.This is one of the very positive uses for ChatGPT, and writing boiler plate code is something it is quite good at, if you use a GPT that has been trained specifically for Acumatica. This is NOT a sales pitch, but on the GPT store, you can get the Acumatica Developer Assistant GPT (by Evan Trowbridge). The usage is throttled, but you can still use it a few times per hour for free. It is substantially more accurate than regular ChatGPT. A simple prompt with a few instructions can get you most of the code for a DAC in a few seconds. You’ll still need to make some adjustments, but this will get you 95% of the way there.Here’s a small example. I will probably refine my prompt so I can add more information to it and have the resulting code more complete,

Hey everybody,Is there a possibility to import the description of stock items via Excel with line breaks? It seems that the import scenario doesn’t take the line breaks from excel into account… Any help is greatly appreciated! :) 

On the shipment/packages Does anyone know if you can automate the “ADD SO SHIP LINES” to pack all the contents automatically?  For example if i only have one item, cut out the steps to add them.  Have it automatically pack the items.  

Hi, is there anyone that has had success bringing in check numbers from a corporate checking account into Acumatica bank feeds (via MX or Plaid)? Our current bank feed with current bank only shows the word “check” with no actual check numbers. Also have a number of corporate credit cards who will no longer be supported via MX or Plaid through my bank Curious which banks anyone has successfully accomplished this functionality (JP Morgan, Bank of America, Truist, etc)

There are three tenants in our Acumatica Instance. For the purpose of creating a SQL view, we used the below DB Script.create or alter view ardiscountView asselect ROW_NUMBER() OVER(ORDER BY Usrdiscountcoden ASC) row,RefNbr,TranType type,Usrdiscountcoden discount,sum(CuryDiscAmt) amount from artran where Usrdiscountcoden is not nulland CompanyID=2group by RefNbr,TranType,UsrdiscountcodenBut in here we had to hardcode the CompanyID. But we want dynamically pick the CompanyID depending on the current tenant. If you can provide a way to perform this it id highly appreciated.  

There is a known issue with the Salesforce Integration if you’re on Hyperforce. Our Salesforce migrated to Hyperforce in February before the known issue was reported.Our sync has not been working since February. Is there any chance this is still getting addressed? 

ACH payments are our primary means of remittance.  Our ACH payments are accompanied by an emailed Remittance Advice (triggered by a Business Event).  This has worked without issue for the two years we have been on Acumatica.  For the same amount of time we have been trying to get Acumatica to email a Remittance Advice when making an ACH payment for a Prepayment (out of Purchase Order). At first we tried making Active a stock Business Event, “Email Vendor ACH Prepay Advice,” which did not work.  We have subsequently tried numerous modifications.  Requests for Vendor Prepayments are fairly infrequent.  Sometimes weeks pass between a failed attempt, a modification and the occasion to try again. At any rate, here is what has most recently failed: Anyone have the magic combination to cause Acumatica to email a Remittance Advice for an ACH Prepayment?

I have 2 tenants in one Acumatica instance, one is for testing and the other one is the live tenant.When I publish a Customization Project in test Tenant I can see the same changes in Live tenant as well.I don’t want this to happen. Is there something that I have to anything specific to handle this?Can anyone advise me on the best practices of publishing customization projects?Thank you.