-
Packing List Function
Dear Sir, Can I set any control to prevent any salesperson to issue a SO for a customer haven't enough credit limit or there isn't any item availability? Thanks Anderson
-
Opening entries
How to post opening entries for G.Ledger,Customer and Vendor ledgers?
-
Locking of Journal Batches based on the Users
I want to lock the journal batches based on the users(who are attached to various warehouse location) and responsiblity center. and all the transactions passed from this batch should be tagged with resposibility center or with location. Please specify any specific method.
-
Process Manufacturing - Food Industry
Anyone has an add-on for Food Process Manufacturing? Thanks, Ed
-
On-line help addition & modification
Hello everybody... I am studing for the Navision Attain Developement Certification and I came across a few matters, like "Standard features of on-line help", "How to add on-line help", "How to modify on-line help". I have search trhou all the documentation I could find, but I have found nothing. Has anyone any PDF's or…
-
Fiscal Years & Accounting Periods
Is it possible to expand an existing fiscal year from 12mths to 15 months?. Current setup: FY 2003 12mths - Jan to Dec (not closed) FY 2004 12mths - Jan to Dec (data posted to Mar 04) Proposed setup: FY 2003 15mths - Jan'03 to Mar'04 FY 2004 12mths - Apr'04 to Mar'05 Thanks for your assistance.
-
Dataports : how to import all the file even...
if there are a lot of errors in the data. 2 steps : 1/ Create a table to store all the mistakes : For instance 50000 "Import file errors" 2/ In the dataport, in each fields wich can contain an error do the next : For instance, if i want to import in the "Sales Header" the "Sell-to customer Name" : OnBeforeEvaluateFieldIF…
-
Field Reference and Flowfield
Hi, I am using FieldRef.CLASS to decide the type of a certain field. But the compiler will complain something like FieldClass <>Option..... For example:IF "RecRef".CLASS = "RecRef".CLASS::Flowfield THEN "RecRef".CALCFIELD; Is there any syntax error here? :?
-
ASP.NET connection with Navision 3.60 using ODBC
Hello, We have build an ASP.NET intranet solution thats getting, updating and inserting data from Navision 3.60 via the C/ODBC connector. The intranet application is used by 20 users and after each quarter the webserver(IIS) must be reset because the intranet application has a timeout. Is there a better C/ODBC driver or an…
-
Zup-File message by closing the client
Sometimes the message appears: "would you like to overwrite the Zup file?" - why can this message does appear? - can i prevent this message ? best regards Scully
-
Export Data to Excel Format using codes
Hi All, Greetings. I found these codings in the Application Designer's Guide, Chapter 16.2. page 402. CREATE(xlApp);xlBook := xlApp.Workbooks.Add(-4167);xlSheet := xlApp.ActiveSheet;xlSheet.Name := 'Personnel Expenses';xlSheet.Range('A2').Value := 'Administration';xlSheet.Range('A3').Value := "G/L Entry".Amount; I've tried…
-
how to print an image in a report with a font in concrete
how to print an image (in a picture box) in a report with a font in concrete? I need this because i have a epson tm88III and it uses his own fonts.
-
Flowfields and Performance
Using Navision 3.60A (North American)… I am in the process of designing a custom statistics form that will be used as an Executive Overview. This form will be a ‘Multiple Tab’ form with a large number (in excess of 100) of FlowFields. These FlowFields will be stored on a single table and collecting data from a number of…
-
Multi grouping in the reports
hi, How to do multiple groupings in Navision reports ? Ex: Group 1: Zone Group 2: State 1 Group 3: District 1 ............Sales................. Group 3: District 1 sales Total Group 3: District 2 ............Sales................. Group 3: District 2 sales Total Group 2: State 1 sales Total Group 2: State 2 Group 3:…
-
Ascii
Hi, Is it possible to get the ASCII value of a character with the Navision-language? Thanks
-
Rounding error
Hi, We have this kind of setup in our inventory: ITEM A which is MTO with BOM BASE UOM:SET - qty per=1 OTHER UOM: EACH Qty per = 1/3 Rounding precision=1 BOM OF A has the following components: ITEM B - 1 PC ITEM C - 1 PC Sales Order has one line with ITEM A UOM=EACH, Qty= 30 With this scenario, the Planned order qty for…
-
Build number
Hi, Navision returns the build number in the message box when I double-click on the 'Version 3.60....' line of the About window (Help->About Microsoft Navision Attain). WHat does the number represent? Thks... Regards, Spy..
-
thanks eromein
My question is if i can print an image in a report with a font in concrete. When you put a textbox y a report in the section you can put a font in concrete. The same as this but with an image. Thanks a lot
-
Is Navision security can restrict user by record level?
Dear all, Is Navision can restrict user by record level? For example, If I don't want user to using some account code on Chart of Account or some customer code on Customer list for any purpose. I found that security make ppl confuse for record filtering. Is there have anyone can help me? Thanks! wpc :lol:
-
Italian localization
Does anyone have information on the requirement for a localized Navision in Italy. Is is OK to run the international version without modification or is there some specific issue with this? I'm not too worried about the language as this can be applied seperately. Thanks Andy
-
Read Permission problems - anyone encounter same prob as me?
Hi all, Just would like to find out if anyone have encountered the same problem as my customer. My customer is running Navision Attain 3.01B on MS-SQL Server with their own license file. In certain parts of the app (finsql.exe), for example, Job Journal, when they key in the Item No., the system will give them an error…
-
First date of the month
Is there a function that gives me the value of the first date of the month. Because I need Quotes and Sales Orders to change USD to Pesos based on the first date of the current month.
-
Automatically Importing Objects
Does anybody know how to automate the process of importing objects into a database? Is this even possible? A solution such as this would be great for remote support. The ideal solution would need to ensure that the objects being imported are in the correct sequence to prevent any errors from cropping up. Thanks Craig
-
BOM and Serial No
How can we associate a Serial No. on a BOM Product at BOM Journal? Thank You
-
export excel
I Want to export item No. to excel report, "item No." is code eg. item No.= 0014525 after export i have in excel report 14525 how method to obtein 0014525
-
Addresses in report - suppressing lines
Hi all, Simple problem - just no idea of how to do it. I have several address lines, some of which appear blank and make the address look stupid. Is there a way or calculation that I can do to display only lines that have data, and if not, to bring up the following line instead? Thanks! Stephen H.
-
navision remotely??
are there any programs out there that lets you maintain navision remotely?? i mean that is specifically for navision? thanks trint
-
Navision Application Server
Hi All, I have a client that has purchased the Application Server granule. The strangest thing is that buying this granule does not give them permission to use the application server setup table, as well as the other forms and codeunits associated with this. I need to get information in and out of Navision, and the…
-
Change Log Issues
I need to have the Change log create Insert Log entries on records that are inserted through a dataport. Application Management seems to handle this issue Online, but through dataports it seems to not go through that codeunit. Any Suggestions? BTW - I am using 3.70
-
Upgrade my configuration, Sql or Seaside?
Hello all, I have actually this configuration : Naivision Attain 3.60 database in native mode (seaside) The database is one file = 18Go PIII 500Mhz, 756Mo de RAM, HDD SCSI, no RAID 30 users I want to migrate my server because my server is old and the user has one problem, when an user validate, navision lock the table and…