Monday, June 22, 2015

Dynamics NAV LS Retail - POS Inventory Lookup does not work INV_LOOKUP

Other Issues:
POS Inventory Lookup is blank
POS Inventory lookup is unresponsive
https://portal.lsretail.com/Portals/35/LS%20Nav/LS%20Nav%20Documentation/How-To%20documents/How%20to%20Set%20Up%20POS%20Inventory%20Lookup%20-%20LS%20Retail%20NAV.pdf?ver=2015-04-28-234844-327
Solution:

  • Check the Retail Product Group>POS Inventory Lookup for each group
    • Confirm this table is synchronizing, and is ticked on HO and POS store card
  • Check the pos inventory lookup field on store card.
  • Check the pos inventory lookup field on each Item category card.
  • Check the inventory lookup field in the functionality profile card and select the HO distribution location.
  • Check the POS Functionality Profile>POS Functionality Profile Web Servers
    • Tick Local request
  • Ensure all post inventory lookup options are setup for all location profiles, stores and terminals
  • Run the Update POS Inventory Lookup Utility - For all stores
    • Store>Actions>Update POS Inventory Lookup
    • This is codeunit 99008909
  • Enable the Get Inventory Lookup in Web Service Setup>Web Requests
    • Edit the request xml
    • Add the Level 3>Normal>Text> Location_Profile if it's missing 
    • Tick optional
  • Clicking the Inventory button in the POS run the POS command INV_LOOKUP
    • C99001570
    • C99009513 Web Services Client: GetInventoryLookup
    • C99009512 WS Functions
  • Schedule this to run every hour
    • C99008909 LSC Pos Trans Server Utility


If all else fails,
  • T99001608 UpdateInventory
    • The PTsActive flag comes in True instead of False, and prevents the correct calculation of the "Phys. Inventory" field in C99001570
    • Modify the code to add 

    CALCFIELDS("Calc. Phys. Inventory","Calc. Total Sales","Calc. Purch. Order.","Calc. Posted Sales",
      "Calc. Total Inv. Adjmt.","Calc. Posted Inv. Adjmt.");
    "Phys. Inventory" := "Calc. Phys. Inventory";

before the Net Inventory Line (154)

1 comment:

  1. Thank you for detailed post on Inventory lookup. I did followed all these steps.. But what POS is shwoing on inventory lookup is, POS own inventory, and not the HO inventory. Transaction server is ON, as transactions are replicating using tranasction server.

    Please guide.

    ReplyDelete