Dynamics GP - SQL View - Miscellaneous Cheques and Distribution details

SELECT     TOP (100) PERCENT dbo.CM20200.CHEKBKID, dbo.CM20200.CMTrxNum, dbo.CM20200.CMTrxType, dbo.CM20200.TRXDATE, dbo.CM20200.GLPOSTDT,
                      dbo.CM20200.TRXAMNT, dbo.CM20200.CURNCYID, dbo.CM20200.paidtorcvdfrom, dbo.CM20200.DSCRIPTN, dbo.CM20200.Recond, dbo.CM20200.RECONUM,
                      dbo.CM20200.ClrdAmt, dbo.CM20200.clearedate, dbo.CM20200.VOIDED, dbo.CM20200.AUDITTRAIL, dbo.CM20200.SOURCDOC, dbo.CM20200.SRCDOCTYP,
                      dbo.CM20200.SRCDOCNUM, dbo.CM20200.POSTEDDT, dbo.CM20200.Checkbook_Amount, dbo.GL00100.ACTDESCR, dbo.GL00105.ACTNUMST,
                      dbo.CM20400.DEBITAMT, dbo.CM20400.CRDTAMNT, dbo.CM20400.DistRef, dbo.CM20200.VOIDDATE
FROM         dbo.CM20200 INNER JOIN
                      dbo.CM20400 ON dbo.CM20200.CMRECNUM = dbo.CM20400.CMDNUMWK INNER JOIN
                      dbo.GL00100 ON dbo.CM20400.ACTINDX = dbo.GL00100.ACTINDX INNER JOIN
                      dbo.GL00105 ON dbo.CM20400.ACTINDX = dbo.GL00105.ACTINDX
WHERE     (dbo.CM20200.SOURCDOC = 'cmtrx')
ORDER BY dbo.CM20200.CMRECNUM

Dynamics GP - SQL View - Open PO Lines and Line Comments

SELECT        POP10100.DOCDATE, POP10100.PONUMBER, POP10150.CMMTTEXT AS POComment,
                         CASE POLNESTA WHEN 1 THEN 'New' WHEN 2 THEN 'Released' WHEN 3 THEN 'Change Order' WHEN 4 THEN 'Received' WHEN 5 THEN 'Closed' WHEN 6 THEN 'Cancelled' END AS POLineStatus,
                         CASE POP10100.POTYPE WHEN 1 THEN 'Standard' WHEN 2 THEN 'Drop Ship' WHEN 3 THEN 'Blanket' WHEN 4 THEN 'Blanket Drop Ship' END AS POType, POP10110.ITEMNMBR, POP10110.ITEMDESC,
                         POP10550.CMMTTEXT AS LineComment, POP10100.VENDORID, POP10110.LOCNCODE, POP10110.QTYORDER, derivedtbl_1.QTYINVCD, POP10110.UNITCOST,
                         CASE POstatus WHEN 1 THEN 'New' WHEN 2 THEN 'Released' WHEN 3 THEN 'Change Order' WHEN 4 THEN 'Received' WHEN 5 THEN 'Closed' WHEN 6 THEN 'Cancelled' END AS DocStatus,
                         GL00105.ACTNUMST, POP10100.BUYERID, PM00200.VNDCHKNM, POP10100.TAXAMNT, (POP10110.QTYORDER - derivedtbl_1.QTYINVCD) * POP10110.UNITCOST AS RemainingLinetotal,
                         POP10100.REMSUBTO
FROM            POP10100 INNER JOIN
                         POP10110 ON POP10100.PONUMBER = POP10110.PONUMBER INNER JOIN
                         PM00200 ON POP10100.VENDORID = PM00200.VENDORID LEFT OUTER JOIN
                             (SELECT        PONUMBER, POLNENUM, POPRCTNM, RCPTLNNM, QTYSHPPD, QTYINVCD, QTYREJ, QTYMATCH, QTYRESERVED, QTYINVRESERVE, Status, UMQTYINB, OLDCUCST, JOBNUMBR, COSTCODE,
                                                         COSTTYPE, ORCPTCOST, OSTDCOST, APPYTYPE, POPTYPE, VENDORID, ITEMNMBR, UOFM, TRXLOCTN, DATERECD, RCTSEQNM, SPRCTSEQ, PCHRPTCT, SPRCPTCT, OREXTCST, RUPPVAMT,
                                                         ACPURIDX, INVINDX, UPPVIDX, NOTEINDX, CURNCYID, CURRNIDX, XCHGRATE, RATECALC, DENXRATE, RATETPID, EXGTBLID, Capital_Item, Product_Indicator, Total_Landed_Cost_Amount,
                                                         QTYTYPE, Posted_LC_PPV_Amount, QTYREPLACED, QTYINVADJ, DEX_ROW_ID
                               FROM            POP10500
                               WHERE        (POPTYPE IN (1, 3))) AS derivedtbl_1 ON POP10110.PONUMBER = derivedtbl_1.PONUMBER AND POP10110.ORD = derivedtbl_1.POLNENUM LEFT OUTER JOIN
                         GL00105 ON POP10110.INVINDX = GL00105.ACTINDX LEFT OUTER JOIN
                         POP10550 ON POP10110.DOCTYPE = POP10550.DOCTYPE AND POP10110.PONUMBER = POP10550.POPNUMBE AND POP10110.ORD = POP10550.ORD LEFT OUTER JOIN
                         POP10150 ON POP10100.PONUMBER = POP10150.POPNUMBE

Dynamics NAV LS - Attribute Name does not display under retail item card attribute

• Search for Attribute Setup
• Update the Description field to anything different

Dynamics NAV - How to Enable Item Attributes on Items

• Search for Retail Setup
• Other Fasttab>Assign attribute codes

Dynamics NAV - Pick Ticket - Nothing to Handle

Check the following

• Do i have enough stock in my bin?
• Register Whse Inv Journal> enter qty
• Go to Item Journal
• Calculate Whse Adjustments
• Post Item Journal
• Is my bin assigned a bin type that has "Pick" ticked?
• Search for bin type
• Tick Pick for appropriate bin type
• Am i a warehouse employee?
• Check the Units of Measure of the item in the Bin and on the Sales Order.
• If the exact uofm does not exist in the bin, it will not find anything to pick
• Check the bins that are holding the stock, they may not be pickable
• Enable "Allow Breakbulk" on the location to allow it to pick/fulfil in any UofM

Dynamics NAV - Tiered Discounts by Dollar Amount

Dynamics NAV 2015 does not support tiered discounts by Amount, only by Quantity.
This would need to be customized.

Dynamics NAV - Remove Transfer Orders

Sometimes Transfer Orders can seem to be "stuck".
To unstick them:

• Search for Picks window
• Post all Picks
• Search for Warehouse Shipments
• Post all Warehouse Shipments (These will generate more picks)
• Post all Picks
• This should complete the Shipment part of the Transfer
• Search for Put-Aways window
• Post all Put-Aways
• Search for Warehouse Receipts
• Post all Warehouse Receipts (These will generate more put-aways)
• Post all Put Aways
• This should complete the Receipt part of the Transfer
• Search for Transfer Orders
• Reopen the Transfer Order
• Delete the Transfer Order

Customizations that would help

• Once completed, set status to Closed
• Create Routine to delete all closed transactions