Tuesday, January 31, 2017

Dynamics NAV - Menus do not show up when searching in search bar

http://www.erpsoftwareblog.com/2014/11/wont-search-find-report-dynamics-nav/

Saving a view on a page will allow you to find it when searching
Otherwise, modify the menusuite and add a menusuite with your object to have it visible in the search bar

Saturday, January 28, 2017

Dynamics NAV - How to setup and use EFT, Electronic Funds Transfer, ACH,Electronic Payment, Export Payment to File



  • Pre-Requisites
    • Setup EFT Bank information on the following windows mainly under the Transfer Fasttabs
      • Company Information Screen
      • Bank Accounts
      • Vendors
      • Payment Journal Template
    • Create a Payment Journal Batch with a Bal Account type of "Bank Account" and select a bank account
  • Navigate to Posting Exchange Column Definitions
    • Define Column definitions for EFT Output
  • Navigate to Posting Exchange Definitions
    • Define a format for your EFT output

Friday, January 27, 2017

LS Retail - Dynamics NAV Tables


  • Trans_ Sales Entry - Unposted POS Transaction Line Detail
  • Transaction Entry - Posted POS Transaction Headers
  • Trans_ Infocode Entry - POS Infocode Entry Data

LS Retail - Remove "Purge Old Transactions?" prompt on POS


  • Functionality Profile
  • Set Trans. Delete Reminder to nothing
Related Errors:
"The Date is not Valid"

This occurs if you use a number that is too large for the Trans. Delete Reminder

LS Retail - No Terminal Selected


  • Retail Users> Set default terminal

Thursday, January 26, 2017

Windows 10 - USB Mouse disconnects or loses power randomly. You hear the sound of the USB device being unattached. How to restart a usb port or connection.

Original Workarounds here
https://support.microsoft.com/en-us/help/817900/usb-port-may-stop-working-after-you-remove-or-insert-a-usb-device

http://www.tomshardware.com/answers/id-1783536/usb-ports-disconnecting-reconnecting.html

At the end of the day the only thing that really worked for me was restating the machine, or restarting the Chipset Host Controller under the Universal Serial Bus Controllers


  • How to restart a usb port or connection
    • Go to Control Panel>Device Manager>Universal Serial Bus Controllers
    • Each USB port will have a corresponding Host Controller
    • For each one, right click and disable, then right click and enable
  • How to disable USB Suspend Power Settings
    • Scroll to the right and type 'Power Options' in the search field and click on it.
    • Click 'Change plan setting' on your chosen plan.
    • Click 'Change advanced power setting' on your chosen plan.
    • Find 'USB settings' and open.
    • Find 'USB selective suspend setting' and change it to disabled.

Friday, January 20, 2017

Dynamics GP - Table Open Error

This error occurs if a specific report in a dictionary may have been corrupted or is out of date.
Restore your dictionary to resolve.

eOne Flexicoder - Access to the window1 window was denied

Create a task to give users access to this window under security tasks Flexicoder>Windows>System>Window1

Thursday, January 19, 2017

Dynamics GP - Report Writer - Display 0 dp for Quantity on SOP Invoice


  • Create a calculated field of type integer equal to the Quantity field
    • Integer fields naturally have 0 dp, and require no formatting
  • To display 2 dp, create a calculated field of type currency equal to the Quantity field
    • go to the field properties, and select the formatting from the SOP Work Amounts table > Decimal Places Currency 
    • This will force it to format to the currency decimals for this item (which should be 2)
    • To remove the $ sign, apply the format DLR_RB0_STR, remove the format field (set to none)

Saturday, January 14, 2017

SQL - Dynamics NAV - Row Combine - How to combine a single field with multiple rows into a long string with | to use in filters


Example2
SELECT p1.grp,
          ( SELECT [Item No_] + '|'  [BI_ItemQty] where QtyOnHand <> 0 ) p2
             WHERE p2.grp = p1.grp
             ORDER BY [Item No_]
               FOR XML PATH('') ) AS AllComm
      FROM (select [Item No_], 1 as grp from [BI_ItemQty] where QtyOnHand <> 0 ) p1
     GROUP BY grp ;

Windows 10 - Disk Usage goes to 100% or very high after resuming from sleep, suspend, or raising the lid

https://support.microsoft.com/en-us/kb/2922899

Workaround
  • Change power plan to Balanced.
  • Start Command Prompt as administrator, and then run the following commands:

powercfg /setacvalueindex scheme_max sub_disk 0b2d69d7-a2a1-449c-9680-f91c70521c60 1
powercfg /setdcvalueindex scheme_max sub_disk 0b2d69d7-a2a1-449c-9680-f91c70521c60 1
  •  Change the power plan back to Power Saver.
 
You can also contact the computer vendor for a BIOS update that may fix the issue.

Thursday, January 12, 2017

Dynamics GP - "Duplicate Numbers are not allowed" in Edit List

One of your tables has errant or half-posted numbers

Use these queries to figure out what has been duplicated

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/12/04/identifying-duplicate-transactions/



— RM Duplicates
select RMDTYPAL, DOCNUMBR, COUNT(*) as [COUNT] from
(
select RMDTYPAL, RMDNUMWK as DOCNUMBR from RM10301 W
UNION ALL
select RMDTYPAL, DOCNUMBR from RM10201 W
UNION ALL
select RMDTYPAL, DOCNUMBR from RM20101 O
UNION ALL
select RMDTYPAL, DOCNUMBR from RM30101 H
) C
group by RMDTYPAL, DOCNUMBR
having COUNT(*) > 1

Microsoft Dynamics - How to submit a microsoft support request, open a support case or raise an incident

https://mbs2.microsoft.com/support/newstart.aspx


  • Login to Partnersource
  • Click Business Center
  • Bottom Left > Click New Support Request

Wednesday, January 11, 2017

Sunday, January 8, 2017

Dynamics NAV - Force Post Item Journal Entry to INTRANSIT location

This is not recommended for live environments, and should only be used for testing or recovery from damaged data.
This will allow you to do Item Journals against the INTRANSIT location

  • Modify C21
    • Rem out this line
    • ERROR(UseInTransitLocationErr,"Location Code");
    • You need to leave this line remmed out for the adjust costs job to run correctly
  • Modify C22
    • Rem out these lines
    • OldItemLedgEntry.TESTFIELD("Order Type",OldItemLedgEntry."Order Type"::Transfer);
    • OldItemLedgEntry.TESTFIELD("Order No.",ItemLedgEntry."Order No."); 

Tuesday, January 3, 2017

Dynamics NAV - Stock Count


  • Before beginning
    • Identify all blocked items and remove blocks before counting if required
    • Post all transfers, shipments, invoices, journals and anything that will impact inventory 
    • Run the adjust costs job
    • Print an inventory valuation report
    • Ensure that the Unit Cost on all Items is correct (This is what all positive adjustments will be costed at)
      • Set all Unit Costs to the Last direct cost * Exchange Rate if necessary
      • It is also possible to enter the Cost manually on the Inventory Journal itself
  • Regular Location
    • Departments > Warehouse > Good Handling Multiple Orders > Periodic Activities > Phys. Inventory Journals
    • Create Batch if one does not exist
    • Home>Process>Calculate Inventory
      • Include Items not on inventory
      • Include items with no transactions
      • Enter Document number
      • Enter Filters for location
      • Where Blocked is No
      • Click Ok
      • This will populate the journal with all items that can be found in that location
      • Enter quantity counted in the Qty.(Phys. Inventory) column
    • If any items are not populated, manually enter them
    • Click Post to post adjustments
  • Store Location using LS NAV - Stock Counting Worksheet
    • Create  anew counting worksheet 
      • ESL/Departments/LS Retail/InStore Management/Setup/Inventory Management
    • Pull up worksheet on device with scanner
      • Departments/LS Retail/InStore Management/Worksheets
      • Scan Item barcode to pull up item on worksheet
      • Enter count under Qty. (Phys. Inventory) column
      • Click Accept
        • Compress transactions if you want it to summarize similar lines, otherwise say no
      • Click Post to post changes as Item Ledger Entries and update GL

  • Warehouse Location
    • Departments > Warehouse > Good Handling Multiple Orders > Periodic Activities > Whse. Phys. Inv. Journals
    • Create Batch if one does not exist
    • Home>Functions>Calculate Inventory
      • Include Items not on inventory
      • Enter Document number
      • Enter Filters for location: WH
      • Enter filter for BIN if required
      • Click Ok
      • This will populate the journal with all items that can be found in that location
      • Enter quantity counted in the Qty.(Phys. Inventory) column
    • If any items are not populated, manually enter them, but enter the quantity in the Quantity column instead of the Qty.(Phys. Inventory) column
    • Click Register to finalize adjustments (This has not updated inventory or GL as yet)
    • Create Item Journal
      • DEPARTMENTS > WAREHOUSE > INVENTORY > TASKS > Item Journals
      • Select Template and journal
      • Home>Process>Calculate Whse. Adjustment
      • Click Post (This updates the GL and Inventory)
  • Warehouse Location with Tasklet Offline Count
    • Departments > Warehouse > Good Handling Multiple Orders > Periodic Activities > Whse. Phys. Inv. Journals
    • Create Batch if one does not exist
    • Home>Functions>Calculate Inventory
      • Enter Document number
      • Enter Filters for location: WH
      • Enter filter for BIN if required
      • Click Ok
      • This will populate the journal with all items that can be found in that location
    • Enter quantity counted Using the Tasklet Handhelds
    • Navigate back to Departments > Warehouse > Good Handling Multiple Orders > Periodic Activities > Whse. Phys. Inv. Journals
      • Pull up the batch and journal you calculated originally
      • Click Actions>"Import Offline Count"
      • Enter Handheld Number (1-4)
      • This will import the Tasklet Count into the calculated list
      • It will automatically insert new lines if necessary
    • Make any changes necessary
    • Click Register to finalize adjustments (This has not updated inventory or GL as yet)
    • Create Item Journal
      • DEPARTMENTS > WAREHOUSE > INVENTORY > TASKS > Item Journals
      • Select Template and journal
      • Home>Process>Calculate Whse. Adjustment
      • Click Post (This updates the GL and Inventory)

Dynamics GP - "The date cannot be part of a different fiscal year"

http://mystiquesmemory.blogspot.com/2012/03/date-cannot-be-part-of-different-fiscal.html

http://mystiquesmemory.blogspot.com/2016/01/fiscal-period-setup-error-date-cannot.html


In this case we had an issue where the First start day could not be set to 1-Jan-2017 for the 2017 fiscal year. It kept giving us the error  "The date cannot be part of a different fiscal year".

After running a

delete sy40100
where year1=2017
delete SY40101
where YEAR1=2017
delete sy40102
where year1=2017
delete SY40103
where YEAR1=2017

and a

GP>Tools>Utilities>System>Reconcile
the system wiped out the 2005 fiscal periods, and replaced them with the 1-jan-2017 period
This looks like the table got corrupted in some way, and the 2005 values were replaced with 2017 dates

We were able to change the first and last dates for 2005 back to the correct dates through GP, and recalculate the periods.
This freed up the 1-jan-2017 period, and allowed us to recalculate the 2017 year correctly.

A full reconcile was done on the GL, AR and AP for all years from 2005 onward