Your post is confusing. When using Batch Create, nothing is fetched or retrieved from any database. The Batch Create function allows you to enter data, not use data already present.
Thank you for your response. Allow me to clarify the issue:
When I copy data from a spreadsheet and paste it into the text field, and then click on Batch Create, all data gets inserted as expected, except for the Supplier and Account fields. Although both ledgers are already added to the manager, they are not being recognized or inserted during this process.
I hope this explanation helps in identifying the issue. Looking forward to your guidance.
You either use UUIDs or since recent versions the Codefor the Suppliers before pasting the spreadsheet data back into Manager Batch Create (I agree with @Tut that you are confusing us what you are doing)
Do not just tell us a feature does not work. Explain what you have done and why you think there is an issue. If your question relates to an apparent software problem (rather than an accounting topic), tell us your operating system (including the version), Manager edition (desktop, server, or cloud), and exactly what you think is wrong. If possible, post screen shots illustrating the problem.
Thank you for the clarification regarding using the Codefor the Suppliers. It resolved the issue with the Supplier field successfully. However, the problem with the Account field still persists, as it is not being recognized even after ensuring that the ledger exists in the manager.
I am attaching a screenshot for your reference. As marked in green, the Supplier field worked correctly, but the Account field (highlighted in red) is still not being added.