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
• 
  

LS NAV - LS Mobile Hardware service cannot start

• Config file at “C:\ProgramData\LS Retail\LS Hardware Station\devices” is corrupted
• Delete the file
• Start Hardware Service

LS NAV - Z-Report does not display Tender Remove Transactions for some staff or some terminals

Staff 1 :- S005 (Manager)

Staff 2 :- S006 (Manager)

Staff 3 :- S008 (Cashier)

Scenario 1 :- If Staff 1 does a remove tender of $100 and staff 2 does a remove tender $200, the code filters through the staff and only prints the last staff remove tender based on order in the staff table . So, because staff 2 ID number (S006) comes after Staff 1 ID number (S005), the Z-Report will only print Staff 2 remove Tender of $200.

Scenario 2 :- If Staff 1 does a remove tender of $500 and staff 3 does a normal sale transaction of $20, the Z-Report will not print any remove tender. This is because, same as scenario 1, Staff 3 ID number (S008) comes after Staff 1 ID number (S005) and Staff 3 doesn’t have a remove tender attached to it so it shows no remove tender on the Z-Report even though Staff 1  did a remove tender.

This was a bug in LS Code that was updated and resolved in Business Central 13 (see below).

Codeunit:-

99008903 POS Print Utility

Documentation:-

LS-9602  ThJ - Mark Trans. Payment entries from all Staff with Z-Id when "Statement Method" = Total

Function:-

PrintXZLines

Code:-

IF StaffID_p <> '' THEN

  PaymEntry.SETRANGE(PaymEntry.StaffID,StaffID_p);

//LS-9602 -
ELSE
  PaymEntry.SETRANGE("Staff ID");

//LS-9602 +

Dynamics NAV - How to do a General Ledger Journal with VAT

• Go to General Journal
• Enter line with the following fields populated
• Account Type: GL Account
• Account No.: Must be populated
• Gen. Posting Type: Must be populated
• Gen. Bus Posting Group: Must be populated
• Gen. Prod Posting Group: Must be populated
• Vat Bus. Posting Group: Must be Populated
• Vat Prod. Posting Group: Must be Populated

LS NAV - Tender Remove transactions do not print on Z-Report for a specific POS

• This is a bug in LS NAV
• Refer to the link below for the solution

https://cowmasterscorner.blogspot.com/2019/05/ls-nav-z-report-does-not-display-tender.html

NAV CAL - Click a button and run a codeunit passing in the current record as a parameter

<Action1000000000> - OnAction()
MyCodeunit.MyFunction(Rec);


Rec will pass the current record

EDI X12 Schema notes - 850 PO

• Interchange (Envelope) ISA

• Auth. Qualifier	Text	2
  Auth. Information	Text	10
  Security Qualifier	Text	2
  Security Information	Text	10
  Int. Sender ID Qualifier	Text	2
  Int. Sender ID	Text	15
  Int. Receiver ID Qualifier	Text	2
  Int. Receiver ID	Text	15
  Int. Control Stds. Identifier	Text	1
  Int. Control Version	Text	5
  Int. Control Number ID	Text	9
  Acknowledgement Requested	Text	1
  Usage Indicator	Text	1
  Component Element Separator	Text	1

• Functional Group (Transaction Batch) GS

• Functional Identifier Code	Text	2
  App. Sender Code	Text	15
  App. Receiver Code	Text	15
  Date	Text	8
  Time	Text	8
  Group Control Number	Text	1
  Responsible Agency Code	Text	1
  Version	Text	6

• Purchase Order (Transaction) ST
• BEG
• REF
• Addresses
• Lines (Transaction Lines)