Skip to main content
Answer

Getting error ,The multi-part identifier "INItemClass.ItemClassCD" could not be bound in acumatica in this query

  • December 22, 2023
  • 2 replies
  • 390 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>>,
         And<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;

Best answer by Manikanta Dhulipudi

Hi @mayurig23 

I found similar case Pls check 

 

2 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @mayurig23 

I found similar case Pls check 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • December 22, 2023

@mayurig23  In the above query you already commented itemClassCD condition, hence it should not come with that error.

Can you please share the right query and also share the other DACs like TSFixedDemand, TSProductionOrdersCreateFilter and TSProdFormulaMTranSplit