[development-axapta] how to filter data on forms (date and time fields)...

[jannolii]

Hi!
 
I'm in need of advice. I have a form and i want to filter data by 
specifying time limit... for example: show rows that are newer than 
25.08.2004 12:00:00. But how can i do that when Axapta holds date 
and time separated (different types). Ok... i can make a query of my 
own and filter data only by date (>= 25.08.2004). And then i could 
check on each returned row date and time (date > 25.08.2004 && time 
> 12:00:00). And each row that is returned i put in somekind of temp 
table and sow only a temp table on form ... or i make a list of 
recid's or primary key's and then i  make a query of my table with 
inner join on that list etc.
But isn't there a easy way? Does somebody know how to make it 
easier? Or maybe somebody knows such form in Axapta where this has 
been already done?
 
Please, let me know if you do.
 
Axapta 3.0 SP2
MS SQL 2000 server
 
 
Thanks in advance.
 
Janno Liivak
 











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Cheque printing

[Matt Benic]

Hi Jason,
Excuse my ignorance, but the text only driver? Do you mean a standard
windows driver? I am just using the standard epson fx890 driver..

Regards,

Matt Benic
Axapta Developer
UTi Sun Couriers Division


-Original Message-
From: Jason Crook [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 05:11 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Cheque printing


Ive also had endless problems with the Epson printers ,my solution which
works perfectly was just to use the generic text only driver

Regards

Jason Crook

Exordia





From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 13:57
To: Axapta Dev
Subject: [development-axapta] Cheque printing



Hi All,
We print company cheques using an Epson FX 890 dot matrix printer. We
have
been having problems with the printer skipping cheques. I have been
trawling
through the printer settings on wondoze, and have had no luck with the
problem so far. Would there be anything in Axapta that could influence
this.
Note it's not just that the alignment is off (that happens too, over
time)
but that the printer skips entire checks when printing.
Regards,

Matt Benic
Axapta Developer
UTi Sun Couriers Division






Yahoo! Groups Sponsor

ADVERTISEMENT
click here









Yahoo! Groups Links

*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/

*  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

be>

*  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service  .



[Non-text portions of this message have been removed]






Yahoo! Groups Links
















Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Create Word document from code

[Harry Nilsen]

Thanks, this looks like the answer I was looking for.

-Original Message-
From: Amund [mailto:[EMAIL PROTECTED] 
Sent: 26. august 2004 11:41
To: [EMAIL PROTECTED]
Subject: Re: [development-axapta] Create Word document from code

Hi,
you could have a look at Tools->Development tools->Wizards->COM Class  
Wrapper Wizard, check out how things are done in the SysExcel*,  
SysMicrosoftAgent or SysOutlook* classes, or create your own class in
the  
lines of:

(Note: All error and version checking has been left out.)

class MyMSWord
{
 COM wdApp;  // Word
 COM wdDocuments;    // All documents
 COM wdDocument; // Current document
 COM wdBookmark; // Current bookmark

 container   wdBookmarksEnum;
}

void new()
{
 wdApp   = new COM("Word.Application");
 wdDocuments = COM::createFromObject(wdApp.Documents());
 wdBookmarksEnum = this.bookmarksEnumerate();
}

// Create a new document, based on template
boolean documentAdd(str _template)
{
 wdDocument  = wdDocuments.Add(_template); // Add method of Word  
"Documents" object
 wdSelection = wdApp.Selection();  // The added document is
now  
the active one
 return true;
}

// Inserting text into bookmark
void bookmarkText(str _bookmark, str _text)
{
 this.bookmarkSelect(this.bookmarkIndex(_bookmark)); // Selecting  
bookmark
 wdSelection.Text(_text); // Insert text into bookmark
}

// Select a bookmark by index
boolean bookmarkSelect(int _bookmarkIndex)
{
 COM cBookmarks;
 ;

 if (_bookmarkIndex <= conlen(wdBookmarksEnum))
 {
 cBookmarks = wdDocument.Bookmarks();
 wdBookmark = cBookmarks.Item(_bookmarkIndex);
 wdBookmark.Select();
 }
 return (wdBookmark ? true : false);
}

// Find bookmark index from name
int bookmarkIndex(str _name)
{
 return confind(wdBookmarksEnum, _name);
}

// Enumerate bookmarks in current document
container bookmarksEnumerate()
{
 container   ret;
 int i;
 COM cBookmarks;
 COM cBookmark;
 ;

 cBookmarks = wdDocument.Bookmarks();
 for (i=1; i<=cBookmarks.Count(); i++)
 {
 cBookmark = cBookmarks.Item(i);
 ret = conins(ret, i, cBookmark.Name());
 }
 return ret;
}

Then you should be able to do something like this:

static void adbTestWordBookmarks(Args _args)
{
 MyMSWord  wd = new MyMSWord();
 CustTable   custTable;
 int n;
 ;

 //wd.Visible(1); // Make Word visible if desired. By default it's
not

 while select custTable order by name
 {
 wd.documentAdd("C:\\Program Files\\Microsoft  
Office\\Templates\\1033\\Professional Fax.dot") // Create new  
document
 wd.bookmarkText("Cc", "Tech. dep.");      //
Bookmark
 wd.bookmarkText("Company", "Acme");     //
Company
 wd.bookmarkText("Fax", custTable.TeleFax);    // Fax
(number)
 wd.bookmarkText("From", "Hal");
// From
 wd.bookmarkText("Pages", "1");        //
Pages, could be obtained from  
Document object
 wd.bookmarkText("Subject", "Fax from Axapta");  // Subject
 wd.bookmarkText("To", custTable.Name);      // To
 wd.documentSave(strfmt("Fax to customer %1.doc",  
custTable.AccountNum)); //or wd.documentPrint(...);
 wd.documentClose();
 }
}

Looking at the vba code generated by the macro recorder in MSWord is
quite  
useful for figuring out how to do a specific task.
The vba code from MSWord can then easily be ported to Axapta.

Hope this helps.

Amund

Wed, 25 Aug 2004 17:02:34 +0200 skrev Harry Nilsen <[EMAIL PROTECTED]>:

> Hi!
>
>
>
> I have to create a Word document based on a Word template with
bookmarks
> from code using data from a table in Axapta.
>
>
>
> Does someone have an example of code which could help me out ?
>
>
>
> Regards,
>
> Harry
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.







 
Yahoo! Groups Links



 











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [development-axapta] Create Word document from code (2)

[Amund]

There are also some code in the DocuActionCOM_Word class that could be  
useful.

Amund

Wed, 25 Aug 2004 17:02:34 +0200 skrev Harry Nilsen <[EMAIL PROTECTED]>:

> Hi!
>
>
>
> I have to create a Word document based on a Word template with bookmarks
> from code using data from a table in Axapta.
>
>
>
> Does someone have an example of code which could help me out ?
>
>
>
> Regards,
>
> Harry
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.





 Yahoo! Groups Sponsor ~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE: [development-axapta] Cheque printing

[Jason Crook]

Ive also had endless problems with the Epson printers ,my solution which
works perfectly was just to use the generic text only driver 

Regards 

Jason Crook 

Exordia

 



From: Matt Benic [mailto:[EMAIL PROTECTED] 
Sent: 26 August 2004 13:57
To: Axapta Dev
Subject: [development-axapta] Cheque printing

 

Hi All,
We print company cheques using an Epson FX 890 dot matrix printer. We
have
been having problems with the printer skipping cheques. I have been
trawling
through the printer settings on wondoze, and have had no luck with the
problem so far. Would there be anything in Axapta that could influence
this.
Note it's not just that the alignment is off (that happens too, over
time)
but that the printer skips entire checks when printing.
Regards,

Matt Benic
Axapta Developer
UTi Sun Couriers Division






Yahoo! Groups Sponsor

ADVERTISEMENT
click here
 

 
 

 



Yahoo! Groups Links

*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
    
*  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

be> 
    
*  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service  . 



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] integration axapta 3.0 whith lotus notes

[sguettler]

hi,

has anybody informations about an easy way to integrate lotus notes and 
axapta?

my intension is, lotus notes has a role of a mobile client to collect 
orders and printing invoices.

the communication between lotus and axapta should realized by the 
replicate function from lotus notes.

or is there a better possibility? 

thank you for any information.

Best Regards

Sascha Güttler

 

[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE : [development-axapta] how to filter data on forms (date and time fields)...

[Steeve Gilbert]

Check this article on TechNet :
http://technet.navision.com/default.asp?MenuFunctionName=EISNewsArticle&MenuFunctionType=Output&NEWSID=351

You can do that :

Str _expression_ = strfmt("(((%1 == %2) && (%3 >= %4)) || (%5 > %6))",
    fieldStr(YourTable, DateField), 25\08\2004,
    fieldStr(YourTable, TimeField), 60*60*12, //12:00:00    fieldStr(YourTable, DateField), 25\08\2004);
YourTable_ds.addRange(fieldNum(YourTable, DateField)).value(_expression_);



Steeve... 


-Message d'origine-
De : Janno Liivak [mailto:[EMAIL PROTECTED] 
Envoyé : 26 août 2004 07:18
À : [EMAIL PROTECTED]
Objet : [development-axapta] how to filter data on forms (date and time fields)...


Hi!
 
I'm in need of advice. I have a form and i want to filter data by specifying
time limit... for example: show rows that are newer than 25.08.2004
12:00:00. But how can i do that when Axapta holds date and time separated
(different types). Ok... i can make a query of my own and filter data only
by date (>= 25.08.2004). And then i could check on each returned row date
and time (date > 25.08.2004 && time > 12:00:00). And each row that is
returned i put in somekind of temp table and sow only a temp table on form
... or i make a list of recid's or primary key's and then i  make a query of
my table with inner join on that list etc.
But isn't there a easy way? Does somebody know how to make it easier? Or
maybe somebody knows such form in Axapta where this has been already done?
 
Please, let me know if you do.
 
Axapta 3.0 SP2
MS SQL 2000 server
 
 
Thanks in advance.
 
Janno Liivak
 


[Non-text portions of this message have been removed]





 
Yahoo! Groups Links



 













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Re: Axapta Update

[lvargas0123]

James, Thanks for your help. 

I'll talk to my partner about that.

Lucas!


--- In [EMAIL PROTECTED], "James Flavell" 
<[EMAIL PROTECTED]> wrote:
> Hi Lucas,
> 
> Depends on how much modifcations you have done and whether you 
expect you
> might want to use new features that might come along (of course 
you must
> still pay for any new modules you want).  If you have huge amounts 
of
> modifications you may never want to upgrade but then again you 
might say
> never say never...
> 
> If you dont take the maintenance and a few months or years down 
the line you
> decide to upgrade you can either repurcahse the software at the 
list price
> or I believe MBS will allow you to pay your 'outstanding' 
mainteance with a
> late penalty charge (not sure the percent, I think it increase 
with every
> month that passes so not sure where the point of becoming more 
expensive
> than repurchasing would be).
> 
> Also take note MBS future plans of a singel ERP product (in a good 
few
> years), if you have the maintenance programme you will get all the
> corresponding functions free (i.e. the future ERP produt will be 
treated
> just like a new Axapta version).
> 
> The yearly mainteance amount should be based on only the modules 
you have
> purchased. If you purcahse extra modules your mainteance will be 
changed to
> include these.  If you do not upgrade your mainteance will be 
based on your
> original purcahse price but once you upgrade your mainteance will 
be based
> on the list price of the latest version.
> 
> If really you have purchased some modules but never use them it 
might be
> possible for you to swap them for other modules (ask you partner 
to help dx
> with MBS on the possiblity) to the same value but dont ever expect 
MBS to
> remove modules you dont use (basically you already have the 
license code so
> there is nothing stoping you from using them) although if you are 
planning
> to upgrade then this might be an option as MBS can issue the new 
license
> code without those modules...
> 
> Finally take note any service pack or hotfix for the version you 
have I
> believe is not part of the mainteance, basically such items are 
available to
> you since you bought that version.  Mainteance is stricly for new 
versions
> (I dont know if you requested a copy of SPs for versions that you 
didnt
> purchase whether you are legally allowed to be given but I would 
expect your
> partner will freely give you).
> 
> I hope that helps you, if you have a decent partner they should be 
able to
> clearly explain these things when they meet you
> 
> Anyone wish to correct me or add to what I have said?
> 
> All the best
> James
> 
> James Flavell
> International Business Consultant
> Email: [EMAIL PROTECTED] / [EMAIL PROTECTED]
> Tel  : +65 97582281(SG)
> 
> PT Columbus IT Indonesia
> Jakarta Stock Exchange Tower II, 17th Floor
> Suite 1701
> Jl. Jend Surdiman Kav. 52-53
> Jakarta 12190
> Indonesia
> 
> Tel: +62 21 515 7684
> Fax: +62 21 515 7799
> 
> 
> 
>   -Original Message-
>   From: lvargas0123 [mailto:[EMAIL PROTECTED]
>   Sent: 25 August 2004 22:26
>   To: [EMAIL PROTECTED]
>   Subject: [development-axapta] Axapta Update
> 
> 
>   Hi yall
> 
>   I've been using axapta for almost a year now, and it's time for 
me
>   to buy the update contract from my business partner. I wonder if 
I
>   could live without the periodicall updates... and if I can't I 
need
>   to know if the price of the update is based on the original 
price I
>   payed or on the actual price of the product.
> 
>   Besides, I'm not using (didn't buy) all of axapta's modules, do I
>   have to pay for the updates of the modules I'm not using?
> 
>   I would appreciate any information anyone could give, cuz I have 
get
>   much from my business partner.
> 
>   thanks in advance
> 
>   Lucas!
> 
> 
> Yahoo! Groups Sponsor
>   ADVERTISEMENT
> 
> 
> 
> 
> 
> ---
-
> --
>   Yahoo! Groups Links
> 
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
> 
> b.. To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> 
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms 
of Service.
> 
> 
> 
> [Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [development-axapta] table views

[Max Belugin]

Hello James Flavell,

четверг, 26 августа 2004 г., you wrote:

JF> I know this is might be a bit of a black box question given that the DBMS
JF> can do what it likes but I would like to get any insight (esp for MS SQL

maybe QueryAnalyzer can help you?

-- 
Best regards,
 Max

http://belugin.newmail.ru
ICQ:9406811




 Yahoo! Groups Sponsor ~--> 
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM
~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

[development-axapta] Exporting/Importing SP1 -> SP2

[Jens Fudge]

Hi


I have a customer with a Axapta 3.0 SP1 application. In this application
they have multiple companies, eight, I think.

They also have a bunch a Axapta 3.0 SP2 with empty databases.

They want to export the different companies (From SP1) to the different
Axapta's (SP2).

The export is easy, but it seems that importing the data is a bit tricky. I
let the import run for approx 50 hours, yes 50 hours And it still didnt
finish, so I killed it via task-manager.

Does anyone know of a way to import data from a SP1 to a SP2 application?

Thanks for your time.

Jens



EDB Gruppen A/S inviterer til stort kundearrangement i Odense Congress Center i dagene 
6.- 8. 9.2004. 
Læs mere og tilmeld dig på http://www.egforum.dk




 Yahoo! Groups Sponsor ~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [development-axapta] Refresh Form

[Baran Sasmaz]

Try :
 
_ds.executeQuery();


Alfonso Collados Arroyo <[EMAIL PROTECTED]> wrote:
Hi,
I need to refresh a form after an operation.
How can I do this?

Thanks


Yahoo! Groups SponsorADVERTISEMENT


-
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
  
   To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


    
-
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.

[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE : [development-axapta] How to show container content in the grid

[Steeve Gilbert]

I don't have much experience with containers but I think you'll have to extract the data yourself to be able to show it on you grid.  Have a look at Forms/SysDatabaseLog.

Steeve... 


-Message d'origine-
De : Baran Sasmaz [mailto:[EMAIL PROTECTED] 
Envoyé : 26 août 2004 05:00
À : [EMAIL PROTECTED]
Objet : [development-axapta] How to show container content in the grid

Hi,
 
I have problems while showing the content of the container in the grid.
My datasource has two field. First field is the id of type string and the second of type container. 
When I add the field of type container to the grid, grid size changes and the content of the container cant be shown. 
 
I need your help.
How can i do this?
 
Thanx in advance.
 
Baran.

    
-
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!

[Non-text portions of this message have been removed]





 
Yahoo! Groups Links



 











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Strange records in table CustInvoiceJour

[Jens Strandberg]

Thanks Steve - and others,

You are correct, those are indeed from a Free Text Invoice.

However, I find it very strange that:

CustTrans holds 1 record, USD 1,480 (which is correct)
CustInvoiceJour holds 1 record, USD 1,480 (which is also correct)
BUT
CustInvoiceJour also holds 3 records, i.e. 3 X USD 1,480, (identical dates
etc. as the correct one) that are not marked as "Updated".

As a result, the invoice turnover report - and others - will show 4 X USD
1,480 - UNLESS you query only those records that are "Updated" and/or have
an InvoiceID.

Is this a bug or a "feature" in Axapta - or did one of our users do
something very odd to achieve this ?

Thanks in advance.

Best Regards,
Jens
  -Oprindelig meddelelse-
  Fra: Steve Wright [mailto:[EMAIL PROTECTED]
  Sendt: 26. august 2004 10:56
  Til: [EMAIL PROTECTED]
  Emne: RE: [development-axapta] Strange records in table CustInvoiceJour


  Hi Jens

  Theses are from AR Free Text Invoices.

  I beleive CustInvoiceTable is used to store the Free Text Header.  When
you
  post the invoice the header is copied to CustInvoiceJour.

  Regards,
  steve

    _

  From: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Sent: Thursday, 26 August 2004 2:47 PM
  To: [EMAIL PROTECTED] Com (E-mail)
  Subject: [development-axapta] Strange records in table CustInvoiceJour


  Hello there,

  I have come across some strange records in table CustInvoiceJour. These
are
  without SalesId, Qty, InvoiceID, LedgerVoucher and with Updated not
checked.
  Also, Refnum is set to "Customer".

  I am only able to track these records ind Table Browser; not elsewhere
  (probably my skills are just limited...)

  Do you know where the records come from ?

  The reason for asking is that the invoice journal and invoice turnover
  report show these figures, and since they are not related to any sales
  orders, I am worried. In one case we have 3 identical records in
  CustInvoiceJour with the same date, customer, invoiceamount etc., i.e. 3 X
  USD 10,000 and one record with salesID, i.e. 1 X USD 10,000. The above
  reports then show a total of USD 40,000.

  Also - in the above example - we have only one corresponding record in
  CustInvoiceTrans.

  Any input will be greatly appreciated. Thanks in advance !


  Best Regards,
  Jens




  Yahoo! Groups Sponsor

  ADVERTISEMENT


 click here




    _

  Yahoo! Groups Links


  *  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
  


  *  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]




  *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
   .




  [Non-text portions of this message have been removed]



    Yahoo! Groups Sponsor
  ADVERTISEMENT






--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Refresh Form

[Cenk Ince]

Hi Alfonso;

If you mean refreshing data source on form try :

  Datasoursename_ds.refresh();
  // like inventtable_ds.refresh();

If you want to refresh form try :
  
  Element.reload();
  Or
  Element.activate();

I hope that helps.


-Original Message-
From: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 26, 2004 11:59 AM
To: 'Development-Axapta (E-mail)
Subject: [development-axapta] Refresh Form

Hi,
I need to refresh a form after an operation.
How can I do this?

Thanks




 
Yahoo! Groups Links



 











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] How to show container content in the grid

[Anil Ozay]

Hi Baran,
 
you can find a sample Classes/SysTableBrowser/showAllFields()
 
this is the class of tableBrowser of Axapta.. This is a part of code,
when the field is container :
 
    formBuildControl =
formBuildGridControl.addControl(FormControlType::STRING,'TableBrowserCon
tainer');
 
formBuildControl.datasource(formBuildDataSource.id());
 
formBuildControl.dataField(fieldId2Ext(fieldId,j));
    formBuildControl.label(dictField.name());
    formBuildControl.helpText(dictField.label());
    formBuildControl.displayLengthMode(0);
    formBuildControl.displayLengthValue(5);
    formBuildControl.lookupButton(2);
 
 
i hope it helps you..
 
Anil Ozay
 
Axapta Technical Consultant
DataSistem Genel Otomasyon ve San. Tic.A.S
+90 232 4631663 - 208
 



From: Baran Sasmaz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 26, 2004 12:00 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] How to show container content in the grid


Hi,

I have problems while showing the content of the container in the grid.
My datasource has two field. First field is the id of type string and
the second of type container. 
When I add the field of type container to the grid, grid size changes
and the content of the container cant be shown. 

I need your help.
How can i do this?

Thanx in advance.

Baran.

    
-
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!

[Non-text portions of this message have been removed]




Yahoo! Groups Sponsor  
ADVERTISEMENT
click here
   
 
   



Yahoo! Groups Links


*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
    
*  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

be> 
    
*  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service  . 




[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE : [development-axapta] Refresh Form

[Steeve Gilbert]

Try element.redraw() or refresh the dataSource with

ATable_ds.executeQuery();
ATable_ds.refresh();

Steeve... 


-Message d'origine-
De : Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED] 
Envoyé : 26 août 2004 04:59
À : 'Development-Axapta (E-mail)
Objet : [development-axapta] Refresh Form

Hi,
I need to refresh a form after an operation.
How can I do this?

Thanks




 
Yahoo! Groups Links



 











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Cheque printing

[Matt Benic]

Hi All,
We print company cheques using an Epson FX 890 dot matrix printer. We have
been having problems with the printer skipping cheques. I have been trawling
through the printer settings on wondoze, and have had no luck with the
problem so far. Would there be anything in Axapta that could influence this.
Note it's not just that the alignment is off (that happens too, over time)
but that the printer skips entire checks when printing.
Regards,

Matt Benic
Axapta Developer
UTi Sun Couriers Division











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] how to filter data on forms (date and time fields)...

[Janno Liivak]

Hi!
 
I'm in need of advice. I have a form and i want to filter data by specifying
time limit... for example: show rows that are newer than 25.08.2004
12:00:00. But how can i do that when Axapta holds date and time separated
(different types). Ok... i can make a query of my own and filter data only
by date (>= 25.08.2004). And then i could check on each returned row date
and time (date > 25.08.2004 && time > 12:00:00). And each row that is
returned i put in somekind of temp table and sow only a temp table on form
... or i make a list of recid's or primary key's and then i  make a query of
my table with inner join on that list etc.
But isn't there a easy way? Does somebody know how to make it easier? Or
maybe somebody knows such form in Axapta where this has been already done?
 
Please, let me know if you do.
 
Axapta 3.0 SP2
MS SQL 2000 server
 
 
Thanks in advance.
 
Janno Liivak
 


[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Refresh Form

[Girish Bhatkal]

suppose the you are on purchTable form and the changes are done in
purchTable then you should write
purchTable_ds.reread();
purchTable_ds.refresh();
  -Original Message-
  From: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED]
  Sent: 26 August 2004 09:59
  To: 'Development-Axapta (E-mail)
  Subject: [development-axapta] Refresh Form


  Hi,
  I need to refresh a form after an operation.
  How can I do this?

  Thanks


    Yahoo! Groups Sponsor
  ADVERTISEMENT






--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] table views

[James Flavell]

Can anyone tell me what kind of processing over head there is in using table
views?  I understand that ax basically creates SQL views in the database but
I was wondering if say I join inventrans and inventdim in a view and want to
filter by warehouse and a specific item number, will the view first filter
by item number or will the view return all joins and then filter?

I know this is might be a bit of a black box question given that the DBMS
can do what it likes but I would like to get any insight (esp for MS SQL
2000) as I am tempted to use views for some customer requirements but do not
know in a few years whether it will become too slow to use once the number
of transactions grow...

THanks
James


[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [development-axapta] is there any where to check that a dimension value on inventorytrans

[jagjeet singh]

Have a look on inventory dimension group on item card.
you can set which dimension you want to be mandatory
over there in all over the system.

Ta
--- James Flavell <[EMAIL PROTECTED]> wrote:

> I hope someone can help me,
> 
> Whenever an inventtrans is created/updated etc I
> want to check that one of
> the dimensions is set.  This is because I have
> created an inventory movement
> report that assumes the dimension is always set but
> I dont want to have to
> go round every place in the system and put
> mandatory/checks as this will
> take forever, so I am hoping there is on place I can
> catch this.  If the
> dimension is blank I would want to give an error and
> abort the operation the
> user was doing.
> 
> If I was to put such checking in the validatewrite
> of the inventtrans I am
> not confident as I think it maybe too late as I know
> there are a lot of
> processing that is done before inventtrans is
> finally updated...
> 
> 
> Thanks
> James
> 
>   -Original Message-
>   From: Theissen, Annette
> [mailto:[EMAIL PROTECTED]
>   Sent: 25 August 2004 23:50
>   To: '[EMAIL PROTECTED]'
>   Subject: AW: [development-axapta] Rows in a select
> 
> 
>   Try this:
> 
>  InventTrans inventtrans;
>  ;
>  select count(RecID) from inventtrans where
> inventtras.transtype==3;
>info(int2str(inventTrans.RecID));
> 
>   The number of records is then stored in
> inventTrans.RecID.
>   Also, please consider using enums instead of
> numbers. Here, you ought to
>   write InventTransType::Purch instead of 3. It
> makes the code a lotmore
>   readable!
> 
>   Hope this helps!
> 
>   Annette
> 
> 
>   Mit freundlichen Grüßen / Best regards
>   Dipl. Phys. Annette Theißen
>   System Software Entwicklung
>   __
>   Viscom AG - Carl-Buderus-Str. 9-15 - D-30455
> Hannover
>   Phone: +49/511/94996-0 - Fax: +49/511/94996-900
>   mailto:[EMAIL PROTECTED]
>   -
>   http://www.viscom.de 
> 
>   -Ursprüngliche Nachricht-
>   Von: Alfonso Collados Arroyo
> [mailto:[EMAIL PROTECTED]
>   Gesendet: Mittwoch, 25. August 2004 16:40
>   An: 'Development-Axapta (E-mail)
>   Betreff: [development-axapta] Rows in a select
> 
> 
>   Hi,
>   How can i know in a 'select' the number of
> registers returned?
>   For example,
>   Code:
> InventTrans inventtrans;
> ;
>   select inventtrans where
> inventtras.transtype==3;
> I need to know the number of registers.
> 
>   Thanks
> 
> 
>   Yahoo! Groups Sponsor
> 
>   ADVERTISEMENT
> 
> 
>
 
>
oups/S=1705006764:HM/EXP=1093531563/A=2319498/R=0/SIG=11thfntfp/*http://www.
>   netflix.com/Default?mqso=60185352&partid=5285298>
> click here
> 
> 
>
   :HM/A=2319498/rand=146572662>
> 
> 
> _
> 
>   Yahoo! Groups Links
> 
> 
>   *  To visit your group on the web, go to:
>   http://groups.yahoo.com/group/development-axapta/
>  
> 
> 
> 
>   *  To unsubscribe from this group, send an
> email to:
>   [EMAIL PROTECTED]
> 
>

> 
> 
>   *  Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service
>    .
> 
> 
> 
> 
>   [Non-text portions of this message have been
> removed]
> 
> 
> Yahoo! Groups Sponsor
>   ADVERTISEMENT
> 
> 
> 
> 
> 
>

> --
>   Yahoo! Groups Links
> 
> a.. To visit your group on the web, go to:
>
> http://groups.yahoo.com/group/development-axapta/
> 
> b.. To unsubscribe from this group, send an
> email to:
> [EMAIL PROTECTED]
> 
> c.. Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
> 
> 
> 
> [Non-text portions of this message have been
> removed]
> 
> 
> 




__
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now. 
http://messenger.yahoo.com



 Yahoo! Groups Sponsor ~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

[development-axapta] Import Error

[Sam, Abin]

hi all,

  Can anybody tell me how to clear out this error. I got this error when I
tried to import some data to production related tables. Actually I have
selected all the tables selected on my def group.

  The error is :-

 "Table reference when importing to table 'Calculation' not specified, so
the imported reference to table 'Production BOM' is kept."


 Thanks in advance !

Sam.










Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [development-axapta] Create Word document from code

[Amund]

Hi,
you could have a look at Tools->Development tools->Wizards->COM Class  
Wrapper Wizard, check out how things are done in the SysExcel*,  
SysMicrosoftAgent or SysOutlook* classes, or create your own class in the  
lines of:

(Note: All error and version checking has been left out.)

class MyMSWord
{
 COM wdApp;  // Word
 COM wdDocuments;// All documents
 COM wdDocument; // Current document
 COM wdBookmark; // Current bookmark

 container   wdBookmarksEnum;
}

void new()
{
 wdApp   = new COM("Word.Application");
 wdDocuments = COM::createFromObject(wdApp.Documents());
 wdBookmarksEnum = this.bookmarksEnumerate();
}

// Create a new document, based on template
boolean documentAdd(str _template)
{
 wdDocument  = wdDocuments.Add(_template); // Add method of Word  
"Documents" object
 wdSelection = wdApp.Selection();  // The added document is now  
the active one
 return true;
}

// Inserting text into bookmark
void bookmarkText(str _bookmark, str _text)
{
 this.bookmarkSelect(this.bookmarkIndex(_bookmark)); // Selecting  
bookmark
 wdSelection.Text(_text); // Insert text into bookmark
}

// Select a bookmark by index
boolean bookmarkSelect(int _bookmarkIndex)
{
 COM cBookmarks;
 ;

 if (_bookmarkIndex <= conlen(wdBookmarksEnum))
 {
 cBookmarks = wdDocument.Bookmarks();
 wdBookmark = cBookmarks.Item(_bookmarkIndex);
 wdBookmark.Select();
 }
 return (wdBookmark ? true : false);
}

// Find bookmark index from name
int bookmarkIndex(str _name)
{
 return confind(wdBookmarksEnum, _name);
}

// Enumerate bookmarks in current document
container bookmarksEnumerate()
{
 container   ret;
 int i;
 COM cBookmarks;
 COM cBookmark;
 ;

 cBookmarks = wdDocument.Bookmarks();
 for (i=1; i<=cBookmarks.Count(); i++)
 {
 cBookmark = cBookmarks.Item(i);
 ret = conins(ret, i, cBookmark.Name());
 }
 return ret;
}

Then you should be able to do something like this:

static void adbTestWordBookmarks(Args _args)
{
 MyMSWord  wd = new MyMSWord();
 CustTable   custTable;
 int n;
 ;

 //wd.Visible(1); // Make Word visible if desired. By default it's not

 while select custTable order by name
 {
 wd.documentAdd("C:\\Program Files\\Microsoft  
Office\\Templates\\1033\\Professional Fax.dot") // Create new  
document
 wd.bookmarkText("Cc", "Tech. dep.");   // Bookmark
 wd.bookmarkText("Company", "Acme");// Company
 wd.bookmarkText("Fax", custTable.TeleFax); // Fax (number)
 wd.bookmarkText("From", "Hal");// From
 wd.bookmarkText("Pages", "1"); // Pages, could be 
obtained from  
Document object
 wd.bookmarkText("Subject", "Fax from Axapta"); // Subject
 wd.bookmarkText("To", custTable.Name); // To
 wd.documentSave(strfmt("Fax to customer %1.doc",  
custTable.AccountNum)); //or wd.documentPrint(...);
 wd.documentClose();
 }
}

Looking at the vba code generated by the macro recorder in MSWord is quite  
useful for figuring out how to do a specific task.
The vba code from MSWord can then easily be ported to Axapta.

Hope this helps.

Amund

Wed, 25 Aug 2004 17:02:34 +0200 skrev Harry Nilsen <[EMAIL PROTECTED]>:

> Hi!
>
>
>
> I have to create a Word document based on a Word template with bookmarks
> from code using data from a table in Axapta.
>
>
>
> Does someone have an example of code which could help me out ?
>
>
>
> Regards,
>
> Harry
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.






 Yahoo! Groups Sponsor ~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

[development-axapta] Query with join in X++ code

[smeagul2303]

Hi,

I have headdata (Table head) and linedata (table line).
Instead of showing all headdata and selecting linedata,
I want to show all linedata and select the corresponding headdata.
This works fine, I have joined headdatasource to linedata.

My problem concerns the filter on my headdata.
To evaluate the filter in headdata_ds.executeQuery is not the 
right place. The query to search for linedata has to be a join
on headdata. The filter values have to be put in this join query.
So I create a query with a childDatasource.

This is code in linedata_ds.init()
public void init()
{

    super();
    
   .

   headQBD = this.query().dataSourceNo(1).addDataS
ource(tablenum(HEAD));

   headQBD.LinkFields( "LinkField-Head", "LinkField-Line" );
   headQBD.joinMode(JoinMode::InnerJoin);
   filterHead =  headQBD.addRange(fieldNum(HEAD, filterfield));

}

and now linedata_ds.executeQuery :
public void executeQuery()
{
 
    if(formControl.selection() !=0 )
    filterHead.value(int2str(formControl.selection()));
 
    else
    filterHead.value('');

  
    super();
}

FormControl modified - event calls linedata_ds.executeQuery.
The filter has no effect on the selection of linedata.
Does anyone know why ?

Is there any example in Axapta which hits my problem ?


Regards 

Manfred











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] How to show container content in the grid

[Baran Sasmaz]

Hi,
 
I have problems while showing the content of the container in the grid.
My datasource has two field. First field is the id of type string and the second of type container. 
When I add the field of type container to the grid, grid size changes and the content of the container cant be shown. 
 
I need your help.
How can i do this?
 
Thanx in advance.
 
Baran.

    
-
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!

[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Strange records in table CustInvoiceJour

[Steve Wright]

Hi Jens
 
Theses are from AR Free Text Invoices.
 
I beleive CustInvoiceTable is used to store the Free Text Header.  When you
post the invoice the header is copied to CustInvoiceJour.
 
Regards,
steve

  _  

From: Jens Strandberg [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 26 August 2004 2:47 PM
To: [EMAIL PROTECTED] Com (E-mail)
Subject: [development-axapta] Strange records in table CustInvoiceJour


Hello there,

I have come across some strange records in table CustInvoiceJour. These are
without SalesId, Qty, InvoiceID, LedgerVoucher and with Updated not checked.
Also, Refnum is set to "Customer".

I am only able to track these records ind Table Browser; not elsewhere
(probably my skills are just limited...)

Do you know where the records come from ?

The reason for asking is that the invoice journal and invoice turnover
report show these figures, and since they are not related to any sales
orders, I am worried. In one case we have 3 identical records in
CustInvoiceJour with the same date, customer, invoiceamount etc., i.e. 3 X
USD 10,000 and one record with salesID, i.e. 1 X USD 10,000. The above
reports then show a total of USD 40,000.

Also - in the above example - we have only one corresponding record in
CustInvoiceTrans.

Any input will be greatly appreciated. Thanks in advance !


Best Regards,
Jens




Yahoo! Groups Sponsor  

ADVERTISEMENT
 
 click here  
 
   

  _  

Yahoo! Groups Links


*  To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
 
  

*  To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
 
  

*  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
 . 




[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Tax Codes

[James Flavell]

Is the vendor havnig a branch/.office in each city, if so why not create
avendor for each and invocie accoutn can all point to one vendor.

If vendor only ahs one office but delviers to all the cities etc then you
can look at the address table, you can setup axapta to have a tax code for
each address (sorry cant rememebr if there is a parameter setting but I
think if you fill in the tax code on the address it will take it)
  -Original Message-
  From: hildacabrejos [mailto:[EMAIL PROTECTED]
  Sent: 26 August 2004 07:01
  To: [EMAIL PROTECTED]
  Subject: [development-axapta] Tax Codes


  Hello
  I have a very big problem, I think.   In our company we are just
  starting to work with AXAPTA and we have a doubt.  We have 18 branch
  offices and each office can buy items.  This means we have a vendor
  for 1 or many branch offices.  How do we create a sales tax group for
  this vendor if we have diferent taxes for each city.

  Example:
  Vendor xx has the standard sales tax group
  Item yy has a standard item sales tax group

  In this point there is no trouble if we buy an item in one city, the
  tax codes that match will be registered.

  But if we buy to the same vendor in diferent cities, that have a
  diferent porcent for the same tax code, we have a problem, because a
  vendor can only have one tax group and the city determines de amount
  of tax that we have to charge.

  Example:
  Tax zz  in Medellin = 6%, Itagui= 10% and so on.

  What can we do?..

  Thank you
  Hilda Cabrejos
  Transportes Botero Soto
  Colombia




    Yahoo! Groups Sponsor
  ADVERTISEMENT






--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Strange records in table CustInvoiceJour

[lho]

Perhaps from free text journal.
 
// Lars
 
 

-Original Message-
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent: 26. august 2004 08:47
To: [EMAIL PROTECTED] Com (E-mail)
Subject: [development-axapta] Strange records in table CustInvoiceJour


Hello there,

I have come across some strange records in table CustInvoiceJour. These are
without SalesId, Qty, InvoiceID, LedgerVoucher and with Updated not checked.
Also, Refnum is set to "Customer".

I am only able to track these records ind Table Browser; not elsewhere
(probably my skills are just limited...)

Do you know where the records come from ?

The reason for asking is that the invoice journal and invoice turnover
report show these figures, and since they are not related to any sales
orders, I am worried. In one case we have 3 identical records in
CustInvoiceJour with the same date, customer, invoiceamount etc., i.e. 3 X
USD 10,000 and one record with salesID, i.e. 1 X USD 10,000. The above
reports then show a total of USD 40,000.

Also - in the above example - we have only one corresponding record in
CustInvoiceTrans.

Any input will be greatly appreciated. Thanks in advance !


Best Regards,
Jens




Yahoo! Groups Sponsor  

ADVERTISEMENT
  click here  
     


  _  

Yahoo! Groups Links


*  To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/  
  

*  To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]  
  

*  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service  . 




[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] is there any where to check that a dimension value on inventorytrans

[Girish Bhatkal]

Hi James,

if you for these transactions financial postings are also activated. then
you can go to that posting account (from inventory postings form). now go to
chart of account , select the account and then go to the dimension tab and
select the mandatory dimension/ "To be filled in"


 -Original Message-
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 02:36
To: [EMAIL PROTECTED]
Subject: [development-axapta] is there any where to check that a dimension
value on inventorytrans


  I hope someone can help me,

  Whenever an inventtrans is created/updated etc I want to check that one of
  the dimensions is set.  This is because I have created an inventory
movement
  report that assumes the dimension is always set but I dont want to have to
  go round every place in the system and put mandatory/checks as this will
  take forever, so I am hoping there is on place I can catch this.  If the
  dimension is blank I would want to give an error and abort the operation
the
  user was doing.

  If I was to put such checking in the validatewrite of the inventtrans I am
  not confident as I think it maybe too late as I know there are a lot of
  processing that is done before inventtrans is finally updated...


  Thanks
  James

    -Original Message-
    From: Theissen, Annette [mailto:[EMAIL PROTECTED]
    Sent: 25 August 2004 23:50
    To: '[EMAIL PROTECTED]'
    Subject: AW: [development-axapta] Rows in a select


    Try this:

   InventTrans inventtrans;
   ;
   select count(RecID) from inventtrans where inventtras.transtype==3;
 info(int2str(inventTrans.RecID));

    The number of records is then stored in inventTrans.RecID.
    Also, please consider using enums instead of numbers. Here, you ought to
    write InventTransType::Purch instead of 3. It makes the code a lotmore
    readable!

    Hope this helps!

    Annette


    Mit freundlichen Grüßen / Best regards
    Dipl. Phys. Annette Theißen
    System Software Entwicklung
    __
    Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 Hannover
    Phone: +49/511/94996-0 - Fax: +49/511/94996-900
    mailto:[EMAIL PROTECTED]   -
    http://www.viscom.de 

    -Ursprüngliche Nachricht-
    Von: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED]
    Gesendet: Mittwoch, 25. August 2004 16:40
    An: 'Development-Axapta (E-mail)
    Betreff: [development-axapta] Rows in a select


    Hi,
    How can i know in a 'select' the number of registers returned?
    For example,
    Code:
  InventTrans inventtrans;
  ;
    select inventtrans where inventtras.transtype==3;
  I need to know the number of registers.

    Thanks


    Yahoo! Groups Sponsor

    ADVERTISEMENT



 click here






  _

    Yahoo! Groups Links


    *  To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/
    


    *  To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]





    *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
     .




    [Non-text portions of this message have been removed]


  Yahoo! Groups Sponsor
    ADVERTISEMENT





  --
--
  --
    Yahoo! Groups Links

  a.. To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/

  b.. To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

  c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



  [Non-text portions of this message have been removed]



    Yahoo! Groups Sponsor
  ADVERTISEMENT






--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Refresh Form

[Alfonso Collados Arroyo]

Hi,
I need to refresh a form after an operation.
How can I do this?

Thanks










Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Strange records in table CustInvoiceJour

[James Flavell]

I am not sure but are those not updated Free text invoice records???
  -Original Message-
  From: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Sent: 26 August 2004 15:47
  To: [EMAIL PROTECTED] Com (E-mail)
  Subject: [development-axapta] Strange records in table CustInvoiceJour


  Hello there,

  I have come across some strange records in table CustInvoiceJour. These
are
  without SalesId, Qty, InvoiceID, LedgerVoucher and with Updated not
checked.
  Also, Refnum is set to "Customer".

  I am only able to track these records ind Table Browser; not elsewhere
  (probably my skills are just limited...)

  Do you know where the records come from ?

  The reason for asking is that the invoice journal and invoice turnover
  report show these figures, and since they are not related to any sales
  orders, I am worried. In one case we have 3 identical records in
  CustInvoiceJour with the same date, customer, invoiceamount etc., i.e. 3 X
  USD 10,000 and one record with salesID, i.e. 1 X USD 10,000. The above
  reports then show a total of USD 40,000.

  Also - in the above example - we have only one corresponding record in
  CustInvoiceTrans.

  Any input will be greatly appreciated. Thanks in advance !


  Best Regards,
  Jens



    Yahoo! Groups Sponsor
  ADVERTISEMENT






--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Looking for eGraph module for Axapta

[hoffmanc2003]

Hi All,

eGraph is a MBS Partner module by MPS Graphics for Axapta that 
provides an administrative environment for the graphical print 
industry.

I am looking for anyone that has deployed, enhanced, or used the 
eGraph modules.

Please contact me at;   c.hoffmann @ cqu.edu.au

Chris.












Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Web Service/XML

[rama rama]

Try this code, that work for me... and look at the end of the Web Address.

real ObtenerTipoCambio(date fecha)
{
    str sfecha;
    real ntipocambio = -1;
    WebService ws;
    ;
    try
    {
    sfecha = date2str(fecha, 321, 2, 3, 2, 3, 4);
    ws = new 
WebService("http://crux.bccr.fi.cr/bccr/TipoCambio.asmx?wsdl");
    ntipocambio = ws.getTipoCambioVentaHistorico("Ricoh Lanier de Costa 
Rica", sfecha);
    }
    catch
    {
    ntipocambio = -1;
    }
    return ntipocambio;
}

Regards,
RM.





De: gonzalo_edo [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 25 de Agosto de 2004 10:14 a.m.
Para: [EMAIL PROTECTED]
Asunto: [development-axapta] Web Service/XML


I execute the code to connect to an Web Service and this error is
returned:

Method 'MSSoapInit' in COM object of class 'MSSOAP.SoapClient'
returned error code 0x80020009 (DISP_E_EXCEPTION) which means:
WSDLReader:Loading of the WSDL file failed HRESULT=0x80070057 -
WSDLReader:XML Parser failed at linenumber 62, lineposition 19,
reason is: End tag 'span' does not match the start tag 'br'.
HRESULT=0x1.


This is the code I'm using:

str 3   user= 'GBS';
    COM soapClient = new COM("MSSOAP.SoapClient");
WebService w = new WebService
("http://crux.bccr.fi.cr/bccr/TipoCambio.asmx");
    print w.getTipoCambioVenta(user);
    pause;

What am I doing wrong??

Does Axapta don't support .asmx Web Services??

I hope anybody has a solution to this...

_
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.latam.msn.com/











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] select and query

[Cenk Ince]

Hi all;

I have a sql statement like "Select inventtable where
inventtable.itemid=="123645" join ..

I have a query and i want "select" statement to fill query, but sql
statement is dynamic that, each time i get "select", it works on
different tables. 

Note : "Select" statement is in Axapta format, i mean it's not transact
sql or ANSI SQL.


Thanks...













Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] is there any where to check that a dimension value on inventorytrans

[James Flavell]

I hope someone can help me,

Whenever an inventtrans is created/updated etc I want to check that one of
the dimensions is set.  This is because I have created an inventory movement
report that assumes the dimension is always set but I dont want to have to
go round every place in the system and put mandatory/checks as this will
take forever, so I am hoping there is on place I can catch this.  If the
dimension is blank I would want to give an error and abort the operation the
user was doing.

If I was to put such checking in the validatewrite of the inventtrans I am
not confident as I think it maybe too late as I know there are a lot of
processing that is done before inventtrans is finally updated...


Thanks
James

  -Original Message-
  From: Theissen, Annette [mailto:[EMAIL PROTECTED]
  Sent: 25 August 2004 23:50
  To: '[EMAIL PROTECTED]'
  Subject: AW: [development-axapta] Rows in a select


  Try this:

 InventTrans inventtrans;
 ;
 select count(RecID) from inventtrans where inventtras.transtype==3;
   info(int2str(inventTrans.RecID));

  The number of records is then stored in inventTrans.RecID.
  Also, please consider using enums instead of numbers. Here, you ought to
  write InventTransType::Purch instead of 3. It makes the code a lotmore
  readable!

  Hope this helps!

  Annette


  Mit freundlichen Grüßen / Best regards
  Dipl. Phys. Annette Theißen
  System Software Entwicklung
  __
  Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 Hannover
  Phone: +49/511/94996-0 - Fax: +49/511/94996-900
  mailto:[EMAIL PROTECTED]   -
  http://www.viscom.de 

  -Ursprüngliche Nachricht-
  Von: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED]
  Gesendet: Mittwoch, 25. August 2004 16:40
  An: 'Development-Axapta (E-mail)
  Betreff: [development-axapta] Rows in a select


  Hi,
  How can i know in a 'select' the number of registers returned?
  For example,
  Code:
    InventTrans inventtrans;
    ;
  select inventtrans where inventtras.transtype==3;
    I need to know the number of registers.

  Thanks


  Yahoo! Groups Sponsor

  ADVERTISEMENT


 click here





    _

  Yahoo! Groups Links


  *  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
  


  *  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]




  *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
   .




  [Non-text portions of this message have been removed]


    Yahoo! Groups Sponsor
  ADVERTISEMENT






--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Strange records in table CustInvoiceJour

[Jens Strandberg]

Hello there,

I have come across some strange records in table CustInvoiceJour. These are
without SalesId, Qty, InvoiceID, LedgerVoucher and with Updated not checked.
Also, Refnum is set to "Customer".

I am only able to track these records ind Table Browser; not elsewhere
(probably my skills are just limited...)

Do you know where the records come from ?

The reason for asking is that the invoice journal and invoice turnover
report show these figures, and since they are not related to any sales
orders, I am worried. In one case we have 3 identical records in
CustInvoiceJour with the same date, customer, invoiceamount etc., i.e. 3 X
USD 10,000 and one record with salesID, i.e. 1 X USD 10,000. The above
reports then show a total of USD 40,000.

Also - in the above example - we have only one corresponding record in
CustInvoiceTrans.

Any input will be greatly appreciated. Thanks in advance !


Best Regards,
Jens











Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Tax Codes

[hildacabrejos]

Hello 
I have a very big problem, I think.   In our company we are just 
starting to work with AXAPTA and we have a doubt.  We have 18 branch 
offices and each office can buy items.  This means we have a vendor 
for 1 or many branch offices.  How do we create a sales tax group for 
this vendor if we have diferent taxes for each city.

Example:
Vendor xx has the standard sales tax group
Item yy has a standard item sales tax group

In this point there is no trouble if we buy an item in one city, the 
tax codes that match will be registered.

But if we buy to the same vendor in diferent cities, that have a 
diferent porcent for the same tax code, we have a problem, because a 
vendor can only have one tax group and the city determines de amount 
of tax that we have to charge.

Example:
Tax zz  in Medellin = 6%, Itagui= 10% and so on.

What can we do?..

Thank you
Hilda Cabrejos
Transportes Botero Soto
Colombia












Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.