Question

Sales to Production order creation issue-> When I am creating sales to production order with Blend to container order time its not creating production order processing screen source code is attached for reference

  • 22 December 2023
  • 3 replies
  • 37 views

 

public PXFilteredProcessingJoin<TSFixedDemand, TSProductionOrdersCreateFilter,
            InnerJoin<InventoryItem,
        On<InventoryItem.inventoryID, Equal<TSFixedDemand.inventoryID>>,
    LeftJoin<SOOrder,
        On<SOOrder.noteID, Equal<TSFixedDemand.refNoteID>>,
    LeftJoin<SOLineSplit,
        On<SOLineSplit.planID, Equal<TSFixedDemand.planID>>,
    LeftJoin<SOLine,
        On<SOLine.orderType, Equal<SOLineSplit.orderType>,
        And<SOLine.orderNbr, Equal<SOLineSplit.orderNbr>,
        And<SOLine.lineNbr, Equal<SOLineSplit.lineNbr>>>>,
    LeftJoin<INItemClass,
        On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>,
    LeftJoin<SOOrderType,
        On<SOOrderType.orderType, Equal<SOOrder.orderType>>,
    LeftJoin<TSProdFormulaMTranSplit, On<TSProdFormulaMTranSplit.planID, Equal<TSFixedDemand.planID>>
      , LeftJoin<TSProdBOMMtranSplit, On<TSProdBOMMtranSplit.planID, Equal<TSFixedDemand.planID>>>
   /* , LeftJoin<TSProdBOMMtranSplit, On<TSProdBOMMtranSplit.planID, Equal<TSFixedDemand.planID>>>*/>>>>>>>,
    Where<
        Where<TSFixedDemand.supplyPlanID, IsNull,
            And2<Where<TSFixedDemand.inventoryID, Equal<Current<TSProductionOrdersCreateFilter.inventoryID>>,
                Or<Current<TSProductionOrdersCreateFilter.inventoryID>, IsNull>>,
            And2<Where<TSFixedDemand.siteID, Equal<Current<TSProductionOrdersCreateFilter.siteID>>,
                    Or<Current<TSProductionOrdersCreateFilter.siteID>, IsNull>>,
            And2<Where<SOOrder.customerID, Equal<Current<TSProductionOrdersCreateFilter.customerID>>,
                    Or<Current<TSProductionOrdersCreateFilter.customerID>, IsNull>>,
            And2<Where<TSFixedDemand.planDate, GreaterEqual<Current<TSProductionOrdersCreateFilter.requestedOnStartDate>>,
                    Or<Current<TSProductionOrdersCreateFilter.requestedOnStartDate>, IsNull>>,
            And2<Where<TSFixedDemand.planDate, LessEqual<Current<TSProductionOrdersCreateFilter.requestedOnEndDate>>,
                    Or<Current<TSProductionOrdersCreateFilter.requestedOnEndDate>, IsNull>>,
            And<Where<INItemClass.itemClassCD, Like<Current<TSProductionOrdersCreateFilter.itemClassCDWildcard>>,
                    Or<Current<TSProductionOrdersCreateFilter.itemClassCDWildcard>, IsNull>>>>>>>>>>> FixedDemand;

 


3 replies

Userlevel 7
Badge

Hi @mayurig23 were you able to find a solution? Thank you!

when I am removing hold and trying to create production order its coming blank I have attached screen shot of it

Userlevel 7
Badge +16

HI @mayurig23 

What happens when you Remove the Hold on the Order then click the 3 dots and chose Create Production Order?

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved