Best Of
Re: Microsoft.Dynamics.Nav.Runtime.NavVariant variable not initialized
Looks like some customisation , is there any?
Re: Date format Word layout
Format("Gen. Journal Line"."Posting Date", 0, '<Day,2>/<Month,2>/<Year4>'))
Re: Address formatting in sales invoice RDLC report
How addresses print across the various document reports is controlled by the address format setup between "General Ledger Setup" and "Countries/Regions". Typically no report layout changes are needed. Unless you need to move where it prints.
The report's dataset populates an 8 line array. Which the layout prints. The above setup determines how that array is populated. The standard setup includes several options including "custom".
The report's dataset populates an 8 line array. Which the layout prints. The above setup determines how that array is populated. The standard setup includes several options including "custom".
bbrown
1
Re: how to set boolean true - as a default
Assuming it is a field of the Normal class (i.e. not a FlowField), there are two possibilities:
- it is set by code in some trigger or an event related to a relevant trigger
- it is set by the InitValue property of the field on the table
vaprog
1
Re: Write Adjust Cost routine as a SQL Query?
Adjust Cost is much more than just a single SQL statement. While it would be technically possible to recreate it as a process external to NAV, it would be much more involved than just writing a SQL query. You would need to understand and replicate the complete functionality of the process. In the long run, it may create just as many locks and take just as long. Since it still needs to do all the same work.
I would rather suggest focusing effort on improving performance of the current process.
I would rather suggest focusing effort on improving performance of the current process.
bbrown
1
Re: Ways to deal with vendor consignment
samantha73 wrote: »I think the problem is Purchase Invoice Item Charges do not create GL entries and only shown in item ledger Non-Inventoriable Costs
Costs over a sale can't go in inventory, only decrease gross profit. Because it's something that you don't have on inventory
KTA8
1
Re: How to count a particular Character in a String
STRLEN(DELCHR(TextLine, '=', DELCHR(TextLine,'=', '@')));this is enough (without '<' and '>'...)
Belias
2
Re: what are prerequisites of autosplit key to use in my code ?
To be clear, autosplitkey is not a code function. It is a property of the page. About the only prerequisite is that the primary key of your table end in an integer. Also you must populate all the other fields of the primary key before moving off the line.
bbrown
1