Discussion Forums

Hi everyone, we are looking to present data on costs of goods sold to show the average costs of components included in the average costs of finished goods. Our raw materials are average cost, which are then used to produce WIP items (average costs) using production orders, which are then converted to FG (average costs) upon the addition of final components. It seems like this might be possible by drilling down into production orders that led to the final cost of the goods sold. I know average costs complicates this and it might be easier under the specific cost method, but does anyone have any experience with this particular scenario or any ideas to share? Thanks!

Looking to add to the Details column an Attribute that is assigned to the PO Line Inventory ID.  I have a Attribute created for Inventory ID called Revision.  I am trying to get this available to the PO Order Line.  I don’t want a new Custom Filed, because I want to pull in the value of the Attribute at the Inventory ID level. 

Hi,I’m new to Acumatica and I was wondering how I can import line items from an excel file into “Cash Purchases” in Payables, please? Thank you!

Hello,I want to set up a fixed price for a customer so that the price is unchanged according to quantity.In fact, the customer's exact requirement is that, depending on the quantity band, the price is either a fixed price or per unit:- Band 1: <600 ==> fixed price- Band 2: from 601 to 4000 ==> quantity rate- Band 3: over 400 ==> quantitative rateWith the sales price screen, you can manage quantity-based prices for bands 2 and 3 by defining the price per unit, but how can you manage band 1 so that the price is always the same regardless of the quantity entered on the order line?How can we manage this type of case with Flex, please?Thank you in advance

Hi All,On Employee Time Card EP305000 website version, when open the Select Table, the Week column as default filter the nearest week and continue to count up to websiteOn the mobile version, this field sort ascending as defaultmobile I try to change the way this field is sorted but cant find any defination for this.Are there any idea?

I have a client who pointed out to me that on their customer portal Closed Cases are not displaying the “Last Activity Date” on the “Closed Cases” (SP204010).Is this a known bug with 22.126 version that is fixed in new versions?  Or is this some kind of configuration that is missing?  The screenshot below is of my local test installation of Acumatica with SweetLife and does the exact same behavior that the clients site portal is doing. 

Hi, I am able to successfully create a Sales Order and all of the customer data, line item data etc. is correct except for RequestedOn date. It seems to be auto-assigning to the day before delivery based on the delivery Route assigned to the customer. Even if I put the RequestedOn date weeks in the future, it still assigns to the day before the next delivery route is scheduled. This is what my JSON Request Body looks like:  { "OrderNbr": { "value": "<NEW>" }, "OrderType": { "value": "SO" }, "CustomerID": { "value": "XXXXX" }, "note": "", "CustomerOrder": { "value": "XXXXXX" }, "Details": [ { "InventoryID": { "value": "XXXX" }, "OrderQty": { "value": 1 } }, { "Inventory

Hi, I have created a new business event in the system, which is set to trigger when the PO receipt line date matches today's date. The event is correctly triggering based on this condition, but it is returning the following error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: indexCould someone please help me with this?  I’ve attached business event for your reference. 

Hello everyone,I want to change the default order of Selector Week to descending by Start date.How to do it? Here is the definition of field Week:public abstract class weekId : PX.Data.BQL.BqlInt.Field<weekId> { } protected Int32? _WeekID; [PXDBInt] [PXUIField(DisplayName = "Week")] [PXWeekSelector2(DescriptionField = typeof(EPWeekRaw.shortDescription))] public virtual Int32? WeekID { get { return this._WeekID; } set { this._WeekID = value; } } 

I have a generic inquiry that I am using in a dashboard data table widget. The GI in question has an email address in the result grid and I would like to turn the email address string into a mailto link so that when someone click on the email address on the dashboard it will automatically open the email client with the address already to the TO field. Is there a way to embedd html code into a GI to accomplish that? Any help on this would be greatly appreciated.

I need to change a segment ID for my project tasks segemented key from alphanumeric to numeric but there is a task that has already been used in a posted transaction that is preventing the change. What are my options? CS Error: Edit Mask cannot be changed. There are Project Task identifier TINGÉNIERIE       to which the new edit mask cannot be applied

Hi,Does anyone know if there is the possibility to count the # of lines in this screen in the lower toolbar like on GI’s? We are on 22R2 but upgrading to 24R1 shortly.  

I would like to have a generic enquiry that lists out any AP invoices that are still open and have multiple payments applied.  Can someone advise how to get started.  I don’t know which tables I would need and how to join them.ThanksHere is an example of the data I am looking for: 

Hello,Is there a way to change the price class on the sales order?   Thanks!

Good day everyone, Need some help or suggestions. We are on 2024R1 and the BOM ID Number is limited to 15 characters. THe Item inventroy ID came go up to 30 characters. We typiclly use the top level inventory id number to be the same as the BOM. Unfortuntily, we are running into problems.  We have over 60,000 BOM now and we growing. I am hoping for a suggestion before we start looking for an outside solution . Thank you Kim 

We just upgraded to 2023R2, and the connection to Power BI drops after about 2 hours.   We reconnect, everything works great, but then later it reverts back to the “This content isn’t available” tile and we get the attached error.   

Would it be possible to create a project numbering sequence that included a character based on the project type?

Hello, I'd like some advice on how to appropriately configure pricing and discounts to solve a business need. Here's a concrete example:- For simplicity, let's say we have three different 12oz Cups: white, black, blue. - If a Customer orders 120 12oz Cups, in various colors, they get 10% off those products. - I can't set up this scenario using Sales Prices, so I'm using a Group Discount instead. I like everything about the functionality of Group or Document level discounts...except for one thing: On the ARTran table, the Sales Price—and resulting product margin—aren't correct, because it's applying the discount as a separate line item.  I'm hoping there is just a setting somewhere to "apply discount to components evenly". How have others handled this limitation, or is there anything I'm not thinking of? 

Hello everyone, I am attempting to pull the unit cost for Sales Quotes from InventoryItemCurySettings to automate our gross profit calculations.Has anyone had any luck doing so? Thanks,Aleks

I added import functionality to the Physical Inventory Types screen IN208900.The override for the View for the grid is as follows:  public class INPIClassMaint_Extension : PXGraphExtension<PX.Objects.IN.INPIClassMaint>  {  [PXImport(typeof(INPIClassLocation))]  public      PXSelectJoin<INPIClassLocation,      LeftJoin<INLocation, On<INPIClassLocation.FK.Location>>,      Where<INPIClassLocation.pIClassID, Equal<Current<INPIClass.pIClassID>>>>      Locations;  }When you import the Excel file, the Pick Priority field is not available to map.  I assume that is because the field is not in the INPIClassLocation table.Does anyone know of a trick to get that field added to the view?  

Hello,I've been trying to figure out how to count pages per Sales Order when printing in Batch, but I haven't had any luck so far.Printing individually works fine. However, when printing in Batch (via Print/Email Orders), the 'Page Of' count aggregates all the Sales Orders instead of counting them individually.For example, Order #5 has 11 pages, and Order #8 has 1 page. So when printing in Batch, Order #5 should show 'Page 1 of 11,' and Order #8 should show 'Page 1 of 1.I attempted to update the value of ResetPageNumber to 'True'. It functions correctly if the order has only one page. However, if the order spans multiple pages, it will print '1 of 1' for all the pages. 

Purchase accrual summary has an outstanding item for vendor. There is an order receipt quantity of 48 – this is the correct quantity, but the billed quantity is 24 units.  The billed quantity should be 48 units.  The cost is the same and correct on the receipt and billed lines so there is not a balance in the purchase accrual, but the line does remain on the report.How do we correct the billed quantity to get this off the report?

Hello Everyone, I have been battling on what the best way is to get unit costs to auto-populate onto the Sales Quotes (CR304500) screen.Initially I had used a FieldUpdated handler for inventory ID but as we import plenty of worksheets from excel, this breaks and pushes the values a line down.Yesterday, I was doing the T230 course and I was inspired so I recreated it but for recalculating unit costs on Sales Quotes.Here is the code for the button, hope it helps someone!public class QuoteMaintCostExt : PXGraphExtension<PX.Objects.CR.QuoteMaint>{ public static bool IsActive() => true;//Make sure you have the views public PXOrderedSelect<CRQuote, CROpportunityProducts, Where<CROpportunityProducts.quoteID, Equal<Current<CRQuote.quoteID>>>, OrderBy<Asc<CROpportunityProducts.sortOrder>>> Products;

Hello all,I have been trying to build out a report and i have the User ID set as parameter . So if any user ID is selected under this parameter and the report is run, the full name of the selected User ID isn’t getting displayed. Kindly let me know what is it that i am doing incorrect.    Thanks in advance.

Team, I am trying to delete the Kit Specification and unable to do so getting the following error. Error: The value in the Primary Component field must match one of the Component IDs. Thanks,H