Clarity

Hi All,

We are trying to XOG a transaction but it is failing with below error:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Header><Auth xmlns="http://www.niku.com/xog">
<SessionID>30682103__5DA8BC54-3D2B-488E-B9DB-411B445F425E</SessionID>
</Auth></SOAP-ENV:Header><SOAP-ENV:Body>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_transaction.xsd">
<Header action="write" externalSource="NIKU" objectType="transaction" version="14.3.0.298"/>
<Transactions><Transaction actualCostRate="1" actualCostRateCurrency="EUR" billRate="1" billRateCurrency="EUR" chargeCode="NotSpecified"
chargeable="0" externalID=" " groupId="0000076323" importStatus="N"
inputTypeCode="Standard" notes="2018-04-28_SAP"
projectID="0000076323"
resourceID="z_NL3I_EXT_SERV"
roleID="z_external_service"
taskID="6825485" transactionDate="2018-04-28"
transactionType="X" units="8439.28"
voucherNumber="6825485EXT_SERVNL3I280418"/></Transactions></NikuDataBus></SOAP-ENV:Body></SOAP-ENV:Envelope>

java.lang.Exception:  Project with code 0000076311 does not exist. Please specify a valid project code.

This project is available in the application but still giving the error.

Please let us know what could be the reason.

Thanks,

Pragya SIngh

Is the project financially enabled and financially active?

Here's a screen shot of 2 transactions that I created using an Excel-to-XML converter I built.  Both uploaded without error.  Some suggestions:

1) Don't use the Project ID as the Group ID.  Create a non-intelligent sequential counter for the Group ID.  Note that mine are 1000000 and 1000100 for the two transactions.

2) Populate External ID with some value.  Again, the last part is a sequential counter (10000 and 10001).  I use that same value for External ID and Voucher Number.

3) I don't think you need the Import Status value.

4) I use Unit = 1 and Actual Cost Rate = {the value} instead of the other way around.

Hope this helps!  Good luck. -- Alan

We set the groupID to a constant numeric value (don't know if it has to be a numeric value, just what was used in the GEL script).  In our case, it didn't have to be sequential, it was set to 1234 for all transactions.