Description:-
You can create production orders from sales orders lines.To create a production order from a sales order
After
clicking that you will get error like below
Error : Query missing QueryBuildDataSource for FormDataSource ProdTable IN
Solution: - Go to ProdTable form and add below code.
Create QueryBuildDataSource object.
QueryBuildDataSource qbdsProdTable_IN;
Now create production order from sales order line and you
will success to create production order.
You can create production orders from sales orders lines.To create a production order from a sales order
1. Go
to Accounts receivable > Common > Sales Orders > All sales orders.
2. Select
the sales order you want to create a production order for.
3. Edit
and select sales order line you want to create production order for.
4. On
the sales order lines Actions tab, choose Product and supply. In the Product
and supply list select Production order.
Error : Query missing QueryBuildDataSource for FormDataSource ProdTable IN
Solution: - Go to ProdTable form and add below code.
Create QueryBuildDataSource object.
QueryBuildDataSource qbdsProdTable_IN;
In the if condition add ProdTable_IN as join
data source like below.
qbdsProdTable_IN = qbS.addDataSource(tableNum(ProdTable_IN)); qbdsProdTable_IN.name(ProdTable_IN_ds.name()); qbdsProdTable_IN.addLink(fieldNum(ProdTable, RecId), fieldNum(ProdTable_IN, ProdTable)); qbdsProdTable_IN.joinMode(JoinMode::InnerJoin);
Thanks for comments.....