We load invoices to IFS using the external customer invoice load assisant.
However, we have an issue were we have invoices with 2 rows (Product line and charge line). It doesnt like as it sees the invoice ID on there twice and gives an error.
Is there a way of uploading the rows but having the same invoice ID?
Thanks
Best answer by MKG019
Hi,
It works with item id and row id combination (in template details ) i.e. if you have 2 invoice & posting line you can add item id 1 and 2 in two line and keep Row id empty and if you have 1 invoice line and multiple posting line you can add item id 1 and in Row id 1, 2,3 respectively till posting gets balanced.
Attach is one example of 2 invoice line and posting line sample file.
Regards,
Mukesh Gupta
+13What File template and record type file you are using, HIPT or A type.
If you are using A type record then in the file template "Allow Multiple line" create detail function set as default TRUE or pass the same TRUE in input file and then upload the file.
If you are using HIPT then based on I line item id you will be able to create the posting P and Tax T line easily.
Regards,
Mukesh Gupta
+13Go to detail tab
+13see the attached file with sample data
+13Few corrections sample file is of Supplier Invoice and not of Customer Invoice.
Regards,
Mukesh
Okay i followed the same setup, added the MULTIPLE_LINES_ALLOWED in the template:
But still when load the file, the 2nd lines are ignored giving me a single line invoice.
Does there need to be a ROW ID in the input file?
+13Hi,
It works with item id and row id combination (in template details ) i.e. if you have 2 invoice & posting line you can add item id 1 and 2 in two line and keep Row id empty and if you have 1 invoice line and multiple posting line you can add item id 1 and in Row id 1, 2,3 respectively till posting gets balanced.
Attach is one example of 2 invoice line and posting line sample file.
Regards,
Mukesh Gupta
Thanks for your help. I now have an issue where the invoice header takes the first line from my input file, ignores the second line (Same INVOICE, different ROW ID)
Am i able to do this as part of a function??
Dont worry, my mistake i found that i was using ROW ID when i should have been using ITEM ID!
Thanks for your help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
