public virtual List <PXResult <SOOrderShipment, SOOrder> > UpdateOrderShipments(ARRegister arDoc, HashSet <object> processed) { bool isCancellationInvoice = (arDoc.IsCancellation == true); bool isCorrectionInvoice = (arDoc.IsCorrection == true); var boundInvoice = isCancellationInvoice ? ARInvoice.PK.Find(this, arDoc.OrigDocType, arDoc.OrigRefNbr) : arDoc; var orderShipments = this.Items.View.SelectMultiBound(new object[] { boundInvoice }) .Cast <PXResult <SOOrderShipment, SOOrder> >() .ToList(); foreach (var ordershipment in orderShipments) { SOOrderShipment copy = PXCache <SOOrderShipment> .CreateCopy(ordershipment); if (isCancellationInvoice) { ARInvoice existingCorrectionInvoice = PXSelect <ARInvoice, Where <ARInvoice.origDocType, Equal <Current <ARInvoice.origDocType> >, And <ARInvoice.origRefNbr, Equal <Current <ARInvoice.origRefNbr> >, And <ARInvoice.isCorrection, Equal <True> > > > > .SelectSingleBound(this, new[] { arDoc }); copy.InvoiceType = existingCorrectionInvoice?.DocType; copy.InvoiceNbr = existingCorrectionInvoice?.RefNbr; } copy.InvoiceReleased = !isCancellationInvoice; this.Items.Update(copy); if (!isCancellationInvoice && !isCorrectionInvoice) { SOOrder order = ordershipment; SOOrderType otype = SOOrderType.PK.Find(this, order.OrderType); if ((order.Completed == true || otype.RequireShipping == false) && order.BilledCntr <= 1 && order.ShipmentCntr <= order.BilledCntr + order.ReleasedCntr) { foreach (SOAdjust adj in this.Adjustments.Select(order.OrderType, order.OrderNbr)) { SOAdjust adjcopy = PXCache <SOAdjust> .CreateCopy(adj); adjcopy.CuryAdjdAmt = 0m; adjcopy.CuryAdjgAmt = 0m; adjcopy.AdjAmt = 0m; this.Adjustments.Update(adjcopy); } } } processed.Add(arDoc); } return(orderShipments); }
public static void SetSupportsApproval(PXGraph sender, SOOrderType row) { if (row == null) { return; } using (new PXConnectionScope()) { PXView view = new PXView(sender, true, SupportsApprovalSelect); var r = view.SelectSingle(row.Behavior); row.SupportsApproval = r != null; } }
public virtual void CompleteSOLinesAndSplits(ARRegister ardoc, List <PXResult <SOOrderShipment, SOOrder> > orderShipments) { if (ardoc.IsCancellation == true || ardoc.IsCorrection == true) { return; } foreach (PXResult <SOOrderShipment, SOOrder> orderShipment in orderShipments) { SOOrder order = orderShipment; SOOrderType orderType = SOOrderType.PK.Find(this, order.OrderType); if (orderType.RequireShipping == false) { PXDatabase.Update <SOLine>( new PXDataFieldAssign <SOLine.completed>(true), new PXDataFieldRestrict <SOLine.completed>(false), new PXDataFieldRestrict <SOLine.orderType>(PXDbType.VarChar, 2, order.OrderType, PXComp.EQ), new PXDataFieldRestrict <SOLine.orderNbr>(PXDbType.NVarChar, 15, order.OrderNbr, PXComp.EQ)); PXDatabase.Update <SOLineSplit>( new PXDataFieldAssign <SOLineSplit.completed>(true), new PXDataFieldRestrict <SOLineSplit.completed>(false), new PXDataFieldRestrict <SOLineSplit.orderType>(PXDbType.VarChar, 2, order.OrderType, PXComp.EQ), new PXDataFieldRestrict <SOLineSplit.orderNbr>(PXDbType.NVarChar, 15, order.OrderNbr, PXComp.EQ)); } } PXUpdateJoin < Set <SOLine.completed, True>, SOLine, InnerJoin <ARTran, On <ARTran.sOOrderType, Equal <SOLine.orderType>, And <ARTran.sOOrderNbr, Equal <SOLine.orderNbr>, And <ARTran.sOOrderLineNbr, Equal <SOLine.lineNbr> > > > >, Where <SOLine.lineType, Equal <SOLineType.miscCharge>, And <SOLine.completed, Equal <False>, And <ARTran.tranType, Equal <Required <ARTran.tranType> >, And <ARTran.refNbr, Equal <Required <ARTran.refNbr> > > > > > > .Update(this, ardoc.DocType, ardoc.RefNbr); }
protected GetTaxRequest BuildGetTaxRequestWithFRTCate <TLineAmt, TLineQty, TDocDiscount>(SOOrder order, string docCode, string debugMethodName) where TLineAmt : IBqlField where TLineQty : IBqlField where TDocDiscount : IBqlField { Stopwatch sw = new Stopwatch(); sw.Start(); Debug.Indent(); if (order == null) { throw new PXArgumentException(nameof(order)); } Customer cust = (Customer)Base.customer.View.SelectSingleBound(new object[] { order }); Location loc = (Location)Base.location.View.SelectSingleBound(new object[] { order }); IAddressBase fromAddress = GetFromAddress(order); IAddressBase toAddress = GetToAddress(order); Debug.Print($"{DateTime.Now.TimeOfDay} Select Customer, Location, Addresses in {sw.ElapsedMilliseconds} millisec"); if (fromAddress == null) { throw new PXException(Messages.FailedGetFromAddressSO); } if (toAddress == null) { throw new PXException(Messages.FailedGetToAddressSO); } GetTaxRequest request = new GetTaxRequest(); request.CompanyCode = Base1.CompanyCodeFromBranch(order.TaxZoneID, order.BranchID); request.CurrencyCode = order.CuryID; request.CustomerCode = cust.AcctCD; request.TaxRegistrationID = loc?.TaxRegistrationID; request.OriginAddress = AddressConverter.ConvertTaxAddress(fromAddress); request.DestinationAddress = AddressConverter.ConvertTaxAddress(toAddress); request.DocCode = docCode; request.DocDate = order.OrderDate.GetValueOrDefault(); request.LocationCode = GetExternalTaxProviderLocationCode <SOLine, SOLine.FK.Order.SameAsCurrent, SOLine.siteID>(order); Sign docSign = Sign.Plus; request.CustomerUsageType = order.AvalaraCustomerUsageType; if (!string.IsNullOrEmpty(order.ExternalTaxExemptionNumber)) { request.ExemptionNo = order.ExternalTaxExemptionNumber; } SOOrderType orderType = (SOOrderType)Base.soordertype.View.SelectSingleBound(new object[] { order }); if (orderType.DefaultOperation == SOOperation.Receipt) { request.DocType = TaxDocumentType.ReturnOrder; docSign = Sign.Minus; } else { request.DocType = TaxDocumentType.SalesOrder; } PXSelectBase <SOLine> select = new PXSelectJoin <SOLine, LeftJoin <InventoryItem, On <SOLine.FK.InventoryItem>, LeftJoin <Account, On <Account.accountID, Equal <SOLine.salesAcctID> > > >, Where <SOLine.orderType, Equal <Current <SOOrder.orderType> >, And <SOLine.orderNbr, Equal <Current <SOOrder.orderNbr> > > >, OrderBy <Asc <SOLine.orderType, Asc <SOLine.orderNbr, Asc <SOLine.lineNbr> > > > >(Base); PXCache documentCache = Base.Caches[typeof(SOOrder)]; request.Discount = (documentCache.GetValue <TDocDiscount>(order) as decimal?) ?? 0m; Stopwatch sw2 = new Stopwatch(); sw2.Start(); // Add additional condition to skip the calculation including the freight amount. Per YJ's request. if (order.CuryFreightTot > 0 && !string.IsNullOrEmpty(order.FreightTaxCategoryID)) { var line = new TaxCartItem(); line.Index = short.MinValue; line.Quantity = 1; line.UOM = "EA"; line.Amount = docSign * order.CuryFreightTot.GetValueOrDefault(); line.Description = PXMessages.LocalizeNoPrefix(Messages.FreightDesc); line.DestinationAddress = request.DestinationAddress; line.OriginAddress = request.OriginAddress; line.ItemCode = "N/A"; line.Discounted = false; line.TaxCode = order.FreightTaxCategoryID; request.CartItems.Add(line); } PXCache lineCache = Base.Caches[typeof(SOLine)]; foreach (PXResult <SOLine, InventoryItem, Account> res in select.View.SelectMultiBound(new object[] { order })) { SOLine tran = (SOLine)res; InventoryItem item = (InventoryItem)res; Account salesAccount = (Account)res; bool lineIsDiscounted = request.Discount > 0m && ((tran.DocumentDiscountRate ?? 1m) != 1m || (tran.GroupDiscountRate ?? 1m) != 1m); var line = new TaxCartItem(); line.Index = tran.LineNbr ?? 0; decimal lineAmount = (lineCache.GetValue <TLineAmt>(tran) as decimal?) ?? 0m; decimal lineQty = (lineCache.GetValue <TLineQty>(tran) as decimal?) ?? 0m; line.Amount = orderType.DefaultOperation != tran.Operation ? Sign.Minus * docSign * lineAmount : docSign * lineAmount; line.Description = tran.TranDesc; line.DestinationAddress = AddressConverter.ConvertTaxAddress(Base1.GetToAddress(order, tran)); line.OriginAddress = AddressConverter.ConvertTaxAddress(Base1.GetFromAddress(order, tran)); line.ItemCode = item.InventoryCD; line.Quantity = Math.Abs(lineQty); line.UOM = tran.UOM; line.Discounted = lineIsDiscounted; line.RevAcct = salesAccount.AccountCD; line.TaxCode = tran.TaxCategoryID; line.CustomerUsageType = tran.AvalaraCustomerUsageType; if (tran.Operation == SOOperation.Receipt && tran.InvoiceDate != null) { line.TaxOverride.Reason = Messages.ReturnReason; line.TaxOverride.TaxDate = tran.InvoiceDate.Value; line.TaxOverride.TaxOverrideType = TaxOverrideType.TaxDate; } request.CartItems.Add(line); } sw2.Stop(); Debug.Print($"{DateTime.Now.TimeOfDay} Select detail lines in {sw2.ElapsedMilliseconds} millisec."); Debug.Unindent(); sw.Stop(); Debug.Print($"{DateTime.Now.TimeOfDay} {debugMethodName}() in {sw.ElapsedMilliseconds} millisec."); return(request); }
public virtual void IntegrityCheckProc(INItemSiteSummary itemsite, string minPeriod, bool replanBackorders) { using (PXConnectionScope cs = new PXConnectionScope()) { using (PXTransactionScope ts = new PXTransactionScope()) { foreach (INItemPlan p in PXSelectReadonly2 <INItemPlan, LeftJoin <Note, On <Note.noteID, Equal <INItemPlan.refNoteID> > >, Where <INItemPlan.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> >, And <INItemPlan.siteID, Equal <Current <INItemSiteSummary.siteID> >, And <Note.noteID, IsNull> > > > .SelectMultiBound(this, new object[] { itemsite })) { PXDatabase.Delete <INItemPlan>(new PXDataFieldRestrict("PlanID", PXDbType.BigInt, 8, p.PlanID, PXComp.EQ)); } foreach (INItemPlan p in PXSelectReadonly2 <INItemPlan, InnerJoin <INRegister, On <INRegister.noteID, Equal <INItemPlan.refNoteID>, And <INRegister.siteID, Equal <INItemPlan.siteID> > > >, Where <INRegister.docType, Equal <INDocType.transfer>, And <INRegister.released, Equal <boolTrue>, And <INItemPlan.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> >, And <INItemPlan.siteID, Equal <Current <INItemSiteSummary.siteID> > > > > > > .SelectMultiBound(this, new object[] { itemsite })) { PXDatabase.Delete <INItemPlan>(new PXDataFieldRestrict("PlanID", PXDbType.BigInt, 8, p.PlanID, PXComp.EQ)); } foreach (PXResult <INTranSplit, INRegister, INSite, INItemSite> res in PXSelectJoin <INTranSplit, InnerJoin <INRegister, On <INRegister.docType, Equal <INTranSplit.docType>, And <INRegister.refNbr, Equal <INTranSplit.refNbr> > >, InnerJoin <INSite, On <INSite.siteID, Equal <INRegister.toSiteID> >, LeftJoin <INItemSite, On <INItemSite.inventoryID, Equal <INTranSplit.inventoryID>, And <INItemSite.siteID, Equal <INRegister.toSiteID> > >, LeftJoin <INTran, On <INTran.origTranType, Equal <INTranSplit.tranType>, And <INTran.origRefNbr, Equal <INTranSplit.refNbr>, And <INTran.origLineNbr, Equal <INTranSplit.lineNbr> > > >, LeftJoin <INItemPlan, On <INItemPlan.planID, Equal <INTranSplit.planID> > > > > > >, Where <INRegister.docType, Equal <INDocType.transfer>, And2 <Where <INRegister.released, Equal <boolTrue>, And <INTranSplit.released, Equal <boolTrue>, Or <INRegister.released, Equal <boolFalse> > > >, And <INTranSplit.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> >, And <INTranSplit.siteID, Equal <Current <INItemSiteSummary.siteID> >, And <INTranSplit.invtMult, Equal <shortMinus1>, And <INItemPlan.planID, IsNull, And <INTran.refNbr, IsNull> > > > > > > > .SelectMultiBound(this, new object[] { itemsite })) { INTranSplit split = res; INRegister doc = res; if (split.TransferType == INTransferType.OneStep && doc.Released == true) { if (doc.TransferType == INTransferType.OneStep) { doc.TransferType = INTransferType.TwoStep; Caches[typeof(INRegister)].Update(doc); } split.TransferType = INTransferType.TwoStep; } INItemPlan plan = INItemPlanIDAttribute.DefaultValues(this.Caches[typeof(INTranSplit)], res); if (plan.LocationID == null) { plan.LocationID = ((INItemSite)res).DfltReceiptLocationID ?? ((INSite)res).ReceiptLocationID; } plan = (INItemPlan)this.Caches[typeof(INItemPlan)].Insert(plan); split.PlanID = plan.PlanID; Caches[typeof(INTranSplit)].SetStatus(split, PXEntryStatus.Updated); } PXDatabase.Update <INSiteStatus>( new PXDataFieldRestrict <INSiteStatus.inventoryID>(PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict <INSiteStatus.siteID>(PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldAssign <INSiteStatus.qtyAvail>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyHardAvail>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyNotAvail>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyINIssues>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyINReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyInTransit>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyINAssemblySupply>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyINAssemblyDemand>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyINReplaned>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPOPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPOOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPOReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtySOPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtySOBooked>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtySOShipped>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtySOShipping>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtySOBackOrdered>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtySOFixed>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPOFixedOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPOFixedPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPOFixedReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtySODropShip>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPODropShipOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPODropShipPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyPODropShipReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INSiteStatus.qtyInTransitToSO>(PXDbType.Decimal, 0m) ); PXDatabase.Update <INLocationStatus>( new PXDataFieldRestrict <INLocationStatus.inventoryID>(PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict <INLocationStatus.siteID>(PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldAssign <INLocationStatus.qtyAvail>(PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign <INLocationStatus.qtyHardAvail>(PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign <INLocationStatus.qtyINIssues>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyINReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyInTransit>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyINAssemblySupply>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyINAssemblyDemand>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPOPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPOOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPOReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtySOPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtySOBooked>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtySOShipped>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtySOShipping>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtySOBackOrdered>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtySOFixed>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPOFixedOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPOFixedPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPOFixedReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtySODropShip>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPODropShipOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPODropShipPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyPODropShipReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLocationStatus.qtyInTransitToSO>(PXDbType.Decimal, 0m) ); PXDatabase.Update <INLotSerialStatus>( new PXDataFieldRestrict <INLotSerialStatus.inventoryID>(PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict <INLotSerialStatus.siteID>(PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldAssign <INLotSerialStatus.qtyAvail>(PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign <INLotSerialStatus.qtyHardAvail>(PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign <INLotSerialStatus.qtyINIssues>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyINReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyInTransit>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyINAssemblySupply>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyINAssemblyDemand>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPOPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPOOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPOReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtySOPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtySOBooked>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtySOShipped>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtySOShipping>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtySOBackOrdered>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtySOFixed>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPOFixedOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPOFixedPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPOFixedReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtySODropShip>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPODropShipOrders>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPODropShipPrepared>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyPODropShipReceipts>(PXDbType.Decimal, 0m), new PXDataFieldAssign <INLotSerialStatus.qtyInTransitToSO>(PXDbType.Decimal, 0m) ); PXDatabase.Update <INItemLotSerial>( new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldAssign("QtyAvail", PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign("QtyHardAvail", PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign("QtyINTransit", PXDbType.Decimal, 0m) ); PXDatabase.Update <INSiteLotSerial>( new PXDataFieldRestrict <INSiteLotSerial.inventoryID>(PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict <INSiteLotSerial.siteID>(PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldAssign <INSiteLotSerial.qtyAvail>(PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign <INSiteLotSerial.qtyHardAvail>(PXDbType.DirectExpression, "QtyOnHand"), new PXDataFieldAssign <INSiteLotSerial.qtyInTransit>(PXDbType.Decimal, 0m) ); foreach (PXResult <ReadOnlyLocationStatus, INLocation> res in PXSelectJoinGroupBy <ReadOnlyLocationStatus, InnerJoin <INLocation, On <INLocation.locationID, Equal <ReadOnlyLocationStatus.locationID> > >, Where <ReadOnlyLocationStatus.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> >, And <ReadOnlyLocationStatus.siteID, Equal <Current <INItemSiteSummary.siteID> > > >, Aggregate <GroupBy <ReadOnlyLocationStatus.inventoryID, GroupBy <ReadOnlyLocationStatus.siteID, GroupBy <ReadOnlyLocationStatus.subItemID, GroupBy <INLocation.inclQtyAvail, Sum <ReadOnlyLocationStatus.qtyOnHand> > > > > > > .SelectMultiBound(this, new object[] { itemsite })) { SiteStatus status = new SiteStatus(); status.InventoryID = ((ReadOnlyLocationStatus)res).InventoryID; status.SubItemID = ((ReadOnlyLocationStatus)res).SubItemID; status.SiteID = ((ReadOnlyLocationStatus)res).SiteID; status = (SiteStatus)sitestatus.Cache.Insert(status); if (((INLocation)res).InclQtyAvail == true) { status.QtyAvail += ((ReadOnlyLocationStatus)res).QtyOnHand; status.QtyHardAvail += ((ReadOnlyLocationStatus)res).QtyOnHand; } else { status.QtyNotAvail += ((ReadOnlyLocationStatus)res).QtyOnHand; } } INPlanType plan60 = PXSelect <INPlanType, Where <INPlanType.planType, Equal <INPlanConstants.plan60> > > .Select(this); INPlanType plan61 = PXSelect <INPlanType, Where <INPlanType.planType, Equal <INPlanConstants.plan61> > > .Select(this); INPlanType plan70 = PXSelect <INPlanType, Where <INPlanType.planType, Equal <INPlanConstants.plan70> > > .Select(this); INPlanType plan74 = PXSelect <INPlanType, Where <INPlanType.planType, Equal <INPlanConstants.plan74> > > .Select(this); INPlanType plan76 = PXSelect <INPlanType, Where <INPlanType.planType, Equal <INPlanConstants.plan76> > > .Select(this); INPlanType plan42 = PXSelect <INPlanType, Where <INPlanType.planType, Equal <INPlanConstants.plan42> > > .Select(this); INPlanType plan44 = PXSelect <INPlanType, Where <INPlanType.planType, Equal <INPlanConstants.plan44> > > .Select(this); foreach (PXResult <INItemPlan, INPlanType, SOShipLineSplit, POReceiptLineSplit> res in PXSelectJoin <INItemPlan, InnerJoin <INPlanType, On <INPlanType.planType, Equal <INItemPlan.planType> >, LeftJoin <SOShipLineSplit, On <SOShipLineSplit.planID, Equal <INItemPlan.planID> >, LeftJoin <POReceiptLineSplit, On <POReceiptLineSplit.planID, Equal <INItemPlan.planID> > > > >, Where <INItemPlan.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> >, And <INItemPlan.siteID, Equal <Current <INItemSiteSummary.siteID> > > > > .SelectMultiBound(this, new object[] { itemsite })) { INItemPlan plan = (INItemPlan)res; INPlanType plantype = (INPlanType)res; INPlanType locplantype; SOShipLineSplit sosplit = (SOShipLineSplit)res; POReceiptLineSplit posplit = (POReceiptLineSplit)res; if (plan.InventoryID != null && plan.SubItemID != null && plan.SiteID != null) { switch (plan.PlanType) { case INPlanConstants.Plan61: case INPlanConstants.Plan63: locplantype = plantype; if (sosplit.ShipmentNbr != null) { SOOrderType ordetype = PXSelect <SOOrderType, Where <SOOrderType.orderType, Equal <Current <SOShipLineSplit.origOrderType> > > > .SelectSingleBound(this, new object[] { sosplit }); if (plan.OrigPlanType == null) { plan.OrigPlanType = ordetype.OrderPlanType; } if (plan.OrigPlanType == INPlanConstants.Plan60 && sosplit.IsComponentItem != true) { plantype = plantype - plan60; } if ((plan.OrigPlanType == INPlanConstants.Plan61 || plan.OrigPlanType == INPlanConstants.Plan63) && sosplit.IsComponentItem != true) { plantype = plantype - plan61; } } break; case INPlanConstants.Plan71: case INPlanConstants.Plan72: locplantype = plantype; if (posplit.ReceiptNbr == null) { PXDatabase.Delete <INItemPlan>(new PXDataFieldRestrict("PlanID", PXDbType.BigInt, 8, plan.PlanID, PXComp.EQ)); continue; } if (posplit.PONbr != null) { plantype = plantype - plan70; } break; case INPlanConstants.Plan77: locplantype = plantype; if (posplit.ReceiptNbr != null && posplit.PONbr != null) { plantype = plantype - plan76; } break; case INPlanConstants.Plan75: locplantype = plantype; if (posplit.ReceiptNbr != null && posplit.PONbr != null) { plantype = plantype - plan74; } break; case INPlanConstants.Plan43: case INPlanConstants.Plan45: if (plan.OrigPlanType == INPlanConstants.Plan44) { plantype = plantype - plan44; } if (plan.OrigPlanType == INPlanConstants.Plan42) { plantype = plantype - plan42; } locplantype = plantype; break; default: locplantype = plantype; break; } if (plan.LocationID != null) { LocationStatus item = INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <LocationStatus>(this, plan, locplantype, true); INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <SiteStatus>(this, plan, plantype, (bool)item.InclQtyAvail); if (!string.IsNullOrEmpty(plan.LotSerialNbr)) { INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <LotSerialStatus>(this, plan, locplantype, true); INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <ItemLotSerial>(this, plan, locplantype, true); INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <SiteLotSerial>(this, plan, locplantype, true); } } else { INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <SiteStatus>(this, plan, plantype, true); if (!string.IsNullOrEmpty(plan.LotSerialNbr)) { //TODO: check if LotSerialNbr was allocated on OrigPlanType INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <ItemLotSerial>(this, plan, plantype, true); INItemPlanIDAttribute.UpdateAllocatedQuantitiesBase <SiteLotSerial>(this, plan, plantype, true); } } } } if (replanBackorders) { INReleaseProcess.ReplanBackOrders(this); initemplan.Cache.Persist(PXDBOperation.Insert); initemplan.Cache.Persist(PXDBOperation.Update); } Caches[typeof(INTranSplit)].Persist(PXDBOperation.Update); sitestatus.Cache.Persist(PXDBOperation.Insert); sitestatus.Cache.Persist(PXDBOperation.Update); locationstatus.Cache.Persist(PXDBOperation.Insert); locationstatus.Cache.Persist(PXDBOperation.Update); lotserialstatus.Cache.Persist(PXDBOperation.Insert); lotserialstatus.Cache.Persist(PXDBOperation.Update); itemlotserial.Cache.Persist(PXDBOperation.Insert); itemlotserial.Cache.Persist(PXDBOperation.Update); sitelotserial.Cache.Persist(PXDBOperation.Insert); sitelotserial.Cache.Persist(PXDBOperation.Update); if (minPeriod != null) { FinPeriod period = PXSelect <FinPeriod, Where <FinPeriod.finPeriodID, Equal <Required <FinPeriod.finPeriodID> > > > .SelectWindowed(this, 0, 1, minPeriod); if (period == null) { return; } DateTime startDate = (DateTime)period.StartDate; PXDatabase.Delete <INItemCostHist>( new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict("CostSiteID", PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldRestrict("FinPeriodID", PXDbType.Char, 6, minPeriod, PXComp.GE) ); PXDatabase.Delete <INItemSalesHistD>( new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict("SiteID", PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldRestrict("QtyPlanSales", PXDbType.Decimal, 0m), new PXDataFieldRestrict("SDate", PXDbType.DateTime, 8, startDate, PXComp.GE) ); PXDatabase.Delete <INItemCustSalesStats>( new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict("SiteID", PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldRestrict("LastDate", PXDbType.DateTime, 8, startDate, PXComp.GE)); PXDatabase.Update <INItemSalesHistD>( new PXDataFieldAssign("QtyIssues", PXDbType.Decimal, 0m), new PXDataFieldAssign("QtyExcluded", PXDbType.Decimal, 0m), new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict("SiteID", PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldRestrict("SDate", PXDbType.DateTime, 8, startDate, PXComp.GE) ); foreach (INLocation loc in PXSelectReadonly2 <INLocation, InnerJoin <INItemCostHist, On <INItemCostHist.costSiteID, Equal <INLocation.locationID> > >, Where <INLocation.siteID, Equal <Current <INItemSiteSummary.siteID> >, And <INItemCostHist.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> > > > > .SelectMultiBound(this, new object[] { itemsite })) { PXDatabase.Delete <INItemCostHist>( new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict("CostSiteID", PXDbType.Int, 4, loc.LocationID, PXComp.EQ), new PXDataFieldRestrict("FinPeriodID", PXDbType.Char, 6, minPeriod, PXComp.GE) ); } PXDatabase.Delete <INItemSiteHist>( new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict("SiteID", PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldRestrict("FinPeriodID", PXDbType.Char, 6, minPeriod, PXComp.GE) ); PXDatabase.Delete <INItemSiteHistD>( new PXDataFieldRestrict("InventoryID", PXDbType.Int, 4, itemsite.InventoryID, PXComp.EQ), new PXDataFieldRestrict("SiteID", PXDbType.Int, 4, itemsite.SiteID, PXComp.EQ), new PXDataFieldRestrict("SDate", PXDbType.DateTime, 8, startDate, PXComp.GE) ); INTran prev_tran = null; foreach (PXResult <INTran, INTranSplit> res in PXSelectReadonly2 <INTran, InnerJoin <INTranSplit, On <INTranSplit.tranType, Equal <INTran.tranType>, And <INTranSplit.refNbr, Equal <INTran.refNbr>, And <INTranSplit.lineNbr, Equal <INTran.lineNbr> > > > >, Where <INTran.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> >, And <INTran.siteID, Equal <Current <INItemSiteSummary.siteID> >, And <INTran.finPeriodID, GreaterEqual <Required <INTran.finPeriodID> >, And <INTran.released, Equal <boolTrue> > > > >, OrderBy <Asc <INTran.tranType, Asc <INTran.refNbr, Asc <INTran.lineNbr> > > > > .SelectMultiBound(this, new object[] { itemsite }, minPeriod)) { INTran tran = res; INTranSplit split = res; if (!Caches[typeof(INTran)].ObjectsEqual(prev_tran, tran)) { INReleaseProcess.UpdateSalesHistD(this, tran); INReleaseProcess.UpdateCustSalesStats(this, tran); prev_tran = tran; } if (split.BaseQty != 0m) { INReleaseProcess.UpdateSiteHist(this, res, split); INReleaseProcess.UpdateSiteHistD(this, split); } } foreach (PXResult <INTran, INTranCost> res in PXSelectReadonly2 <INTran, InnerJoin <INTranCost, On <INTranCost.tranType, Equal <INTran.tranType>, And <INTranCost.refNbr, Equal <INTran.refNbr>, And <INTranCost.lineNbr, Equal <INTran.lineNbr> > > > >, Where <INTran.inventoryID, Equal <Current <INItemSiteSummary.inventoryID> >, And <INTran.siteID, Equal <Current <INItemSiteSummary.siteID> >, And <INTranCost.finPeriodID, GreaterEqual <Required <INTran.finPeriodID> >, And <INTran.released, Equal <boolTrue> > > > > > .SelectMultiBound(this, new object[] { itemsite }, minPeriod)) { INReleaseProcess.UpdateCostHist(this, (INTranCost)res, (INTran)res); } itemcosthist.Cache.Persist(PXDBOperation.Insert); itemcosthist.Cache.Persist(PXDBOperation.Update); itemsitehist.Cache.Persist(PXDBOperation.Insert); itemsitehist.Cache.Persist(PXDBOperation.Update); itemsitehistd.Cache.Persist(PXDBOperation.Insert); itemsitehistd.Cache.Persist(PXDBOperation.Update); itemsalehistd.Cache.Persist(PXDBOperation.Insert); itemsalehistd.Cache.Persist(PXDBOperation.Update); itemcustsalesstats.Cache.Persist(PXDBOperation.Insert); itemcustsalesstats.Cache.Persist(PXDBOperation.Update); } ts.Complete(); } sitestatus.Cache.Persisted(false); locationstatus.Cache.Persisted(false); lotserialstatus.Cache.Persisted(false); itemcosthist.Cache.Persisted(false); itemsitehist.Cache.Persisted(false); itemsitehistd.Cache.Persisted(false); } }
public virtual void OrderAvailabilityCheck(PXCache sender, ARTran row, bool onPersist = false) { if (row.InvtMult == 0 || row.SOOrderType == null && row.SOOrderNbr == null && row.SOOrderLineNbr == null || row.Released == true) { return; } if (row.LineType == SOLineType.MiscCharge) { RaiseAvailabilityException(sender, row, typeof(ARTran.inventoryID), Messages.NonStockNoShipCantBeInvoicedDirectly, onPersist, sender.GetValueExt <ARTran.inventoryID>(row)); } var res = GetLinkedSOLine(row); if (res == null) { RaiseAvailabilityException(sender, row, typeof(ARTran.sOOrderNbr), Messages.SOLineNotFound, onPersist); } SOLine line = res; SOOrderType orderType = res; if (orderType.OrderType == null || orderType.RequireShipping == false || orderType.ARDocType == ARDocType.NoUpdate) { RaiseAvailabilityException(sender, row, typeof(ARTran.sOOrderType), Messages.SOTypeCantBeInvoicedDirectly, onPersist, sender.GetValueExt <ARTran.sOOrderType>(row)); } if (line.Completed == true) { RaiseAvailabilityException(sender, row, typeof(ARTran.sOOrderNbr), Messages.CompletedSOLineCantBeInvoicedDirectly, onPersist); } if (line.CustomerID != row.CustomerID) { RaiseAvailabilityException(sender, row, typeof(ARTran.sOOrderNbr), Messages.CustomerDiffersInvoiceAndSO, onPersist); } if (line.POCreate == true) { RaiseAvailabilityException(sender, row, typeof(ARTran.sOOrderNbr), Messages.SOLineMarkedForPOCantBeInvoicedDirectly, onPersist); } if (line.InventoryID != row.InventoryID) { RaiseAvailabilityException(sender, row, typeof(ARTran.inventoryID), Messages.InventoryItemDiffersInvoiceAndSO, onPersist); } int arTranInvtMult = Math.Sign((row.InvtMult * row.Qty) ?? 0m); if (arTranInvtMult != 0) { int soLineInvtMult = (line.Operation == SOOperation.Receipt) ? 1 : -1; if (soLineInvtMult != arTranInvtMult) { RaiseAvailabilityException(sender, row, typeof(ARTran.qty), Messages.OperationDiffersInvoiceAndSO, onPersist); } } decimal absQty = Math.Abs(row.BaseQty ?? 0m); if (PXDBQuantityAttribute.Round((decimal)(line.BaseOrderQty * line.CompleteQtyMax / 100m - line.BaseShippedQty - absQty)) < 0m) { RaiseAvailabilityException(sender, row, typeof(ARTran.qty), Messages.OrderCheck_QtyNegative, onPersist, sender.GetValueExt <ARTran.inventoryID>(row), sender.GetValueExt <ARTran.subItemID>(row), sender.GetValueExt <ARTran.sOOrderType>(row), sender.GetValueExt <ARTran.sOOrderNbr>(row)); } }