Get inspired and gain all the knowledge you need
Hi,I have added a custom field to the ARTran table but I am getting an error when trying to access the extension of this table to update this custom field via code.I imagine I need to replace ‘ARTran’ with something else, but not sure what it would be.Here is the code I am currently using to access this extension:var row = (ARTran)e.Row;ARTran rowExt = row.GetExtension<ARTran>();And here is the error I get:\App_Code\Caches\ARInvoiceEntry.cs(55): error CS0311: The type 'PX.Objects.AR.ARTran' cannot be used as type parameter 'TExtension' in the generic type or method 'PXCacheEx.GetExtension<TExtension>(IBqlTable)'. There is no implicit reference conversion from 'PX.Objects.AR.ARTran' to 'PX.Data.PXCacheExtension'.What do you suggest I replace ARTran with to access the custom field via the extension? Kind regards,Andrew
I’m currently modifying this report. Regarding to this report there is a custom table called APPromaItemList in my instance which contains the sales order details along with the proforma invoice details. Bellow screenshot depicts the modifying invoice report.Modifying Invoice Report000010 is the corresponding sales order number for the above invoice report number 000004. Please check the below screenshot.By this sales order number 000010 I'm generating a sub report of this APProformaItemList table to obtain the ProForma Invoice number. But when generating this the same Proforma Invoice Number is printing 4 times as shown in the above screenshot. It is not what I expected. I need only to print it once. So to overcome this issue ,I grouped by using the Reference Number in the APProforma as shown in the below screenshot.Screenshot of group byBut it was not success. So, to overcome this issue please give me some guidance. Thank you.
I have a customer exposing dashboards to the mobile app. When the flag to expose is set on the dashboard it will appear on the mobile. But later, without any changes, the dashboard is not on the menu of the ios mobile app. Resetting the flag will sometimes resolveversion is 2022R118Is it required to expose dashboard via the Mobile Workspace? Or can they simply use the expose flag in the dashboard settings?Has anyone had issues with dashboard on the ios mobile app?This has been presented to support but I am looking for community feedback - thank you
How can we allow the negative quantity for the stock items when we add the line items on the sales order screen ? I tried using the SOLine_OrderQty_FieldVerifying event and was able to suppress the warning. But it still gives out an error while saving which I am not able to figure out.
In our receiving department we print out receiving labels for ingredients used in production. We normally receive Cases, Pallets, Bags….etc. and we generate an inventory bar coed label to apply to the container. On the Purchase Receipt I have 1 line item on the PO for 4.44 kg. The product is delivered in 5 separate containers 4 - 1 kg and 1 - .44 kg. I select the Line Detail in the Purchase Receipt and add my 5 containers with the lot code and quantity of each. The current bar code Inventory Label is printing from the PO Receipt Line quantity, (ex. 4.44 kg of product) How do I set this up to print a label for each line in the Line Details screen in Report Designer? See image.
Hi Team,Below is the screen shot of my question. I clicked “Load Documents” to show all the open invoices for my transaction period, customer and location. 1) it shows 13,646.73 Applied to Documents after unselecting all invoices. Should it be $0.00 if I unselected all invoices? Why does it show $13K invoices selected? 2) It does not show all open invoices. It only shows 19 invoices when there are 59 open invoices. The next arrow is greyed out. How can I show all open invoices for my criteria?
Hello, I am currently putting together a GI that will provide inventory on hand values on a specific date. With this, I had added the InTran table to acquire the InTran.TranDate values for the Parameters tab. With the addition of the InTran table, I am now getting a large number of duplicate values from the GI. I assume the reason is join related, but I am having trouble getting these duplicates removed. Any assistance would be appreciated! Results Joins
Hello all,I have been trying to import some test AR Invoice data into the system, but getting the follow error: The Import Scenario: Have checked out the Customer Class details and the Tax Zone and Category details too. Everything has been setup as per the requirements.Kindly let me know how to resolve the error.
All of my menu items for CRM, parables, and Finance just vanished and I don’t know how. I have the 2021 r2. I checked if they were disabled and who has access and they all seem to be perfectly fine.Can someone help me recover these?
Upgrade Error: Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe' or one of its dependencies
Hi Team,I’m facing issue after upgrading my customization code from 2020R2 to 2022R2. After, referring to the latest Dll, I compiled my Code. then Later on i cannot access to instance. Below is the error for your reference. Its urgent, could anyone please help me on this. Regards,Ramya Krishna
Hello, I am working on creating an Action to preview and send an email created from an email template. I have the email template created and now I want to add an action to a page to call the template and show a preview where the user can edit the email if necessary. However, I am not finding anything on this. Any help is appreciated.Thanks
Screenshot of my AP AgingAs you can see, the balance for this vendor is 0. The original check that was voided was written for $64,732.24. Everything in the Vendor details looks normal. However, I still have these 2 lines hanging out on my AP Aging. How do I fix this?
My company is transitioning to acumatica and we would like to add sales history to the business account from our stock item list without a sales order. A feature I would like to add to this is to do a import by scenerio to load this information. since I have a lot of information dating back to 2019-present.
Hello experts,I am trying to force End-User must enter value for fields: Weight (BaseItemWeight), Volume (BaseItemVolume) on screen Stock Item IN202500by using condition configuration as following:Set fields required: the default value is 0 because the field type is decimal, so I am able to save the record without entering value. Set condition value must greater than 0 But somehow I didn’t input value for these fields but still could save the recordDo you have any idea?
We are having a workflow issue we need help with. Our warehouses are in Alaska. Our inventory vendors are in the lower 48 states and send inventory invoices weeks before we receive the inventory in Alaska. For planning purposes, we want to get these invoices into our Acumatica system before the inventory arrives. How can we achieve this goal? What workflow can we adopt? Now we are reverting back to Excel spreadsheets and other pre-ERP solutions. Your help is greatly appreciated.
I am using a try - catch and trapping an error. When I get the error, I want to write it to the trace log. I am able to write to the log. There is a property in the System.Exception called “InnerMessages” that is an array of the actual errors that caused the exception. Here is a print screen of the InnerMessages that shows the details I want to write to the log: I write to the log with PXTrace.WriteError(ex);This is the only thing that shows in the Trace screen. It just shows the basic message and the place in my code where the error occurred.My thought is that I could cycle through the InnerMessages array and write it to the trace log so if my customer has an error, I can actually know what it is.Does anyone know how I can access the InnerMessages property? I cannot find any way to do it.
We can successfully import the updated health insurance rates using an import scenario; however, we have to manually set the previous deduction to inactivate it / set the ending date before importing or the import fails. We tried to create a separate import scenario to update existing deductions, but I am not seeing how to differentiate between creating a new deduction vs updating the existing. SQL is so straight forward in comparison. Update … will update the record. Insert will create a new record. Not seeing comparable in the import scenario. Any suggestions?
We are attempting to add several new boxes to the Boxes list. The dimensions on one of the boxes isLength - 6.6 in, Width - 5.6 in, Height - 6.2 inWe are shipping with Easy Post and they accept for fractional box sizes, but we are unable to enter the size as a decimal into the list.Is there a setting that we need to change to allow for fractional measurements to be entered.Thank you!
Greetings community,We would like your feedback with regards to improving our out of the box offerings for sales metrics? We want to know how you are using the current sales metrics and if you are building any additional custom dashboards, reports, general inquiries, pivot tables to support your sales business. What sales KPIs are you interested in seeing in CRM? (i.e. opportunity conversion rates, time spent in each opportunity stage, etc)If you are also interested in participating in a 1:1 customer feedback session with us, please specify that you are interested and i will reach out to you personally. Thank you!Jin KimCRM Product Owner
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.