GP #LifeHacks 103: Track JE’s in #Excel – Paste into GP

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:

1

GP Life Hack #103 … click to see original posting

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s