Friday, May 8, 2015

Dynamics GP - Integration Manager - The ConnectionString property has not been initialized

Original Solution
https://community.dynamics.com/gp/f/32/p/42585/223127

Confirm that the file is closed, and not open anywhere else.

Go to Data Sources (ODBC) in the Control Panel (or C:\Windows\Syswow64\odbcad32.exe if you're on a 64 bit machine).  Click Add... and select Microsoft Access Driver (*.mdb) and click Finish.  Click on the Repair button, and then browse to your IntegrationManagerSamples.mdb database and click OK.  

Usually located at
C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 12\Samples

Thursday, May 7, 2015

Dynamics NAV 2013 - Mass Archive Purchase Orders

Function to Mass Archive all Purchase Orders

MassArchivePurchDoc()

//PurchHdr.SETFILTER(PurchHdr."Document Date",'01/08/14');
IF PurchHdr.FIND('-') THEN BEGIN
REPEAT

    StorePurchDocument(PurchHdr,FALSE);
UNTIL PurchHdr.NEXT = 0;
MESSAGE ('All Purchase Orders Archived');
END;

Wednesday, May 6, 2015

Dynamics NAV - Removing Purchase Orders

First of all, according to this
https://msdn.microsoft.com/en-us/library/hh173005(v=nav.71).aspx

If the order is fully posted, both received and invoiced, then the purchase order is deleted.

So how do i remove old purchase orders?
  1. Run the "Delete Invoiced Purchase Orders" routine
    1. Search for Delete Invoiced Purchase Orders
    2. Enter Range
    3. Click ok
    4. The system will remove all invoiced purchase orders
  2. Another, more drastic method is to simply adjust the Qty Rcd not invoiced to 0, then manually delete the PO
    1. This method should only be used if you are certain that there are no more invoices or receipts to be completed in connection with this transaction.
    2. Manual inventory adjustments and GL journals will have to be done to fix any problems caused by using this method
    3.    update [Purchase Line] set  [Qty_ Rcd_ Not Invoiced] = 0 where [Document No_] =   'PO000155'

Dynamics NAV 2015 LS Retail - The Store logo does not display on the POS, but instead displays the error "Error Loading Media: Invalid URL: The hostname could not be parsed".


All Images are fetched using Local web services. SOAP must be enabled and working correctly for images to be displayed correctly.
  1. Enable SOAP services in the NAV Administration on the POS machine

Friday, May 1, 2015

Dynamics NAV - There is not enough Bin Capacity for Items

Problem
Even though you have set the Warehouse Setup to ignore Bin capacities, you still get this error when tying to generate a Put-Away document

Cause
The Location will use the Put-Away template options to attempt to suggest bins IF you do not tick "Always Create Put Away Line"
If there is insufficient inventory data to allow the system to find a bin using the Put-Away template options, you get the error

Solution

  • If you want the system to generate a put away document with a blank bin to allow users to select a bin manually, Tick "Always Create Put Away Line"
  • When you have some data in the system and bins have inventory in them, you can untick the "Always create put away line" and it will start using the default options to suggest bins

Dynamics NAV LS Retail - LSStart LS Nav Start does not launch POS


Problem
Whenever you launch LSStart, it does not connect.
If you click no, it prompts you to enter connection info and then fails to connect.

Cause
This is because it is reading connection info from the LSSTART.exe file in the
C:\Program Files (x86)\LS Retail\NAV\LSStart
folder.
If it does not save your connection info even when you type it in, you probably do not have access to that folder.

Solution
Give yourself full access to the folder
Or Modify the file manually, save it to your desktop, then copy it over in the folder.

  • Find these lines, and enter the correct connection info


              <Company>Cronus</Company>
              <Object>
                <Type>Page</Type>
                <Id>99008950</Id>
                <Name>EPOS Main</Name>
              </Object>
              <ServiceTierList>
                <ServiceTier>
                  <Name>MyNavInstanceName</Name>
                  <Port>7046</Port>
                  <Host>HOSTNAME</Host>

Dynamics NAV LS Retail POS- FAQ - Issues List


  • Cannot enter beginning float
    • The tender type must be set to "Taken to Safe"