-
Wrong Posting in Transfer Orders
While posting Transfer Order in a multi User Enviornment , the users gets a message that "The Table is being locked by the User XXXX".After some time this message disappear . Now on Re-Posting the same Transfer Order we receive an error message that "Lot No is required for Item AAAA ",on looking at the Item tracking…
-
Remaining Quantity in Warehouse Entry
There is Warehouse Entry (one bin, one item, one lot...etc) Entry Type_______Quantity____Source No.____Remaining Quantity 1. Negative Adjmt.___-12______PZ5-062688___0 2. Negative Adjmt.___-14______PZ5-063546___-14 3. Negative Adjmt.___-1_______PZ5-060181___-1 4. Movement________12______PZ5-062688 ___0 5.…
-
Function -> Get receipt lines in Purchase Invoice
Hi, I have a problem... I have an blanket order, the blanket order was with the last order full delivered. The Invoice should be together with other orders posted in the Purchase Invoice. (Function: Get receipt lines) But i always have an error 'Quantity Received in the associated blanket order must not be greater than…
-
How to trigger F3 during Form Opening?
Hi All, How can i trigger F3 (insert new record) during the form opening? The purpose of doing this is to avoid user to see any record when they open the Sales order. Therefore, i would like to force the system to show no record (untitled - Sales Order) when user open the sales order. The user has to search for the sales…
-
Mail navision
Hello to all, I have a problem when I send mail with navision attain 3.10. The error verification when I have two mail addresses like carbon copy, the outlook form is opened with wrong the CCName field. How I can make? I have already verified that the parameters in Navision come pass to you correctly. Thanks to all
-
Just confirm!
Importing table object doesn't change table data. Yes/No? New object has few ADDED fields & one extra key (not PK).
-
logo in the report
I view a lot of suggestions regarding inserting logo in the report. But when I try to do it, it sends me an error message "It is not a device independent BITMAP". What I do is 1. place a .bmp file in the c drive. 2. fill out two proerpties, bitmap and source expression. Why it happens? Thanks in advance!
-
Basic question.... Form<->SubForm
I have Header table and Lines table. I have form from Header table with subform from Lines table. Classic, wright. The PK in Header table is DocNo. The PK in Lines table is DocNo.,LineNo. Form to subform link is DocNo.=FIELD(DocNo.) How(and where and in what trigger) to auto fill subform DocNo. increment LineNo. I used…
-
Developer Toolkit
I am installing Developer Toolkit but I am getting Database Error: 1111. Before this error shows it says: The server and client do not have the same program version number What should I do? Thanxs :(
-
Question on license file
Hi all! What happen if i forgot to rename my new licence ( i.e CAxxxx.flf) as fin.flf and I just import that file on the server. I then stop and start the service again. Thanks
-
How do i use SETFILTER to avoid certain G/L Accounts
I got the following code CompanyInfo.GET; IF (CompanyInfo."Company ID" = CompanyInfo."Company ID"::"DSI MEX") THEN BEGIN FromSalesInvLine.SETFILTER(Quantity,'>0'); FromSalesInvLine.SETFILTER("No.",'<>256002-0000'); FromSalesInvLine.SETFILTER("No.",'<>135014-0000'); It works but it only ommits one or the other G/L account.…
-
Count number of lines in report Groupfoot
Is there anyway to count the number of lines in a groupfooter and place that number in another footer of the report.
-
CALCFIELDS in the same table where the FlowField is?
I have 3 FlowFields with SUM method in Item table. Each of that FlowFields are calculating theirs sums per Item for every line in Sales Line or Purchase Line (for that Item). Now I need to SUM all sums for Items in the same Class. I wanted to create a SumIndexField but I can't do it with FlowField, so I created decimal…
-
Request Form in Report
Hi I'm new to navision programming reports. Is it possible to create a request form in a report from where I can make a selection from a listbox. The listbox should be filled with some data from an excisting table (a query on that table(filter)) kind regards, robbert
-
[FINISHED] FILTER in DataItemTableView..?
Hi, is it possible to do something like that(this doesn't work...but) WHERE(Document Type=FILTER(Invoice),Calculate Interest=FILTER(Yes)|Remaining Amount=FILTER(>0)) I need OR operator instead of AND which is by default... Thnx
-
Problem with CreatePivotTable (Excel)
Hi all, I've a problem with the CreatePivotTable (Automation Control - Excel) Statement because it works only with these Parameters: xlAppG.ActiveWorkbook.PivotCaches.Add(1,textL).CreatePivotTable('','PivotTable1'); But then the worksheet gets the default name and thats a problem because of the Multilanguage of the Excel…
-
Hot fixes 19 and 22 for 3.60 needed
:( I have some problems with PartnerSource access. If anyone can send me hot fixes 19 and 22 (we have problem with infinite loop for some items with average by location cost method during the adjust cost batch job). Mail: Navision@bbs.ba Thanks in advance!
-
Dimension Error while running Adjust Cost Item Entries Batch
a. Create a new Item and Do Not allot any Default Dimension to this Item. Post some Transactions for this Item . After wards Allot Default Dimension to the same Item and Select Value Posting as "Same Code".Again post some Transactions. Now when we run the "Adjust Cost Item Entries " Batch then it throws an Error "Select a…
-
Customizability vs Upgradeability
What are your views on the impact of customization on Navision's upgradeability? For example, if my company spends $100,000 on customization, is it a major job to move that customization to the next version of Navision when it comes along? What's your guess as to the cost of that job compared to the initial cost?
-
Flexible Grouping in Report
Is it possible to get the information from the user at run time and group the record accordingly??? eg. A report is required in the Relationship Mgmt. for To-Do list. this list can either be group on Opp. No. or on Customer No.
-
Fax 2 reports
I have a request that to fax 2 reports in one go. As one report in portrait and other in landscape format, I cannot merge those 2 reports in one. Do you know how to do that? Appreciate any idea and suggestion. Thanks
-
Illegal operation II
Hi there!! I have the same problem : http://www.mibuso.com/forum/viewtopic.php?t=7913 But with three differences : 1.- It is a WinXP platform. 2.- Very high frequency. Printing always produces Illegal Operation. 3.- The field "Main menu id" (Users setup) is filled and it's working correctly. I tried to delete Zup file.…
-
Manufacturing - Inventory Costing
Hi, We are using Manufacturing in Navision Attain 3.6. The problem is that when I run the Inventory Valuation report, it shows me a huge amount as expected cost. I am running this report after running Adjust Cost-Item Entries and Post Inventory Cost to GL. I have tried to analyse the problem and I found out that the Output…
-
Relationship Management - Outlook Syncronisation
Hi, We are implementing Relationship Management in Navision Attain 3.6. The client have multiple Branches. We need to setup the Outlook Profile for Sales Person. Now the Problem is that If just give our Navision Server in WAN it gives a very slow response and if we setup VPN/WTS, it does not allow us to select the Outlook…
-
File searches in Navision
Is there a way to do a file search with a standard Navision data type? I looked at the functions and methods in the Navision 'File' data type and couldn't see a way to do this. What I need to accomplish is this: When the user runs a dataport and types in the filename to import/export to, instead of typing in…
-
Accessing Multiple Companies
Hi.. If I have 2 companies in My DB, if I log in to one Company and if I need to get some data from the other company, is it possible to do? if possible how? I need a direct method, not like using data ports. can somebody advice on this? Thx Roshan
-
UOM Visual UPDATE
sorry it's the best description I could think of at the time. OK I have created a seperate tab for Unit Of Measure on my Item Card. Example/ Base Unit of Measure : EA Sales Unit of Measure : DL Purch Unit of Measure : TR What I would like to do is pull the "Qty. per Unit Of measure" for each corresponding code and show it…
-
costing method
Hi, we have items with uncorrect Costing method. We would like to change the costing method, but navision hinders us to do so, because of entries in Item ledgery Entry. it is a simple security programming in the validation of the "costing method" in table 27 "Item" we would like to outcomment this security programming,…
-
GL Consistency error
Dear friends, In Codeunit 12 u can see that there is a code related to GL consistency. Actually the consistent function doesnot allow us to post if the we pass "false" as boolean parameter and this happens only all the parameters…
-
How to uncheck modified option in object designer?
I know the answer(manualy) if I have 10 or 20 objects which are checked(modified), but my problem is that All Object are checked....how to unchecked them all(automaticaly)? I tried to use Object table from CU and set modified field to false, but it's not allowed :D Thnx