What 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

Great sounds good

Am currently using A type

Where do i find the ‘Allow Multiple Line’ function?

Go to detail tab 

see the attached file with sample data

Few 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?

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

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