Discussion Forums

Hi,I have recently added a new custom Ship Date field to the Project Quotes screen, but I am finding that this field isn’t having its value persisted after saving and refreshing the screen.Is there a property or piece of code I need to add in to ensure this new keeps its value?Below is the code I have used to create the new field, as creating it via the usual method was producing the same non-persisting result.Let me know if you need any other information.Kind regards,Andrew namespace PX.Objects.PM{ public class PMQuoteExt : PXCacheExtension<PX.Objects.PM.PMQuote> { #region UsrShippingDate [PXDBDate] [PXUIField(DisplayName="Ship Date")] public virtual DateTime? UsrShippingDate{ get; set; }

Hey Guys,Looking to create a workflow where an SO goes into a status of Awaiting review, and is not released until there is a file uploaded to various lines in the SO, and there is an approved status on a custom field.Is there anyway once a file is uploaded to automate an email to the customer, with the attachment of that file, with a green and red button on the email they can click approve or decline, or need review.if they click approve, it feeds a business event back to the SO screen and releases it, and if they decline it send an email to our team requesting revisions.Can anyone help me as to having hyperlinks in the email body that allow this to happen. Cheers.

Hi,Is there a way for me to set us fixed asset approval flow in the system? Currently there is no approval in that I can assign approval map in Fixed Asset Preferences. If I would like to set up approval map in General Ledger for Fixed Asset Depreciation, is there a way to set up in the system? Or it can only be done through customization? Thank you. Regards,Chern 

Hi,Has anyone encounter issue where you imported the Appointments with line detail successfully, but the service order that created automatically from the imported appointments has missing line detail? When I created the appointment manually, the service order that created automatically has no issue with line detail, only when using import scenario that this issue happen. Thank you. Regards,Chern

Hello community, I have been experiencing something with PXRedirectRequiredException and am wondering if this is intended behaviour.I have an action which creates a Non-Conformance record from a Sales Order.For the purpose of traceability, I added a custom field to display the NCR number.doc = gilMaint.ISORecords.Insert(doc);//Insert the recorddoc.SOOrderNbr = order.OrderNbr;doc.CustomerID = order.CustomerID;gilMaint.ISORecords.Update(doc);gilMaint.Actions.PressSave();//Save the new record to generate a DocNumber through autonumberingSOOrderISOExt orderExt = PXCache<SOOrder>.GetExtension<SOOrderISOExt>(order);//Find DAC extensionorderExt.UsrNCRNumber = doc.DocNumber;//Assign custom field valueorderEntry.Document.Update(order);orderEntry.Actions.PressSave();//Save the Sales Order recordPXRedirectHelper.TryRedirect(gilMaint, PXRedirectHelper.

Hi All, I am creating an import scenario for sales orders and after a lot of troubleshooting I was able to get to the end of it without any errors, however after importing my data I saw that Line Description is coming up as blank.I believe that is because of the highlighted info on the screenshot below where I set it to Null. However I don’t know how else to get the data that I need to be in the false statement.My if statement is supposed to bring the item description from my import file if the item id is “!” (exclamation mark) otherwise, just use the description that the system uses based on the inventory id. Essentially, in this situation, the “!” is a comment item, so it should change as per the import file, otherwise it’s an actual stock item, thus should use the description set in Acumatica.I tried looking into the internal fields but could not find the name of the field to bring it up, if it is that simple.Does anybody have an idea?

is it possible to import multiple units of measure conversions on the same import scenario?  

We are using an automation to create cases from our Work Orders outlook email. We’re running into a couple issues. First is duplicate cases. Ex. If someone replies all it adds a RE: to the front of the subject and creates a new case. Or if a new contact is added to the email it creates a new case. Now we have multiple cases for one conversation. Second - The attachments in the email (in activities) does not transfer over when creating SO from Case. Is there a way to have the attachments from the email transfer over?

Good day everyone,I’m looking for advice on handling daily releases for large purchase orders in Acumatica. One of my clients places substantial weekly purchase orders with their suppliers (500 lines or more), but due to space constraints in their warehouse, they send the total order qty while requesting daily deliveries. This way, the supplier is aware of the total quantity but ships it in smaller, daily increments.Basically we are looking for an operation like this example:  They manage a high volume of part numbers with variations in model, size, and color (matrix items), which adds complexity to the process. Has anyone encountered a similar scenario, and if so, what strategies have worked for you to streamline this kind of operation?We explored the option of blanket orders but having to g

For some time now the bills and adjustments screen is taking a long time to load. It takes around 8 - 10 seconds. We have 31k records on there. What can we do to improve this load time?

Is there a way to default the warehouse of the production order from the bill of material rather than the inventory item?

Is there a good way to clear out the messages in the email queue? We have a ton of garbage messages I would like to just delete. 

Dear experts,I want to make field Tax Registration ID required but a single space or multiple spaces should still be considered valid inputI implemented following event handler: RowPersisting, FieldVerifying, FieldUpdated but the value of this field is always null even though I input a space character “ “I don’t know if Acumatica might be automatically trimming whitespace inputs to null during data processing.Have you experience this kind of issue?

We have 4 budgets each year.  Original, F1, F2 and F3.  For example, in April we create a F1 budget  to enter actual results for Jan - Mar, and then adjust April - December for current forecasting. The problem is we have to open all the closed Financial Periods to get the revised budget amounts to import.    Is there a work-around?   

We are being tasked to create a Purchase Order for Landed Costs.  The customer has to call in subcontractor to use a crane.  They would like to able to track those costs to the items them are pulling off the truck and would like to make sure that the subcontractor is following the PO

Hello. I need a resulting statistic that shows me Inventory Turnover Ratio: (This measures how efficiently you sell through your inventory.)Has anybody done this yet on an acumatica dashboard, and if so, can you share the method here? Please and thank you

I am experiencing an issue with Report Designer. When I make changes in Report Designer, they appear in the preview tab but do not reflect in the URL.Please note that I have saved the changes to the server with a new version and activated the version in Acumatica. My user permissions allow access to Report Designer, yet the changes still do not appear. I specifically tried modifying the dunning letter printing format in Acumatica.

Hello! Does anyone know what is causing this error while trying to release an invoice? The system only has one currency set up which is USD; all chart of accounts has USD listed as currency; the ACTUAL ledger also has USD listed as currency. Am I missing anywhere to check for this?  

I have been trying to send a token via API Key Authorization method but I've been getting an unauthorized error: {StatusCode: 401, ReasonPhrase: 'Unauthorized', Version: 1.1, Content: System.Net.Http.NoWriteNoSeekStreamContent, Headers:{  Date: Wed, 23 Oct 2024 16:35:03 GMT  Transfer-Encoding: chunked  Server: Microsoft-IIS/10.0  Content-Type: application/json; charset=utf-8}}This is my code:using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.Common.Extensions;using PX.Objects;using PX.Objects.IN;using RiverlandDesarro

Good Morning, WITHOUT using the “Mark for PO” feature, is there any way to create a filter showing which Service Orders are “Ready to Schedule”? I have created a filter looking at the INSiteStatus table, ensuring that the QtyOnHand > 0 (for the specific warehouse). Which works great, except that it doesn’t look at all item rows. Meaning a Service Order may require three different Inventory Items, and my filter will show the Service Order as “Ready to Schedule” when just one item meets my criteria of QtyOnHand>0.  I would like the filter to only show the Service Call as “Ready to Schedule” when ALL Inventory Items have a QtyOnHand>0.  Any ideas would be appreciated. Thanks,Alec

Has anyone seen this before?On the Calendar Board filter, the check boxes visualy change when you try to check them. Clicking or double clicking the boxes does not activate the filters. The only way I can get the box to check is to tab to that box and spacebar. This happens on both Chrome and Edge. 23 R1 (we’re upgrading to 24 R1 in less than 2 weeks)   

Before I submit a support ticket, I wanted to see if the community has this answer already… I have two almost identical Service Contracts created, both Active and invoiced. In the Service Order, when I select the first contract that I created (0063) or don’t select a contract at all, the Target Equipment appears for selection in the details properly (see first screenshot). I have another Service Contract (0068) that I created, but when I select this in the Service Order, the Target Equipment disappears from selection. I have absolutely no idea why this is the case. Has anybody encountered this or know why this is happening? Can there not be 2 service contracts active at the same time? This seems to be a bug to me… 

Hello everyone. This is my first time posting here and I have been working with Acumatica for only a month with little training, so please bare with me. We have an existing PO for a project that is generating the following error when trying to enter a PO receipt: “One purchase order line or multiple purchase order lines cannot be added to the bill. See trace log for details”. See trace log screenshot attached.After trying to read the trace log, I noticed an issue pointed out to one specific inventory ID item (108-12) but I have no idea what is the issue with it and how to fix it. Another thing that was mentioned to me here is the column named “Billing based on”. Apparently it was always consistent before, either receipt or order, with this PO it’s mixed. What is this field, where do we set it up? Where does it pull this selection from?Thank you so much for your assistance with this issue.

Looking for a Acumatica reference that utilizes Field Service Mobile App for Scheduling Technicians, Accessing Service Orders, Applying Actual Labor, Invoicing, and collecting Payment all through the Acumatica Mobile App.  This prospect is eager to talk with a customer that is using these features on the Mobile App.