Rose Business Solutions Dynamics GP

Archive for June, 2009

The Landed Cost functionality in Dynamics GP helps you accurately capture the actual cost of inventory receipts.

Every time this issue comes up, I have to figure it out, again; how do you match a landed cost vendor’s invoice to the receipt. The trick is to check the “LC” (Landed Cost) check box on the entry line.

Once you do that, you can look up the “Item” and you will see the landed cost items, not your inventory item master file. Select the landed cost item you want to invoice, and then click on the expansion arrow next to the “Matched to Shipment” field label.

Here’s an example:

These are the landed costs applied to the receiving transaction:

These are unmatched landed costs for the “Insurance” item, from two different receipts. Find the receipt you’re looking for and check the “Match” box.

Now the landed cost item from the receipt has been matched to the vendor’s invoice, and it is ready to post.

Take a look at my short video to see this in action.

Smart Tags offers a good way to extend Dynamics GP beyond your GP-user base. Access to the information can be easily secured using Windows security, and there is no additional licensing required.

My previous post discusses some of the basic functionality of Smart Tags, from the user’s standpoint.

The Microsoft Office Smart Tag Manager for Microsoft Dynamics GP 10.0 page is a good place to start if you want to try it out.

I put together this little video to show you how easy it is to install and setup.

If you’re not using Smart Tags, you should at least try it out and see if your non-GP users like it.

The best way to maintain an accurate inventory is to continually count your inventory. That is, count part of your inventory every day, and count each item several times per year.

Dynamics GP has an easy to use process that will assist you in making cycle counts. There are basically two steps:

Create a Stock Count Schedule (Transactions >> Inventory >> Stock Count Schedule)

Complete and post a Stock Count Entry (Transactions >> Inventory >> Stock Count Entry)

There are a variety of ways to create a Stock Count Schedule. You will want to use the “Mass Add” feature on the Stock Count Schedule screen. I’m guessing these are the three most popular ways to select items to include on the Stock Count Schedule:

ABC Code (Run the ABC Wizard to assign codes to items: Tools >> Routines >> Inventory >> Item ABC Analysis)

Item Class

Next Stock Count Date (Set up the Stock Calendar: Tools >> Setup >> Inventory >> Stock Calendar, and assign the “Next Count Date”: Cards >> Inventory >> Count Cycle Assignment)

Once you have completely entered your count results and analyzed variances, you can process the entry; the variance transaction will be created, and the count items will be released for the next count.

This is a good way to keep up on your inventory counts. Try it out.

See my video to see it in action.

Clients and prospects often ask whether they can create payables checks without having to enter a new vendor. You can, using the Miscellaneous Check function. This function is somewhat orphaned in the Financial series. It will create bank reconcilation and general ledger transactions.

From the online documentation:

“You can create individual checks to make a one-time payment when you don’t want to create a vendor record for the person or business you’re paying. Use the Miscellaneous Check window to print checks for one-time purchases that are not recorded as transactions anywhere else. You can print and post a check from this window, or you can post checks from this window without printing them.”

Navigate to the Miscellaneous Check screen:

Transactions >> Financial >> Miscellaneous Checks