Skip to main content
Solved

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

  • December 22, 2023
  • 2 replies
  • 447 views
  • Translate All

     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 

 

View original

2 replies

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

Hi @mayurig23 

I found similar case Pls check 

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

@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

Translate