-
Cannot Clear A Blob Field
Maybe cause it's late but I can get it to clear. I created a Blob field on the item table called "Picture2" - same a "Picture" In "picture2" I imported the JPG of the BMP which is in "Picture" if the code below worksOnPush()IF Picture.HASVALUE THEN IF CONFIRM(Text002,FALSE,TABLECAPTION,"No.") THEN BEGIN CLEAR(Picture);…
-
Print an Image on a Report from a BLOB field
:( Is it possible to Print an Image on a Report from a Blob File? If So, how?? Thanks
-
Business Analytics, Navision 4.0, BAConfigurator40
Setup : MS SQL 2000 with SP4 MS SQL Server Analysis Services (updated with SP4) SQLXML 3.0 SP3 MS SQL Server notification Services 2.0 SP1 Windows Server 2003 with SP1 Business Analytics modules from Navision 4.0 SP1 (42 pieces) Problem: After I Update XML from BA Database-Functions i will get error message - "Error during…
-
Merging pdf documents using Amyuni
Hello, I'm trying to merge two pdf documents (both saved on a hdd) from within Navision, using the API provided by Amyuni. For the life of me I cant get the Syntax right. I have tried the following (where Amyuni is a automation variable of type 'Amyuni PDFCreactiveX Component'.IPDFCreactiveX):…
-
Can someone help?
I want to display amounts in text or words on a report ,can anyone help with a function or some code to do this. :-k
-
How to install specific modules?
Hello everyone, I will proceed to my first Navision installation,the customer wants just SOME MODULES.How to proceed to accomplish this customized insatallation?
-
Average Cost of Item becomes zero
Why is it sometimes when we do an SO (say for instance the item has Base UOM pc, Sales UOM is pc) using the BOX unit of measure, after posting, the average cost becomes zero. Any idea will highly be appreciated! Regards to All
-
Cost Amount (Actual) in Value Entry
Sometimes it return zero. Create PO then receive and invoice. Create SO using warehouse or not. But why cost amount (actual) in value entry return to zero ? It could be happen if we receive first, before we invoice it we create SO and post it, right ? Thanx.
-
Multiple Group Totals in Report
Got a report I need to create for an auditor and wondering if anyone has created anything similar or has any ideas on the best way to approach. The report will be based off of the Item and Item Ledger Entry tables. For each item I'll want to report the total quantity on hand by Variant, Location and Bin. Anytime Item No.,…
-
Job Journal Issue
After successfully posting a job journal a client of ours has noticed that a blank line is automatically inserted into the Job Journal line. The only way to remove this line is by deleting it. At this stage the rest of the default settings are populated into the Job Journal which is fine. Is the blank line creation a bug…
-
Can run multiple Navision databases on same server ?
Hello, We currently have a Production Navision server and a seperate Test Navision server. We now also want a Training Navision database. Can/will another instance of the Navision engine run on the same server as the TEST database, pointing to a different database file ? If so, how is a seperate instance started up? Will…
-
Using faxcom in Navision with SBS 2000
Hello, I have a problem using the faxcom 1.0 API connecting to SBS 2000 :?: . I´m not able to connect to the faxserver. I tried to connect to \\machine name\shared fax or just \\machine name but I just get an error message. When I debug the program code stops at the line "faxserver.connect(machine name)". Any suggestions…
-
Grouping in reports in OnPreDataItem - is it possible?
Hi to all :D I have got a question, is there any possibility of grouping information in the report, without using GroupTotalfields property of the item. The case is, i have to get the report, which runs on the table Item, but with two different groupings. As i understand i can get them sorted as i wish with SETCURRENTKEY,…
-
Printing Labels to an Okidata Printer
I created a label that we must print on form fed labels to an Okidata printer. It works fine when I test it on a Laser printer, however, will not print on the Okidata. On the Okidata, it prints one line of garbage and then goes forward about six labels before printing another line of garbage. This continues for about five…
-
Non-order stock in or out provision
Hi friends Is there a way to accomplish the same. How to make a Non-order stock in or out, for example, receiving a pile of goods to warehouse, with no order before it? regards Pritish
-
difference between Whse. Reclass. Journals and the Warehouse
What is the difference between Whse. Reclass. Journals and the Warehouse Movement? I found they have the same result. regards Pritish
-
Count not updating on form
I have a text box on a form, say box1, that is set to the number of entries in a filtered table, rec1. This count should change based on what is selected in another text box, box2. I have tried everything from CurrForm.UPDATE to CLEAR(rec1) and resetting the filters and it will not update automatically. Thanks in advance.
-
How to print outside the printable area ?
Hi all. I want to print a report but its too big if i print it on A4, so I set the papersize to A3 but I want to print it on A4, can I do that ? Can it print on next pages ? Or something to scale or adjust or fit in ? Thanx.
-
Email address validation
Hi guys, Have an email field. Can we validate email addresses in Navision using C/Side? Jim
-
Wrong count of records in form
Hello, I've got a slight problem. I'm using COUNT on a form based on the table the form uses. There are no records in the table (checked with Object designer) yet COUNT returns the value "2". Checked via FIND('-') which returns: nothing. I ran a deleteall on the table, still the same error. Ran a count via a CU, value is…
-
Database Information(Tables)
When I click a bunch of tables to optimize the pop-up gives you the: 1)Table Name 2)The Key it's working on. I would like to add the Table No. Can this be done? if so where in the heck is it hiding?
-
Warehouse Item Journal
Hi friends When i carry out this activity, where can i see this Periodic Activity – Warehouse Item Journal a. ) Where to see the on hand stock of items with report or inquiry? b. ) After item removed from bin ,it has been adjusted to the ADJUSTMENT bin, how software knows that ? regards Pritish
-
Column layout after object compilation
Hi, Maybe was treated before the subject but I cannot find solution, maybe does not exist. Is there any trick to have to columns layout NOT modified even the object is compiled (especially list forms) ? Thanks
-
Stretch a Picture
Hi all I would like to ask : 1. How to stretch a picture ? 2. Can navision run a flash file ? Thank you very much.
-
Using CFront in C#
My first experiment with CFront. I can read from a Navision 3.01b database using CFRONT (cfront.dll dated 8/7/2002) within C#. However, if I try to modify a record with the AssignField() function, I get a "type mismatch" error returned from mscorlib.dll. However, even doing explicit typecasting still generates the…
-
Color Change
Hi Friends I would like to change the Color of the Main Menu based on the Companies selected. any one with any suggestions pls..? :?: Cheer's Prem
-
Pick Document (distinguish take line and pick line)
Hi friends please help me on this In a pick document, how to distinguish the take line and pick line? How does the program know which bin code is for TAKE and which one is for PICK? regards Pritish
-
Break Bulk does not suggest bulk information
Break Bulk: when I use a different UOM to pick, the system didn’t suggest the break bulk information. Why? Please help regards Pritish
-
Error printing a Report
Hello I have a problem when i print a Report and the resolutin of the monitor is too higth the navision Crashes, i make a test whith the same computer but whit a lower resolution and it works, can anyone help me. thanks
-
Adjust cost item entries - Please help!
Please can someone help, I have a customer how is running Navision 3.60 and they are unable to run the Adjust Cost item entries function - Applies to entry must no be 0 in item journal line template name"Journal Batch Name=",Line No=0".. I did all the obvious things like looking int the item journal line table etc but am…