Hi,I have customized a new screen. To my screen I’m getting data from soorder DAC and soline DAC. This time, I need to get sales orders without duplicating from the view to my custom screen. When new row is inserted into my line level, I need to update TotalDiscount field of header level with soorder.curydisctot value which is taken from the soorder screen header level. To accomplish avoid duplicating when adding same sales order number , I tried the below code in the row inserted event but it didn’t work.protected void APProformaItemList_RowInserted(PXCache cache, PXRowInsertedEventArgs e) { var row = (APProformaItemList)e.Row; APProforma item = APProformas.Current; //add so discount into form var distinctSOLines = this.APProformaItems.Select().FirstTableItems.ToList().Select(x => x.Ponbr).Distinct(); foreach(var itemlist in distinctSOLines) { SOOrder order= SelectFrom<SOOrder>.Where<S
Hi,I have customized a new tab called ‘Discount’ to my custom data entry screen. There are two fields called Discount Amount and discount percentage in the grid as below.When I changed a value of discount percentage, I want to set value to discount amount based on discountable amount just after the field updated. For that I used below code but it get executed when adding a new row.protected void APProformaDiscount_DisctPercent_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (APProformaDiscount)e.Row; APProforma item = APProformas.Current; decimal? amount = (row.DiscountableAmt * row.DisctPercent) / 100; //row.DisctAmt = amount; cache.SetValue<APProformaDiscount.disctAmt>(row, amount); }Even I tried with cache.SetValueExt but it also didn’t work.Note: this is custom graphCan someone help me on this to find a solution please?Thank you.
Hi all,we have 3 tenants in our erp instance as below.Company (prod) uat2 test instanceout of these three, company tenant is being used as the production while other two tenants for testing purposes. Normally, We do our customizations into uat2 tenant, after testing and if it is ok, we publish the customizations into multiple tenants from uat2 to be applied them in the other tenants as well. We have done some customizations recently only for the uat2 tenant, but never published it to other tenants. However, without publishing from uat2 to all tenants, some of customizations have been applied in the company tenant as well. The issue is how it can be happened without giving ‘publish into multiple tenants’ from uat2? Can someone provide me a solution on this?Thank you.
Hi,I created a new setup form for my custom screen in the same customization project. After publishing, it’s working fine in my local instance. Now I want to add this into the UAT instance and publish my customization project, But after importing and publishing the project package, setup form is not visible in the project editor, only the custom screen which is Proforma Invoice can be seen.what is the reason for this and can someone help me to resolve this?Thank you.
Hi, this is a report modification. I need to get below bank details of DetailValue column to my ARInvoice. These information are taken from CashaccountPaymentMethodDetail DAC.For a particular CashAccountID, Detail Value is changed based on DetailID from 4545 to 4549 as above.ex: if DetailID=4545, Bank Name if DetailId=4546, Account number….And also it depends on the PaymentMethodID as well. If I made an expression to retrieve DetailValue Based on DetailID, It only retrieves the first value which is the Bank Name. I need to get the DetailValue per each DetailID from 4545 to 4549. Can someone help me with a solution to do this?Thank you.
Hi,There is a requirement which is to remove quote type ‘sales quote’ and show only ‘project quote’ in the create new quote pop-up screen when clicked on create quote button of opportunities. Screenshot is attached for the reference.show only the ‘project quote’Could this be done using customization project editor?Thank you.
Hi,I have to get Account Id ,Transaction Description from APTran Table and adjusted amount from ApAdjust Table for my Payment Voucher Report.I need to join ApPayment Table , APAdjust Table and ApTran Table.1st I joined ApPayment Table(column - RefNbr) and ApAdjust Table(column-AdjgRefNbr) below like that. Then I joined ApAdjust Table(column - AdjdRefNbr) and ApTran (column-RefNbr)Table below like that.But,After adding 2nd join report designer show below error. If we remove the second join error is gone. Can you give the solution for this issue.Thanks
Hi,I have to add another two more conditions to my custom view.*get sales orders when InventoryItem.itemType == charges or soline.openQty > 0The sql query is something like this to get an idea,Select * from soline lineinnerJoin soorder order on line.orderNbr/ordertype= order.orderNbr/ordertypeleftJoin solinesplit split on line.orderNbr/orderType/lineNbr = split.orderNbr/orderType/lineNbrleftJoin inventoryItem item on line.inventoryId= item.inventoryIdwhere other conditions....and order.status != "Cancelled" and (item.itemType == "Charges" or line.openQty > 0) I tried to apply above condition in the below bql query but it doesn’t look like as what I wanted. so could someone please to help me on this?public PXSelectJoin< SOLine, InnerJoin<SOOrder, On<SOLine.orderNbr, Equal<SOOrder.orderNbr>, And<SOLine.orderType, Equal<SOOrder.orderType>> >, LeftJoin<SOLineSplit, On<SOLine.orderNbr, Equal<SOLineSplit.orderN
Hi all,I need to get SOLine.POrderNbr filed to my custom smart panel . This customized smart panel consists fields of both SOOrder and SOLine DAC’s. But After adding the SOLine.POOrderNbr field, unlike other fields, it’s not visible in smart panel preview. When I checked SOline DAC, it shows that the POOrderNbr field is not existing in DataBase. How can I set this kind of fields into my custom screen? Appreciate if you can help on this as well. Thank you.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.