Solved

Hello all,I have been trying to add a time field in acumatica. I know how to add a single field on detail level: We have the option to add a date field but how shall I add only a time field?Thanks in advance.

Does anyone have a recommendation for how to make a list of what Generic Inquires use a specific table or specific field?  This would be useful when Acumatica makes a change to a table (INSiteStatus) or field (AMReplenishmentSource) so we can quickly edit our GIs that would be affected.  I know I can have a GI list all of our GIs, but not sure how to look deeper into them to get this information.  Possible?

Has anyone also noticed that the global / universal search in Acumatica is not returning 100% of the possible results since we did the update for R1 2033.   For example not all customers populate, not all invoices etc…  Any feedback on this would be greatly appreciated.

Dear ALL,Go to Access History screen > Select User as admin > Operation: Access Screen => We see a lot of screens being used even though this admin User has no Log-in during this period.  Please help us explain. Best Regards,NNT

Hi, would love some tips/ticks on capturing a photo of a receipt on Iphone and automatically creating expense entry (if possible at all). Current process is only to add the image and then you have to manually add the expense entry. 

Hi,We have a client who is using the  “When Used” method of tracking serial numbers.  They have issued a part to a production order and it has failed in the assembly, we need to “un issue” the defective part and S/N and issue a new one.  We have tried to create a negative material transaction for the part and get this error “The material cannot be returned because the item with the SD-5874-4623-00007 lot or serial number has not been issued for the RO WO-000286 production order.”  We are copying the S/N from the material transaction for the production order in question.  Is there a way to un-issue When Used serial numbers from a production order? Appreciate any insight or ideas!

View & DAC public PXFilter<TestViewDAC> TestView; [Serializable] public class TestViewDAC : PXBqlTable, IBqlTable {     #region      [PXDBDecimal(2)]     [PXDefault(TypeCode.Decimal, "0.00", PersistingCheck = PXPersistingCheck.Nothing)]     [PXUIField(DisplayName = "Test Total", Required = false)]     public decimal? UsrTestTotal { get; set; }     public abstract class usrTestTotal : PX.Data.BQL.BqlDecimal.Field<usrTestTotal> { }     #endregion     #region       [PXDBDecimal(2)]     [PXDefault(TypeCode.Decimal, "0.00", PersistingCheck = PXPersistingCheck.Nothing)]     [PXUIField(DisplayName = "Test Amount", Required = false)]     public decimal? UsrTestAmount { get; set; }     public abstract class usrTestAmount : PX.Data.BQL.BqlDecimal.Field<usrTestAmount> { }     #endregion } TS Codes:  Html Codes:  The compiled UI is not displayed, but the UI settings are gray. 

Hello,I am having an issue trying to find where in the access rights I can allow a role to create activities & tasks on a Lead record. The users can create and view tasks from the task screen as well as relate the task to a lead. But on the lead page, the activity buttons are grayed out. I have a sandbox environment where the same users with the same roles are able to create activities on lead records. I cannot find the difference between the two environments. Thanks for the help,Tyler  

Hi All,So I’ve got a costing question for a stock item and I hope I can explain it well enough for someone hopefully to help me out!I currently use landed costs for many additional costs for PO’s (shipping/delivery/surcharges, etc.) and it works great because the parts get received into inventory and then the cost go directly onto them.I’m having an issue with stock items I have created for ‘outside processing’.  Once they are received in on the PO, they pretty much get moved thru the production order and the parts stay in inventory for about 5 minutes so if we get a landed cost later, the average cost of that stock item never gets updated because the quantity of stock is zero.I’ve tried doing WIP adjustments to the production order and do not see the costs carrying over.  Does anyone have any other ideas or suggestions on how to get these additional costs into the stock item?

Hi All,we created a GI and published to UI with granted for all roles, next we created business event with GI and added a email subscriber and schedule also. Now in system monitor we are getting below errorwe are in 24R1, version 24.107.0004. Can someone please help us what the issue is about.ContextScreenId = GIXXXXXXContextUserIdentity = adminCurrentCompany = companyEventID = Scheduler_SchedulerThrewExceptionEventIdSourceContext = SchedulerException =PX.Data.PXException: Error: A site map node with the screen ID GIXXXXXX cannot be found.   at PX.Data.PXGenericInqGrph.CreateInstance(String screenID, String prefix)   at PX.SM.AUScheduleMaint.CreateGraph(String graphName, Boolean secure)   at PX.Data.Process.ScheduleProcessor.ProcessSchedule(AUScheduleMaint graph, AUSchedule schedule, Object key)   at PX.Data.Process.ScheduleProcessor.TryProcessSchedule(AUSchedule schedule, AUScheduleMaint graph, Object key, DateTime nextrun)

Hello everyone,How to fix the above error? This is an order placed in BigCommerce from a B2B customer. Also, to add context: the user used to placed the order is a super admin, that “masquerades” the Customer, and place order in behalf. Not sure if that is related, but just mention if can help.

We are hosted on Acumatica’s platform, but we have two servers. I’m assuming (for lack of information) that this is a load balancing situation. We have two urls ourname and ourname-process. We are told it shares the same database. We were told we only need to install on the main server, so we install on that server. However, randomly, when we install, it causes issue. After install:Main server functions as normal. Process server:All pages are white when loaded. It loads the menus, etc. API connections to the server break with a 500 error. We can still login to the process server.I’m attaching a screenshot and the package that broke the process server. Again, it works fine on our dev server (same version), and it works fine on our live main - just breaks the production. 

 Anyone managed to import compliance > common attributes (CL301000) to vendors at all? We can import all the other standard compliance values per supplier but we don’t seem to have the ability to select any compliance common attributes from compliance preferences or have that compliance common attribute available on the import scenario, any info would be appreciated. Thanks  

I did a very large import of contacts for a sales campaign going on and it seems that roughly 6,000 of the 8,500 contacts imported did not populate the state field despite them all following the same state name formating for the import. however if I select the contact individually in the Import and re import the contact it populates the state field without producing a duplicate contact (usually). is there something wrong with my mapping that is causing this?  

Hi,I’m working on my first customization adding a new table / DAC with a foreign key linking to Customers.The need is to restrict the selection of the customer to only customers belonging to a specific class.This is what I currently have in my DAC definition for this field:  #region CustomerID [PXRestrictor(typeof(Where<Customer.customerClassID, Equal<Customer.customerClassID.Contains<"SPECIAL">>>), "Not a Special Customer")] [Customer] [PXDefault] public virtual int? CustomerID{ get; set; } public abstract class customerID : PX.Data.BQL.BqlInt.Field<customerID> { } #endregionI’m getting a “CS1031: Type expected” error on “SPECIAL”. I can’t find an example of creating a PXRestrictor condition that isn’t based around a boolean, null check or comparison to a value from a matching field on this DAC. Is there a way I can create this sort of hard-coded filter?Appreciate any guidance here.

My production ticket seems too be splitting locations of the same items and I’m trying to find ways to correct that. I also would like help to find a way to sort locations as well so I can have people pick from the same general area of where the items are by and not have them going all over the place when the sheet doesn’t have it in order. 

How can I add the BOM to a Production Order that has already been released?

I’m trying to setup integrating FedEx, and I’ve been trying to setup the RestCarrier setting. All of the guides I’ve seen are just for PX.FedExCarrier.FedExCarrier, and don’t work for PX.FedExRestCarrier.FedExRestCarrier.

I am trying to make a copy of the Sales Orders GI that is in Acumatica but I want the GI to display the Inventory ID of the items in the Sales order, I tried adding the SOLine table to the GI and relating it to the SOOrder table but the Inventory ID result tab just shows up as blank for all sales orders despite having multiple Inventory items and Inventory ID codes in each SO. has anyone else ever done this before and could show me what I need to do to get those ID codes to display in the GI?

When I create a Production Order for a specific assembly, the system grabs a BOM that is NOT set as the default. What am I doing wrong? Why doesn’t the RO use the default BOM? I’m assuming there is a setting somewhere I’m missing...Thanks!! 

Hi team, is there by default, or has anyone had success customizing a ‘first sale date’ on the stock item profile? This would function as the date of the first sales order released which contained that SKU.  The idea being we could use this to report on product lifecycles. For instance, products are tagged as ‘Launch’ if their first sale date is <12months ago. We would then run a scheduled automation monthly to switch SKUs into the next sales phase at 13 months.Thanks!

When I run Allocations by Project,  I am getting an error message of  “ The given key was not present in the dictionary.” but only on one project.  All of my other allocations ran without an issue.  The project was setup from a template like all the projects are.  It only has one cost on it for the month. I checked the one cost that hit and there was nothing unusual about it.  Everything except the amounts and the customer appear to be the same on this project versus the other projects that ran without issue.  Any ideas of where to look for the issue?

We will be creating Blanket Sales Orders, after being on Acumatica for a while.I noticed that Blanket Sales Orders show up alongside the child sales orders on the SOOrder and SOLine DACs, which causes lines to duplicate in GI’s using these tables (For each child sales order line, a blanket order shows).My current plan is to filter each GI (we have hundreds affected) where the order type’s SOOrderType.Behavior = “Blanket order” as a future proof if the order type id or additional blanket order types are introduced. (DAC)Is there another route that doesn’t require a change to every GI?Anything else I should be thinking through?

Hi everybody.I’m trying to modify a GI but i cannot get it to work the way i want.what I want is for this column to be displayed as the "mold" column (with dashes) 

.