-
" Data is missing for InStore document HO-XXXXX-XXXXXX " while processing document (purchase order)
Hi, When we are processing document (Purchase order) from Instore Document form system throwing "Data is missing for InStore document HO-IS1215-094335". document is being process in Head Office level. same PO is correctly relicated to store and processed. please refer attached screen.
-
urgent urgent plaise with apply code
how to initialize lettering code,when I just letter writing was part of the accounting account ,the system displays code as {] he just limit in lettering code , thank you for your help and understand
-
Sales orders have old Bin locations after bins updated with new physical locations
I've found different results on how to be setup bins and locations but what matters is what it currently is setup, and if we need to change moving that way. Currently we have a location as Shipping: and Bins are shelf numbers and rows. We rearrange the room for new products and move everything every few years. We update…
-
CFrontDotNet Initialization Error with ASP NET
Hi We are trying to use CFRONT with ASP.NET. and we encountered this error when it tried to connect to database. We are using NAV 5.0 with CFRONT included in DVD installer. ASP NET 3.5. I have tried to put both CFRONT.dll and CFRONTSQL.dll to BIN directory of our web site. pLease help. Thank you all. The Navision CFront…
-
How to do warehouse shipment by updating Zone,Bin and location Code
Hi all, I'm getting some error "Nothing to Handle" when create pick at warehouse shipment module. At the specified location i have ticked Bin Mandatory and Directed Put-Away & Pick checkbox. I cannot update Qty-To-Ship at Sales Order. Is that could be the reason for the error?? Can anyone help me? Thanks in Advance.
-
prepayment and table g/l entry how can reverse flow
hello my friends thank you in advance to all people respond to my questions right now I worked on the parameter of the prepayment invoice sale, then the states were well have validated the only thing that incorrect accounting Scriptures I want to reverse flow and credit party when validate the final invoice thank you
-
source expression
hello, how can I make a source expression of a specific field in a page to be a field in a table in order to use it in another page fields?
-
Codeunit 230: global variable and parameter called LastGenJnlLine
Hi all, In codeunit 230 GenJnlManagement, there is a global variable called LastGenJnlLine, and in the function CalcBalance, there is also a parameter called LastGenJnlLine. How does that work? In the scope of the CalcBalance function, does the name LastGenJnlLine refer to the global variable or the local parameter? BR…
-
Planning Worksheet for Subassemblies
Hi, I have a firm planned production order for a top level parent item. The top level item has several levels of subassemblies and some purchased items. For example: Top level Finished Good -Level One Sub -Purchased Items - Level Two Sub - Level Three Sub - Level Four Sub What I'm finding is that when I run the planning…
-
cours of NAV in frensh
hi i need a cours of dynamics NAV 2009 (fonctionnls and technicals ) thank you
-
How to set the "Inventory value" (posted, expected and actual) to 0,00€ when quantity is 0?
In our stock we have quantity 0 but "Inventory value (actual)", "Inventory value (expected)" and "Inventory posted to GL" e.g. 0,02€. How can I set the value to 0,00€?
-
SAFEARRAY in NAV Classic Client
Hello every one. I have created a COM dll by adding a webservice reference. One of the method in webservice returns list of items order wise. The dll is used as an automation variable in NAV 2009R2 version. Issue is that the method which brings back items list need to be handled in SAFEARRAY as function definition…
-
Intercompany error
I'm using IC Gen journal, but when i'm clicking the complete line actions in the IC Inbox then complete the list in the IC inbox action. Im getting error "IC G/L ACCOUNT DOES NOT EXIST". do i need to include in the IC chart of account the G/L account that i have in the partner company? thank you.
-
need help urgent about prepayment sales invoice
After I posted the prepayment invoices to record the unearned revenue, I would like to post 100% sales invoice on sales order, but it's not possible, system pop-up the error message "Gen Prod Posting Group must have a value in Sales Line:..Line No.=20000". This Sales Order has only one sales line. plaise help it is top…
-
How do i make report to print the value of date filter and salesperson filter on the report header
I developed my report on sales person commission. On running the report, the user inputs date filter e.g 01.09.16..30.09.16 and sales person filter e.g Johnson Old. In the header, I want the report to print the values for the date and saleperson filters like this: Period: 01.09.16..30.09.16 Sales Person: Johnson Old How do…
-
Report Qty. Shipped Not Invoiced
Hi all, I'm working on NAV Classic 5.0 and looking for a way to report the Qty. Shipped Not Invoiced on sales order lines. Is there a standard report available? If not, in which tables can I find the correct quantities and values? And (important): how can I report this in the past? Meaning, what was the amount/qty shipped…
-
Production Journal
Hi, I have a multi-level production order. I want to backflush one of the subassemblies. When I go in to the production journal and drop the Flushing Method to Backflush, the Consumption Quantities and Run Times are blank. When I look at the actual components and routing for the subassembly line, I can see the consumption…
-
delete sequentialites whats it is the impact in system
the impact on removing sequences
-
bitmaps on report
best way when bitmap is greater than 32 k
-
Group total fields not working in sale report
Hi all, I am creating customerwise itemwise sale report in Navision 4.0 SP3 from "Sales Invoice Header" and "Sales Invoice Line" tables and linked both table through dataitemlink on document no., then added "Sell-to Customer No." & "No." fields in group total fields and Quantity, Amount in Total Fields of Line table as per…
-
Item Charge Assignment
I need so assign some Item Charges to items entries produced from manufacturing, not listed under Receipt Lines Purchasing. Is there any way this could be done ? Thanks
-
SQL Permissions for Administrators
Hi, We are running NAV 2009 SP1 on SQL 2005 in Standard Security Mode and are trying to get to grips with the required SQL permissions for our Administrators. The functions our Admins will be performing: Adding/Removing/Amending Windows Logins Importing/Exporting Objects We have given all of the admins the SUPER role in…
-
How to filter the items specific to the order on lokup
when i pick order number on a the Sales form no. 45. I want to look up items. When I click the item look up I want to see only the items that are associated with the order number rec that I have. What code do i put.
-
Item Card
Hi, We are running Navision 2009 R2 and have a question on item card. We have created a lot of items in the system and my question is how to find out that item has been created but this item hasnt been used at all in any operation in the system and has no sales or purchases or positive or negative adjustments against it.…
-
CALCIFIED does not working!!
I have two record variable of ITEM table and another one is Transferline table(Created by me). ItemRec.SETFILTER(ItemRec."Location Filter",TransferLine."Warehouse Location"); ItemRec.GET(TransferLine."Item No"); MESSAGE('At %1 Location for Item %2',ItemRec."Location Filter",ItemRec."No."); END; ItemRec.CALCFIELDS("Qty. on…
-
Issuing a Credit for Tax
Hi, What is the best way to issue a credit memo to a customer for tax that the customer should not have been charged for? This applied to US taxes. Thanks, Steve
-
Type Conversion
Type conversion is not possible because one of the operators contains an invalid type. I have been trying to simply add two variables of type integer and display the result in a pop up window using MESSAGE function. op1 := 10;
op2 := 20;
op1 := op1 + op2;
MESSAGE(op1); This is the code segment. The type of variables op1…
-
how to make a selected line appear on the fact box
Hey, on the General Journal page> Actions>Incoming Documents> Select Incoming Document, then the incoming document page opens and i select any line i want, this line will then appear on the 'Incoming Document File' Fact Box on the General Journal page. I want to know what is the code or property that allows me to do this .…
-
Sales Order - Import of customer + sales order
Hi all, im trying to import a XML document containing one Customer and one Sales Order from another system. I have tried to do the "Walkthrough: Inserting Data from XML Documents to Multiple Tables" and have added some functionality. The import works, but it's missing the Sales Order Lines. The system throws an error and i…
-
How do I automatically fill a field on a form
On a form, based on Form no. 45 Sales List, I look up to pick order number. I want the corresponding customer number to be filled in automatically when I pick the sales order number.