I did some changes to the standard commercial invoice and made the below report.In this case i wanted to get the customer part number corresponding to the inventory Id in the sales order. Please check the below screenshot.So I joined the InventoryItem with the INitemXref by the Inventory ID. And also i joined the INitemXref with the BAccount by the BAccountId as follows.But when doing this below “XML not well-formed” error pops out.So please give me a support to overcome this issue. Thank you.
I have created a Custom Commercial Invoice and there is a Net Weight(Kg) filed in it as follows. Commercial InvoiceCorresponding to the above invoice there a two orders in the the detail section of the Sales Orders’ Invoices tab as follows.Sales Order Invoice TabThere is only one order weight for both these items in the FREIGHT section as follows. Freight tabIf i use the =Sum[SOFreightDetail.Weight] for get the summation as the Net Weight(Kg) the weight is getting double. Please check the below screenshot.Commercial InvoiceCan I know If there is another different Order in the DETAILS section of the Sales Order Invoice Tab and if there is different order weight for that in the FREIGHT detail section, how to get the total net weight for the above invoice without repeating the same weight?
I’m currently modifying this report. Regarding to this report there is a custom table called APPromaItemList in my instance which contains the sales order details along with the proforma invoice details. Bellow screenshot depicts the modifying invoice report.Modifying Invoice Report000010 is the corresponding sales order number for the above invoice report number 000004. Please check the below screenshot.By this sales order number 000010 I'm generating a sub report of this APProformaItemList table to obtain the ProForma Invoice number. But when generating this the same Proforma Invoice Number is printing 4 times as shown in the above screenshot. It is not what I expected. I need only to print it once. So to overcome this issue ,I grouped by using the Reference Number in the APProforma as shown in the below screenshot.Screenshot of group byBut it was not success. So, to overcome this issue please give me some guidance. Thank you.
I created a new report and added it to work space. But I can not the pass the parameter to the report. Please check the below screenshot. Can you please give me a solution to fix this issue? Thank you. Below screenshots depicts some preparation details regarding to my new custom report.My custom reportPassed parameterSet Filter
I want to export the Sales orders data as xml. I went through the I100 Integration Scenarios 2022 R2 training guide also. But i could not find a way to export as xml. Can you please give me a guide to accomplish this task? Thank you.
Hi,I developed a custom screen as below.As you can see in the above screen shot, I have already saved some records to the database for the above mentioned reference number. After adding and saving record to the database as above, i need to keep the all fillable fields as non editable.I tried to accomplish this task by putting the following event handler.protected void APProforma_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (APProforma)e.Row; APProforma item = SelectFrom<APProforma>.Where<APProforma.refNbr.IsEqual<APProforma.refNbr>>.View.Select(this, row.RefNbr); if (item.RefNbr != null) { //row.Currency = item.RefNbr; APProformas.AllowInsert = false; APProformas.AllowSelect = false; APProformas.AllowDelete = false; APProformas.AllowUpdate = false; APProformaItems.AllowInsert = fals
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.