Error while updating CashFlowAssignments of JournalEntries with Service Layer

[beka]

Hello experts,

I’m trying to assign a Cash Flow Line Item to a Journal Entry line using Service Layer. My payload looks like this:

{
  "JournalEntryLines": [
    {
      "Line_ID": 0,
      "CashFlowAssignments": [
        {
          "PaymentMeans": "pmtBankTransfer",
          "CashFlowLineItemID": 63,
          "JDTLineId": 0
        }
      ]
    }
  ]
}

If there is already a record in OCFT (Cash Flow Transactions table), and I specify CashFlowAssignmentsID, the request works.

But when no record exists in OCFT yet, I get the following error:

{
  "error": {
    "code": -2028,
    "message": {
      "lang": "en-us",
      "value": "No matching records found (ODBC -2028)"
    }
  }
}

My question: How can I create a new CashFlowAssignments row for a Journal Entry line via Service Layer when no OCFT row exists yet?

Thanks in advance for your guidance!

[ANKIT_CHAUHAN]

Hi beka,

Can you perform the same action successfully using SAP Business One client (performing the steps manually)?

If yes, you can try to retrieve that Journal Entry using GET request in Service Layer and verify your data.

If no, the same cannot be done via Service Layer as well.

Kind regards,

ANKIT CHAUHAN

SAP Support

[beka]

Hi @ANKIT_CHAUHAN,

[beka]

Hi @ANKIT_CHAUHAN, from SAP B1 client it works. Even this request works after manual actions are taken.