Dynamics NAV - Warehouse Handling is Required

Check The fields on the Warehouse Tab, set them to true

1. Require Receive

2. Require Pick fields





Original Solution
http://dynamicsuser.net/forums/p/29337/154874.aspx

Dynamics GP - Modifier and VBA Visual Basic - ODBC Connection

Private Sub GetItemCost()

Dim objRec
Dim objConn
Dim cmdString

Set objRec = CreateObject("ADODB.Recordset")
Set objConn = CreateObject("ADODB.Connection")

objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=GP\GPSQL;Initial Catalog=TWO;User Id=sa;Password=pw"
objConn.Open


cmdString = "Select CURRCOST from IV00101 where (ITEMNMBR='" + ItemNumber + "')"

Set objRec = objConn.Execute(cmdString)

If objRec.EOF = True Then
ManufacturingOrderReceiptEn.CurrencyM105 = ""
Else
ManufacturingOrderReceiptEn.CurrencyM105 = objRec!CURRCOST
End If
objConn.Close
End Sub

Ensure that you add all fields you need to VB
Ensure you run GP as administrator or the VB will not save
Call this in the body to execute for each record
ManufacturingOrderReceiptEn.CurrencyM105 is an empty calculated field
You must put the calculated field in the BODY or the appropriate section where the VB code is running

Dynamics GP - Business Analyzer - Reporting Services Web Service address

http://localhost/ReportServer_GP

Replace localhost with your server name

Dynamics GP - SQL View - Inventory Base UofM

SELECT     dbo.IV00101.ITEMNMBR, dbo.IV00101.UOMSCHDL, dbo.IV40201.BASEUOFM, dbo.IV40201.UMDPQTYS
FROM         dbo.IV00101 INNER JOIN
                      dbo.IV40201 ON dbo.IV00101.UOMSCHDL = dbo.IV40201.UOMSCHDL


------------------------------------------------------------------------------------
--UofM Conversion Table

SELECT        IV00101.ITEMNMBR, IV00101.UOMSCHDL, IV40201.BASEUOFM, IV40201.UMDPQTYS, IV40202.EQUIVUOM, IV40202.EQUOMQTY, IV40202.QTYBSUOM, IV40202.UOFM
FROM            IV00101 INNER JOIN
                         IV40201 ON IV00101.UOMSCHDL = IV40201.UOMSCHDL INNER JOIN
                         IV40202 ON IV40201.UOMSCHDL = IV40202.UOMSCHDL

eOne Smartconnect - Information Node taGLTransactionHeaderInsert not found in GLTransactionType. The element node is required for this transaction type.

Your map is grouping incorrectly on fields that are not the keys identified in the map header.

Either fix the keys in the map header, or change the grouping fields in the map.

SQL 2008 R2 - How to setup log shipping

Pre-requisites

• User account being used to setup the log shipping have sysadmin role in sql
• Primary SQL server
• Primary Backup Folder that Primary and Secondary servers can access
• Primary database set to Full or differential recovery
• Secondary SQL Server
• Secondary Backup Folder  that Primary and Secondary servers can access

Setup Log Shipping

• Right click on the database you want to ship on the primary server>Tasks>Ship Transaction Logs
• Add secondary server
• The easiest options is to let it generate a full backup and restore it to the secondary (first option)
• Restore Transaction Log in norecovery mode if you don't need to access it
• Restore Transaction Log in standby mode if you need to access it

To bring a restoring database from NORECOVERY to RECOVERY

RESTORE DATABASE database_name WITH RECOVERY

If you script out the whole thing to a query window, the script has two parts, one for the primary, one for the secondary.

Run each part of the script manually on each respective server to create the jobs if it doesn't do it automatically.

Good guide here
http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/

Dynamics GP - PO Prepayments

PO Prepayments allows you to create Check Payments against PO's as if they were invoices.

1. Setup PO Prepayments
1. Tools>Setup>Purchasing>PO Processing
2. Tick Allow Purchase Order Prepayments near the bottom of the window
1. If you tick create manual prepayment, it allows you to print the check directly from the PO screen when it is closed
2. If you do not tick create manual payment, you must use the check payment process to generate the payment
3. This enables the PO Prepayment field on the PO Entry Window on the left by the remaining subtotal
2. Create a PO
3. Enter a value in the prepayment field, save and close
4. Create Check Batch
1. Transactions>Purchasing>Edit check Batch
2. Create batch, tick Purchasing Prepayment Batch on the top right hand side
3. Close and reopen the Edit Check Batch window
4. The batch should only display PO's that can be prepaid
5. Select PO's, print checks
5. Once a payment is made against a PO, you cannot edit the PO
6. To edit the PO, you must remove the payment.