Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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!

  • Suggested answer
    JeffreyPW Profile Picture
    JeffreyPW 228 on at
    RE: Statement Posting - Incorrect warehouse is affected

    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.

  • JeffreyPW Profile Picture
    JeffreyPW 228 on at
    RE: Statement Posting - Incorrect warehouse is affected

    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?

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at
    RE: Statement Posting - Incorrect warehouse is affected

    Hi,

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

  • Xusheng Profile Picture
    Xusheng on at
    RE: Statement Posting - Incorrect warehouse is affected

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

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Zain Mehmood Profile Picture

Zain Mehmood 462 Moderator

#2
Danny Bilodeau Profile Picture

Danny Bilodeau 156 Moderator

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 120 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans