Auto Invoice Grouping Rule for Web ADI - when Transaction Numbering is Automatic
Hi,
we are able upload and create Invoices by creating the custom layout, code etc.
We are using the Source, transaction type, Line Number and Line Description fields (Line Transaction Flexfield) to identify unique (separate) lines.
The problem is to identify 'Separate Invoices' in a single upload.
As Transaction Numbering is Automatic, transaction number is generated when the Invoices is generated. So we cannot use that field in the Grouping Rule.
So the question is how to create separate invoices when the Transaction numbering is Automatic.??
We should be able to upload Invoices having same source, transaction type, gl date, transaction date, customer, customer location, terms etc. (all the fields in the Layout are same), there might difference only in the quantity and price fields.