Discussion Forums

import {    PXFieldState,    PXFieldOptions,    linkCommand,    controlConfig,} from "client-controls";import { POOrder } from "src/screens/PO/PO301000/PO301000";export interface POOrder_UsrSalesRepID extends POOrder { }export class POOrder_UsrSalesRepID{    UsrSalesRepID: PXFieldState<PXFieldOptions.CommitChanges>;} <template>    <field after="#fsColumnB-Order [name='OwnerID']" name="UsrSalesRepID"></field></template>This is my code. It doesnot show on the UIBut this other code  similar shows the field on the UI import {    PXFieldState,    PXFieldOptions,    linkCommand,    controlConfig,} from "client-controls";import { POOrder } from "src/screens/PO/PO301000/PO301000";export interface POOrder_Requisition extends POOrder { }export class POOrder_Requisition{    @controlConfig({allowEdit: true, })    UsrRelatedRequisitionCD : PXFieldState<PXFieldOptions.CommitChanges | PXFieldOptions.Disabled>;} <template>    <field after="#fsOrderInfo-Othe

Hello,We’re trying to process a Credit Return where some of the returned product goes back into inventory, while the rest is damaged and should not be restocked.What is the recommended process in Acumatica to return only part of the product to inventory and exclude the damaged portion? Is there a way to split the quantity between what’s restocked and what’s written off, all within in the same return?Thanks in advance for your help!

We have a modified version of the Dispatch report that we have been running for the past 2-3 months.   The hyperlinks have always worked,  however this morning when we tried to follow the hyperlink for the Production Order# and received the following error:  [A]PX.Objects.AM.AM_AMProdItem_ExistingColumn cannot be cast to [B]PX.Objects.AM.AM_AMProdItem_ExistingColumn. Type A originates from 'jps3kegx, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' in the context 'LoadNeither' in a byte array. Type B originates from 'rseahp0x, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' in the context 'LoadNeither' in a byte array. What is really odd is that we have never had any issues following the hyperlink until today.  The Report has not been revised for at least a month.       Does anyone have any ideas on what is causing this new issue?

We are having difficulty finding a paid invoice report by vendor per project and given a certain payment date range.  Does anyone have a solution for this problem.  

Hi!In Classic UI, fields are added dynamically using RowSelected event.However, when switching to Modern UI, these dynamically added fields are not showing.How can we dynamically add fields in Modern UI to ensure they are displayed as in classic?Please refer the below code and screenshots. protected void InventoryItem_RowSelected(PXCache sender, PXRowSelectedEventArgs e){ foreach (KeyValuePair<string, PXFieldSelecting> pair in fieldSelectingHandlers) { Base.FieldSelecting.RemoveHandler(typeof(KNCFSiteAssociation), pair.Key, pair.Value); KNSCCommerceConfigsSites.Cache.Fields.Remove(pair.Key); } fieldSelectingHandlers.Clear(); { string fieldName = "UsrKNWHProductType"; string displayName = "Product Type"; PXFieldSelecting handler = new PXFieldSelecting(delegate (PXCache dsender, PXFieldSelectingEventArgs de) { KNCFSiteAssociation currentrow = de.Row as KNCFSiteAssociation; object value = null;

Do I have to fill out the ACA Reporting form (PR207000) if I am using Aatrix to file 1095s?If using Aatrix, is there a way to get the system to prepopulate the Policy of Origin and the months of coverage, based on the employee’s payroll data in Acumatica? When I did a trial run, all Policy of Origin boxes and employee coverage month boxes were empty.

Hi GuysHoping someone can help with this query.In some instances, we have to manually create a credit note adjustment as the standard way of reversing will not work due to the UK having CIS (UK Tax for Construction).When manually creating the credit note, we cannot add the PO number and therefore, does not deduct the credit amount off the PO to leave a remaining balance.There seems to be ‘Add Subcontract’ but we use ‘Drop-ship’ as this option defaults to the site address where the other PO types do not.Is there any way to get the PO added when manually creating a credit adjustment? Thanks  

Is it possible to override a method in a framework graph abstract class?  I am attempting to override a method in the 24R2 Sales Order entry screen for the Add button on the dialog that opens when the Add Items button on the Details tab is selected -- Inventory Lookup. The method is PX.Objects.Extensions.AddItemLookup.AddItemLookupBaseExt<TGraph,TDocument,TItemInfo,TItemFilter>.AddSelectedItems(). I have tried extending it like this including the full class hierarchy:public class KRSOOrderEntry_Extension : PXGraphExtension<AddItemLookupBaseExt<SOOrderEntry, SOOrder, SOOrderSiteStatusSelected, SOSiteStatusFilter>, SiteStatusLookupExt<SOOrderEntry,SOOrder, SOLine, SOOrderSiteStatusSelected, SOSiteStatusFilter>, AlternateIDLookupExt<SOOrderEntry, SOOrder, SOLine, SOOrderSiteStatusSelected, SOSiteStatusFilter, SOOrderSiteStatusSelected.salesUnit>, SOOrderSiteStatusLookupExt, SOOrderEntry>and I receive a runtime error:“Graph extension KRSOAddItemLocation.KRSOOr

Hi community,I have an expression that displays the orderDate and percentage data as on following screenshot. However, I want to hide the time part of both the OrderDate and DueDate, only showing the date. How can I achieve this?= 'Zahlbar bis ' + Format(DateAdd(CDate([SOOrder.OrderDate]), 'd', IIf([Terms.DayDisc] Is Null, 0, [Terms.DayDisc])), 'dd.MM.yyyy') + ' (mit ' + Format(CDbl(IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent])), '0.00') + ' % Skonto = ' + Format(CDbl(IIf($TotWithTax Is Null, 0,     $TotWithTax * IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent]) / 100)), '#0.00') +' EUR zu zahlen: ' + Format(CDbl(IIf($TotWithTax Is Null, 0,     $TotWithTax - ($TotWithTax * IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent]) / 100))), '#0.00') + ' EUR) bis zum ' + Format(    DateAdd(        CDate([SOOrder.OrderDate]),        'd',        IIf(            [Terms.DayDue00] Is Null,            IIf([Terms.DayDue01] Is Null, 0, [Terms.DayDue01]),            [Terms.DayDue

I’m trying to build a GI that ties a Business Event to the Username who triggered the Action that drove the business event. In some cases we use a ‘kiosk’ style machine to allow people to clock in, and knowing which machine they clocked in on will help us determine who should review their time clock entries.  I have the BPEventHistory table pulled, but I can’t figure out how to show the username of the person who executed the action that triggered the BE.

Is it possible to convert sales opportunities to service contracts? It is possible to create service orders, but I don’t know how to do the same with service contracts. This would save our team 2-3 minutes per contract on 1,000’s of new contracts per year.

I’ve searched here but couldn’t see this specific question asked, but I have a customer who just went live and now they want to increase the length of the inventory ID from the current 15 to 25.  Can this be done safely with items already existing in the system?  Will those items be unaffected if this is done?  Thanks.

Anyone got a working import scenario to create a Project Cost projection that contains all the budget lines from the project that has Budget / Actuals? 

I am trying to connect APInvoice and EPAapproval tables in generic inquiry but both tables can’t be directly joined. I already read some topics here 3 years ago that they can directly connect two tables with note ID. Based on this photo.Is there some kind of modification or setups do I need to do. Thanks community

Hello everyone! I would like to gather some inputs regarding this scenario:Base currency = PhpClient creates a prepayment document directly from the purchase order being created (in $). Suppose that the prepayment created would have an exchange rate of 1$ = 56Php. The prepayment created that time is not yet processed with payment since they still have to buy dollar in their local bank.Now, after a week, they were able to buy a dollar but it is no longer 56php, it was already at 58Php. in the Checks and Payments screen, the cross rate column is changed to 58php but the payment cannot proceed since the system will not allow the prepayment valued at 56php to be paid at 58php. Is there any other way to process this kind of transactions? 

Is there an option in Acumatica to create a credit memo directly from the Sales Order screen using a Credit Memo order type or other suitable order type without generating any inventory transactions?The customer prefers not to use the Invoice screen, as they want the credit memo to reflect the exact customer pricing. Their goal is to issue a credit memo without affecting inventory.

Hello,I am need to definitions for the ItemCostHistory table.  Acumatica help does not have table definitions so I am reaching out to the community for some help.See screenshots belowThank you. 

We use a Sales Order Type with Automation Behavior = ‘Quote’ for quoting Parts and Service inquiries.  We would like to start using this functionality for quoting used product that we take in on trade.  These used products have many Lot/Serial Attributes (we use the GitHub customization) that define Year, Make, Model, VIN, Color, Specs, etc. that we would like to display on the Printed Quote for the customer.  However, it appears you cannot allocate a serial number to a Sales Order with Automation Behavior ‘Quote’ (in order to get those attributes to display on the Printed Quote, you would have to allocate the serial number to the document first).  You can only allocate to Sales Orders with Automation Behavior ‘Sales Order’ based on my testing.  Does anyone have a creative solution?

We have a business event which sends a notification to the Purchase Order Approver.We want the owner of the PO to be notified also. Which screen field should be used so that the PO owners email can be copied in the CC field on the email template? Regards

How can I configure PM301000 screen permissions so that a specific role can only:-Insert new projects (header level only),-Delete lines in the following tabs: Task, Revenue Budget, and Cost Budget,I’ve tried setting “Insert” access for the Projects screen and “Delete” for the related detail screens (Project Task, Project Revenue Budget, and Project Cost Budget), but users can still delete existing records.What would be the best way to achieve this behavior?Thank you!.PM301000 

I want to use rest API to upload item prices against a vendor, can I directly upload to the “Supplier Price” without going through the worksheet hold and release route?

For 24R2, Professional Services was a customization project.  For 25R1, I assume that is replaced by a feature (Enable/Disable Features)?

I’m using a join between ARInvoice & ARTran as well pulling data from FSAppointment. I need ARTran for credit memos detail lines because it wont always match the appointment detail lines. When activated ARInovice-ARTran join causes a duplicate of how ever many artran lines there are. Any workarounds? I cant group by ARTran ref number for some reason as it removes my billable Labour totals. For context RefNBR 008452 in the last picture should just be the first 3 lines but its doing 3x the return because there is 3 lines of ARTrans in the document. 

HI All,I have read the help topic from Acumatica system and read Processing Return for Credit Without Receipt (below link) mention “return without receipt and shipment’.https://aneximports.acumatica.com/(W(44))/Help?CompanyID=Anex+Select+Imports+Ltd.&ScreenId=ShowWiki&pageid=7251c08c-2dc9-4c25-9193-6bb81568e541I read through the whole document and the only suggestion is to turn off “Automatically Release IN Documents” in Sales Orders Preferences so it don’t issue automatically. This is a very tedious solution as I understand it as for all Sales Orders will now need to manually be issue, which will cause a lot more work then just do a credit memo then adjust the items that were return by the CM. Does anyone have a better way to solve this issue? I need to create Credit Memo that show the stock items while not return them back to the system. The old system I used would ask me if I want to return item back to stock which was a nice feature, and I am surprise Acumatica don’t have s

I am trying to get a report showing detailed BOMs including costing and I can’t seem to find how to do this? Can anyone help?