Summary
Learn about the process of transforming for import into MindBridge a general ledger file exported from Sage 300 ERP.
Notes/Prerequisites
This guide assumes that you have exported a CSV file from Sage 300 ERP in the following format, as detailed in the Sage 300 ERP: Export the general ledger guide.
Transform the data
The problem
The exported file does not contain any column headers, which might cause issues during ingestion into MindBridge.
The solution
Remove the empty columns and add the first row with the column headers as shown below:
- Account Number
- Description
- Year
- Prd.
- Source
- Doc. Date
- Reference
- Posting seq.
- Batch-Entry
- Debits
- Credits
- Second Reference
The formatted file should look like this:
Your file does not require any additional formatting and is ready to be imported into MindBridge.
Previous step: Sage 300 ERP: Export the general ledger
Next step: Sage 300 ERP: Import the general ledger into MindBridge
What do you think of this guide? If you have any feedback, or you think you can help us improve it, then we would love to hear from you! Let us know if this article was helpful or not below. We are offering rewards for any information that leads to the improvement of a guide or the creation of a new one.
Anything else on your mind? Chat with us or submit a request for further assistance.