Discussion Forums

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. 

I am currently customizing the check remittance report and I’m trying to get it to total up the dollar value of the invoices before the cash discount is taken. I can get it to work unless the amount of invoices exceeds the number of lines on the remittance, in which case it only totals those currently contained in the report with the following expression =SUM([APPrintCheckDetailWithAdjdDoc.AdjdInvtMult]*[APPrintCheckDetailWithAdjdDoc.AdjdCuryOrigDocAmt]). How can I get it to sum all of them?  the APPayment DAC doesn’t appear to contain that amount anywhere so the report needs to add it up somehow.  Any help is much appreciated.

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  

We are having an issue with our 3-way match.Issue PO - ok Goods received - ok Invoice received, but cost/quantity does not match PO for some reasonI’ve read that we’re supposed to do a return transaction and then re-receive, but we often can’t do the return transaction, because doing so will throw us negative (and the system kicks an error that won’t let us proceed….we actually have negative inventory enabled).What is the best way to proceed in this case?  

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,Do you know how transactions are picked into the “Reconciled Documents Dated After < Reconciliation Date> “ . And how can we fixes the difference? Appreciate your help. Thank You,Dulanjana

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?  

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. Acumatica Community Webinar - Acumatica Customer Portal Payments - August 27, 2024 | 9am - 10am PTThis webinar will cover main features and benefits, installation, set-up steps and common payment flowsRegister HERE Debbie Baldwin - Acumatica Community Featured Member for August 2024Meet Debbie Baldwin our Acumatica Communi

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?

My customer have some short terms Projects . Projects Last for 2 ,3 days . They uses employee and Equipment time cards for Posting project costs. The Challenge is since the Acumatica Time sheet is Weekly , they are not able to bill (T&M) the Customer when the project is complete . They have to wait until the week is closed.How others are managing this type of projects  ? Any suggestions ? 

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?

Hello,Has anyone encountered the following - If I copy the Item Class name from different places it gives me different values and I’m wondering why, and which one is the appropriate one to use if I’m trying to use the Item Class name as a FILTER for my Ecommerce Export Filter.I have a class ID defined as such:: Now...if I copy the value from different places, I get the following ‘versions’: “PURCHASED -MISC”  (If I copy from the Stock Item Summary Screen)“PURCHASED_-MISC______ “ (if I copy from the Item Class)“PURCHASED MISC”  (If I copy from the Stock Item General Tab of the item).why does this happen?

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?

Wir haben mal im Arbeitskalender CS209000 der Ressource Unterbrechungszeiten hinterlegt, diese sollten Pausen darstellen.Ich habe diese Zeiten in ALLEN Kalendern und Ressourcen wieder gelöscht und auch neue Aufträge damit erstellt.Trotzdem habe ich in der Ressourcen Planung AM000001 seit dem bis 2029 alle Pausen eingeplant und angezeigt. Auch “Planung und Kapazitäten aktualisieren” AM512000 hat diesen umstand nicht mehr ändern können.

I am using version 24.106.0018. I created a date field named UsrXYZ. Below is my code:#region UsrXYZ[PXDBDate][PXUIField(DisplayName="Date")]public virtual DateTime? UsrXYZ { get; set; }public abstract class usrXYZ : PX.Data.BQL.BqlDateTime.Field<usrXYZ> { }#endregion However, in SSMS, it showed as below: SELECT DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALEFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'RQRequisition' AND COLUMN_NAME = 'UsrXYZ';I need a Date picker field. What am I doing wrong here?