You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Integration-To reject duplicate records from the file

edited Jun 25, 2020 3:53PM in Integration 9 comments

Content

My requirement is that I am getting the header and line details in a single file for AP invoice creation. Like in this format.

BusinessUnit,LegalEntityName,InvoiceNumber,Currency,InvoiceAmount,TransactionDate,InvoiceDescription,PaymentTerms,ItemNumber,LineExpenseAmount,LineDescription,Company,NominalAccount,CostCenter
UK Operations,UK Operations,INV-90909,GBP,989,2020-06-12,Standard unmatched Invoice,Immediate,10,989,Standard Line,P1010,0001,CC00000
UK Operations,UK Operations,INV-90910,GBP,1020,2020-06-14,Standard unmatched Invoice,Immediate,10,990,Standard Line,P1010,0001,CC00000
UK Operations,UK Operations,INV-90910,GBP,1020,2020-06-14,Standard unmatched Invoice,Immediate,11,30,Standard Line,P1010,0001,CC00000

 

Problem is that for multiple lines, the same header information is also repeated in the file. And I have to create two separate files for Header and Line in AIC. So how can I reject those repeating Header information in AIC. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!