Skip to main content

Fixed Assets to include tax as total cost in Dynamics GP

Microsoft introduces a new useful feature in Dynamics GP 2016 R2 that enable the option to include tax amounts in Dynamics GP. This feature enables the users to include tax amounts in capitalised item from Purchase Order Processing.

The 'Include Tax in Acquisition Cost' option can be configured at Fixed Assets Company Setup window.

Path: MSDGP > Tools > Setup > Fixed Asset > Company

To illustrate how the feature works, refer to guided steps below.

1.    Assuming you are purchasing a new office equipment fixed asset using Purchase Order. The asset purchase value at $820, with tax $49.20, total purchase value for the asset is $869.20.

2.    After the Shipment and Invoice Matching is done, the asset purchase detail should be interfaced to Fixed Asset module now.
3.    To record the newly purchased asset, go to Asset General (Cards > Fixed Assets > General).


4.    After select the "Class ID" to trigger the generation of next Asset ID, select [Purchase] button.

5.   Noticed that the office equipment purchase earlier is split into different cost under same Purchase Order Number and Receiving, where 1 of the cost is the real asset cost, another 1 is the tax value.
6.   Mark the "M" for matching the 2 items together (820.00 + 49.20). 
7.   Select "Select" to proceed with current selection.

           Definition of "P" and "M:

           - Mark the M box. This will combine the asset cost and the tax amount to the asset which link to same Purchase Order. (To include tax with asset cost)
           - Mark the P box. To select only the asset cost. This will exclude the tax amount which link to the same Purchase Order. (To include only asset cost)
           - Take note that these 2 options will affected the outcome which displaying in Acquisition Cost and Asset Purchase screen.


8.   Refer to the "Acquisition Cost", the asset value is $869.20 which is the asset cost plus tax amount instead of "$820.00.

*** Take note that the tax $49.20 recorded in Invoice Matching earlier by default will charge to Tax Expense account. You will need to change the distribution account to Fixed Asset Purchase Clearing account. When the asset is registered to the FA module, the total asset value $869.20 will be credit out back to Fixed Asset Purchase Clearing account.
But if you have already charge to tax expense account, the only way to rectify this is to create account reclassification using Journal Entry.

Comments

Popular posts from this blog

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries.      Path: Reports > Financial > Cross-Reference > Select "Journal Entries"             Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports      Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry      Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry      Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry      Path: Reports > Sal...

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for  numerous accruals and reversals,  allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches  i.    After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii.    There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j...

How to Record a Refund from a Vendor in Dynamics GP

Assuming you have scenario where there is over payment to your vendor or supplier, but you don't have any open invoice due to this vendor, you can simply enter a Return transaction using Payable Transaction Entry screen. Path: Transaction > Purchasing > Transaction Entry > Select "Return" from Document Type. 1.     Assuming there is a refund of $100 from the supplier, enter the refund details as per screenshot attached. 2.     Enter the refund amount to "Returns" and also "Check" field. 3.     The check entry screen will pop out to record the cash receipt details. 4.     Take note of the Distribution entry, DR Bank and CR Purchase. 5.     After the Return is posted, the document status will be "HIST". No apply require. 6.     This will also create a Bank Deposit to be deposited.         (Transaction > Financial > Bank Deposits)