web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Statement Posting - In...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Statement Posting - Incorrect warehouse is affected

(0) ShareShare
ReportReport
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)
  • Xusheng Profile Picture
    Xusheng on at

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

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at

    Hi,

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

  • JeffreyPW Profile Picture
    JeffreyPW 228 on at

    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?

  • Suggested answer
    JeffreyPW Profile Picture
    JeffreyPW 228 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 302 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 183 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 120 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans