Hi all, I’m looking a way to make a chart for the Adjust cost. When an user click at the assist buton i want to show a window with a chart which will represent the Adjust cost. I mean a chart which will show the variation of the adjust cost. Did anyone already develop something like that, or any idea. Thanks
This will not be quite so easy as in standard Navision you will not be able to differentiate value entries that result from an adjust cost item entries routine. We had to do quite a lof of development work to make these go to a seperate GL account so we could identify them. Once you have a way of identifying them the charting should be relatively straightfoward, I would suggest to have a look at the download sections of the various Navision sites for some examples or add-ons. Hope this helps and this was indeed what you were after. Regards Meint
Actually its not so difficult, and yes I have done this. any years ago I developed an Add=On for Navision called StockManager. This in fact was in the DOS version of Navision, and there are clients using it in versions up to 2.60 Financials. (The first version was released in 1994) Stock Manager has a new table that tracks the value of Item ledger entries, this table breaks down each adjustment to the Item ledger entry as a seperate entry. From the Item ledger its is then possible to drill down to the Value Entries. In addition to this, a second table links each of those value adjustments to the GL entry that was created when the adjustment was made. From this second table, it is very easy to create reports that show how adjustments were posted to the G/L, and makes it very easy to audit Inventory Adjustments. Vlaue entries in Navision are basically the same as the StockManger Entry table, but I never nderstood whey they never used the second table to make it easier to audit GL postings. Anyway, core to it all, is tat you need a table that links GL Entry to Value Entry. Either you could create a new table, or you could do some mods to the existing Value entry table. Creating a new table is far far less work.
quote:
…Anyway, core to it all, is tat you need a table that links GL Entry to Value Entry. Either you could create a new table, or you could do some mods to the existing Value entry table. Creating a new table is far far less work.
Originally posted by David Singleton - 2006 Mar 25 : 00:01:50
I think this is already done in later versions of Navision (I checked a 3.70.B NA not sure about when this change was done). On the G/L Entry Table, there is a field Value Entry No. and on the Value Entry Table, there are multiple G/L Entry fields. I’m not sure if spirou is looking for this or a table which shows the cost which will be adjusted once the report is run (ie a preview of the output of this function)…That is a different story [8D]
Huh, perhaps I have missed a trick here but in all the research I have done it has not been able to differentiate a value entry that was created through the Adjust Cost - Item Entries from one that was created e.g. when you posted the sales invoice. There is no identifier that states that this was an entry that was automatically generated by the ACIE routine and the variance does not go into a seperate account. We were interested in this because we wanted to find purchase variances in COGS after we had posted the sales invoice and it proved to be rather difficult. As described in my previous message, we changed a fair bit of code to get the ACIE rotoutine to post the difference into a seperate GL account and are tracking and analysing them that way. Meint