Dynamics GP - Exchange Rate in Ar Trial Balance does not match exchange rate on transaction

This happens if you have done a revaluation

• mc020102 - Holds exchange rate before revaluation
• mc020104 - Holds exchange rates after valuation

You need to use both to calculate the real exchange rate. Use MC020104 first, then MC020102 if blank

How to Build an iOS App

• Download and install Virtualbox
• https://www.virtualbox.org/wiki/Downloads
• Setup MacOS(Mojave) virtual machine 
• https://www.intoguide.com/download-macos-mojave-vmdk-file/
• https://www.intoguide.com/install-macos-mojave-virtualbox-windows/
• On host machine, run these scripts replacing "Your VM Name" with your VM name.

• cd "C:\Program Files\Oracle\VirtualBox\"
  VBoxManage.exe modifyvm "Your VM Name" --cpuidset 00000001 000106e5 00100800 0098e3fd bfebfbff
  VBoxManage setextradata "Your VM Name" "VBoxInternal/Devices/efi/0/Config/DmiSystemProduct" "iMac11,3"
  VBoxManage setextradata "Your VM Name" "VBoxInternal/Devices/efi/0/Config/DmiSystemVersion" "1.0"
  VBoxManage setextradata "Your VM Name" "VBoxInternal/Devices/efi/0/Config/DmiBoardProduct" "Iloveapple"
  VBoxManage setextradata "Your VM Name" "VBoxInternal/Devices/smc/0/Config/DeviceKey" "ourhardworkbythesewordsguardedpleasedontsteal(c)AppleComputerInc"
  VBoxManage setextradata "Your VM Name" "VBoxInternal/Devices/smc/0/Config/GetKeyFromRealSMC" 1

• On VM, Download XCode
• https://developer.apple.com/xcode/
• Learn Swift
• Build your app
• https://codewithchris.com/lesson1/

Dynamics GP - SSRS vlookup equivalent to another dataset to get related values

https://www.sqlservercentral.com/articles/using-lookup-function-to-bridge-datasets-in-report-builder

1. We are trying to add the Item UofM to the HITB report
2. Create dataset with lookup values (Eg. ItemMaster)
3. In field, create expression as follows

=Lookup(HITBItemNumber,HITBItemNumber,ItemMasterBaseUofM, LookupDatasetName)

Example:

=Lookup(Fields!ITEMNMBR.Value,Fields!ITEMNMBR.Value,Fields!BASEUOFM.Value, "ItemMaster")

NAV - Filtering on a Flowfield is very slow

• Enter other filters first to reduce the number of records
• Enter your flowfield filter last so that it does not try to calculate for every single record in the table

NAV CAL - Get next number in No. Series

Name DataType Subtype Length
NoSeriesMgt Codeunit NoSeriesManagement

    NoSeriesMgt.GetNextNo(MyNoSeries,TrxDate,true);

How to use DEVOPS SCRUM to manage your ERP Implementations

• Plan analysis sessions based on ERP Process list for items in scope
• Create workshops
• Create Business processes
• Complete Analysis and Fit/Gap Sessions for  a workshop or business process, take notes
• Create requirements (Work Tasks) for customer requirements based on notes
• Update task descriptions with full detail to accurately estimate
• Assign tasks
• Execute task
• Update Documentation, attach to Work Task
• Documentation should include 
• Objects and field descriptions
• Process walkthrough with screenshots
• Update Test cases
• When Documentation and Testing are complete, mark task as complete
• If tests are not successful, adjust task, test script and documentation to meet requirement
• If scope change is too large, it may require a new task
• Use search to confirm if missing functionality is already in existing task
• When entire epic is complete, combine all documentation into an epic FDD
• When all epics are complete, combine all documentation into a complete FDD

How to run a SCRUM Sprint Planning Session

• Assemble entire team and Customer
• Review Physical Kanban Board
• To Do, In Progress, Done
• Tasks are not done unless testing and documentation is also completed
• Update Tasks in Devops during Backlog Grooming Session
• Review product backlog list
• Review any new User Story backlog items that have been added, flesh them out, confirm if they will be moving forward with them in the next sprint (Usually done in weekly backlog grooming session)
• Assign to resource responsible for ensuring the tasks in user story are completed
• Create, Assign, and estimate each task
• Resources will generally volunteer to take on tasks based on their own capacity
•