Skip to main content

Posts

Showing posts from September, 2018

Prevent Posting to Control Accounts in Dynamics GP

There is a feature where most accountant seeking for in Enterprise resource planning (ERP)  is the prevention of  posting a transaction using control account code. As control account amount should always tally to the detail of sub-ledger like Payable Account or Receivable Account, manual posting to control account should be prevented. Path: Cards > Financial > Account. Simply uncheck the "Allow Account Entry" on any of the Control Account in Account Maintenance will prevent users from posting using Control Account. A message will pop out to indicate the account code is not allow for posting.

View Management Reports with web browser

Some users might not have the luxury to sit in the office to print Management Reports, they are always on the go or there have office in several location. I found 2 useful way to enable user to get the latest financial reports by using Management Reports' Web Viewer even  without installation of the Management Reporter on client . Refer to the links below on the setting configuration. 1. Generate Report via Web Viewer 2.  External Access to your based Web Viewer Reports from outside your cloud or network

What is the difference between age by document date and age by due date?

Due Date The invoice is categorized by the number of days past the due date. If the payment terms are 60 days, then the date range in the most left column should only be the first 60 days. More than 60 days will be sitting under second column onwards, which shows they are now overdue for payment. Invoice Date   the invoice is categorized by the number of days since the invoice was posted To illustrate the difference between age by "Due Date" and "Document Date", I have printed out AP Aging Report as showing below. There are two invoice posted into different period with 60 Days payment terms. a. Aging is printed as at May-2018 Due Date    -   Both invoice sitting under "Current" period as both invoice has not pass the 60 Days period when printing in May-2018. Document Date    -   Invoice from April will be moving to 31-60 Days; whereas invoice from May will still sitting in Current Period because it is posted in the same month as the aging date printed.

This vendor has been assigned to a purchase order or an unposted receipt.

Got a case where my client hit the following error when they are trying to change the status of the vendor from "Active" to "Inactive".  "This vendor has been assigned to a purchase order or an unposted receipt. The status can't be changed to Inactive". Checking to the Purchase Order which raised under this vendor, noticed the status still shows "Open PO" even though payment has been made and the status in the PO is already closed. GP will not move the completed PO to historical table until "Remove Completed Purchase Order" is performed. This step is require if Maintain Purchase Order History option is enabled in Purchase Order Processing Setup. Path: MSDGP > Tools > Routines > Purchasing > Remove Completed Purchase Order   i.     User may select range by "PO Number", "Vendor ID" or even "Document Date" from document range.    ii.     Select [Insert] to enter the range that selected.    iii