Auto Repeat Sales Invoice Schedule Job Not Run in ASC Sequence

[edwardleehl7097]

Information about bug

Sales Invoice Auto Repeat created in sequence for example:
AUT-RP-0001 ====> INV2210001 (Ref Doc)
AUT-RP-0002 ====> INV2210002 (Ref Doc)
AUT-RP-0003 ====> INV2210003 (Ref Doc)
AUT-RP-0004 ====> INV2210004 (Ref Doc)
AUT-RP-0005 ====> INV2210005 (Ref Doc)
The above setup on Oct and the auto repeat schedule is set to 1st of Monthly.

After the Auto Repeat Schedule completed the schedule task. The result of Sales invoice create as below:
AUT-RP-0005 ====> INV2210005 (Ref Doc) ====> INV2211001 (New Invoice Generated)
AUT-RP-0004 ====> INV2210004 (Ref Doc) ====> INV2211002 (New Invoice Generated)
AUT-RP-0003 ====> INV2210003 (Ref Doc) ====> INV2211003 (New Invoice Generated)
AUT-RP-0002 ====> INV2210002 (Ref Doc) ====> INV2211004 (New Invoice Generated)
AUT-RP-0001 ====> INV2210001 (Ref Doc) ====> INV2211005 (New Invoice Generated)

The Sales Invoice Generated in opposite way in numbering, instead of follow the ASC Sequence. Anyone can help to fix this?

Module

Accounting

Version

ERPNext: v14.4.0 (version-14)
Frappe Framework: v14.13.0 (version-14)
Frappe HR: v1.0.0 (develop)
Payments: v0.0.1 (develop)

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

No response

[edwardleehl7097]

Anyone can help?

[edwardleehl7097]

anyone can help on this?