Solved

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. 

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: 

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 

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

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 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

In sales quotes screen I am updating the ExtPrice of the non stock items based on some other fields by calculations. But the Amount is not changing as it does when we normally change the ExtPrice of the item. Can anyone help me here with this.

Hello TeamWe have a requirement like get the next thursday date based on the current Date in GI. Tried in the SQL like below and it is working fine, Can you please provide Equivalent syntax in GI.DECLARE in SQL @GivenDate DATE = '2024-05-15';  SELECT DATEADD(DAY, (4 - DATEPART(WEEKDAY, @GivenDate) + 7) % 7, @GivenDate) AS NextThursday;Could someone please help on this.Thank you.  

When the report executes, I want to get the Current Available Credit value of the Customer to the Customer Statement MC report. Please check the below screenshot. But when inspecting the relevant DAC(CustomerBalanceSummary) shown in the above, it is Non-existent in the DB. Please check the below screenshot. So can i know how to get this detail to the Customer Statement MC report? Thank you.

We just resolved a long standing dispute with a vendor that resulted in a refund.  I want to record this through the AP module so that my vendor history is complete.  It seems like the GL entries should be:dr AP/ cr expensedr cash/cr apI must be missing something because I see a lot of posts here saying to enter a “vendor credit” but I don’t have that option in my AP.  This leaves me with either entering a “debit adj” or a “credit adj”.  A credit adj records dr exp/ cr AP, so that’s wrong.  This seems to leave me using a debit adj.  But, once I record that it seems I can only apply it to an invoice or a credit adj.  I can’t seem to then cash settle it.I can enter it directly in the banking module and the GL will be correct (dr cash / cr expense) but my vendor history will be incomplete.Thanks in advance for any help.

I have a client that is on 24R1. They setup their companies without branches. However, when they go to enter a A/P bill under the details section only one company is showing up to select from. See below. There is no company restriction setup. Can someone help me to try to figure this out?  Here is the list of companies:  Thanks, Frances 

Hello all,Can anyone let me know how we can implement the vendor approval workflow apart from customization?Thanks in advance.

We have created a generic inquiry which calculates the difference between the last user password change date and today() to get a number. This works.We now want to use that number to filter the records.e.g daysSincePWChange is greater than 0. The filter works if we use EQUAL or STARTS WITH and a given number, which means the result is being treated as a string. What can we do to ensure the calculated results are treated as numbers? Regards 

Is there a way to “close” multiple completed production tickets base on close date?  For example, I would like to close all completed production tickets that were completed between 01/01/2023 to 03/31/2023. 

I need assistance cleaning up my purchases clearing.  I have a balance hanging in the account due to incorrectly receipting a quantity of 6 when the order quantity was only 3.  What is the best way to correct this in the system? 

Does DRP assist in planning for overstock purchase returns? 

How do you make changes to time in the Work Crew Time Entry screen that is already in “Completed” status?

Under the GL Account tab, the COGS Account does not show up.  However, in the customization fields list, it is there, along with the all the fields that DO show up.  I can’t find anything different in the settings for that field than the others.  How do i get the COGS account field to display on the tab?  I’m new at this  and somewhat lost, even after watching videos, because what is shown in the videos does not seem to work for this.  Thanks for any help