Global Dimension 1 Code in Transfer Orders

(1) Share

Report

Posted on by Greg Kujawa

583

So each of our company's Location Codes is set with a default Global Dimension 1 Code. Something doesn't seem to be flowing correctly in terms of this dimension when looking at the effects after transactions are posted. Here's an example.

Item is available at SAW Location Code (default DCH Global Dimension 1 Code).
The item is transferred from the SAW Location Code (default DCH Global Dimension 1 Code) to the NSH Location Code (default NASH Global Dimension 1 Code). Posted transfer shipment and posted transfer receipt in the books. We use the IN-TRANSIT step, although there are no default global dimension codes or anything like that defined for this dummy Location Code.
The item is sold from the NSH Location (default NASH Global Dimension 1 Code), with a posted sales invoice.
There are no errors with any of these transaction posting, but looking at the posted transfer receipt, it appears as if both the header and lines reflect the DCH Global Dimension 1 Code. Not the NASH Global Dimension 1 Code where the item was received from transfer.
As a result the sale of the item hits the COGS GL account so that it impacts the DCH Global Dimension 1 Code. Not the NASH Global Dimension 1 Code as one would expect.

Any suggestions on where to start digging into this in order to fix the behavior?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (1)

Report

That's standard behavior. You can only have 1 dimension code in a transfer order, and this dimension is used for both the the transfer shipment and transfer receipt. The reason being that while you can use dimensions to store inventory by dimension code, that's not really their primary use. If you want your scenario to work for you, you have to use the item journal or item reclass. journal to transfer the inventory instead of transfer orders.

For example, in the journal you would have 1 line for the negative adjustment with the 1st dimension code, and then a 2nd line with the positive adjustment with the 2nd dimension code.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Greg Kujawa 583 on at

Like (0)

Report

Yes, I see this now. It's working as it should. I was digging into some troubleshooting and thought this behavior was causing our issue. It's not. Thanks for the quick reply!

Was this reply helpful? Yes No
PRao 394 on at

Like (0)

Report

I agree with Valentin Castravet. System only considering Transfer- to- Code Dimension by default. If you want to change the dimension you can change in header and then Post the Transfer Order.

Item Journal and reclass journal with 1 line with Positive and other line with negative indifferent line, where dimension will be automatically populated based on location. Make sure document number should be same.

Thanks,
PR

Was this reply helpful? Yes No

Join the conversation

Community site session details

Global Dimension 1 Code in Transfer Orders

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Global Dimension 1 Code in Transfer Orders

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates