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

How do I modify invoice request xml file by adding posting date?


Hi,

We import customer invoice requests via xml files from an external data source. Currently the standard SAP xml file does not include the posting date, and invoices enter SAP with a blank posting date. When the invoice is released, the posting date is taken from the invoice date.

Due to our month end processes, we have hundreds of invoice requests every month where we do not want posting date to equal the invoice date, and for each of those invoices the posting date is manually entered one invoice at a time during the release process. This is very time consuming.

We would like to build functionality in our external system to create the posting date at the xml file generation stage. Could anyone let us know the following:

- what is the name of the posting date field on invoice requests (invoice documents)?

- where would we place the additional script in the xml file?

I'm attaching one of our current xml files (which already contains one section that has been customized)

Your suggestions would be appreciated.

Thanks,

Kerstin

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2014 at 11:01 PM

    Kerstin,

    The closest i could find in the WSDL of the Manage Invoice Request Web Service that handles this integration is "<ProposedInvoiceDate>" or possibly even "<ProposedDeviatingPostingdate>", both of which sit directly under the <CustomerInvoiceRequest> element.

    For more information, go to the Service Explorer, find the ManageInvoiceRequestsIn Web Service, download the WSDL, and open it in SOAP-UI or something similar. This way you can see all the fields that you can write to, which is where i found these two elements.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dan, thanks so much for your suggestions!


      <ProposedDeviatingPostingdate> is indeed the right name for Posting Date in Invoice Requests. I further realized, after downloading the WSDL, that this name is case sensitive, and was able to import the posting date by calling it <ProposedDeviatingPostingDate>.

      Kerstin

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2014 at 07:31 PM

    Please note that it is the section handling Region Code that is customized in the existing xml file

    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.