As an alternative to using the Transfer to Accounting button in GL Batch Process, you can create a file layout that matches the Sage 300 file specifications. The File Layout can then be used to export the GL batch to a CSV file to be imported into Sage 300.
Create a File Layout for Sage 300
Go to General Ledger Integration, Maintenance, Batches, GL File Layout.
Select Add.
Enter a File Layout Code.
Enter a Description
Select the Header 1 tab and click Delete Selected Row.
Then select the Footer 1 tab and click Delete Selected Row.
On the Detail 1 tab, select the field in Source List and use the green right single button to add to the Destination List, for the following:
Ledger_Account
Amount
Ledger_Account_Description
Reference
Use the blue up and down buttons to sort the fields, as specified above, in the Destination List.
Click on the File Detail tab. Enter the Name of Output File. This is the name that is used when the batch file is generated.
Enter CSV as the Extension of Output File.
Enter the Path of Output File. This is the location where the batch file is saved. You can use the Browse button to locate.
Select an option in Action if file exists. The value selected here determines what happens when a new batch file is generated, but a previous copy exists. You can choose from:
Overwrite file
Append to file
Append date & time to file name
Append count to file name
Always Append Date & Time to file name
Always append count to file name
In File Format, choose CSV (comma separated values).
Select Item Specific (Padchar used with no default) as Field Width.
Click OK to save the File Layout.
Attach the Batch Layout to your Batch
Go to General Ledger Integration, Maintenance, Batches, Batches.
Edit the batch.
Select the Sage 300 File Layout in File Layout.
Click OK to save.
After you have processed the GL batch in General Ledger Integration, Transactions, Batch Process, rather than using Transfer to Accounting, click Generate File. This will produce a CSV file according to your Batch File Layout, which can be imported into Sage 300.