Skip to main content

Posts

How to Specify Default Purchase Account for Vendors in Microsoft Dynamics GP

Microsoft Dynamics GP allows user to setup a set of default account codes to be selected during transaction entry. This will come in handy if non-account staff will need to record purchase transaction in Payable Transaction Entry, as this will eliminate user from selecting the wrong accounts code from the Chart of Account list. This can be set up  on a per-vendor basis so each transaction you enter can use different posting accounts according to your needs. Path: Cards > Vendor > Accounts    1.     Enter or change the default posting accounts in <Purchase>.    2.     Choose the Purchases ellipses button to open the Additional Vendor Accounts window.     3.     Enter the additional purchase accounts to use for this vendor. Select default purchase accounts. During transaction entry, each account you marked to appear as the default value for transactions appears in the Payables Transaction Entry Distribution window.    4.     Choose <OK&g
Recent posts

Microsoft Dynamics GP 4 Tips and Tricks for Month End Closing

Having lost don't know whether you have completed all the task in Dynamics GP during month end closing? Follow the top 5 tricks below to counter check all your account is in order.    1.     Has all the batches in Purchasing Module, Sales Module, Fixed Asset and last by not least, Financial Module posted? You may have a quick check using "Master Posting". This screen allows to post multiple batches from different modules. Path: MSDGP > Tools > Routines > Master Posting    2.     Have you make sure all the sub-ledgers tally to GL control account? You can print out the Historical Aged Trial Balance from Purchasing or Sales to match against the GL control account in Financial Trial Balance. Alternatively, you may use the "Reconcile To GL" tools which available in Dynamics GP all version. Just enter the parameter and the modules that you are comparing, Dynamics GP will match the document automatically and generate the result in Excel. For more in

Hello April!

Boy it was a busy schedule in March. The most exiting event that happen in March is we managed to attend "Dynamics 365 Business Central Training for Finance, Trade and Logistics" held in Singapore. Many great feature were found available in Business Central which include raising sales order from Outlook to increase revenue opportunities or your can even approve expenses from your phone which optimize company operations. For more info about Business Central, feel free to visit the following link to get an overview how Business Central can connect to your business and helps you makes smarter decisions. https://dynamics.microsoft.com/en-my/business-central/overview/

Target date's fiscal year may not be greater than the current fiscal year for the selected book

We do get a lot of question asked why they are not able to perform fixed asset depreciation with the following message shown " Target date's fiscal year may not be greater than the current fiscal year for the selected book ".  The message happens when user are doing their first depreciation in the new financial year. What missing here is user did not perform Fixed Asset Year End Processing, although they have done the Financial Year End processing in Dynamics GP. Take note that Financial Year End processing doesn't include Fixed Asset module, it need to done separately. To perform Fixed Asset Year End Processing:- Path: MSDGP > Tools > Routines > Fixed Asset > Year End    i.     Select the book that sitting in "Available Books", and "Insert >>" to the "Selected Books".    ii.     Select "Continue" to proceed on the year end processing for fixed asset.    iii.    This process should takes around 3 to

The Customer/Vendor Consolidation setup information is missing or damaged

This message "The Customer/Vendor Consolidation setup information is missing or damaged" normally indicates the the Customer/Vendor Consolidation is not configured. To tackle this, you need to enter the "Default Suspense Account" in the Customer/Vendor Consolidation Setup. Path: MSDGP > Tools > Setup > Company > Customer Vendor Setup For more info on the Customer/Vendor Consolidation Setup, you may refer to one of our written blog follow by this link " Save time by setting up Customer/Vendor Consolidations in Dynamics GP ".  Save time by setting up Customer/Vendor Consolidations in Dynamics GP

I Believe That ...

Embed from Getty Images “Don’t chase people. Be yourself, do your own thing and work hard. The right people – the ones who really belong in your life – will come to you. And stay.”   – Will Smith -