Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2014 at 05:16 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ajay Maheshwari

      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

  • author's profile photo Former Member
    Former Member
    Posted on Nov 06, 2015 at 08:24 AM

    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


    pastedImage_0.png (47.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.