Supply chain | Supply Chain Management, Commerce

Statement Posting - Incorrect warehouse is affected

(0) Share

Report

Posted on by Community Member

Hello Everyone,

I have a case with one of my customers who is using the retail (Dynamics AX 2012 R3 CU13), as they are in the food business they are using "Batches" to track their items expiry.

Upon posting the statement the system is generating the Sales Orders, Sales Invoices and Customer Payments perfectly according to the actual sales and following the configured setups, however when I check the "Inventory Transaction" that is linked to the sales order and sales invoice I realized that the system has affected a different warehouse not the one that is linked to the sales order and linked to the retail store.

Anybody have seen behavior this before? Could this be related to quantity missing in the retail warehouse and accordingly the system automatically decided to select a different picking warehouse?

I am using the Periodic Posting for the Statements.

Any insights will be great!

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Xusheng Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Does this is for cross store return? Have you can reproduce this issue at DEV ENV?

Was this reply helpful? Yes No
Oksana Kovaliova 3,597 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

It does not look like standard behavior. Can be some customization that is causing the issue.

Was this reply helpful? Yes No
JeffreyPW 228 on at

Like
a
(0)

Report
Copy link

Link copied!

I am seeing this same behavior in the latest version of Dynamics 365 Finance. No customizations.

A retail store's statements post fine, but, upon further investigation, the inventory dimension is specified as a different warehouse than the financial dimensions. I suspect it is because the store doesnt have adequate inventory, so the next available warehouse gets dinged for the inventory... Even though in both item model groups and the warehouse configs we have allowed both physical and financial negative inventory... Was this ever solved?

Was this reply helpful? Yes No
Suggested answer

JeffreyPW 228 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue ended up being because the Item Model Group to which all items belonged was configured to allow negatives at the site level, but it wasnt checked for warehouse level... which afaik is the default when creating an item model group. So even though each warehouse was configured to allow negatives, the item model group allowed it as a site wide thing... So, if another warehouse in the site had inventory, ding... The solution was to create a new model group allowing negatives on a site AND warehouse level, and then making sure each warehouse allows it... Then the drama of moving all items/recreating items in the new model group and done.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Statement Posting - Incorrect warehouse is affected

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Statement Posting - Incorrect warehouse is affected

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates