Hi, Do anyone encounter such problem. in the description of recurring journal, enter number sign(#) with number example; #02-01, after post it change to 27 -01 I tested in general journal, is work fine, but not on recurring journal. Full description; "Maintenance fee for the mth #02-01A/B/C" after post it become…
how to insert the data one table to another Customer have a 6 month Contract period when create the customer 1000 with 6 months contract that record should be save on contract list with 6 months records like jan,feb,march like until 6 month can you give me reference code if you any links also likes this Contract1…
Hi all, I need to use the GET function.The below is the scenaio encountered. I need to get the record from a table A with the following tables. Table A field P- type CODE field q- type CODE field POSTING DATE- type DATE field q- type Text field X- type CODE from Table B field Y- type CODE from Table B field Z- type DATE…
Hi all, is that possible to create matrix form with 2 level? columns usually show the date... let say 01/08/13 02/08/13 03/08/13 ....................... and so on but i want to differentiate the date become 2 : AM and PM 01/08/13 02/08/13 03/08/13 AM PM AM PM AM PM to more clearly, please check my attachment thx
If u did not Place check mark then system automatically will take first Lot number even u select manually. For example : 01/01/01 Purchase receipt Qty = 1 , Lot No = 100 02/02/02 Purchase receipt Qty = 1 , Lot No = 200 03/03/03 Purchase receipt Qty = 1 , Lot No = 300. On 04/04/04 u want to sales QTY = 1 Lot No = 300( U…
Hi all, im newbie to navision and im facing some problems in this situation. What i need to do is to distribute a resource and check for the dates where the resource is already allocated. For example,i have the date ranges Resource 1 10-02-09 to 20-02-09 20% Resource 1 03-02-09 to 12-02-09 20% Resource 1 15-02-09 to…
Yes, from the object designer. Another similar question. You have a range of dates e.g. 01/01/08..12/02/08 stored in a variable. Can you filter or truncate the string when there is .. operator? Thanks
Hi guys, I want to copy data between two copies of the same object (create replica of the table) using SQL statement. Something like: insert into [Test Table 02] select * from [Test Table 01] It gives an error: As suggested by the error message I can change this code intoinsert into [Test Table 02] (field1,…
This post is no question. It is just something I want to share, so you know how to use the DateExpression in the CALCDATE function:NewDate := CALCDATE(DateExpression [, Date]) You might think that the DateExpression<1Y+1M> will give the same result as<1M+1Y> , right? Well, most of the time, but not always! This week one of…