(Navision Financials 2.50 CZ) Dear advanced users, which is the easiest way to set up initial inventory (for all items) when I want to start using Navision Financials? Suppose that I have already created the item cards and set appropriate properties (=filled the required fields) for all the items. I thought it would be a good idea to use Phys. Inventory Journal for this purpose. But the batch “Calculate Inventory” does not seem to work as I would expected. Even with checked “Items Not on Inventory” option, it does NOT generate appropriate lines in the Phys. Inventory Journal for these brand new items. Surprisingly (for me), when I post a Positive adjustment for some item, then the Negative adjustment for the same item (the same amount, so the inventory is 0 again), this item IS processed by “Calculate Inventory” (when the “Items Not on Inventory” option is checked). Why? Does NF set some flag on the item when its inventory is changed for the first time? (I would prefer this method (not using the Item Journal), because of it seems to me that using the Item Journal for that purpose would consume too much time; I like that the “Calculate Inventory” batch fills the journal, so that I only need to change some values and post it.) Thank you for your help. If you consider my problem to be too simple and stupid, it is caused by the fact that I am new to Navision and now I try to implement Financials for the very first time, in a company I am an employee of :). karel2
The answer is very simple. If there is no item ledger entries for some item the batch “Calculate Inventory” will not process this item even if you’ll check “Items Not on Inventory”. So you have to modify this report or create your own. Best regards, Const.
I entered a sample positive adjustment line in the Item Journal; used a dataport to export the values from the Item Journal into a CSV file; made sure the positive adjustment posted properly and that the Item Card showed correct quantity on hand; exported the items & quantities on hand from the prior system into an Excel spreadsheet; reformatted the Excel spreadsheet to “look” like the CSV file; then I dataported all of the records from the spreadsheet into the Item Journal; then I posted the Item Journal from within Navision.
CSV files are not a good dataport format— even though that is what the Navision dataport designer defaults to. Use Tab-delimited instead. Why? Because Excel puts quotes around data from text cells which have commas in them. That creates UGLY results when you import the CSV file into Navision. This is probably not a problem for this particular import (unless you did something questionable like putting commas in Item No. entries) but this often is a problem in other circumstances. ------- Tim Horrigan horrigan@aol.com Edited by - horrigan on 12/20/00 5:34:45 PM