How can i get Bill of Material - Component ID for an assembly using ODBC on sales order

Vote count:

0

How can i get Bill of Material - Component ID for an assembly using ODBC, I am trying to sync sales order from sage with 3rd party application, I am able to get the sales order from 4 different tables using SQL statement but on the sales order if Item is assembly how can i show BOM Items attached to it.

  $result = mysqli_query($con,"SELECT DISTINCT 
                               Customers.CustomerId, 
                               Customers.Customer_Bill_Name, 
                               Customers.WhichShipVia, 
                               JrnlHdr.INV_POSOOrderNumber, 
                               JrnlHdr.ShipByDate, 
                               JrnlHdr.GoodThruDate, 
                               JrnlHdr.CustomerSONo, 
                               JrnlHdr.Reference, 
                               JrnlHdr.TransactionDate, 
                               JrnlRow.DistNumber, 
                               JrnlRow.Quantity, 
                               LineItem.ItemId, 
                               LineItem.SalesDescription, 
                               LineItem.PartNumber, 
                               LineItem.ItemDescription 
                   FROM JrnlHdr, JrnlRow, Customers, LineItem
                   WHERE JrnlHdr.POSOisClosed = 0 
                        AND JrnlHdr.PostOrder = JrnlRow.PostOrder 
                        AND JrnlHdr.CustVendId = Customers.CustomerRecordNumber 
                        AND JrnlRow.ItemRecordNumber = LineItem.ItemRecordNumber 
                        AND JrnlHdr.JrnlKey_Journal = 11 ORDER BY TransactionDate");

asked 1 min ago

Kuku

12

How can i get Bill of Material - Component ID for an assembly using ODBC on sales order