Hello all,
I have a scenario where I have a GI with thousands in lines in acumatica and I would like to import those lines on automation basis. So I would like to import 100 lines under one schedule/one go. How can I do so?
Solved
Restriction to apply to the # of records to be imported
Best answer by hsethia25
hi
Hope this helps!!
In the GI, you should set the Select Top value as 100:
This way, the GI will not show more than 100 records.
It may be worth ensuring there is some sort of flag to determine whether the rows have been processed, if not, it may duplicate the processing.
+7
Limit the GI to 100 Records
- Set the GI Top Records = 100.
- Sort by a unique field (such as CreatedDateTime or NoteID).
However, unless the imported records are excluded afterward (for example, by updating a processed flag), the same 100 records will be imported repeatedly.
Use Automation Schedule with Multiple GIs
Create multiple GIs using ranges, for example:
- GI1: IDs 1–100
- GI2: IDs 101–200
- GI3: IDs 201–300
Then create separate Automation Schedules for each GI.
hi
Hope this helps!!
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.