Run the consistency check for Inventory - Item - On-hand, this should fix
your onhand qty in inventsum be aware this can be a lengthy job depending on
how many transactions you have. You can get to it from
Basic\Periodic\Consistency Check. You should run it in a test environment
first to be
Try using the TextChange or selectionChange event instead of Modified.
-Regards
-Preston
_
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of asrivastava
Sent: Sunday, December 11, 2005 11:49 PM
To: development-axapta@yahoogroups.com
Subject:
Searching the word Random will give you this info in the Axapta help
Regards
-Preston
Class: Random extends Object kerndoc://Classes/Object
Run on: Called
COMMAND://SHOWMETHODS Methods
new KERNDOC://Classes/Random/new
nextInt KERNDOC://Classes/Random/nextInt
on it, lookup() is never
called. Could it be because the form that contains the control with
the lookup button is SysQueryForm ?
--- In development-axapta@yahoogroups.com, Preston A. Larimer
[EMAIL PROTECTED] wrote:
The lookup method only fires when the lookup button on the field
is clicked
@yahoogroups.com, Preston A. Larimer
[EMAIL PROTECTED] wrote:
Rick look at the example of overriding a lookup here, you can use
other
fields on the form for setting your criteria ranges, vs.hardcoding
as I do
in the example...
http://www.axaptalink.com/index.php?option=content
http
Rick look at the example of overriding a lookup here, you can use other
fields on the form for setting your criteria ranges, vs.hardcoding as I do
in the example...
http://www.axaptalink.com/index.php?option=content
http://www.axaptalink.com/index.php?option=contenttask=viewid=23
Sorry attachment was missing before. -Preston
Preston A. Larimer
GREENLIGHT BUSINESS TECHNOLOGY SOLUTION
Professional Solutions Group, LLC
219-697-7601
[EMAIL PROTECTED]
www.greenlightbts.com
-
Building
Someone IM'd me for this XPO .here it is.
-Preston
_
From: Preston A. Larimer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 10:52 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Aidas Slivinskas had solution for
SysDataImport
Hey Jen
Support the Xbox 360 in SA campaign
http://forums.xbox.com/ShowPost.aspx?PostID=12592431
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of Preston A.
Larimer
Sent: 26 July 2005 05:33 PM
To: development-axapta@yahoogroups.com
Subject: RE
This topic was discussed in the group once before, you can search the group
at yahoo, it is also archived
at http://www.mail-archive.com/development-axapta%40yahoogroups.com/ which
I think is an easier search.
This particular thread is at this link
Hey folks, think I know the answer already, but want to see if anyone else
can tell me I'm wrong.
When using select statements you can force the noLock hint on a selection by
setting the property SelectLocked to false on the Common object you are
querying. For example
custTable ct;
This code should get you what you want, of course its written for a 5 day
work week, not 4, but you should be able to see were the change needs made,
if not give a shout. Look at the imbedded function in the following job.
-Preston
static void DlvDays(Args _args)
{
Assuming you know how to do display methods on a report, this example is
from a 128 barcode added to a picking list report
display str getSObarCode()
{
BarCode barCode = BarCode::construct(barCodeType::Code128);
;
barCode.string(true, strUpr(salesPickingListJOurnalTable.SalesId));
Setting up the Axapta Cluster environment
The Axapta Object Server environment offers a load balancing feature -
called the Axapta Object Server Cluster. A number of object servers can be
assigned to the same Axapta Object Server Cluster. A client be configured to
connect to a Cluster. It
Krishna, check out Accounting Software Advisor,
http://www.accountingsoftwareadvisor.com/ . It's full of resources for
helping you choose the right system for your needs.
-Preston
_
From: Krishna Kumar [mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 11:25 PM
Tony, to further Jesper's point, if 2.5 was working as it should, any
configID you had associated with an inventSerialID should have been
represented on the inventTrans and inventSum tables (or one of the other 38
or so tables represented in the upgrade method) in the form of the
inventDimID
Create the bmssa user on the server then run this script against the
restored DB using query analyzer.
http://www.axaptalink.com/index.php?option=contenttask=viewid=9
-Preston
-Original Message-
From: hilda cabrejos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 05, 2005 8:24
Assuming the table on your report has the item ID, this display method
should do the trick; remember to set the font on your control to the
appropriate barcode font, and size.
-Preston
display str lItemIDBC()
{
BarCode barCode = BarCode::construct(barCodeType::Code128);
;
Typicaly setting a field to required is done on the table, so the rule is
enforced through out the entire application; however if you do truly just
need a field to be required on a specific form you can alter the WRITE
method on the data source object on the form, from the looks of your
Jesper, this looks like a standard error I get when using c# and the
standard com connector, if you use COM+ instead you can logon and off with
out the error showing up. I believe there was a thread on technet at one
time that confirmed this behavior when not using COM+.
-Preston
Just a clarification,
systemDateGet() gives you the date used for posting transactions, by default
this will be the same as the machine date, but the user can over ride it
with Menu:Tools\System Date, this can be used if a user needs to enter
transactions as of a past date. For
This may fix your problem with str2Con
http://www.axaptalink.com/index.php?option=content
http://www.axaptalink.com/index.php?option=contenttask=viewid=49Itemid=2
7 task=viewid=49Itemid=27
-Preston
_
From: byteway_so [mailto:[EMAIL PROTECTED]
Sent: Friday, November 19, 2004
meddelelse-
Fra: Preston A. Larimer [mailto:[EMAIL PROTECTED]
Sendt: 18. november 2004 09:44
Til: [EMAIL PROTECTED]
Emne: RE: [development-axapta] Joining two
customers into one
Jens, the merge method takes care of all of the
related tables for you, I
have a version of the code
Alfonso, correct me if I'm wrong, but I expect this is what you are dealing
with, the class InventReport_dimparm dialog is this
public Object dialog()
{
;
dialog = super();
dialogDimGroup =
inventDimParm.addFieldsToDialog(dialog,@SYS53654,true);
return dialog;
}
And your
Alfonso, I put the declaration for the dialogGroup in the dialog method in
my exaple, but in reality that declaration has to go in the classDeclaration
of the base class in order to be visible in the sub class.
Sorry if it causes confusion.
-Preston
_
From: Alfonso Collados
...)
If the Rename option was just enhanced a bit, this would be the right
approach.
/Jens
-Oprindelig meddelelse-
Fra: Preston A. Larimer [mailto:[EMAIL PROTECTED]
Sendt: 18. november 2004 02:52
Til: [EMAIL PROTECTED]
Emne: RE: [development-axapta] Joining two customers into one
This link
Boolean bufCMP(rec1, rec2)
Or
rec1.equal(rec2)
ciao
-Preston
_
From: smeagul2303 [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 11:19 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Compare Records
Hi all,
I'm looking for a method
commaIO handles this for you, and you can read a comma delimited string
right into a container making for easy processing.
-Preston
static void sampleCSVread(Args _args)
{
commaIO myfile;
container inputFields;
fileName inputFile = 'c:\\test.csv';
int iCount = 0;
;
Hey folks, I'm in the progress of setting up a community site where we
can all exchange information by writing articles and documentation, I
have a few more features to add, but I'd say I'm 80% there. Feel free
to check it out and register, I've already started to move some of my
personal
Matt,
We have a client with 160 users spread across 2 AOS and they also have
an EMC SAN for SQL. Based on the DB growth your showing and your
expected additional users you should start working with MBS and your VAR
to help you optimize your Hardware config, and also optimize Axapta's
indexes
There are times when the Log file will not shrink even if the maint
routines are set properly running the following commands in Query
analyzer will force the shrink of the database and log file. Replace
dbName with the Name of the database, Percntage in the second line is
the percent of
Method on the CustPackingslipTrans table named initFromSalesLine.
-Preston
-Original Message-
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 12:42 PM
To: [EMAIL PROTECTED] Com (E-mail)
Subject: [development-axapta] SalesLine -- CustPackingSlipTrans.
This is some Code I made to test the Connection in c#, it calls a static
class method a couple times and writes the output to the console, then
executes a query and writes output of the name field from the custTable
to the console as well. Then it calls another static method that does
the same
The query that populates the lines for salesPickingListJournal is
located on the SalesPickingListJournalTable::
querySalesPickingListJournalLine below is the method with a modification
I did to force the sort by location. There is a similar method on
custPickingListJourTable
Any one have an example of using the HeapLog class, or know how to
invoke it. I'm wrestling with a memory issue, and it looks like it
would be useful in tracking objects in the heap.
Thanks
-Preston
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Does any
one have some sample code that prints an Axapta report to a
network printer via the Axapta Com control?
Thanks
-Preston
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group,
Title: Nachricht
Put this code in the init method of your
form and call it from different places and see what you get, it should help you
get moving with this.
Note: If the form object is being called
from a class like salesEdit lines, then this will
always point to a class, and you
Anil,
Look on your SQL server at the Master data
base views there should be approximately 20 views with the owner listed as
INFORMATION_SCHEMA, in particular the one view named VIEWS is what Axapta is
trying to use, If
the owner is DBO it would be my guess you at some time
-Original Message-
From: Preston A. Larimer
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 12:34 PM
To:
[EMAIL PROTECTED]
Subject: RE: [development-axapta]
AX SP2 database error..
Anil,
Look on your SQL server
at the Master data base views there should
Is this a standard Axapta report? A few of
the standard reports that use inventDim dont populate
them with the query, but use the fetch method to get the inventDim
record to display so setting the sorting on the Data source has no effect. Let us know which report it is if its
standard
Title: Message
See if
this will help you on your way Best regards
-Preston
Modify the lookup method on teh control to build the lookup form
Example:
public void lookup()
{
//This lookup basis the list criteria on information in 2 tables
//All display fields come
Title: Message
I have
done this using a temp table, create a temp table that matches your report
column format, base your report on the temp tableand populate it with the
selected valueswhen the report is run.
-Preston
-Original Message-From: pbercher
[mailto:[EMAIL
Title: Message
Have
you tried rebuilding the Application Object Index?
If you
dont know how... find the file in the application directory with the extension
.aoi and rename it, you can delete it later if it fixes your problem, then
restart axapta you should get a message about
Boris,
MOST all fields in Axapta use an extended data type (EDT) or a base
enumerator (baseEnum) , if you look at the field in the table in the
AOT, and get the property for this you can then find the EDT/baseEnum
change the label, and it will effect all places it is used in the
system. If
Title: Purchase digit problem..
Hey
Anil,
I think your problem is not the EDT, but
in the actual price calculation, the price is calculated by priceDisc::price2Amount,
this is used on both purch and sales lines and will
round the price based on the default currency settings, so you
Here are some notes I made for myself on
doing this, you will override the lookup method on the control, you also may have to set the lookupButton property on the
field.
Gluck. -Preston
public void lookup() { //This lookup basis the list criteria on information in 2 tables //All
Sorry didnt get what you wantedIf
you really want generic,
Table count in the datasource element.dataSourceCount(),
First table name from
data source - element.dataSource(1).name(),
Field contents from the
first field of the first table
Hey Cenk, I had
this problem, below is what I got from MS on a fix
that has worked for some..
It did not work on my issue though I ultimately ended up deleting all
records in the transaction log alder than 9 months and has fixed it for
now. I know there has to be a code
issue here but I
be used because the method is protected. if you
declare your asciiio object as an object, you are able to use the finalize
method.
ex.
object export = new asciiio(filename,'W');
Regards
Maarten
Aanhalen Preston A. Larimer [EMAIL PROTECTED]:
Use the finalize method of asciiIO . Export.finalize
The only thing I dont like about this is that you have to assume the incoming date format . You could write a method that does the str2Date conversion looping through the alternative combinations to find a valid date and relying on the winAPI::getSystemLocaleDateStr() call as the final say if a
Oops, I should run these things before I mail them, there where to mistakes in the prev Job
static void pl_scratch(Args _args)
{
str dateRange = '2003-10-13..2003-10-17,2003-09-15,2003-08-15,';
boolean firstLoop = true;
int dblDots;
int start;
int end;
int sLen;
int
Third Time is the Charm Right.
while(rangeCnt (EndDateRange-startDateRange)){
Needs to be
while(rangeCnt = (EndDateRange-startDateRange)){
-Original Message-
From: Preston A. Larimer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 12:25 PM
To: [EMAIL PROTECTED]
Subject
Hey, we run across this in almost every 3.0 install weve done, at the posting of the SO and PO Reports the code tries to determine the proper place to pull the number of copies and originals from, and if this cannot be determined then default values are used. Someone at MBS has determined the
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: Print forms gace error - Nothing to print
Hi,
I have tried both ways.
But i still get the same error message.
Please help.
thanks,
ag
--- In [EMAIL PROTECTED], Preston A. Larimer
[EMAIL PROTECTED] wrote:
Hey, we run across this in almost
enum2String(Enum) Returns the string value of the enum so enum2String(noYes::No) returns No
I use the these two methods for getting element names and values form an enum value or index.
static str enumValueString(str _Enum, anyType _enumValue)
{
DictEnum dictEnum;
;
dictEnum = new
Cenk, Try this info Ive used it for creating custom paper for Old Okidata Printers
http://support.microsoft.com/default.aspx?scid=kb;EN-US;157172
-Preston
-Original Message-
From: Cenk Ince [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 6:40 AM
To: [EMAIL PROTECTED]
See MS KB Article 157172 for instructions on creating custom paper forms in XP and 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;157172
-Original Message-
From: Thomas Jensen [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 4:02 AM
To: '[EMAIL PROTECTED]'
Yes you can you would use Axapta in a 2-tier mode, every client has a connection to
the database server and need access to a shared application directory on a file server.
-Preston
-Original Message-
From: mchiat [mailto:[EMAIL PROTECTED]
Sent: Friday, September 26, 2003 2:59 AM
To:
Try changing your link type on the data source to inner or outer join
-Preston
-Original Message-
From: Cenk Ince [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 5:38 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] displaying fieds from different tables on a grid
Hi
Hey, the process for choosing the alternative Item takes place in the Forms\SalesTable\dataSources\SalesLine\Methods\validateWrite you could grab the original sales item id there and place it in a new field on the sales line then either init it to the journals you want to report it on or use
a strange behavior I am finding.
-Original Message-
From: Preston A. Larimer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 10:40 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Bank Reconciliation Report
If the report is working fine for some and not others try deleting
You should be able to open up those two files in a text editor and fix the numbering,
and you may want to delete the .ali files so they reindex.
-Original Message-
From: Mikael Dalgård [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 2:03 AM
To: [EMAIL PROTECTED]
Subject:
:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 2:33 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: Alternative Item number
Hello,
There is no method validateWrite under
forms\salesTable\datasources\salesLine\methods.
--- In [EMAIL PROTECTED], Preston A. Larimer
[EMAIL PROTECTED
Forgot to mention the method needs to be static and needs to be called as ClasName::Method(), If you use this.method() it runs on where the current class is running.
-Preston
-Original Message-
From: Preston A. Larimer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 8:49 AM
Hi, Ive run into this before, the way around it is set your call to the Winapi in another method set that method to run on the client and call this method from inside the startup method.
-Preston
-Original Message-
From: Theissen, Annette [mailto:[EMAIL PROTECTED]
Sent: Friday, October
Ive used this code in 2.5 to packslip a salesOrder, think it will work in 3.0, but havent tested.
void packSlipOrder(salesID currSalesID)
{
SalesFormLetter_PackingSlip SFLPS;
salesTable _salesTable;
_salesTable.data(salesTable::find(currSalesID));
if(!_salesTable){
Hey,
The Misc Charges table (markupTrans) is linked by TableID (markupTrans.TransTableID) and recID (markUpTrans.TransRecID), so the charges associated with a particular salesOrder will have most likely show a transTableID of 366 and the transRecID will be the recID of the salesTable record for
67 matches
Mail list logo