How to generate one invoice number by uploading multiple line items relating to the same invoice, through the App “Import Supplier Invoices”

[Former Member]

Hi Team,

By using the App “Import Supplier Invoices” we can import multiple supplier invoices into the system all at once. After uploading system considering all the line items as invoices and generating multiple invoice numbers.

Let’s say an example, we have one invoice from Taxi ABC and there are 50 lines where costs are being allocated to 50 different projects. If we use the upload template, then system is considering 50 lines and ultimately 50 invoice numbers are getting generated.

Requirement:

1)    1) Instead of generating 50 invoices, system could be able to generate only one invoice?

2)   2)  Is there any possibility to generate workflow for Supplier invoices? If so, how a workflow would work with the generation of many invoices.

PlThanks & Regards,

KKartheeka

[David_Byrne · Accepted solution]

Hi

Yes you can have mulitple lines in an invoice in the Import Supplier Invoices app. the document number is controlled by the Invoice ID column in the template so for the same invoice they would have the same invoice ID for each line.

to give the example attached I have create a template with 2 document and 2 lines for each. when I post this template the program creates 2 invoices not 4 as the invoice ID for each document is the same for both lines.

in answer to your second question yes documents in this app are taken into workflow if saved

Hope this helps

David

[dasenw · Accepted solution]

Hi David, Thank you, this is very helpful - another question for you. Is it possible within the template to use different company codes? For instance, we receive invoices that cover multiple offices (different regions of the world) that are in different company codes/profit centers. when I try and do this manually, I get an error regarding different tax jurisdictions [I'm very new to SAP, so please excuse my user error 🙂 ]

Thank you,

Dasen

[dasenw · Accepted solution]

Great, thank you David. We will definitely be testing this.

[David_Byrne · Accepted solution]

Hi Dasen

To be honest I have never tested this but cross company code journals are possible so may work. there are some limitation and particularly for posting across different countries is not allowed if VAT is included

Would need to be tested to confirm

David

[Arturo_P · Accepted solution]

Thanks!

[former_member787724]

I have the same question... Did you solve this issue? Thanks!