HQ Worksheet 330 Wizard Issue

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

We have an issue with creating a worksheet 330 for Inventory Transfer using the "Transfer items based on each store's re-order information."

When we issue the worksheet, the PO it creates does not contain the appropriate transfer amounts, even with the items are way below the re-order number in HQ.

Creating a transfer from the store using the re-order information results in a correct PO.

We have 3 store and 1 warehouse and this issue is affecting 2 out of the 3 stores. One store is working perfectly from the HQ. We've re-indexed the the database and it fixed it for a few days, but it is now acting up again.

HQ version is 2.0.2000 on Windows 8.1

Any idea would be greatly appreciated.

Thanks!

*This post is locked for comments

All responses (10)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

I'm also having this problem. I have a few items that are not being added to PO when running 330. I have adjusted inventory levels for that store and item in HQ. When I ran SO Client at the store, it took a very long time to process the inventory worksheet. Running 330 with only the one item on there takes a very long time.

Seems like maybe it's timing out for that item and not adding it, maybe?
Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

This is the value shown in our HQ:

This is the On Order values at each of the stores and Warehouse:

We do have some on order, but the amounts are not adding up.
Jeff @ Check Point ... 13,380 on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

Fredrick,

The store should not be modifing the info, only HQ. To be honest, we turn off all editing functions at the store level via Security.

Modify the HQ info and send it down using a 308 worksheet.
Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

We do have it set in HQ. Always has been. Issue still persists.
Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

Read my previous post , you have to set the reorder and restock data on HQ Manager , not RMS
Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

We have no open POs at any store and the issue is still present. The items affected show a large quantity on order in HQ, but the stores are showing 0 on order.
Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

Ok i did figured it out , it is because HQ use the reorder and restock data located in HQ Store Quantity tab , not the RMS inventory reorder / restock level

http://i.imgur.com/wf0dbWa.png

So now my question is , how to push the Reorder and restock level from the store level to the HQ quantity tab

I have read something similar with price and store price (HQ) not being populated

community.dynamics.com/.../180954

someone has proposed a a SQL command to fix this price issu

set itemdynamic.price=itemdynamic.snapshotprice

any idea
Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

of course we already did that.

Doing a PO using Store operation manager for a specific supplier will give use about 50 different items to order

Doing the same task using the same parameter on HQ manager , the PO generating will contain 3 products ...
Jeff @ Check Point ... 13,380 on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

Make sure there are no open PO's or Transfer for the items
Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Worksheet 330 Wizard Issue

We have the exact same issue here , 2 stores 1 warehouse

HQ version is 2.0.2000 on Windows 7 64bits

any idea ???