Cowmaster's Corner: Dynamics NAV - LS Retail - OMNI

Friday, February 9, 2018

Import new C10012900 WI LS MGT for v110.06.00.490 and all other required objects
Confirm that General Ledger Setup>LCY Code is a Valid code that matches an existing Currency Code
Install OMNI Server
Install OMNI windows Service - creates omni db
Check web service setup
Confirm web requests available
Import newest web requests
Validate web requests
Import newest associated objects
This is very important, replecommitems does not work if this is not done

Create Distribution Group for ECOMM, Webshop, and add only the Web Store WEBSHOP in the subgroup
Store Group List - Set the web store to have it's own distribution list and subgroup
Do not leave the webshop in the same distribution group as all other stores

Add member WEBSHOP to the subgroup
run "truncate table [CRONUS$Preaction]" to clear any existing actions
run "truncate table [CRONUS$WI Item With Daily Updates]" to clear any previous items
Create all of the sync jobs by running page "WI Default Data"
WI Stores-Set default webshop store
Set Store Vat Bus Posting Group
Round small decimals to 0.01

UpdateWI_LS_ProductStockQuantity(VAR WILSProduct_p : Record "WI LS Product";VAR Item_p : Record Item)
//UpdateWI_LS_ProductStockQuantity
IF WILSProduct_p.NavParentGroupedProductId = '' THEN
WILSProduct_p.StockQuantity := Item_p.CalcPhysInventory(WILSProduct_p.NavPK,'',StoreLocation_g)

This piece of code breaks if you have decimals, change it to round down to 0 decimals

WILSProduct_p.StockQuantity := Round(Item_p.CalcPhysInventory(WILSProduct_p.NavPK,'',StoreLocation_g),0,'<')

Create POS Startup Data
Set Item Distribution for all items for the web store with attributes and a photo
Run ECOMMERCE JOB (C10012900 WI LS MGt-this always runs for ALL items)
Check T10012867 WI Items with Daily Updates
T10012912 is populated with all items to replicate to omni
Clear all preactions, then run ecommerce job
-ReplEcommItems uses the Preaction table to control the final action sent per item
10012861 WI Price provides prices to OMNI

Sales Price has been set with a Vat Product Posting group that matches the store
VAT Product Posting group is updated on item card

A package import to update the vat field with the same value counts as an update to trigger the sync

If you're getting trouble syncing items and prices, ensure you run the jobs in this order

Web store is in it's own store group
Item distribution is set to the web store group
Item Prices have the same Vat Prod Posting group as web store
Item has attributes and images
Item quantities are in whole numbers, or mod the codeunit to round to 0 dp
Run ECOMMERCE JOB (C10012900 WI LS Mgt) to populate WI Products based on Item Distribution (Setup job to run every hour, updates items)
Run C10012870 WI Mgt Priceonly to update the WI Price Table based on the WI Products table (Setup Job to run every 10mins, updates stock and prices)

Cowmaster's Corner