Global Dimension 1 Code in Transfer Orders

(1) Share

Report

Posted on by Greg Kujawa

627

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

All responses (3)

Answers (1)

PRao 114 on at

Like (0)

Report

Global Dimension 1 Code in Transfer Orders

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
Greg Kujawa 627 on at

Like (0)

Report

Global Dimension 1 Code in Transfer Orders

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!
Verified answer

Valentin Castravet 24,894 Super User 2024 Season 2 on at

Like (0)

Report

Global Dimension 1 Code in Transfer Orders

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/