Author: Belinda Allen

Belinda Allen (Microsoft MVP) is both a Microsoft Certified Professional for Dynamics GP (MCP) and a Microsoft Certified Trainer (MCT). She is also the co-founder of Smith & Allen Consulting, Inc. (www.saci.com), a business management software consulting firm for over 24 years. Belinda began implementing ERP systems so long ago that Windows was not an operating system, but an application. Larger businesses used old Main Frames with monitors that were Green and Black and smaller business did accounting by hand. Having seen the evolution that has taken place over the years from pieces of paper to analytics, Belinda still gets excited every time she helps a business improve. Belinda is also well known for her Blog www.BelindaTheGPcsi.com. Her blog is about sharing really useful information about the product quickly and succinctly. She has earned the nickname GP CSI because she excels at reviewing GP problems and figuring what went wrong and why. With followers all over the Globe she is able to share knowledge and achieve her mission: “To Improve the Lives and Business Success of my Followers.” In her time off, Belinda enjoys sailing, woodturning, crochet/knitting, sewing/quilting, reading and playing the ukulele (Belinda often participates in Ukulele Jams in NYC.)

Payables Cash Document Numbers in Microsoft Dynamics GP (with video)

In this video I show users how I use the Cash Document number in Microsoft Dynamics GP. 

Originally Posted 7/29/13

In this video I show users how I use the Cash Document number in Microsoft Dynamics GP.

In this video I show users how I use the Cash Document number in Microsoft Dynamics GP. 

Continue reading “Payables Cash Document Numbers in Microsoft Dynamics GP (with video)”

Using Negative Deductions in Microsoft Dynamics GP (with video)

Question:  I use manual check entry in (Microsoft Dynamics GP) to re-pay a deduction that was taken in error.  Is there a better way to do that? 

Answer:  Yes, use a negative deduction!

 

Question:  I use manual check entry in (Microsoft Dynamics GP) to re-pay a deduction that was taken in error.  Is there a better way to do that?

Answer:  Yes, use a negative deduction!

Question:  I use manual check entry in (Microsoft Dynamics GP) to re-pay a deduction that was taken in error.  Is there a better way to do that?  Answer:  Yes, use a negative deduction!

Watch this video and see how I do this in Microsoft Dynamics GP.

Continue reading “Using Negative Deductions in Microsoft Dynamics GP (with video)”

Microsoft Dynamics GP Sales Tax – More Detail

I was sent an email recently from someone who ready my January Post (link below) regarding Microsoft Dynamics GP Sales Tax Calculations.  The email requested more information on the following section of the blog:

I was sent an email recently from someone who ready my January Post (link below) regarding Microsoft Dynamics GP Sales Tax Calculations.  The email requested more information on the following section of the blog:

Originally Posted 5/29/13

I was sent an email recently from someone who ready my January Post (link below) regarding Microsoft Dynamics GP Sales Tax Calculations.  The email requested more information on the following section of the blog:

If the item is going to be delivered to the customer, AND the tax was setup with the item, we charge based on the tax details that are common in both the Item tax schedule AND the customer’s tax schedule.

Continue reading “Microsoft Dynamics GP Sales Tax – More Detail”

Bill of Materials Introduction – Microsoft Dynamics GP (with video)

Here I’ll provide a brief demonstration on the functionality of the Bill of Materials module in Microsoft Dynamics GP Inventory Control.

Here I’ll provide a brief demonstration on the functionality of the Bill of Materials module in Microsoft Dynamics GP Inventory Control.

Here I’ll provide a brief demonstration on the functionality of the Bill of Materials module in Microsoft Dynamics GP Inventory Control. 

Continue reading “Bill of Materials Introduction – Microsoft Dynamics GP (with video)”

When did it post in Microsoft Dynamics GP (with video)

I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate:

Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded?  For instance, all December 2012 entries that were recorded and posted after January 15, 2013. 

I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate: Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded?  For instance, all December 2012 entries that were recorded and posted after January 15, 2013. 

I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate:

Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded?  For instance, all December 2012 entries that were recorded and posted after January 15, 2013. 

Microsoft Partner Rod O’Connor from Briware Solutions gave a great answer regarding how to have this show in SmartList.

Continue reading “When did it post in Microsoft Dynamics GP (with video)”

Selling Kits in Microsoft Dynamics GP (with video)

An item type assigned to items that consist of other component items that are assembled at the time of sale. The kit is a single item with an item number; it consists of one or more component items in your Microsoft Dynamics GP inventory. Component items can be services, sales inventory, discontinued, miscellaneous charge, and flat fee items.

What is a Kit?  (THIS IS DIRECT FROM GP HELP)

An item type assigned to items that consist of other component items that are assembled at the time of sale. The kit is a single item with an item number; it consists of one or more component items in your Microsoft Dynamics GP inventory. Component items can be services, sales inventory, discontinued, miscellaneous charge, and flat fee items.

 I do not know what McDonald’s uses for an Accounting/ERP system, but if you use Microsoft Dynamics GP Sales order Processing, I’m sure you can think of a lot of opportunities by using Kits.

Continue reading “Selling Kits in Microsoft Dynamics GP (with video)”

Microsoft Dynamic GP Outstanding Transactions in Bank Reconciliation

The Outstanding Transactions Report in Microsoft Dynamics GP Bank Reconciliation is a report worthy of attention.  Although almost every posting report in GP can be reprinted at a later point in time, this information cannot.

The Outstanding Transactions Report in Microsoft Dynamics GP Bank Reconciliation is a report worthy of attention.  Although almost every posting report in GP can be reprinted at a later point in time, this information cannot.

Originally Posted 05/05/2013

The Outstanding Transactions Report in Microsoft Dynamics GP Bank Reconciliation is a report worthy of attention.  Although almost every posting report in GP can be reprinted at a later point in time, this information cannot.

Continue reading “Microsoft Dynamic GP Outstanding Transactions in Bank Reconciliation”

Microsoft Dynamics GP – SOP work by Document or Batch?

I have a Distribution Client who uses Sales Order Processing (or SOP) in Microsoft Dynamics GP.  As this client fills orders, they handle each order one at a time.  In this video I demonstrate how I suggest using batches to save time in the following areas:

I have a Distribution Client who uses Sales Order Processing (or SOP) in Microsoft Dynamics GP.  As this client fills orders, they handle each order one at a time.  In this video I demonstrate how I suggest using batches to save time in the following areas:

eggwithbarcode-resized-600

  • Transfer from Backorder to Order
  • Printing Orders and Packing Slips
  • Transferring to Invoices
  • Printing or emailing Invoices
  • Posting Invoices

If you use Deposits, or any of the fields at the bottom of the invoice, you’ll need to make sure you do this.  A Good practice is to always select to include Totals and Deposits!

 

Continue reading “Microsoft Dynamics GP – SOP work by Document or Batch?”

Microsoft Dynamics GP Multiple Doc SOP Transfer?

There is an alternative to transferring Microsoft Dynamics GP SOP documents by individual document or batches, called “Sales Multiple Orders to Invoice Transfer.” 

There is an alternative to transferring Microsoft Dynamics GP SOP documents by individual document or batches, called “Sales Multiple Orders to Invoice Transfer.” 

I have a Distribution Client who uses Sales Order Processing (or SOP) in Microsoft Dynamics GP.  As this client fills orders, they handle each order one at a time.  In a previous blog posting, I demonstrate how I suggest using batches to save time in the following areas:

  • Transfer from Backorder to Order
  • Printing Orders and Packing Slips
  • Transferring to Invoices
  • Printing or emailing Invoices
  • Posting Invoices

There is an alternative to transferring SOP documents by individual document or batches, called “Sales Multiple Orders to Invoice Transfer.” 

This window is available only if you’re using sales fulfillment workflow.  Note the screenshot is from GP2018.

Continue reading “Microsoft Dynamics GP Multiple Doc SOP Transfer?”

Microsoft Dynamics GP Quote Expiration Date (with video)

OK, so you use Microsoft Dynamics GP Sales Order Processing (SOP) and you send Quotes to customers and prospects using this module.  Did you know you can use Expiration Dates on Quotes?  Do you know how to work around Expiration Dates on Quotes?  Do you know how to manage Expired Quotes?

Microsoft Dynamics Quote Expiration Date (with video)

OK, so you use Microsoft Dynamics GP Sales Order Processing (SOP) and you send Quotes to customers and prospects using this module.  Did you know you can use Expiration Dates on Quotes?  Do you know how to work around Expiration Dates on Quotes?  Do you know how to manage Expired Quotes?

I do recommend using expiration dates for Quotes as a form of protection against changing prices.  Expiration dates do print on Quotes by default so there is very little extra work involved in setting them up.

Where do you setup the default number of days until expiration?

Let’s start by setting up a default number of days for a quote to expire.  This is handled by going into the Sales Order Processing Setup window.

Continue reading “Microsoft Dynamics GP Quote Expiration Date (with video)”