Retail items and products not showing up

(0) Share

Report

Posted on by Community Member

Hello all,

recently i have came across a problem where i created a new items and then ran process assortment without any errors and then run N-1040 job after that when reviewing download session log it ran successfully without any errors but when i enter any of the item details in POS nothing shows up... i have searched alot for a solution and tried alot of scenarios but no use.

i have Microsoft dynamics ax 2012 R3 CU9 with simple retail POS

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Hassan_rulz 3,801 on at

Like (0)

Report

RE: Dynamics ax 2012 R3 Retail items and products not showing up

Hi MarGroup,

I have also faced this issue recently and solution was to run the jobs with admin id.

Regards,

Hassan

Was this reply helpful? Yes No
Suggested answer

Mohd irfan mehdi 956 on at

Like (0)

Report

RE: Retail items and products not showing up

Hi MarGroup,

1.First check that the Product category is attached on product or not.

2. Product is showing in the assortment list or not. Retai > Assortment.

3. In the Assortment List store is attached or not.

4. in Organization hierarchy Assortment is attached or not.

5. after check all these setup you can also check the packet of 1040 job in download folder. whether data was created or not.

please revert me

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Retail items and products not showing up

@Hassan

thanks for your response but i am already an admin and also i tried with another admin user still no effect.

@Mohd

thanks for your response i checked all the point you mentioned and everything is OK items were in the assortment list and already attached to store and found it in orgnization hierarchy and also found data in the download folder

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Retail items and products not showing up

also when i open the retail store database and search in table RetailInventTable i cannot find the items at all.

Was this reply helpful? Yes No
Mohd irfan mehdi 956 on at

Like (0)

Report

RE: Retail items and products not showing up

Hello,

Make a change on product means attached tax on product and than remove it, and resend your product.

it product is applied please revert me.

can you share the product data which is present in sending packet.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Retail items and products not showing up

i tried adding tax to item and changing the name also and the search name but still the N-1040 job runs successfully and i find in the download session that it completed successfully but still does not appear in POS

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report
RE: Retail items and products not showing up

Check whether RetailInventTable Is blank. If it is then there are two contributing factors :

N-jobs delete table data and then re-insert all the data using the main data from the AX table.

The Replicate DataAreaID was probably unchecked for a subjob of the N-1040 (Products, prices, and bar codes)

Since N-jobs delete table data prior to writing, it deletes all of the existing items that were in POS. This is as expected with N-jobs. However, after an accidental unchecking of the Replicate DataAreaID for a subjob, the rows in that table are then not inserted into the POS database during the scheduled job.

if this is the specific issue then locate and correct the N-1040 subjob ADDP-InRBO that updates the RetailInventTable.

     1. Go to Retail > Setup > Retail Scheduler > Scheduler subjob
     2. Select Job Number N-1040.
     3. Under the Subjobs fast tab, find RetailInventTable in the Description field.
     4. Right click on the subjob number and select View Details.
     5. Under the Setup fast tab, checkmark Replicate DataAreaID.
     6. For Field for DataAreaid, select DATAAREAID from the dropdown.
     7. Run the N-1040 job.

There are other factors causing items not to show at POS. (but not limited to) things to check

    - Add items to a published Assortment (Retail > Setup > Assortments) and then run the Assortment Scheduler (Retail > Periodic > Assortment Scheduler)
    - Ensure the subjob is defined by the right job:   Retail Scheduler > Scheduler job > select N-jobnumber > General tab > Subjobs defined by job: N-jobnumber
    - Check the distribution filters for the job: Retail Scheduler > Scheduler job > select N-1040 > Setup > Distribution filters > Groups should be set to All (set in Retail Scheduler > Setup > Distribution Groups)
    - Check specific tables at POS that are related to the job you are running to see whether any data is coming across.
    - Start or restart the Store Connect service.
    - Check the IncomingMessages and OutgoingMessages tables of your AXRetailMSG databases for connection issues.
    - Check your Retail Store Connect profiles to ensure a proper connection is set

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Retail items and products not showing up

@magic1949

Thanks for your response but i already tried this and please be noted that i have dynamics ax 2012 R3 CU9

Was this reply helpful? Yes No
Suggested answer

Ansar Basha 1,582 on at

Like (0)

Report

RE: Retail items and products not showing up

Go to Retail Store>Inventory Tab in Ribbon>View channel products, see if the products are showing up in HQ.

If so, then see the language for the products such as en-us.

go to store >Edit and change the language same as product master.

In channel> make query like select *from ecoresproduct to see if you have products in DB, if you have the products and not showing up in POS then sure this is problem in assortments.

Regards,

Ansar Basha.S

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Retail items and products not showing up

@Ansar Basha

Thanks for your replay i checked all your points and everything is OK the language of products is same as store but when i run the query on channel store database i cant find the missing products in ECORESPRODUCT but all the old items is correct and is there.

Was this reply helpful? Yes No