Get inspired and gain all the knowledge you need
Recently active
How can I get the Phantom Inventory ID to show up on the Production Ticket Details?I can pull in the Phantom BOM ID but how do I link the Phantom BOM ID to pull in the Inventory ID/Item Description? What joins do I need to make this happen? Attached is screen shot of what my production ticket looks like and the tables from the report.
Hi, We are currently piloting the Acumatica production order system. We are planning on using Advanced Planning to schedule production orders. When we run scheduling from rough cut planning screen , most of the production orders schedule just fine. We however, have a few that will not schedule. I suspect that this is due to some material constraints. These are lower level production orders generated from the ‘generate sub assemply’ feature on production orders.For the production order type, we are not checking for material availabilityFor each of the detail items on the production order on the material tab - we have set to do not check material availability.Our issue, is that the system gives us no clue or message as to why the production order will not schedule. There are no error messages or warnings, so it is very difficult to figure out why it will not schedule.Does anyone have any tips on how I might figure out why a production order will not schedule given the limitations on feed
We have Customer View Standard Acumatica Dashboard in Acumatica, One of my customers reported the dashboard is not visible and throwing an error ' The given key was not present in the dictionary”Troubleshootsteps performed. Imported standard customer view Dashboard in Local instance the error remains the same. Uploaded each GI in the local instance, the error remains the same. Customer Management Featured present in the system. Access rights verified. Unpublished all packages and verified still getting the same error The given key was not in the dictionary.
Hi, In the Sales Orders screen, after clicking ‘Add Items’, as shown in the second image below, a client is wanting the Warehouse field to be set to ‘MAIN’ in the dialog box shown in the third image below. The code I currently have set up doesn’t seem to work. I am using the FieldDefaulting event but would I need to combine this event with another one, like RowSelected, to pass the value through? Let me know if I can provide any other information. Kind regards,Andrew protected void SOSiteStatusFilter_SiteID_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { if (e.Row == null) return; SOSiteStatusFilter row = (SOSiteStatusFilter)e.Row; INSite site = PXSelectReadonly<INSite, Where<INSite.siteID, Equal<Required<INSite.siteID>>>>.Select(Base, "MAIN"); row.SiteID = site?.SiteID; }
I am using the financial report writer to build a project P&L for my client. I am having trouble getting the project name to appear in the title since there does not seem to be a parameter available.In my column set, I have added:=@StartProject + ' - ' + THIS IS WHERE I WANT THE PROJECT DESCRIPTIONThe project code is an auto-numbered ID and without the name makes it difficult to identify the reports.Thank you in advance.
I am creating a quote form for a customer who has quotes / sales order and invoices with many line items. They have requested that alternate rows on the detail section are highlighted in order for the customer to be able to read these better.
We have a service contract schedule where the Generate From Service Contracts button is disable even though there is no appointment or service order linked to the schedule. There are four other schedules that have been created after this one and the second one does have an appointment created. The last three don’t have an appointment and the button is enabled on each of them. Since there is a schedule with an appointment created after the schedule in question could that cause the button to be disabled?
Good day Team, I am trying to add the AP Bills Branch ID to the AP642000 Additional Remittance Form, I used the APAdjust table with the APPayment, doing Doctype equal to AdjgDocType and RefNbr equal ADJgRefNbr, also used the adjd ref and doctypes to test but did not worked either. When I used the APAdjust.AdjgBranchID, as I tested on a GI, it worked, but when doing in the report designer does not work. I have used other tables as well, but no luck. I hope, there is a way.
We are receiving the following error when trying to change warehouse location on an order that contains a non-stock kit with stock items. We have warehouse locations turned off. Is anyone else having this issue? IN Error: Failed to process Component '70001 ' when processing kit '10001 '. An error occurred during processing of the field Location value MAIN Error: Location 'MAIN ' cannot be found in the system.
I got this out Quickbook’s.I just want to know what are people thoughts on tackling this. I just have to do a detailed upload from Jan - June of 2023.
When working with Generic Inquiries in Acumatica, it's common to use multiple columns to validate different pieces of information based on specific business requirements. However, this can sometimes lead to a cluttered interface that is hard to understand and interpret. In this post, I'll show you a technique to consolidate multiple validation columns into a single 'Message' column, which will make it easier to communicate concise information about various source columns through one unified message all without developer customization. This post will include Screenshots, Examples, and Generic Inquiries that use the SalesDemo dataset. Our ExampleConsider a Generic Inquiry where you create validation columns using formulas for one or more data elements. Let's use an example request as our starting point:Add a column to validate each vendor with 30D terms is within the US. Add an indicator to columns where a subcontractor is outside the US. Solving: Conventional vs. Streamlined Approach C
Are there any character limits to warehouse and warehouse location names? Ie. length and special characters like dashes?ex. Warehouse-Bulk-Fuel
It is my understanding in Acumatica Labor Overhead is not calculated unless you apply a qty to an operation. It is also my understanding that this qty triggers a “move” (but not into inventory) operation which kicks off the Labor over head calculation. Which is fine in many cases however in some case you have long run assembly time where you might be on an operation for a long period of time. The pitfall here is you will not be able to track the labor dollars effectively until you post a qty complete to an operation (even if that operation may not be complete in reality). Couldn’t this behavior just be a preference to allow the labor transaction to trigger the overhead? Even if the qty complete it posted as 0? I hope that all makes sense.
I have created a Date Parameter for a custom report. I am trying to filter the report by this parameter, the result is coming back with no data (a blank report). I am selecting a date that i am 100% sure is in the dataset because i have a raw dump of the data. What am I missing, why is my filter not working? Does this have something to do with the values being seen as text instead of date?
Hello Acumatica Community,i am trying to add the attributes of a stock item to the PO Line in the Details TabThese Attributes:For my problem i found this post: I thought i could transfer that to the PO and add the inventory attributes to the Details Tab. After 2 very long days and suffering i no longer know what to do. I would like you to take a look into the code of my customization. I added a new custom field in POLine which i believe later stores the value of the specific attribute. But i am not sure if i correctly defined which attribute to show.Here is my Code for the DAC Extension of POLine:using PX.Common;using PX.Data.BQL;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AP;using PX.Objects.CM.Extensions;using PX.Objects.Common.Bql;using PX.Objects.Common.Discount.Attributes;using PX.Objects.Common.Discount;using PX.Objects.Common;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.IN.Matrix.Interfaces;using PX.Objects.IN;usin
