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 need to create a new custom table in acumatica and load data taken from an excel file into the newly created table. Can someone provide me the work around to accomplish this?Thank you.
Hi guys,I’m getting this error when I try to select and add values from my smart window to the grid which is customized by me. APProformaItemList is the DAC for my grid and poNbr is the foreign reference for the DAC POOrder which is used to load data into the smart panel.following code snippet is the reference.SelectFrom<POOrder>. Where<APProformaItemList.ponbr.IsEqual<POOrder.orderNbr.FromCurrent>>.View.Select(this);how can I fix this error? As I’m new to acumatica , I don’t know what I have done wrong in my code. So If someone could help me in this and needs the full code let me know please.Thank you in advance.
Hi,I wanted to localize acumatica into another language. I followed steps in the below blog post and attempted to accomplish it in my local instance.https://asiablog.acumatica.com/2018/01/how-to-translate-acumatica.htmlHowever, in translation dictionaries, the operation is already completed but the string file is not downloaded to translate.I tried again by clicking collect strings but the string file wasn’t downloaded. I tested this in my local instance. Was that the issue or will there be another reason for that? Can someone help me with this?Thank you.
Hi all,I have a field updated event for soorder invoices screen Artran qty field which is used to get line weight by multiplying item weight and qty as below.public PXSelect<InventoryItem> dataview; protected void ARTran_Qty_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (ARTran)e.Row; ARTranExt detail = PXCache<ARTran>.GetExtension<ARTranExt>(row); foreach (PXResult<InventoryItem> result in dataview.Select()){ InventoryItem item = result; if(item.InventoryID == row.InventoryID) { detail.UsrItemWeight = item.BaseItemWeight; decimal? LineWeight = row.Qty * detail.UsrItemWeight; detail.UsrLineWeight = LineWeight; } } }usrLineweight is the custom field for Line Weight in details level of invoices screen. The line weight should be calculated just after qty field is updated. But it’s only working in the time when adding a new row. How can I solve t
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.
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, 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,I’m a freshman to acumatica development. I followed some of recordings of Acumatica T series and started customizing a new screen for Pro-forma Invoices. Below screen shot shows what I have done so far. Now I need to add a button called Add Orders in the tab and when click on the button , pop-up a new window with all the available sales orders according to the customer ID (name) to be selected and add to the grid. Below screen shot taken from a different screen for the reference. In this scenario, following points are identified cases.how to add a button and when clicked on the button pop-up a new screen . Do I need to add this button as an action or any other way to do this? How to load data into the newly opened window.? Do I need to customize this screen as well? how to filter data in this newly opened window/screen according to the customer ID?It’s really appreciated if someone can suggest me a solution to achieve these steps.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.