Excel GL copy paste Dynamics GP
Process to copy and paste GL entry from excel to GL.
- Open the GL entry Transaction
- Enter your Transaction reference
- Prepare your excel file data respecting the format below. (you could use smartlist to export account with their description)
| Account Description | Account Number | Debit Amount | Credit Amount |
| Accounts Receivable | 000-1200-00 | $ – | $ 25,200.18 |
| Inventory – Retail/Parts | 000-1300-01 | $ 8,935.41 | $ – |
| Inventory – Finished Goods | 000-1300-02 | $ 3,135.95 | $ – |
| Commissions Payable | 000-2120-00 | $ 706.55 | $ – |
| IL State Sales Tax Payable | 000-2300-00 | $ 1,413.10 | $ – |
| Chicago City Sales Tax Payable | 000-2310-00 | $ 235.51 | $ – |
| US Sales – Retail/Parts | 000-4110-01 | $ 17,852.96 | $ – |
| US Sales – Finished Goods | 000-4110-02 | $ 5,698.61 | $ – |
| Cost of Goods Sold – Retail/Parts | 000-4510-01 | $ – | $ 8,935.41 |
| Cost of Goods Sold – Finished Goods | 000-4510-02 | $ – | $ 3,135.95 |
| Commissions – Sales | 300-5130-00 | $ – | $ 706.55 |
- Select and Copy from Excel data without the Header Line
- Click on the Excel button to past the data
Notes :
- The transaction in question should be balanced. GP will allow you to import data unbalanced but will never let you post it as unbalanced… good control from GP.
- If for any reason, there are errors, GP will print a validation report for you that show some messages that help you troubleshoot the error.
hope that helps and Contact-us for one hour Free consultation on how to use better your Dynamics GP.