on 06-12-2015 7:52 PM
I've been for a while trying to update the UDF of an outgoing payment using SAP B1 IF.
I have no problems with ingoing payments, I just use:
<DocType>rCustomer</DocType>
<DocEntry>MyDocEntry</DocEntry>
<U_MY_UDF>Something</U_MY_UDF>
If I delete the DocType tag it also works on ingoing payments, but there's no way I can manage it on outgoing ones, i use rSupplier but it throws me errors. What am i doing wrong?
Thank you.
Hi,
Could you give more information, for example which error while occur?
Are the settings in the SBO-atom correct?
What did you tried already?
Best Regards
Teun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My transformation atom looks like this:
<Payments>
<row>
<DocType>rSupplier</DocType>
<DocEntry><xsl:value-of.....></DocEntry>
<U_LAST_EXPORT><xsl:value-of...></U_LAST_EXPORT>
</row>
</Payments>
I'm sending this:
<UpdateOutPayment>
<DocEntry>905</DocEntry>
<LastExport>2015-06-12 12:00:00</LastExport>
</UpdateOutPayment>
And the error is this:
Exception : DI Error: (-10) Busines partner type does not match document.
Then, i add the CardCode in the atom:
<CardCode><xsl:value-of...></CardCode>
And send the corresponding card code, and the error is this:
Exception : DI Error: (-1029) [ORCT.DocType] , 'Field cannot be updated (ODBC -1029)'
But I need to set the DocType in the atom, otherwise it updates the ingoing payment with that DocEntry and I need to update the outgoing one.
That's what I'm struggling with.
Thank you in advance.
Hi Felipe,
use in the SBO-atom the method "update", and in your XML only use the udf, no other fields. Because else the atom is trying to update also those fields, which is your error.
Use the correct value as the "Key Value" in the SBO-atom (DocEntry) and also the correct "Key Name" of course.
This should work, also try to update the field manually in the SBO-gui, if this works it should also work in B1i.
If this doesn't work post an picture of SBO-atom.
Best Regards Teun
Hi Teun,
Thank you for your answer, unfortunately it didn't work, i mean, IT WORKED, but not as I expected, it updated the INGOING PAYMENT, and I need to update the OUTGOING one, so I think I need to set the DocType anywhere else, or to set another document number rather than 24.
Any other suggestion?
Thank you so much.
Hi,
Can you please tell us which error your are facing ?
Thanks,
Tushar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.