search

meridianww / M4PLBase

0 stars 1 forks source link

Update Manual Order Template #484

Open nmfujimoto opened 3 years ago

nmfujimoto commented 3 years ago

Need to update the current csv file to import manual orders into the system with additional fields (Product Type, Plant Code, etc.) and specific columns that are required for order creation.

nmfujimoto commented 3 years ago

Use the attached file as the updated template for manual orders. Manual Spreadsheet (M4PL Template).xlsx

prashantaggarwal1999 commented 3 years ago

FinalManualOrderUploadTemplate.zip

@nmfujimoto this is the Final Template which we are using now.

prashantaggarwal1999 commented 3 years ago

@nmfujimoto here is the mapping with the job and CSV Columns:

ShipmentType = !string.IsNullOrEmpty(currentJob.ShipmentType) ? currentJob.ShipmentType : "Cross-Dock Shipment", JobType = !string.IsNullOrEmpty(currentJob.OrderType) ? currentJob.OrderType : "Original", JobCustomerSalesOrder = currentJob.CustomerSalesOrder, JobCustomerPurchaseOrder = currentJob.CustomerPurchaseOrder, JobCarrierContract = currentJob.Brand, JobProductType = currentJob.ProductType, JobBOL = currentJob.BOL, JobBOLMaster = currentJob.BOLParent, JobBOLChild = currentJob.BOLChild, PlantIDCode = currentJob.PlantCode, JobManifestNo = currentJob.ManifestNo, JobServiceMode = currentJob.ServiceMode, JobChannel = currentJob.Channel, JobOriginDateTimePlanned = currentJob.ArrivalDate.ToDateTime(), JobOriginDateTimeBaseline = currentJob.ArrivalDate.ToDateTime(), JobDeliveryDateTimePlanned = currentJob.EstimateDeliveryDate.ToDateTime(), JobDeliveryDateTimeBaseline = currentJob.EstimateDeliveryDate.ToDateTime(), JobSiteCode = currentJob.LocationCode, JobOriginSiteName = currentJob.OriginSiteName, JobSellerSiteName = currentJob.SellerSiteName, JobSellerCode = currentJob.SellerSiteNumber, JobDeliverySiteName = currentJob.DeliverySiteName, JobDeliveryStreetAddress = currentJob.DeliveryAddress1, JobDeliveryStreetAddress2 = currentJob.DeliveryAddress2, JobDeliveryCity = currentJob.DeliveryCity, JobDeliveryPostalCode = currentJob.DeliveryPostalCode, JobDeliveryState = currentJob.DeliveryState, JobDeliverySitePOC = currentJob.DeliverySitePOC, JobDeliverySitePOCPhone = currentJob.DeliverySitePOCPhone, JobOriginSitePOCPhone2 = currentJob.DeliverySitePOCPhone2, JobDeliverySitePOCEmail = currentJob.DeliverySitePOCEmail, JobQtyOrdered =currentJob.QuantityOrdered.ToInt(), JobPartsOrdered = currentJob.PartsOrdered.ToInt(), JobTotalCubes = currentJob.TotalCubes.ToInt(), JobDeliveryCommentText = currentJob.DeliveryComment

Madhusmi commented 3 years ago

@nmfujimoto Testing Completed on Staging environment and it is working as expected.