Update AR Credit Memo Cancellation Document thru DTW

[leanjohn]

Hi All,

Does anyone encounter this error is DTW when Updating fields of posted ar credit memo cancellation document : 1 Update Failed '14' is not a valid value for property 'BaseDocType'. The valid values are: '-1' - '', '0' - '', '16' - 'A/R Returns', '13' - 'A/R Invoice', '203' - 'A/R Down Payment' '14' is not a valid value for property 'BaseDocType'. The valid values are: '-1' - '', '0' - '', '16' - 'A/R Returns', '13' - 'A/R Invoice', '203' - 'A/R Down Payment'65171

How can we template this update to be successful. Sap version 9.3 PL 05

Thanks!

Lean

[neilos]

Hello John,

Doc type 14 is an A/R Credit Memo. So it can't have a A/R credit memo as an A/R credit memo base document.

What document are you trying to use as it's base?
-1 means it doesn't have one, so it is just a credit memo for a BP with no other transactional documents linked to it.
13 is an A/R invoice
These two are 'usually' the more common.
If you know the document and what type it is, you can look up the type number here - https://blogs.sap.com/2017/04/27/list-of-object-types/

Neil

[leanjohn]

Hi Neil,

I'm updating the Cancellation Document for AR Credit Memo therefore its base document is AR Credit Memo also which is 14.

Also on my update file only the DocNum and 1 UDF field only. For regular posted AR CM it is okay, just the cancellation document has a problem.

Regards,
Lean

[neilos]

Right, I didn't digest the question fully.
I'm not 100% sure, but I would expect in that case for the A/R Credit Memo to have the status of cancelled, which will have the BaseDocType unchanged, when cancelling it creates a new document number, the base type for this new document will be -1.

I have done a quick test for this. See table below;

Numerator | Document Number | Document Type | Cancelled | Manual Numbering | Base Document Type

1083 | 924 | I | N | N | 13 - This is the control test of a closed document

1082 | 923 | I | Y | N | 13 - This is the Original memo that has been cancelled

1091 | 932 | I | C | N | -1 - This is the The cancelled document

I cancelled number 923, which created doc 932. Base type for the cancelled is -1 as you can see.
Also getting doc 924 to show an unchanged document.

Hope that helps, the link for the document will be the BaseRef and BaseKey a in a usual document.

If you want more details of the documents, let me know and I'll post more details.

Neil

Edit formatting

[leanjohn]

Hi Neil,

Thanks for confirming. So why does DTW blocking me to update the Cancellation Document (in your testing Doc Number 932).

Do I have to add something on the DTW Template? There were No BaseType on ORIN. I'm jus updating a header UDF.

Regards,
Lean