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
  • 315 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 

 

View original
Did this topic help you find an answer to your question?

2 replies

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

Hi @mayurig23 

I found similar case Pls check 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings