How to edit a production order

[former_member310784]

Using asp.net, I would like to show and edit the articles and ressources from a production order. Any clues how I can do it ? Maybe a tutorial that does something similar not necessarily in asp.net

[former_member310784]

Hello, thank you for the answer, so you mean that in order to show the Production Order details I can use a sql query with the tables I need but when I need to update the Production Order I have to use the SAPbobsCOM?

[ANKIT_CHAUHAN]

Hi,

Yes, you got it right. In order to show the details on the form, you can use SQL Query only.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[former_member310784]

hi again... how to get a list of all the production orders? I tried same as BP to create a recordset but there is nothing similar to .GetBPList

[ANKIT_CHAUHAN]

Hi,

To show the details of the Production Order, you need to use the Tables OWOR, WOR1 and other relevant tables.

To update the Production Order, you need to include SAPbobsCOM.dll into your project code so that you can get the access to Business Object for Production Order in SAP Business One and later you need to use the code something like this:

SAPbobsCOM.ProductionOrders oPO = (SAPbobsCOM.ProductionOrders)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oProductionOrders);
oPO.GetByKey(155);
oPO.Lines.Add();
oPO.Lines.ItemNo = "AB 2000";
int U = oPO.Update();

if (U != 0)
{
    MessageBox.Show(oCompany.GetLastErrorDescription());
}

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP SME Support