Sunday, January 31, 2016

Remote Desktop - Clipboard stops copying - cannot copy and paste

This happens sometimes when you copy a very large file, and the copy paste functionality times out or just stops working.

To fix this, do the following


  • Open task manager on remote machine
  • end rdpclip.exe
  • Click Run
  • Run rdpclip.exe

You should now be able to copy and paste as normal.

Saturday, January 30, 2016

Dynamics GP - Recover a stuck batch - receiving transactions

SELECT MKDTOPST, BCHSTTUS, * FROM SY00500 where BACHNUMB = ‘xxxx’
(Replace xxx with the batch ID)

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 WHERE BACHNUMB=’xxxx’
(Replace xxx with the actual batch ID)

Dynamics GP - Item Qty Allocated has a value but does not show any documents

Original Post
http://www.fmtconsultants.com/2014/10/item-allocation-quantity-does-not-match-sum-of-allocated-orders-in-microsoft-dynamics-gp/


Usually, a Reconcile will fix this.
However if it persists after the reconcile, there is probably some document somewhere that is still being seen.
Run this script to see what else is contributing to that number.
------------------------------------------------------------------------------------------------------------



declare @ITEMNMBR char(30)
select @ITEMNMBR = '%ITEMNUMBER%'

print 'Allocated Documents in Sales Order Processing'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='SOP10200')
Begin
 print 'Allocated Orders in Sales Order Processing'
select SOPNUMBE,ITEMNMBR,ITEMDESC,ATYALLOC
from SOP10200
where ITEMNMBR = @ITEMNMBR and ATYALLOC > 0 and  SOPTYPE = 2
end

if exists (select * from sysobjects where name ='SOP10200')
Begin
 print 'Allocated Invoices in Sales Order Processing'
select SOPNUMBE,ITEMNMBR,ITEMDESC,ATYALLOC
from SOP10200
where ITEMNMBR = @ITEMNMBR and ATYALLOC > 0 and  SOPTYPE = 3
end

if exists (select * from sysobjects where name ='SOP10200')
Begin
 print 'Allocated Fulfillment Orders in Sales Order Processing'
select SOPNUMBE,ITEMNMBR,ITEMDESC,ATYALLOC
from SOP10200
where ITEMNMBR = @ITEMNMBR and ATYALLOC > 0 and  SOPTYPE = 6
end

Print ''
print 'Allocated Returns in Purchase Order Processing'
print '==============================================================='
print ''

if exists (select * from sysobjects where name in ('POP10500', 'POP10310'))
Begin
select A.POPRCTNM,A.ITEMNMBR, QTYRESERVED, A.PONUMBER
 from POP10500 A join POP10310 B
on A.POPRCTNM=B.POPRCTNM AND
A.RCPTLNNM=B.RCPTLNNM AND A.ITEMNMBR=B.ITEMNMBR
where A.ITEMNMBR = @ITEMNMBR and A.QTYRESERVED > 0
end

Print ''
print 'Allocated documents in Inventory'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='IV10001')
Begin
select IVDOCNBR,ITEMNMBR,TRXQTY
from IV10001 where ITEMNMBR = @ITEMNMBR and TRXQTY < 0
select IVDOCNBR,ITEMNMBR,TRXQTY
from IV10001 where ITEMNMBR = @ITEMNMBR and TRXQTY > 0 and IVDOCTYP = 3
end

print ''
print 'Allocated Invoices in Invoicing'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='IVC10101')
Begin
select INVCNMBR,ITEMNMBR,QUANTITY
from IVC10101 where ITEMNMBR = @ITEMNMBR and DOCTYPE = 1
end

print ''
print 'Allocated Assembly documents in Bill of Materials'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='BM10300')
Begin
select TRX_ID,ITEMNMBR,ATYALLOC
from BM10300 where Component_ID <> 0
and ITEMNMBR = @ITEMNMBR and ATYALLOC > 0
end

Print ''
print 'Allocated Orders in Service Call Management'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='SVC00203')
Begin
select CALLNBR,ITEMNMBR,ATYALLOC,LOCNCODE
from SVC00203 where ITEMNMBR=@ITEMNMBR and  LINITMTYP='P'
AND ATYALLOC <> 0
end
select CALLNBR,ITEMNMBR,ATYALLOC,LOCNCODE
from SVC00203 where ITEMNMBR=@ITEMNMBR and  LINITMTYP='P'
AND ATYALLOC <> 0

print 'Allocated Service Call Transfers'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='SVC00701')
Begin
select ORDDOCID,ITEMNMBR,TRNSFQTY from SVC00701
where ITEMNMBR=@ITEMNMBR and TRNSFQTY <> 0
end

print 'Allocated Service Call Transfers (serial)'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='SVC00702')
Begin
select ORDDOCID,ITEMNMBR,SERLTQTY from SVC00702
where ITEMNMBR=@ITEMNMBR and SERLTQTY <> 0
end

print 'Allocated RTV lines'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='SVC05601')
Begin
select RTV_Number,ITEMNMBR, QUANTITY, * from SVC05601 where
ITEMNMBR=@ITEMNMBR and RTV_Status=2
and CUSTOWN=0 and Transfer_Reference=''
end

select RTV_Number,ITEMNMBR, QUANTITY, * from SVC05601 where
ITEMNMBR=@ITEMNMBR and RTV_Status=2
and CUSTOWN=0 and Transfer_Reference=''

print 'Allocated Documents in Depot Management'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='SVC06100')
Begin
select WORKORDNUM,IBITEMNUM,QUANTITY,LOCNCODE
from SVC06100 where IBITEMNUM=@ITEMNMBR
AND WORECTYPE = 2 AND QUANTITY <> 0
End

if exists (select * from sysobjects where name ='SVC06101')
Begin
select WORKORDNUM,ITEMNMBR,ATYALLOC,LOCNCODE
from SVC06101 where ITEMNMBR=@ITEMNMBR
AND WORECTYPE = 2 and ATYALLOC <> 0  
end

if exists (select * from sysobjects where name ='SVC06120')
Begin
select WORKORDNUM,ITEMNMBR,SERLTQTY from SVC06120
where ITEMNMBR=@ITEMNMBR AND WORECTYPE = 2 AND SERLTQTY <> 0
End

print ''
print 'Allocated Documents in Project Accounting'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='PA10901')
Begin
select PAIV_Document_No,ITEMNMBR,PABase_Qty,LOCNCODE
from PA10901 where ITEMNMBR=@ITEMNMBR and
PABase_Qty <> 0 and PAIV_Transfer_Type = 1
end

print ''
print 'This is the (general) allocated or pending issue'
print 'quantity in the MOP1400 for this Manufacturing Order'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='MOP1400')
Begin
select MANUFACTUREORDER_I, ITEMNMBR, ATYALLOC
from MOP1400 where ATYALLOC > 0 and ITEMNMBR = @ITEMNMBR
end

print 'This is the (bin) allocated quantity'
print 'in the MOP1900 for this Manufacturing Order'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='MOP1900')
Begin
select MANUFACTUREORDER_I, ITEMNMBR, ATYALLOC, LOCNCODE, BIN
from MOP1900 where ATYALLOC > 0 and ITEMNMBR = @ITEMNMBR
end

print 'This is the (lot) allocated or pending'
print 'issue quantity in MOP1020 for this Manufacturing Order'
print '==============================================================='
print ''

if exists (select * from sysobjects where name ='MOP1020')
Begin
select MANUFACTUREORDER_I, ITEMNMBR, SERLTNUM,
FROM_SITE_I, DOCNUMBR from MOP1020 where ITEMNMBR =@ITEMNMBR
end

print 'Pending transactions that can hold allocations'
print '==============================================================='
print ''

if exists (select * from sysobjects
where name in ('MOP1200', 'MOP1020', 'MOP1025', 'MOP1026'))
Begin
select * from MOP1020
where DOCNUMBR in (select PICKNUMBER from MOP1200 where POSTED=1)
and ITEMNMBR = @ITEMNMBR
select * from MOP1025
where MOPDOCNUM in (select PICKNUMBER from MOP1200 where POSTED=1)
and ITEMNMBR = @ITEMNMBR
select * from MOP1026
where MOPDOCNUM in (select PICKNUMBER from MOP1200 where POSTED=1)
end



Dynamics GP - Cancelling a check links or reconcile in the middle of processing

If for some reason, you have to close GP or cancel a session during a check links or a reconcile routine, ensure that you run the routine again to completion before doing anything else to allow GP to "finish" whatever it may have been doing.

Other related errors:

  • A get/change next operation on table IV_Item_Mstr failed. A record was already locked
    • This one specifically happens if you were running an inventory reconcile which was interrupted, and then attempt to run a check links or some other function before completing the reconcile
    • To resolve, run the item reconcile to allow it to finish, then you can go back and run check links after
    • You may need to run all of the other reconciles as well to be sure there are no other errors blocking the check links


Friday, January 29, 2016

Dynamics NAV - Sales Demo Topic List


  • What is Dynamics NAV?
    • Software to help manage your business
    • Sales, Purchasing, AR, AP, Inventory, Finance
    • Manufacturing, Service Call, Project Management
    • DOES NOT DO
      • Payroll, HR
  • What is LS Retail?
    • A POS Module for NAV
    • POS, PMS, Hospitality, Forecourt
  • How Expandable / Customizable
    • Very customizable, can change almost every aspect of the software to meet your needs
    • Users can customize certain options, we can customize other parts of the system
    • Additional licenses can be purchased as required
  • Software Warranties
    • Support plan entitles customer to all updates
    • We will charge time and materials to perform upgrades at customer's request
  • What is the difference between LS One and LS Retail?
    • LS One is a standalone POS solution that can be integrated to any existing ERP
  • System Requirements?
    • Check website
  • How is this software going to make my business more efficient?
    • Provides a front to back solution POS to Backoffice and full audit capabilities - SHOW THIS
    • No Down Time
      • Ability to roll out updates immediately - SHOW THIS
      • Offline Mode - SHOW THIS
    • Live Data feedback - SHOW THIS
    • Replenishment - SHOW THIS
    • Loss prevention - SHOW THIS
    • Member Management - SHOW THIS
    • GIFT CARDS - SHOW THIS
    • Pricing and Discounts - SHOW THIS
    • Inventory Control - 
      • Barcodes
      • Overview of Pick/Pack/Ship, Bins, Lots, Serials
    • Reporting & BI
      • Export to excel, email, regular reports
      • SSRS portal
      • Tableau ?
      • LS BI?

Friday, January 22, 2016

Dynamics NAV - Access is denied, you do not have access to this company after restoring a backup from anoter NAV server - How to login to any NAV company

Run this to clear all current user settings

delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]


Ensure that your NAV instance is pointing to the correct database
Restart NAV instance
Right click on NAV and run as administrator
You should get into the company
Add your user and set it as SUPER

Friday, January 15, 2016

Tuesday, January 12, 2016

Dynamics GP - Stock Count Schedule - Mass Add - Bins Enabled - Include Item/Sites with Zero on hand quantity - Does not respect bin filters

This seems to be a bug in Dynamics GP - from GP10 up
In this scenario
  • Bins enabled
  • ALL items have 0 stock
  • Multiple Sites with 1 bin DEFAULT
  • 2 Sites with bin 1A each
  • Create a stock count schedule
    • Mass Add
    • Select Bins
    • Select 1A
    • Tick "Include item/sites with zero on hand quantity"
    • Click Add
    • The system adds ALL items in all sites with 0 qty instead of just the items in the 2 sites with the 1A bins

The only solution to this is to use other filters.

Monday, January 11, 2016

Dynamics NAV 2015 - LS Retail - "Either the caller does not have the required permission or the specified path is read only. No page, report or navigation has been specified in the URL"

We have a machine that connects to both the head office, and to a local instance of LS retail.
Whenever the user launches the remote instance, and then attempts to launch the local instance, they get this error.


I have tried this solution

http://saurav-nav.blogspot.com/2012/09/either-caller-does-not-have-required.html

But it only worked the first time.

The issue re-occurred, and the second time, we had to switch the account that the NAV service was running as from local, back to network service, then it worked fine...until the next restart.
Then the error came back.

This error occurs rarely on specific machines.

It can be temporarily resolved by changing the account on the NAV service, then changing it back to Network Service.

Ensure that the windows user and network service user has full access to the SQL database

Ensure the user and network service user has full access to the Program Files\Dynamics NAV folder and subfolders

If you navigate to
\\mypc\c$\ProgramData\Microsoft\Microsoft Dynamics NAV\80\Server\MicrosoftDynamicsNavServer$DynamicsNAV80\users\default\[Instance]
You should see a folder for each user that attempts to login to that instance, along with a temp folder within that user folder.

In this case, it seems as if our user was unable to create new folders in this location (even though he had the correct security priveleges)

I created the folder structure manually in this location, and this seems to have resolved the error.