Is it possible to write to the Item ledger entry table?

Five · 2004-09-28

Hello All

I would like to find out if it is possible to write directly to the Item ledger entry table with a users licence?

If not then i need to be able to post an item journal to the item ledger entry.But this journal entry must allow me to leave out the quantity and the amount field as zero.Basically i just want to enter a price change in item ledger entry table for that item because the price of the product changed but there is no transaction of any sort .How do u get rid of the error msgs sayin there is nothing to post and that "amount cannot be zero"

i know the above would be best served by using the item card but my problem is that a "stock balances report" which i use picks from the item ledger entry and if i update the item card with the latest price that chnge is not reflected in the item ledger table.So the stock balances report does not get the latest price of the item and is therefore not consistent.
:shock:

Thanks to all that help

sgg · 2004-09-28

IF I get you correctly, the situation is either of the following 2:

1. You want to change the Unit Price, Last Direct Cost, Standard Cost, Profit % and Indirect Cost % on the item or stockkeeping unit cards of some Item(s).

or

2. You want to change the INVENTORY VALUE of some Item(s)

for the situations above, you need not write directly to the ledger entry table. Instead, you need to run either of the following Batch Jobs respectively:

for 1 above, run Adjust Item Costs/Prices Batch Job. This batch Job will make the changes you desire to the Item Card or the SKU card.

for 2 above, you need to do INVENTORY REVALUATION. you can check the help for the batch Jobs you need to run, and how to go about running them.

Five · 2004-09-28

Hi thanks for the reply ,

but what i really want to do is inventory revaluation ? how do i go about doing that from the Item ledger entry?

A report i created called stock balances report uses the item ledger entry(because the client wants it date based).So any given time my client can check his stock balances and the value of his stock.

but the problem comes in when he does a packsize revaluation.He does not buy new items but changes the price of certain items.These changes must now be relected in the item ledger entry so the above stock balances report can run.

i hope this clears it up abit :shock:

sgg · 2004-09-28

You should use the Revaluation Journals

Read the Help on Revaluing Inventory.

Check under Contents -> Inventory -> Revaluing Inventory

RobertMo · 2004-09-28

You are doing this for your client ? You work for MBS Partner ?
Sorry to say that, but you should first learn how Navision works before you start (even to think) to change it...

And don't let the auditors hear about your ideas...

nelson · 2004-09-28

Let me get this straight:
- The system was working;
- A new report was developed;
- The new report doesn't work togheter with the standard inventory functionality;
- Therefore, the existing functionality has to be changed.
Shouldn't it be the other way around?
Shouldn't the report adapt to the existing functionality and processes?
Otherwise, it's like ignoring the whole system and starting from scratch again. And for that, you don't need Navision at all!

chaswin · 2004-09-29

What exactly is the "Packsize revaluation"? Is your client changing the repackaging stock for example?

Five · 2004-09-29

Yes Chaswin..that is exactly what packsize revalution is.

Yes Robert i work for a NSC.Revalution journals were scraped because it did not meet the clients need so he opted for a customised soln.

As for nelson..if u don't have anything constructive to say.Please don't say anything. :twisted:

nelson · 2004-09-29

Yes, of course, you are absolutely correct.
They are your customer and I have nothing to do with it.
I am very sorry.

chaswin · 2004-09-30

Is your client not able to stock in the lowest base UOM (cans/units/etc) and then use the standard Navision conversion factor facility to handle the different pack sizes? As in stocking Castles (local beer) in cans, but selling in cans, 6 pack, 24 cans, etc?

aryaputhra · 2004-10-01

well!

firstly what ought to be done is a Revaluation journal. The revaluation journal will of course change the cost on a historical basis (i.e. what has gone into the item ledger entries).

But however, if you are saying the customer is not satisfied in that whilst viewing the report, the item ledger entry reflects the original cost; then you have two options:

1) modify the report to show the item ledger entries inclusive of the revalued cost.

or

2) Make a backup.

Run an update report to modify the cost directly into the item ledger entry table, value entry table and any respective related table of origin (not recommended and highly unethical actually).

Step 2 can only be considered if the posted entries are by means of an item journal (i.e. no purchase, transfer, whse entries exist) and the exercise is considered a once off one.

Is it possible to write to the Item ledger entry table?

Comments

Categories