I love Excel! Who doesn’t, right? As an accountant, I live in Excel. This is the easiest place for me to track and create Journal Entries. But after all that work, how do we get it into our accounting system, Microsoft Dynamics GP? Easy, we just ‘Paste’ the entry. Simple, I know.
GP Life Hack #103
Dynamics GP offers the cool functionality of pasting in copied data from Excel. This includes distribution reference, the GL Account number, Debit Amount and the Credit Amount: