Copy and Paste from Excel

< Back
You are here:

Starting with AIT for GP2013R2, you can copy an Excel spreadsheet and paste it into a Journal Entry or a Payables Voucher.  For a Journal Entry, you can paste into either a standard  or AIT transaction, in case you do not need to paste intercompany distributions. You should be aware of some of the differences between AIT and GP in the copy and paste feature:

– For AIT the column format in the spreadsheet for an intercompany transaction is as follows:

1. Company
2. Account (fully formatted)
3. Debit Amount
4. Credit Amount
5. Distribution Reference
6. Originating Due From/To Account (GL only, build 12.0m065 or higher)
7. Destination Due From/To Account (GL only, build 12.0m065 or higher)

Note: 5, 6 and 7 are optional. If you do not have those columns in your spreadsheet, your selected worksheet area need only be 4 columns wide.  6 and 7 are necessary only if you want a Due From/To Account that is different from the default.

– For AIT the column format in the spreadsheet for a standard transaction is as follows:

1. Account (fully formatted)
2. Debit Amount
3. Credit Amount
4. Distribution Reference

– Standard transactions cannot be in another currency (this is a limitation from Microsoft, not us).
– AIT transactions can be multicurrency, but the Debit and Credit amounts must be in the functional currency.
– Pasting will add distributions to an existing transaction, so if you want to redo your paste, delete the currently displayed transaction.

Note: 4 is optional. If you do not have those columns in your spreadsheet, your selected worksheet area need only be 4 columns wide.