Owner: Learning Microsoft Business Solutions-Navision URL:http://tutorial-navision.blogspot.com/ Join Date: Sun, 30 Nov 2008 09:50:02 -0600 Rating:0 Site Description: At this blog, you can find aboutLearning Microsoft Business Solutions-Navision. Site statistics:Click here
Report Grouping and Totalling 2008-11-30 09:15:54 1) Open the Properties window (SHIFT + F4) of the data item that you want to group. 2) Enter the name of the field that you want to group by at the GroupTotalFields property.3) Select a key for the DataItemTableView property. You must select a key that contains the field that you want to group by. Otherwise, the grouping won't work.4) Enter the names of the fields that you want Navision to calcula
Report Only Print Preview 2008-11-29 12:30:55 If you have certain report that you only want users to be able to preview but not able to print out the hard copy, you can add the following code at the on prereport trigger:IF Not CurrReport.PrintPreview
THEN Error('This is a Preview only report');Whenever you click on the Print button to print the report through printer, the message will come out 'This is a Preview only report' and prevent you
when ur license occur problem 2008-11-28 03:26:02 Pls go to your program files..Select Nav folder, find client and search file with ext *.flf & *.stxDelete all files found.If the problems havent been settled, find setup.exe (Nav) if any.Install it & run.Re-open your nav, i think it can work properly already.
how to change dimension group code which posted 2008-11-20 20:10:42 How to change dimension group code which has been posted.Pls go to tools- object-designerselect table, item ledger entry, run..View column customer dimension group code.Change it to the correct one.
Currency factor 2008-11-18 18:55:42 When u input beg balance, u will notice the currency factor
.The currency factor is 1 divide by the rate of currency you are using.For ex: 1/9155 = 0....or 1/6460 = ...or 1/1 = ...Pls take note as this is a serious thing. Read more:Currency
Reclass FA 2008-11-04 19:47:05 Firstly, kindly change your FA journal setup at FA, DEPR BOOK code, depr. book, choose FA journal setup.This is in order to make your journal appears at FA G/L Journal.Choose gen jnl.templ u are going to use.After done, pls go to FA reclass jnls at Fixed Asset folder.Pls choose the FA no that u want to reclass, acq cost or depreciation.after posting, pls directly go to FA G/L journal to see the re
Input beg balance for FA accumulation depre 2008-10-24 05:42:17 Using the same template as acquisition cost, but the amount is in negative state.The function is for reducing the book value to the actual book value.
Posting beg balance for FA 2008-10-23 05:26:33 Error:FA posting type acquisition cost must be posted in general journal in FA journal line journal template = "assets", journal batch name = "begbal"; line no =10000Check SME depreciation book card, untick acquisition & depreciation Read more:Posting
When posting GL beginning balance 2008-10-23 01:27:58 Pls bear in mind that the document no must same from account asset to capital.Otherwise there will be comment like this:Doc XXX is not balance etc.Pls check again your posting date, document no, document date.
Error when mapping Beg AP 2008-10-22 04:36:29 value from excel is not valid for field 7 doc no. in sheet open-ap/G527, excel value 00442/CR/R&T/AGT/2008Pls take note that there will be limitation digits for document no input, the maximum is 20digits.If the digits are more than 20, the error comment will similar as above.00442/CR/R&T/AGT/2008 >> 21 digits.
beginning balance for AP 2008-10-20 04:08:45 When we import beginning balance for AP, the figure must be in negative, with vendor in debit side & GL account in credit side.Pls take note that the currency factor is 1/exchange rate.
Sales & receivable setup 2008-10-20 01:22:28 Before using the sales & receivables application area, you need to specify how you want the program to manage aspects of your sales & receivables.For example, you must define basic rules for ordering & invoicing as well as specify the number series that will be used for customers, sales documents, and so on.You must also specify other options such as how you want to calculate & pos Read more:Sales
, setup
if appear to be rounded when posting beg. bal 2008-10-19 21:32:55 when u posted beginning balance, then appear
error to be rounded etc, pls take a look at your rounded figure.Is it 2 behind commas, if the figure that u input is more than that, kindly rounded to 2 commas.
How do we import inventory item to ERP Nav? 2008-10-10 20:18:58 You must know the format of the ledger before importing.To do so, go to tools-object designer-formSelect mapping, then run.Again, select Open-Item.You will see the field no, field name, Field caption.Then u have to create your own data based on the description.Once your data is ready, kindly select file name to browse your file.When it is done, click button function, select import data.Done.
Impact of transaction deletion 2008-10-10 20:08:18 Regarding of transaction deletion for current database, following are the impact to be considered: 1. All transactions history will be deleted 2. Document Numbering to be decided: continue previous number or restart all document number 3. For Inventory module: a. Inventory Stock will be 0 b. Lot Number to be decided: continue previous number or restart the lot
Export sales order from Navision 2008-08-30 22:52:57 Tools-object designer-tableSelect sales line, then run..Find Qty to ship, filter 0Ctrl C & paste to excel file.Done.
How to Export Purchase Order Outstanding 2008-08-30 22:51:08 Go to tools-object designer-Table-PUrchase lineThen Run...Select qty to receive, filter 0Block all the fields, ctrl C then paste to excel file. Read more:Order
, Purchase
Before & after data cleaning/transaction deletion 2008-08-29 09:04:21 The steps to be done before and after data cleaning: 1. Backup current database 2. Create new database 3. Restore last database to new database, this database will be used for disaster recovery 4. After step no. 3 succeeded, do data cleaning will be done. 5. Change General Ledger setup for posting period 6. Setup currency rates 7.
The difference of delete transaction & new database 2008-08-29 08:33:17 Transaction deletion will only delete
transaction recorded previously, but wont delete the master list such as part nos, Lot no, etc.But by creating new database, means you have to redo all the things from the start.Just like re-implement the system.You must scan the barcode, input all the master list, beginning balance & outstanding orders. Read more:difference
how to remove all the transaction 2008-08-29 04:58:14 first go to tools > object designer > form > implementation >run > data cleaning > run
Recommend Site To A Friend
