Transfers

ChristosHSL

Dear All,

Thank you very much for your replies to my question.

A last thing that I would like to ask is the following: Is there a way to reprogram Navision (coding) and remove the restriction of not posting a transfer if the inventory shown for that item is not sufficient?

In simpler words, reprogram it in order to avoid the "not on inventory" message and let you post the transfer.

Please advise.

Thank you in advance.

Regsrds,

Christos.

ara3n

The more importnat question is why are you trying to transfer nothing from one location to another?

Yes it's possible, comment out the code, but in 4.0 you'll get wierd no. a item ledger with quantity Zero. And what about cost.

kine

Yes, as already said, it is possible, but you will corrupt whole system... :!:

Kowa

As I pointed out in your first thread, you can use negative and postive adjustments in an item journal instead ( with the correct unit cost in the positive adjustment), but deactivating the error message will mess up your inventory valuation.

DenSter

How do you get to wanting to transfer inventory from a location that it doesn't exist? So you walk into Location A, because Navision says it has 5 Items X. You get there and it's not there, so now someone says 'don't worry we will just transfer it from Location B, that location also doesn't have any'.

I don't get it..... If you don't have any Item X on any inventory, you will need to do a positive adjustment, not a transfer.

Kowa

DenSter wrote:

How do you get to wanting to transfer inventory from a location that it doesn't exist? So you walk into Location A, because Navision says it has 5 Items X.

The transfer problem comes up when the items are available, but not yet posted. This frequently happens in "Hub-and-Spoke" Environments without WMS where the posting of a great number of purchase orders usually has a delay of 2-3 days until someone at the office has time to check the shipment document.
If there are drop shipments in the agencies and the documents arrive via "snail mail" this can take even longer.

Shenpen

I am not so sure it would break inventory value.

When you make negative inventory with a sales order, then when the next purchase arrives and Inventory Adjustment is run, Item Application entries are backwards generated.

Maybe it works for transfers too.

However, there is a better solution:

1) Write code to a menu item to a transfer order, that creates positive adjusment journal lines with a special reason code into a journal and run that journal so users can just simply post it. It is easy. The only problem is Unit Cost. Maybe you could get the Unit Cost from the next unreceived PO line... or a later automatic generation of revaluation journal lines can be OK. Another idea is to generate this pos adjustments in another location and autogenerate reclass journal lines. If you put the inventory value of this location to a diferent G/L account, that helps in preventing valuation chaos.

2) Write another code that automatically generates negative afjustment to a journal for all positive ones from that reason code (or for the negative inventory of that special location). It could be filtered for date or whatever.