Sage 50 Accounts: I want to import sale invoice data of different customers containing the information as mentioned in the table below. The information of different customers will remain in a single excel sheet which I want to import in together.

Currently, I input the data individually for each customer using the path: Invoices and Credits>Product Invoice>Details. This individual data input is cumbersome for hundreds of data. I have tried to import the data using the Audit Trail Transactions. But Audit Trail Transactions format and the mapping does not match the required field as mentioned below in the table.

How can I solve my problem. Or is there any other way to handle the issue.

May I request to please help me.

Thanks in advance.

Mohammad Ali