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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Warehouse Transactions...
Microsoft Dynamics AX (Archived)

Warehouse Transactions - Main account

(0) ShareShare
ReportReport
Posted on by Cam Phung

Hello All,

I have item A and 3 warehouse: Material, WIP, Inventory.

I want to setup account (Issue, Receipt) according 3 warehouse:

- If Item A in warehouse Material: Issue account and receipt account is 152

- If Item A in WH WIP: Issue and receipt account is 154

- If Item A in WH Inventory: Issue and receipt account is 156.

For example:

1. When I Purchase Item A into WH Material: Dr152/Cr offset account (use Vendor group)

2. When I transfer Item A from WH Material to WH WIP: Dr154/Cr152 (????????)

3. When I sales Item A from WH Inventory: Dr offset account/Cr156 (use Customer group)

AX support setup Item posting account in Sales (Customer group), Purchasing (Vendor group) and Production (Product group).

I does not know whether AX support setup for Inventory Journal?

Thank you,

Phung Luong.

*This post is locked for comments

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese on at
    RE: Warehouse Transactions - Main account

    The design of AX is to use Item group, and not Warehouse, to control the main account posting for inventory issues and receipts.  In other words, if you had Item groups named Material, WIP, and Inventory, and setup those Item groups according to your description, then you would have the main account breakdown that you want, regardless of warehouse.  If you then happened to have item on-hand broken into similarly named warehouses, all the better for you, but it wouldn't drive ledger behavior.

    However, in your example you have the same item A being transferred between warehouses, and since an item can't be in more than one Item group at the same time, that doesn't accomplish what you've asked.  I'm a little surprised that you're not turning raw material A into a WIP item B and finally into a finished good item C, since your example implies some type of light manufacturing being done to the item (why else would you call it WIP?).

    The best alternative I can think of right now is to put those warehouses into different sites, and then use Dimension link to apply a financial dimension to each transaction based on the inventory site.  The main account would not be different in that case, but the financial dimension would serve to differentiate the inventory balance by site (and by warehouse by proxy) in the same way.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans