SEPA XML <Ustrd> blank when more than 4 invoices for one vendor

[Former Member]

We are having trouble with our SEPA payments when one vendor has more than 4 invoices.  From 1 to 4 invoices, the XML file is just fine.  As soon as the 5th invoice is added to the payment run, the Ustrd field is blanked out and no data is sent.

With four invoices:

Once I add the 5th:

I tried adding a 5th line in OBPM2, that didn't work.

I also tried adding a level 4 to the DMEE tree with no luck either.

The field is set to 140 characters and I don't come close to that even with 5 invoices so it's not running out of characters.

I have a question out to the business as to why they run separate FB60 runs for each invoice rather than adding them all to the same run.  I am guessing it is because the vendor requires the separate references so they know which invoices are being paid.

Thanks much,
Andrea

[Former Member · Accepted solution]

I understand that SAP reserves 35 characters for each invoice processed.  When I get past 4 invoices, the limit of 140 characters is exceeded and I get no characters in teh Ustrd field.

Is there a way to change the reserved character amount?  We would never use 35 for one invoice.

If not, is there any way to get the reference from all invoices, even when there is more than 4?  Our vendors need this information to reconcile which invoices are being paid when more than one is included in the payment.

Thank you.

[ajaycwa1981 · Accepted solution]

Hi Andrea

We faced exactly the same issue last week and we could resolve it

We set the ustrd field to level 4, earlier it was level 3.

In obpm1, header tab, we included level 4 and set the no of fields to 99999 against level 4

The length of note to payee in obpm1 was left to 35. But you can change it. We made the no of fields to 999 here, earlier it was 4.

The length of ustrd was left as 140 I guess. I can check and confirm this tomorrow

Please check on the above lines and let me know. Rest assured there is a solution and it will be fixed.

Trust me 😉

Ajay M

[ajaycwa1981 · Accepted solution]

Hi

One small change. Length of ustrd was changed to 9999 from 140, but after taking confirmation from Bank that they can accept more than 140

Ajay M

[Former Member · Accepted solution]

Thank you for the suggestions!  I am now seeing this:  four of the entries repeated 4 times in the XML.  There should be five entries and only on Ustrd field.  What did I do incorrectly?

[ajaycwa1981 · Accepted solution]

Hi Andrea

Could not understand you.

Can you tell what changes you did now? And can you give a screenshot of the settings I mentioned in my earlier reply

Ajay M

[ajaycwa1981 · Accepted solution]

I got your point. You are saying 4 invoices are appearing now, but they are repeating 5 times

Even the 4th invoice no is truncated at 2014 because 35 length is consumed. In our case, one invoice no appears in one line. The 5 lines are coming because you have 5 invoices.

Let me also think in this when I reach office tomorrow.

Ajay M

[Former Member · Accepted solution]

There are four entries, repeated 5 times.  There were 5 different invoices in the payment.

In the XML there are four references repeated 5 times.

There were 5 payments in the run, I expected to see the reference for each in one Ustrd field, not four of them repeated 5 times.

DMEE:

I made the field length 350 rather than 999

[ajaycwa1981 · Accepted solution]

Hi

We have length of 35 instead of 350 and the no of fields as 999 instead of 4

Also under ustrd, we have reference 1, reference 2 and so on. Ref 1 has length of 35 and offset 0. Ref 2 has length of 35 and offset 35. Ref 3 has length 35 and offset 70....

You can try with length of 9 and offset as 0, 9,18 and so on

[Former Member · Accepted solution]

We have four REFERENCE fields under Ustrd.  I added a 5th and included the offset (using length 20), same result, four references are repeated 5 times.  😞

I feel we're very close just can't see to get there!

[ajaycwa1981 · Accepted solution]

Hi

Did you change the no of fields to 999 instead of 4 in the above screen shot

Ajay M

[ajaycwa1981 · Accepted solution]

Hi Andrea

I further checked in our system...

1. We faced the same issue of the tag repeating when RmtInf was Level 3 and USTRD was Level 4..

To address this, we changed both to Level 4... After that the tag did not repeat

2. If you want to have the 5 tags (invoices) in one line, then you can have 5 REFERENCE fields Under Ustrd, the way you have now

If you want to have one invoice in each line, then dont have any REFERENCE field under Ustrd.. We dont have any fields under Ustrd as shown below

I suggest you try with 5 Reference fields Under Ustrd and it will give you 5 invoices in one line, the way it was giving when you had 4 invoices

3. Our Source of filling note to payee is User Exit, because we had a custom requirement.. I am not sure if the user exit is populating / displaying one invoice per line... But my guess is user exit has no role to play in it... It depends on the Pt 2 above

4. Our Note to Payee config in OBPM1 is this

5. And OBPM2 has only one line in it... Not 4 or 5 the way you said in your original post.. however, in our case, OBPM2 has no role because we have used user exit

Try with these and please do let us know if the above answer is Correct... This is the 1st time i am venturing into this, so would like to know if the answer is CORRECT

Br, Ajay M

[Former Member · Accepted solution]

OK, I changed RmtInf to level 4 as well as Ustrd and I have 5 REFERENCE fields.

I left OBPM2 alone for now, both level 1 and 4.

I am getting the same result.  The same text repeated five times and missing one of the five references from the invoices.

I will try removing the 5 reference entries in DMEE and see what that does.  It looks like I am still bumping into the 140 character limit on the Ustrd field

[ajaycwa1981 · Accepted solution]

Hi

Refer point no 4 in my reply and the screen shot.. It has 32 as length and 999 as the field.. Have you maintained the same?

Also, if you want one iinvoice in each line, my colleague says, then the reference fields are not needed under Ustrd.. In this case, Rmt Inf and Ustrd must be Level 4

If you want all invoices in one line, then you can have REF fields under ustrd and in that case RmtInf and Ustrd can have Level 3

Br. Ajay M

[Former Member · Accepted solution]

Yes, I have field length 35 and number of fields as 999.

The bank required all references in one field.  I had both RmtInf and Ustrd at Level 3 when I started all of this (with the reference fields under Ustrd) and I only gpt the reference from four of the five invoices in that one line.  So what you suggest gets me back to where I was when the problem started.

What do I need to do to make SAP allow more information in the Ustrd field?

Updating the field length and number of fields to 25 and 999 in OBPM1 did not work.

Adding a level 4 and assigning it to Ustrd did not work.

Adding level 4 to RmtInf did not work.

Adding another REFERENCE under Ustrd and using an offset did not work.

I just can't seem to get SAP to allow more information in that field.  My guess is that the reservation of 35 spaces per invoice is still the issue.  Once I hit 5, 5x35 is 175 which is over the 170 limit allowed for SEPA.

Which user exit was used to customize this?  Maybe that's what we need to do?

Andrea

[Former Member · Accepted solution]

It's working!  I think I forgot to activate the DMEE the last time I changed it!

Thank you all for your help!

Andrea

[ajaycwa1981 · Accepted solution]

That's. Awesummmmmmm

So what's the final outcome - 5 invoices in one line or 1 per line????

And what were the final settings that worked in terms of

level for RmtInf and ustrd (3 or 4??)

And the no of field for note to payees in obpm1 and length (35/999 or something else)

No of ref fields under ustrd??

Length of ustrd - 140????

Ajay M

[Former Member · Accepted solution]

5 (and then 6) invoices in one line

RmtINF and Ustrd both at level 3

No of fields/length at 35 and 999

Six reference fields under Ustrd (started with 5, that worked, upped to six)

Ustrd is at 140

[Former Member · Accepted solution]

Hi Ajay,

I am trying to set up the note to payee as yours but I am getting, for example:

2 invocies paid and they both come in 2 ustrd tags 2 times, like in Andrea`s case the 5 invoices

Meanning I need one invoice per row (ustrd tag) in the xml.

I checked all your posts above and did the same customizing but maybe I`m missing something.

OBPM1 it is like yours

OBPM2 it should have no impact but I only have this line in it "INV/RE &FPAYP-XBLNR&"

in DME I have created another level 4 - 9999999 repetition factors

I changed RmtInf and UStrd to level 4 and lenght as in your printscreen.

Furthermore I deleted the 4 references under UStrd, here I got an error: since Ustrd had "Own mapping" and "atom handling 01" it issued a messege saying that the Ustrd has no atoms, I deleted the references -  What is that you choosed here for the UStrd Mapping procedure?

Could you please guid me?

Thank you in advance

Peter

[Former Member]

Hi All,

  I require following  format to populate remittance information in XML file, DMEE through User Exit.

Eg: 1

Eg: 2

but printing multiple Invoices following method in XML file format which is not supposed..

Both Rmtinf and Ustrd Level made as 4

<RmtInf>

  <Ustrd>

              Invoice 1.

RmtInf>

<Ustrd>

              Invoice 2.

RmtInf>

<Ustrd>

              Invoice 3.

RmtInf>

<Ustrd>

              Invoice 4

Eg: 3

if i changing Remittance information Level as 3 & Ustrd as 4

Here, getting expected output... but the last invoice printing twice in XML file in multiple cases.

<RmtInf>

  <Ustrd>

              Invoice 1.

              Invoice 2

              Invoice 3

              Invoice 4

              Invoice 4

RmtInf>

I require to print the Eg;1 method. 

Please advice to get result.

Thanks

Ram