Sometimes batch totals and transaction counts get corrupted in GP, there can be many reasons behind this.
To correct them the check links maintenance routine can be executed for “Sales Work”. This will correct the batch totals but will take a very long time to run and is not the sort of thing to be doing during working hours.
Alternatively corrections can be made via SQL which is quick and can address multiple batches,
Reconciling SOP Batches - The Dynamics GP Blogstersome thought needs to be put into batch locking etc if this is to be used regularly as the script in its current form does not check if it is “allowed” to update the batch totals.
Similar post: Reconciling SOP Batches from WITHIN Dynamics GP
Today I found out another way that I thought worth recording for future reference, printing an edit list for the batch. Although this can only be used one batch at a time, it is quick and “built in” to GP.
Go to the Sales Batch Entry Window…
Select the SOP batch of interest and click the print icon.
In the Form to Print combo box, select Edit List and then click the print button.
Select a destination (to screen) in the print destination window that follows. After printing, leaving the batch and then going back into the batch, the totals will be found to be corrected.
Thanks for the hint from Jorge Mejia on GP forums: https://community.dynamics.com/gp/f/32/p/241273/665571#665571
So you want to turn off multiple binning in Dynamics GP and need to record the multiple bin where the stock is held back into the basic single bin field against each location?
This script I just used to do that, it will pick the multiple bin with the most stock as the one to use for the single bin field. I would take a snapshot of the multiple bins table into excel, just for the record if performing this change (IV00112) and for future reference.
,ROW_NUMBER() OVER (
PARTITION BY ITEMNMBR
,LOCNCODE ORDER BY QUANTITY DESC
WHERE qtytype = 1
JOIN IV00102 ON CTE.ITEMNMBR=IV00102.ITEMNMBR AND iv00102.LOCNCODE=CTE.LOCNCODE
WHERE RowSort = 1
AND BIN !=BINNMBR
Then, turn off multiple bins in the inventory setup window, and reconcile the inventory after doing so.
From time to time you encounter systems where the company style is to capitalise names in the system. I know of users who might as well glue the caps-lock on!
If faced with the, we have always done it this way problem, fight it. Excuses come out like its for users with vision problems (there are magnifiers and system tools to help there), improves clarity for parcels going overseas to other cultures (I doubt it makes much difference in compter type, maybe for hand written?), etc.
Capitalisation is a lossy process
In the context of company names, street names, people names, the capitalisation can be important as it conveys information that is lost if it is presented in entirely uppercase.
- McKenzie vs MCKENZIE
- O'Donnell vs O'DONNEL
- MacBain VS MACBAIN
There are many others and in other cultures where the capitalisation conveys information that cannot be recovered again if lose, by the use of automated processing.
It makes it look bad for mail merges later too
"Dear Mr ODONNEL
Thank you for your order."
Just looks bad.
Thus don’t shout at your customers with capitals, use your SHIFT keys!
Now we have Visual Studio 2017 and again it is awesome! Drop what you are doing and start developing with it right now!
If you are a .NET Dynamics GP Addin developer you will find that the project templates are not available for Visual Studio 2017 (at the time of writing this). I wrote how to install them into Visual studio 2015 a while back, but that method cannot be used anymore for Visual Studio 2017. This is because of a new method of discovery that Visual Studio uses for project templates. This has been implemented by Microsoft for Visual Studio 2017, using manifest files to point to the project templates. I’m guessing this is part of making Visual Studio more quick and to perhaps work with marketplace better.
You will also notice that the install directory for Visual Studio has moved into a Visual Studio subdirectory, I guess that makes things tidy & makes sitting different versions together easier? My location for Enterprise project directories is now:
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\ProjectTemplates
below you can see the .vstman manifest files that point to the templates.
The directory structure of the templates has changed a little too, having a 1033 or similar folder holding them and a another manifest file, “Windows.VSTDIR” above each of those folders.
I am working on a solution to get the templates working in Visual Studio 2017 and hope to expand this most in the next day or so.