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

https://support.microsoft.com/en-us/supportforbusiness/productselection

• Login to Partnersource
• Select product
• Enter support request

Dynamics NAV - Revaluation Journal - Open Outbound Entry Found

• Negative stock exists on an item.
• Set the stock to 0 for any negative quantities

Dynamics GP - Project Accounting Tables

http://www.sanjaykumar.us/index.php/dynamics-gp-project-accounting-tables/
https://community.dynamics.com/gp/f/32/t/174218
https://gptables.prospr.biz/project-accounting-tables-dynamics-gp


PA10001 - Project Timesheet Line

PA Billing Header HIST - PA33100
PA Billing Detail HIST - PA33200

PA Billing Header OPEN - PA23100
PA Billing Detail OPEN - PA23200

PA Billing Header WORK - PA13100
PA Billing Detail WORK - PA13200

PA Project Master File - PA01201

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."); 

eOne Smartconnect - Script to get Today's date in a format GP will accept

http://www.eonesolutions.com/help-article/kba-01074-f3b8y5/

Create a calculated field with this formula

return DateTime.Now.ToString("MM/dd/yyyy")

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 
• Departments/LS Retail/InStore Management/Setup/Inventory Management/Inventory Mask Setup
• Type:Counting
• 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
• OR the Whse. Item Journal screen can be used instead after passing adjustment to set all stock to zero first.
• Transactions should all start from the ADJUSTMENT zone
• 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