Skip to main content

Posts

Showing posts from February, 2019

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 -

Changing Sales Invoice Aging Due Date

There is a useful feature in Microsoft Dynamics GP where user able to change sales invoice aging due date using "Edit Receivable Transaction". Refer to the sample below how an Invoice with 30 Days terms extended to 50 Days.    1.      Following invoice “INV0001” is issued on 1st Feb 2019, with 30 Days payment terms, invoice will due on 3rd Mar 2019.    2.     Aging Report printed on 28/02/2019, the invoice is sitting in “Current” bucket.    3.     The invoice will fall under “0-30 Days” bucket if the aging is printed on 4th March 2019 onwards.    4.     User can change the due date manually in GP using “Edit Receivables Transaction”. Path: Transaction > Sales > Edit Receivables Transaction    5.     After changing the Due Date, the aging for the invoice will be revised. Printing the Aging Report 04/03/2019 again will make the invoice fall under “Current” bucket.    6.     But when the aging report is printed on 24/03/2019, the invoice will fall