As a Dynamics GP consultant, when I see Dynamics users [...]
One of our Dynamics GP users said, “For years I [...]
It used to be that office walls were lined with [...]
How do you track your fixed assets? The Manual Way [...]
Getting more checks in the mail is a good thing [...]
How do you send online payments? There is an easy, [...]
Check fraud is a big issue, and banks have put [...]
Microsoft Dynamics GP with Excel Tip: How to Copy/Paste GL Transactions from Excel to Microsoft Dynamics GP in 4 Easy Steps
Using Microsoft Dynamics GP and Excel are a powerful combination for any finance team. Many of our clients are asking about the steps to copy and paste General Ledger transactions from Excel into Dynamics GP. Here is the process in four simple steps.
One of our clients ran depreciation on Fixed Assets and then the General Ledger posting routine. She realized that some of the assets were set up incorrectly and she needed to make changes on the Fixed Asset book setup.
The posting type determines how the account balance will be treated during the year-end closing process in General Ledger in Microsoft Dynamics GP. Balance sheet accounts will be rolled forward to the next year, and Profit and Loss accounts will be rolled into the Retained Earnings account.
When your A/P, A/Record or cash sub ledgers don’t match your General Ledger, the GL reconcile can show you where you have missing or “unmatched” transactions.
Once you export your General Ledger report from Microsoft Dynamics GP to Microsoft Excel there is so much you can do with it. This video will show you a few helpful tricks around pivot tables. Pivot tables are the best way to summarize large amounts of data and focus on the information you need.
Download and Print: Using the Account Rollup Inquiry Screen to [...]
Download and Print: Microsoft Dynamics GP-Import/Export a Blank Budget [...]
STEP 1: Open SmartList. STEP 2: Click on Account Transactions [...]