Discussion Forums

I know Constraint is what defines it, but obviously the start and end date won’t be the same for every Production Order. What would automatically adjust the end date to be a different day from the start day? 

Hi everyone,I’ve added a checkbox called UsrOptional to mark certain line items as optional. When checked, the item is displayed as “optional” in the Sales Quote screenNow, the customer wants the total of these optional items to be excluded from the regular “Total Net” amount. Instead, this total should be displayed separately under a label like “Total Optional Items Net”.Does anyone have an idea how to implement this?Or other ways to handle it ?Thanks in advance!  

Hi Community!  Is anyone aware of an investment or portfolio management software that can integrate with Acumatica and/or come up with a solution to support an investment management company on Acumatica? I did not find any integrations of this type on the Acumatica Marketplace. Thanks!

Good day,In shipments screen I added in the header an unbound field with a button and a tab named Labels with a grid. When entering a quantity of labels to be made the button is pressed and it creates the label record in the custom table and appears in the grid,  but my problem is that when creating labels the first time they appear and a few seconds later they disappear until I refresh the screen, the records are in the database and the labels are created just fine, but I don't know why they randomly disappear from the screen, I am not sure if I missed a configuration for the grid in the editor. public class SOShipmentEntry_Extension : PXGraphExtension<PX.Objects.SO.SOShipmentEntry>{ public PXSelect<EVTCCustomLabels, Where<EVTCCustomLabels.shipmentNbr, Equal<Current<SOShipment.shipmentNbr>>>> LabelsView; public PXAction<SOShipment> generateLabel;

I need to update the default warehouse on about 3000 items.  Does anyone have instruction on the import scenario to do this? Thanks,

Subassembly item, “item A” is included in materials for various Manufacturing Formulas.For “item A” we create independent batch tickets.However, every time a Super Batch using a Formula that includes “item A” is generated, a sub batch is also generated for “item A”.Is there any way to discontinue the creation of sub batches for certain subassembly items?

I want to add a tag to Shopify orders with the dropship PO Number from the line details in Acumatica. I see the “mark for PO” field, but not the PO Number field. 

I created a generic inquiry it was working correctly until I tried to add the payments received column.  Now the contract amounts/billing amounts and payment amounts are wrong on ones with multiple invoices.  I know the problem is creating duplicate lines for projects with multiple invoices. I tried the grouping function and getting rid of the sum function but that didn’t work so I think it how I joined the tables.  I can’t figure out how to fix it.  I attached the xml file.

Good day,I’m working on a webhook for integration with a third party.  The webhook runs find until I try to create an ARInvoice and add an ARTran to the InvoiceEntry.   The error I’m getting is in the SM_ARInvoiceEntry.cs file IsLineCreatedFromAppSO method.  The base.Base.Accessinfo.ScreenID is null.We have a separate integration using a custom screen with a custom Action, but using webhooks will be much better for our purposes.  Is there a way I can set the ScreenID from a webhook in order to create the ARInvoice with ARTran items? Here is the webhook code: namespace EcrsWebhook{ public class EcrsWebhookHandler : PXGraph<ARInvoiceEntry>, IWebhookHandler { private static readonly Newtonsoft.Json.JsonSerializer Serializer = new JsonSerializer(); decimal INFRA_DISCOUNT = (decimal)0.15; public async Task HandleAsync

Hi EveryoneI noticed that when we generate project billing to create a pro forma invoice, the change order line items do not have tax category assigned. Although the associated project task does. I am wondering if this is similar to the situation described in this thread below, when commitment does not have a non-stock item, tax category is blank despite project task. Since this discussion was from two years ago, has there been any changes to this?Anyone got any suggestion on how to improve this? It’s painful to assign tax category manually on the pro forma for change order items after generation.Thanks.

I am currently experiencing an issue when attempting to create invoices in the system. The process is being blocked with the following error message: "Invoice Nbr cannot be empty."Could you please advise on the cause of this issue and guide me on how to resolve it?Thank you very much for your support and helping.

We are using Role Level Security to provide specific users with access to specific projects (Group Type A), which works.  However, this configuration requires us to update the role level security with each job that is created.   Is there a way to associate role level security with a employee workgroup, rather than an individual user?

I have added a custom columns to the SOLineSplit which i want to add the custom fields to  LotSerialNbr selector lookup. Attribute for the selector was uses as below.  [SOLotSerialNbrAttribute.SOAllocationLotSerialNbr(typeof(SOLineSplit.inventoryID), typeof(SOLineSplit.subItemID), typeof(SOLineSplit.siteID), typeof(SOLineSplit.locationID), typeof(SOLine.lotSerialNbr), FieldClass = "LotSerial")]need to added two more columns SOLineSplitExt.UsrConversionUnit , SOLineSplitExt.UsrQtyINPiece  

I may be out of my league with this, but I really thought I was going to be able to edit an email before it gets processed using a GI and a business event, with maybe an Import scenario? The goal is to add an email into a CC and then process the email. My GI pulls the Purchase Order Notification emails that are pending processing, and cross checks the items in that PO for specific items. These are items that a specific email needs to know about. And I have that email on every line in that GI as well. So every pending email on this GI needs the email on the same row, added to the CC.  However, after creating the GI and Business event. I cannot use my GI or any email screens in the Screen Name field of the Import Scenario. So now I am stuck. Am I able to use an Action Scenario for this? Or am I out of luck on this task? I have no experience with Action Scenarios, but I am able to pick my GI in the Screen Name Field of an A

Hello everyone!,I need to add a custom screen in my mobile project, but when I want to enter the screen I see the following error "The sitemap does not contain the parent container." I identified it that happend when I have a SmarthPanel control on the ASPX page it doesnt work. Someone know how can I fix this?   

Hello all,I have been trying to add medium & flat rate shipping methods in ship via codes, but they arent appearing in the list. The integration with stamps.com and acumatica shows successful, but not able to see medium & flat rate. 

Hi Team,We are working with Build 23.112.0032 and working on a customization where we have to add an image url ( https://xyz.s3.amazonaws.com/kkltQWuXULPcHQ6TmoMsZkiJOK93x8.png) as File attachment to a Sales Order record through code. We tried to insert this image url under Name field in UploadFile table and later to map this record along with Sales Order NoteID under NoteDoc table but we are facing issue with approach. Can you please suggest the best possible way to achieve this. Thank you in advance! 

We’re on 2024R1 (Build 24.114.0020), just finished CRP2 and trying to finalize configuration for UAT. We don’t have any developers on staff so we’re farming out customizations to our implementation partner.  My issue:We’re using field service to send techs on service orders/appointments and for some reason Acumatica does not include any pre-built roles for the service module at all. Our partner provided some FS Admin roles they had from another user, but it grants way too many privileges to a technician in both the app and online. I started going through the Role myself leaving in the ability to do stuff like add Comments or Notes,  adjust the date filter, Start/Pause/Resume, Depart/Arrive, capture a signature, enter the signature name and do expense receipts against the appt and disallowing editing of most everything else but boy, it’s miles deep!In some cases fields I can see in the DAC either are named differently or just aren’t th

Hello,I am attempting to automate the creation of Tenants on an on--premise server. I found a PowerShell script that looked promising, but it is using PX.Data.Tools.Dll that I can’t find installed anywhere, even with the developer Debugging Tools installed. Does anyone know if automated tenant creation is possible? Thanks,Mark

How can I see where an inventory item was used? I want to be able to see what service order it was used on not just the project. Is there a way to do this?

Hi everyone,I'm trying to create a simple import scenario to release Proforma invoices. However, I consistently receive the error:"0 records of 1 have been processed. The last error was: Another process has updated the 'PMProforma' record. Your changes will be lost."What’s strange is that it seems to perform the Release from Hold action, as the AR invoice is created — but the Proforma itself remains in Open status instead of moving to Closed.Could it be that I’m doing this the wrong way? Any ideas or recommendations would be greatly appreciated!    Import scenarioBefore B.E.

We have a customer that wants to attach incoming emails that may contain multiple attachments to a Sales Order.  The only options I see in the Outlook integration is to a Contact, Case, Opportunity, or Project.   Is there another option I’m missing to add an activity to a Sales Order, Purchase Order, etc?

I am working on SalesOrder Screen SO301000.Problem Statement :-- I want to add the functionality to the page. When Clicking on Save Button I want to know if the Quantity for the for the Row Has changed. If yes, I also want to get the old value and new value and add logic based on the Comparison. But only when clicking on the Save Button  

I know there is already a request for a report of inventory aging here:  However all we really need is one field “inventory age” with the formula “X DAYS SINCE RECEIVED” to inform us how old the inventory is in general. We are fine with it always using the most recent receiving date for each item, without needing a value for every single receiving to have occurred against it. So the field would need to show the count of days since the last time the stock item was received.Days since receiving date. Using the date received field we just need to count days “since”. So received date being yesterday would have the value of “1” in that field for output, for example. What would this formula look like in the results grid builder for GI customization? 

Overview Constructors and Important Properties Projection DAC Differences From Regular DAC Mapped DAC Fields BqlField Binding BqlTable Binding Auto-binding by Inheritance Unbound DAC Fields