Each item weight is calculated using the wire sizes & length.
Our firm produces Steel Welded Mesh for Construction Industry and we make Mesh of different sizes and weights. We are using Navision since 5 years but till now no solution has been reached regarding automatic selling price calculation. Please suggest/guide me, where i am doing wrong or what is missing. it will be very very appreciable to help me. Please help me regarding this query/issue, i am facing this issue from long time.
#AUTOMATICALLY INCREMENT NUMBER BULLZIP PDF PDF#
ie end user is getting pdf in mail), when client is trying from his local machine then only the above mentioned error is coming. SO, once more i want to ensure that i am not getting any error from server side(its working fine. SMTPMAil.CreateMessage(SMTPSetup."Send Email Name",SMTPSetup."Email Sender Email",Customer."E-Mail",'Posted Sale Invoice',' ',TRUE) SendMail(lSalesInvHdr."Sell-to Customer No.",FileName1) RunOnceFile:=BullZip.GetSettingsFileName(TRUE) īullZip.SetValue('Showsettings','never') īullZip.SetValue(' ShowProgressFinished','no') īullZip.SetValue('SuppressErrors','yes') īullZip.SetValue('ConfirmOverWrite','no') I have installed Bullzip also in client side.įor the above requirement I am using this link as reference:ĬreatePDFfile(SalesInvHeader : Record "Sales Invoice Header")
#AUTOMATICALLY INCREMENT NUMBER BULLZIP PDF FULL#
I have created shared path in server side and gave full permission to the user who is testing it.Ģ. when client is sending from his local machine its showing error.ġ. when i am trying in server, its working fine. I am sending PDF invoice attachment through mail through Bullzip PDF printer.ġ. Has anyone any experience with this kond of problem? Same it I try to set the Name of Dataseries. I always get an C/AL error, that the "Values" can not be set. XlSeries.Values := 'Sheet1!C5:Sheet1!C29' When recording a Macro in Excel the VBA-Code looks linke this:ĪctiveChart.SeriesCollection(1).Values = "=(Tabelle1!R15C3,Tabelle1!R22C3,Tabelle1!R29C3,Tabelle1!R36C3)" XlSeries := xlSeriesCollection.NewSeries // create a new Dataseriens in the chartīut now I want to "tell" the new Dataseries from where to get the Data, and that's my problem.
XlSeriesCollection := xlChart.SeriesCollection // create an instance for the automation XlChart.ChartType(54) // setting the chart type (54 = 3D Column Clustered) XlChart := xlChartObject.Chart // Create an instance for the autoamation XlApp.CentimetersToPoints(8),xlApp.CentimetersToPoints(9)) //Create a new chart an place it on the sheet XlChartObject := xlChartObjects.Add(xlApp.CentimetersToPoints(15),xlApp.CentimetersToPoints(5), XlChartObjects := xlworksheet.ChartObjects //Create an instance for automation Now I use the folloing C/AL-Code to create the chart: XlSeries: 'Microsoft Excel 11.0 Object Library'.Series XlSeriesCollection: 'Microsoft Excel 11.0 Object Library'.SeriesCollection XlChartObjects: 'Microsoft Excel 11.0 Object Library'.ChartObjects XlChartObject: 'Microsoft Excel 11.0 Object Library'.ChartObject XlChart: 'Microsoft Excel 11.0 Object Library'.Chart XlRange: 'Microsoft Excel 11.0 Object Library'.Range XlWorksheet: 'Microsoft Excel 11.0 Object Library'.Worksheet XlWorkbook 'Microsoft Excel 11.0 Object Library'.Workbook XlApp: 'Microsoft Excel 11.0 Object Library'.Application I use the following Globals of type Automation: I create an Excel-Sheet with Navision using Automation-Variables to control Excel.Ĭreating a Excel-Sheet and fill it with data is not a problem, but now I want to create a chart based on the data in the Excel-Sheet. But when I do TempAXSlave.FINDSET I see there is only one record in that table.Ĭan you please help me with this problem ? On the AX Slave - OnPostDataItem() I want to generate an excel file based on the temp table. TempAXSlave.InsuranceCompanyName := "AX Slave".InsuranceCompanyName TempAXSlave.AccountNumber := "AX Slave".AccountNumber TempAXSlave.SETRANGE(InsuranceCompanyName,"AX Slave".InsuranceCompanyName) TempAXSlave.SETRANGE(CaseID,"AX Slave".CaseID) TempAXSlave.SETRANGE(AccountNumber,"AX Slave".AccountNumber) The problem is that I cannot insert more than one record in the temp table. I'm using the same table Ax Slave but is a temp table On After Get Record trigger I want to check if there is already inserted the combination between customer, caseID and InsuranceCompanyName and if it's then I just increment one field. Using a report, I have a dataItem based on Ax Slave table.
0 kommentar(er)
