When things go wrong – Missing or Invalid Date on SOP Edit List

 

3d man holding stop sign

This error kept coming up at a client whom was using the Sales Document Consolidation product from Binary Stream.

As it turned out, the problem was because the DUEDATE field in the SOP10100 table was showing a value of 1900-01-01 00:00:00.000, that is not a valid date in the Dynamics GP SOP posting world. This situation came about because (as near as we could tell), the customer did not have a default payment term assigned to them.

If you get this error on your SOP Edit List, go take a look at that field.

Kind regards,

Leslie

Taken from:
When things go wrong – Missing or Invalid Date on SOP Edit List

July 18, 2014 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 116

How Report, Column, and Row formatting work together – MSDN Blogs

… in the Row Definition occurs third. In each of these cases, the formatting that occurs last will override any formatting that occurred earlier. Check out the video to learn more. http://www.youtube.com/watch?v=dUkQa-9YeEE.

Continue Reading:
How Report, Column, and Row formatting work together – MSDN Blogs

July 18, 2014 · Ryan Sandness · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 92

Join us in October at GPUG/CRMUG Summit 2014 in St. Louis, MO

As we put together our schedule of events this fall, we want to make sure you know about one of the most beneficial events for users. Join us and hundreds of GP & CRM users at GPUG & CRMUG Summits,
October 14-17, in St. Louis, MO. 

Here are the reasons we love the Summit events: 

There are literally HUNDREDS of breakout sessions available on nearly every GP/CRM subject you can dream up. 
The

More:
Join us in October at GPUG/CRMUG Summit 2014 in St. Louis, MO

July 17, 2014 · Abbey · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 113

SQL view for Dynamics GP vendors with last activity date

I have seen many requests recently for a way to see what Dynamics GP vendors have had no recent activity. Since ‘recent’ can mean different things, I thought I would put together a view that shows the last activity date for each vendor. Once you have this you can easily filter for whatever date range you …

More:
SQL view for Dynamics GP vendors with last activity date

July 17, 2014 · Victoria Yudin · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 263

Do not automatically unapply other documents if one is voided: 921385

Please vote for this suggestion if you agree.

Vote here: https://connect.microsoft.com/dynamicssuggestions/Feedback

Read about it here: https://connect.microsoft.com/dynamicssuggestions/feedback/details/921385/do-not-automatically-unapply-other-documents-if-one-is-voided

This refers to the new feature in GP2013 that will automatically unapply all documents (except payments) from a vendor invoice if even one of those documents is voided. For instance, if you pay an invoice using checks, credit memos, returns and write offs – ALL of those documents (other than checks) become unapplied when one of the checks is voided.

I just posted the suggestion on Connect, here’s why the new feature is a bad idea:

This new feature is a DISASTER and should be an option, NOT an automatic unapply of all non-payment documents. Here’s what happens.

You have a payable to a vendor

$1,000

You pay by check ($400)

($400)

You pay by check ($415)

($415)

You apply a credit memo of ($10)

($10)

You apply a credit memo of ($75)

($75)

You apply a return ($50)

($50)

You write off ($50)

($50)

Remaining Balance

$0

At this point the invoice is fully applied and in history, as are the other apply documents.

Now, you void the $400 payment. Magically the following documents become unapplied:

  • The credit memo of ($10)
  • The credit memo of ($75)
  • The return for ($50)
  • The write off of ($50)

Now the balance of the invoice shows to be $585 instead of the ‘real’ balance of $400

WHAT! This is insanity!

So now you have to go back and figure out what those four documents should be applied to and apply them. This is causing a real problem and it should not behave this way. At least present a dialog asking the user if they want to unapply the other documents, don’t just do it. And why the inconsistency with the payments, why aren’t they unapplied too, the returns are.

This new ‘automatic’ feature is a nightmare and should instead be an option, not a mandate.

Kind regards,

Leslie

View post:
Do not automatically unapply other documents if one is voided: 921385

July 16, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 169

Allow changes to the Amount Paid field on the Edit Payables Check Batch window: 921350

Please vote for this suggestion if you agree.

Vote here: https://connect.microsoft.com/dynamicssuggestions/Feedback

Read about it here: https://connect.microsoft.com/dynamicssuggestions/feedback/details/921350/allow-changes-to-the-amount-paid-field-on-the-edit-payables-check-batch-window

I just posted the suggestion on Connect as appears below:

Currently, if you check a voucher on the right side of the Edit Payables Check Batch window, the Amount Paid defaults to 100% of the Open amount. What if I don’t want that? What if I want to pay less than the total amount.

Well, then we have to open that particular payment in the Edit Checks window and change the amount. OR, we have to enter the check anew in the Edit Checks window. Either way, it adds a lot of steps to the payables function.

I think we ought to be able to just change the amount on the Edit Payables Check Batch window and go on with processing the check run.

Kind regards,

Leslie

Read this article:
Allow changes to the Amount Paid field on the Edit Payables Check Batch window: 921350

July 15, 2014 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 88

Add a Mark/Unmark All button to the Edit Payables Check Batch window ID: 921336

Please vote for this suggestion if you agree.

Vote here: https://connect.microsoft.com/dynamicssuggestions/Feedback

Read about it here: https://connect.microsoft.com/dynamicssuggestions/feedback/details/921350/allow-changes-to-the-amount-paid-field-on-the-edit-payables-check-batch-window

I just posted the suggestion on Connect as appears below:

The Edit Payables Check Batch window is a widely accepted, much sought after window and I was thrilled to see its addition to the program. However, I find it difficult to use if you have a long list of vouchers for a vendor and you need to uncheck most of them.

As soon as you select a vendor on the left-hand side, all of the vouchers are marked on the right-hand side. If you want to Unmark them, you have to do it one at a time. I expected the little check box above all of the other checkboxes would provide the Mark All, Unmark All functionality but it does not. If it’s supposed to, it’s broken.

This would reduce the amount of time it took for the payables clerk to pay vouchers if only a few vouchers were paid. Clients do not necessarily want to pay ALL of the vouchers outstanding, so there’s always a second step to ‘Unselect’ the ones you do not want to pay.
It’s easy to miss some vouchers, and end up paying too many. Cash out the door.

It would be much better if the default were ‘unchecked’, since changing the default doesn’t make sense at this point, I think we need an “Check/Uncheck All” button, or an option in the Payables Setup window that controls the default behavior

Kind regards,

Leslie

See original article:
Add a Mark/Unmark All button to the Edit Payables Check Batch window ID: 921336

July 15, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 104