Transfer order issue in NAV SG 5.0 SP1

phani_kaushik

Hi,

The Singapore version of NAV 5.1 seems to post wrong inventory entries into G/L upon posting a transfer order.

Even in Cronus, this is the case:

24-01-08 109001 2110 Resale Items Direct Cost on 24-01-08 2,308.50 -2,308.50 G/L Account No 2871 0
24-01-08 109001 7170 Inventory Adjmt., Retail Direct Cost on 24-01-08 2,308.50 2,308.50 G/L Account No 2872 0
24-01-08 109001 2110 Resale Items Direct Cost on 24-01-08 2,308.50 2,308.50 G/L Account No 2873 0
24-01-08 109001 7170 Inventory Adjmt., Retail Direct Cost on 24-01-08 2,308.50 -2,308.50 G/L Account No 2874 0

The 1st two entries are actually correct whereas the other two are just nullifying the 1st two, which is wrong.

Can someone help me out whether there are any hotfixes or any other way to solve this?

kapil4dynamics

What is wrong ? U shipped it ,

Cr Inventory A/c
Dr Inventory Adjustment From Transfer from Code

NAV automatically received it in "In Transit"

Dr Inventory A/c
Cr Inventory Adjustment.

After posting the receipt at Transfer to

Cr Inventory A/c
Dr Inventory Adjustment From In Transit

AND

Dr Inventory A/c
Cr Inventory Adjustment. at Transfer to Code.

matttrax

A transfer order by definition cancels itself out...you ship something, then you receive it back in at a different location.

Kowa

It is also possible for each location to have it's own inventory account in the inventory posting setup. That is not used in the Cronus database, but is recommendable, especially if each location is regarded as a seperate profit center.
If you set it up that way your first and third entry will touch different accounts.