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!

  • 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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans