Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Ehab Moustafa]

Dear all,

I’m using GP 2015 R2 and I face this issue;

When receive In-Transit Transfer without Landed Cost items, transaction distribution is posted okay to GL. But, when assign Landed Cost items into In-Transit Transfer receiving transaction… I note that only Landed Cost distribution is posted to GL module and inventory distribution for original items’ cost is missing in GL… when investigate In-Transit Transfer transactions in inventory module I found distributions okay for both Ship & Receive !!

Is there any system setup that prevent distribution integration when use LC into In-Transit Transfer Receiving transaction??

——————————
Ehab Moustafa
Advanced Solutions Experts Co.
Alexandria
——————————

[David Joosten]

Hi,
Just to check, is the stock transfering into a location with a different GL control account linked to that location. If it is not moving into a new GL location, the stock transfer will be a debit and credit to the same account and no actual GL transaction will be created. The only variance will be the landed cost and therefore it will be the only GL transaction that is created.

In order for the stock control account to be different, you would need to use the location segment override.

Regards,

——————————
David Joosten
Enterprise Architect
Premier FMCG (Pty) Ltd
Waterfall City
——————————
——————————————-

[Thaddeus Suter]

When posting an Intransit Transfer with Landed Costs there should be two Journal entries produced and the LC is applied on the Receipt to Destination.

1. The Post of the Shipment from Warehouse to Intransit results in a debit to Intransit IV and a Credit to Warehouse IV even if the accounts are the same a GJ is created.

2. The Receipt of the Shipment posted by Batch results in a Credit to Intransit and to Landed Costs and a Debit to Destination IV. also even if the accounts are the same.

See posted Journal entry below for number 2 where $40.50 LC is applied to a $810 item.

Make sure you Post by Batch and the setups for Posting Series – Inventory – Intransit Transfers are Post To and Post Thru the GL and do not mark “Allow Transaction Posting”

——————————
Thaddeus Suter
Retus, Inc
Helotes TX
——————————
——————————————-

[Ehab Moustafa]

Hi again,

In first, thank you for your support.

Actually I have tested as Thaddeus explained and I finally get the distribution into GL module but in wrong way… in my case I had configured three GL accounts which use third segment as site’s account segment ID and GP system should use the appropriate GL account according to used Site ID in system transactions… So, item quantity has been issued from site 1 Via Site 2 to site 3… when ship quantity distribution is posted okay as below;

Site 1 will be credited and Via Site will be debited
When receive item quantity into Site 3 with LC, the LC should debit site 3 account by its additional cost and in the same time Site 3 account should be debited with item original cost and Via site “2” should be credited to close previous shipping transaction… but what I found is as below;

If I test the same transactions without LC everything is okay!!

Any suggestion?

——————————
Ehab Moustafa
Advanced Solutions Experts Co.
Alexandria
——————————
——————————————-

[Thaddeus Suter]

The second distributions screen shot above does not indicate an Intransit-Transfer Receipt as the distributions would be inventory, not purchasing.

Also when receiving an Intransit transfer the Distributions button is greyed out and is not accessible. You do not see the distributions until you print the Posting Distributions Journal.

See example below of a correct Intransit Receipt with Landed Cost. Note the Distributions cannot be accessed. The transaction should be saved to a batch and posted.

——————————
Thaddeus Suter
Retus, Inc
Helotes TX
——————————
——————————————-

[Ehab Moustafa]

Hi Thaddeus,

Yes, you are right… you couldn’t access Receiving In-Transit Inventory distribution until transaction to be posted and the second screen that I attach in my previous post was from GL when I already post source transaction in Purchasing module. But, as you can note.. JE has two distributions, one for LC amount & the other one should be for inventory which is the wrong one!!

Do you face the same issue?? I had have tried many GP versions and faced the same result for Inventory distribution!!

Is it a system bug?

——————————
Ehab Moustafa
Advanced Solutions Experts Co.
Alexandria
——————————
——————————————-

[Thaddeus Suter]

No it is not a bug. The Intransit Transfer w LC posts just fine since at least V2010/2013 with correct distributions as I have shown above.

You have a problem in your setups somewhere that go beyond the scope of this thread as there are many setups to review.

Your VAR should be able to review the setups by looking at the windows and resolve the problem.

Review:
Any Custom Modifications/Triggers related to POP and NONINVEN Receipts.
Any Third Parties related to POP Receipts
Posting Setups
Posting Account Setups
POP Setups
IV Control Setups
LC Setups
Item Setups
Item LC Setups
Location Code Site Segments

——————————
Thaddeus Suter
Retus, Inc
Helotes TX
——————————
——————————————-