SAP B1 – DI Transactions, a deeper look.

				
					//The entry function for http request with the GET method
function POST() {
  console.log("POST Method was called.");

  let oServiceLayerContext = new ServiceLayerContext();

  // Preparing the order payload
  // We will prepare as many things as possible before starting the transaction
  let oOrder = new Document();
  oOrder.CardCode = "C001";
  oOrder.DocDate = "2022-01-01";
  oOrder.DocDueDate = "2022-01-31";

  let oOrderLine = new DocumentLine();
  oOrderLine.ItemCode = "A0001";
  oOrderLine.Quantity = 1;
  oOrderLine.Price = 50;

  oOrder.DocumentLines = [oOrderLine];

  console.log(JSON.stringify(oOrder));

  try {
    // Starting our transaction
    oServiceLayerContext.startTransaction();

    /** @type {SAPB1.DataServiceResponse} */
    let oAddResult = oServiceLayerContext.Orders.add(oOrder);

    console.log("*** Order add result ***");
    console.log(JSON.stringify(oAddResult, null, 4));

    if (!oAddResult.isOK()) {
      throw HttpModule.ScriptException(
        HttpModule.HttpStatus.HTTP_BAD_REQUEST,
        oAddResult.getErrMsg()
      );
    }

    // The order was successfully added!
    // Preparing the invoice payload
    let oInvoice = new Document();
    oInvoice.CardCode = oOrder.CardCode;
    oInvoice.DocDate = oOrder.DocDate;
    oInvoice.DocDueDate = oOrder.DocDueDate;

    let oInvoiceLine = new DocumentLine();
    oInvoiceLine.ItemCode = oOrderLine.ItemCode;
    oInvoiceLine.Quantity = oOrderLine.Quantity;
    oInvoiceLine.Price = oOrderLine.Price;

    // Unlike the DI-API, we can directly get the DocEntry of the newly-created invoice out of the SL response
    oInvoiceLine.BaseEntry = oAddResult.body.DocEntry;
    oInvoiceLine.BaseLine = 0;
    oInvoiceLine.BaseType = 17; // Object type of Sales Order is 17

    oInvoice.DocumentLines = [oInvoiceLine];

    // Log invoice content
    console.log(JSON.stringify(oInvoice));

    // Finally, add the invoice
    oAddResult = oServiceLayerContext.Invoices.add(oInvoice);

    console.log("*** Invoice add result ***");
    console.log(JSON.stringify(oAddResult, null, 4));

    if (!oAddResult.isOK()) {
      throw HttpModule.ScriptException(
        HttpModule.HttpStatus.HTTP_BAD_REQUEST,
        oAddResult.getErrMsg()
      );
    }

    // If both order and invoice were added, commit transaction
    oServiceLayerContext.commitTransaction();

    console.log("POST Method ended.");

    // We will return an HTTP Status Code 201 (Created) + the information of both order and invoice
    HttpModule.response.send(HttpModule.HttpStatus.HTTP_CREATED, {
      Order: oOrder,
      Invoice: oInvoice,
    });
  } catch (oError) {
    // Unlike the DI-API, we need to manually rollback the transaction
    oServiceLayerContext.rollbackTransaction();

    // Return an HTTP error response
    HttpModule.response.send(HttpModule.HttpStatus.HTTP_BAD_REQUEST, oError);
  }
}