Re: [development-axapta] Axapta Lockups

[Jens Strandberg]

Martin,

A couple of pointers:

Are your routing information correct, i.e. are you working with converted
data ? This could be a problem (have faced that ourselves)

Frequent lockups on item numbers could indicate an index problem. Have you
ever re-indexed your database - and if so: how often ?

If you are running Oracle: Are your statistics up-to-date ?

/Jens





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   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] Addition of new field in custtable and salestable

[Jens Strandberg]

Hi,

Take a look at the class SalesLineType. This should give you an idea.

/Jens

-Oprindelig meddelelse-
Fra: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] vegne af maltmega
Sendt: 30. januar 2006 15:30
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Addition of new field in custtable and
salestable


Hi,

I have created a new field called RPD in custtable and salestable of
stringedit type. This field is an additional identificaton for the
customer and dont have any other impact.

The values for RPD in cust table will be unique.

I want the RPD field to be there in SalesForm header and sales line
and to be saved in salestable and salesline.

I have included that in the design in sales header and salesline.

When i create a new sales order how can i get value for RPD from
custtable for the corresponding customer and display in salesform
header and salesline.

In which forms, classes, i have to make changes.


Regards,

Malters.









Yahoo! Groups Links














  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

SV: [development-axapta] Development IV

[Jens Strandberg]

Change to

    ItemId strItemId;
    ;
    ret = super();

    strItemId = hndItemId.toString();
    select firstonly SalesTable where SalesTable.SalesId == strItemId;

/Jens
-Oprindelig meddelelse-
Fra: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] vegne af jetjockey.geo
Sendt: 22. januar 2006 04:05
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Development IV



 Hi guys,

I'm working towards the development cerification. My company has given
me the MBS Axapta 3.0 training manuals and I'm trying to create the
POS application in ch 1. If anyone can point me to a copy of
ax30_enit_deviv_02.xpo, which I haven't received, that would be ideal.
Failing that, I'm tring to retrieve a record from a table when the
Sales ID is entered, with the following code in the Leave() function
of the StringEdit control:

    str strItemId;
    ;
    ret = super();

    strItemId = hndItemId.toString();
    select firstonly SalesTable where SalesTable.SalesId == strItemId;

which generates an error:

Container and unbounded string (text) fields are not allowed in a
WHERE _expression_.

I've tried various other methods, too but can't make anything work.
Any suggestions about how to do this would be appreciated.

 Thanks,

   Gary.








Yahoo! Groups Links
















  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   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] Data conversion: Batches for sales line

[Jens Strandberg]

Hi there,

Well, we have done quite the same thing recently - except that we did not
put batch numbers on sales lines. Instead, we put batch numbers on purchase
lines and inventory.

You need to put the batch number in sales line, as you points out. In
addition, all the batch numbers need to be added to table InventBatch.

But - the tricky part is, that you cannot put batch numbers on sales line,
purch line, inventory etc. in a straight-forward way. You need to build a
set of InventDim's, which will point to the combinations of
inventitemlocation, batch numbers etc.

This is very critical, since Axapta only knows a batchnumber by it's
InventDim.

Does this make sense to you ?

/Jens
  -Oprindelig meddelelse-
  Fra: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] vegne af bbfen
  Sendt: 13. juli 2005 20:22
  Til: development-axapta@yahoogroups.com
  Emne: [development-axapta] Data conversion: Batches for sales line


  hi,

  Has anyone done this before?

  We are converting open sales order from old system into Axapta. For a
  sales line, there can more than one batches for it. Besides salesLine
  table, what other tables need to be populated in order to have the
  batches information also imported?

  thanks.








--
  YAHOO! GROUPS LINKS

    a..  Visit your group "development-axapta" on the web.

    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 LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

SV: [development-axapta] Base Enums

[Jens Strandberg]

Hi Chris,

You simply change the value of the first element to anything but "0"...

/Jens
  -Oprindelig meddelelse-
  Fra: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] vegne af leganchris
  Sendt: 13. juli 2005 15:00
  Til: development-axapta@yahoogroups.com
  Emne: [development-axapta] Base Enums


  I have created a new Base enum and would like for it not to default to
  the first element. Whenever you create a new field in the the form it
  automatically fills in the base enum field with the first element. I
  would like for it to be blank and let the user hit the drop down and
  select which enum to accept.

  Any Ideas?

  Thanks,

  Chris





--
  YAHOO! GROUPS LINKS

    a..  Visit your group "development-axapta" on the web.

    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 LINKS



   Visit your group "development-axapta" on the web. 
   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] Label Files

[Jens Strandberg]

Hello there,
 
We use one label file per developer. That way we will not face similar
problems.
 
/Jens

-Oprindelig meddelelse-
Fra: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] vegne af Tony Depalo
Sendt: 11. juli 2005 08:03
Til: development-axapta@yahoogroups.com
Emne: RE: [development-axapta] Label Files


Hi 

Another question regarding Label Files.  Is anyone in an environment
where there are several developers and want to create labels in the same
label file?..  We have found that the last developer to exit Axapta
overwrites the new label created by other developers.

Thanks

Tony







From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Karsten
Wollesen
Sent: Monday, 11 July 2005 3:37 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Label Files



Hi,

You could try flushing your label files to file.

*  Exit all clients
*  Stop the AOS if you have one running
*  Delete all files named *.ali in the application folder
*  Startup Axapta in 2-tier mode
*  Startup the label editor (this will re-generate alle til label
index files)

Now your labels should be visible.

Regards,

Karsten Wollesen Clausen
Thy Data Center Development A/S


From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of leganchris
Sent: 11. juli 2005 02:21
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Label Files

I have created a new table with and added some new labels for my 
fields. On some of the fields new and old the labels look 
this '@GLS8979' and so on. I have tried recompiling the application, 
but that did not help. Any suggestions?

Thanks








YAHOO! GROUPS LINKS 

*  Visit your group "development-axapta
< http://groups.yahoo.com/group/development-axapta
 > " on the web.
    
*  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 < http://docs.yahoo.com/info/terms/
 > . 





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






YAHOO! GROUPS LINKS 



*  Visit your group "development-axapta
< http://groups.yahoo.com/group/development-axapta
 > " on the web.
    
*  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 < http://docs.yahoo.com/info/terms/
 > . 







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



  _  

YAHOO! GROUPS LINKS 


  
*   Visit your group " development-axapta
 " on the web.
  

*   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 LINKS



   Visit your group "development-axapta" on the web. 
   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] Converting journal information from an external database.

[Jens Strandberg]

Hello there,

I am currently converting data from an old system to Axapta 3.0.

I was wondering if there would be any problem importing "old" journals into
Axapta for look-up purposes ? Would this trigger some un-intentional side
effects ?

I am thinking about customer delivery notes and invoices.

Best Regards,
Jens












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] Search for CustVendExternalItem in form InventTable

[Jens Strandberg]

Hello there,

Ax 3.0 SP 3

I would like to add a feature to the InventTable form, so that I would be
able to search for certain information in CustVendExternalItem, join this
information with the corresponding InventTable records and present the
InventTable records in the "normal" InventTable form.

I am looking for a generic way to accomplish this in order to be able to
expand the search facilities to other, related tables, e.g. InventTxt.

What would be the best solution ?

Thanks in advance !

Best Regards,
Jens













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] Help on method BOM.InitFromInventTable

[Jens Strandberg]

Hello there,

It seems to me that standard Axapta (3.0 SP3) does not consider
InventTable.InventLocationId, when you are adding a new BOM line.

Extract from the code:

    inventDim.configId  = inventTable.standardConfigId;
    inventDim.InventSizeId  = inventTable.StandardInventSizeId;
    inventDim.InventColorId = inventTable.StandardInventColorId;
    // My addition BEGIN
    inventDim.InventLocationId  =
inventTableModule::find(this.ItemId,ModuleInventPurchSales::Invent).InventLo
cationId;
    // My addition END

    this.InventDimId    =
inventDim::findOrCreate(inventDim).inventDimId;


Axapta will find the correct InventDimId (shown by
box::info(this.inventdimId); ), but it is not displayed in the form.

What am I missing ?

Thanks in advance !!

Best Regards,

Jens













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] Rename dimensions [further info]

[Jens Strandberg]

Hi William,

Thanks for your offer; that would be nice to see how it is done.

I am looking forward to hearing from you.

/Jens
  -Oprindelig meddelelse-
  Fra: William S. Jacobsen [mailto:[EMAIL PROTECTED]
  Sendt: 14. april 2005 10:07
  Til: development-axapta@yahoogroups.com
  Emne: RE: [development-axapta] Rename dimensions [further info]



  Hi

  I have made the code for renaming and merging Dimensions (ver 3.0) for a
  customer.

  It does not require much changes, but it is "brain-surgery", so you should
  be sure to do it all correct.

  I do not have the time now to find at send it, but if you want i will find
  it for you!



  Best regards
  WSJ Consult Aps.
  William S. Jacobsen
  Mailto:[EMAIL PROTECTED]
  Tlf.:   +45 48 22 49 22 / +45 40 54 42 25
  Fax:    +45 48 22 49 25

  Slangerupgade 79
  DK-3400 Hillerød
  http://www.wsj.dk <http://www.wsj.dk/>

  -Original Message-
  From: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED]
  Sent: 14. april 2005 03:32
  To: development-axapta@yahoogroups.com
  Subject: RE: [development-axapta] Rename dimensions [further info]



  hi

  It seems to be working for EDTs that do not have more than one member in
the
  array.

  Unfortunately Dimension has more than one member.

  does not help you I guess

  regards

  harry

  Jens Strandberg <[EMAIL PROTECTED]> wrote:

  Harry,

  I added the field Valid to Dimensions using the EDT "Valid".

  After this I went to the EDT "Dimension", Relations and added ad new
  "related field fixed" relation with this clause "1 == Dimensions.Valid".

  I then changed a few dimensions in order to make them "Valid".

  To my understanding, this should work. However, I still see all
Dimensions;
  valid and not so valid ... :-)

  What did I mess up ?

  Thanks in advance.

  /Jens
    -Oprindelig meddelelse-
    Fra: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED]
    Sendt: 13. april 2005 11:18
    Til: development-axapta@yahoogroups.com
    Emne: Re: [development-axapta] Rename dimensions [further info]



    hi Jens

    I assume that the reason why you want to delete dimensions is because u
  dont want them in lookup. If this is correct then add one more field
called
  valid on dimensions and use this field in defining the 'related field
fixed'
  relation with the extended data type. You achieve your purpose without
  having to delete the dimension values.

    regards

    harry

    Jens Strandberg <[EMAIL PROTECTED]> wrote:

    Hello there,

    Anyone out there who knows how to rename (or merge) dimensions ?

    I need to get rid of old dimensions that will not be used any more. If
  there
    is no way to rename/merge, would Axapta be angry, if I 1) pulled out the
    DeleteActions on table Dimensions, 2) deleted the dimensions and 3) put
in
    the DeleteActions again ?

    The consistency check would probably detect the missing dimensions, but
  they
    haven't been used for 3-4 years.

    Any thoughts or pointers on this ?

    Best Regards,
    Jens


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






    -
    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!?
    Yahoo! Small Business - Try our new resources site!

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






  --
--
  --
    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 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!?
  Tired of spam?  Yahoo! Mail has the best spam protection around
  http://mail.yahoo.com

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






    _

  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] Rename dimensions [further info]

[Jens Strandberg]

OK, Harry; thanks for your input anyway... :-)

/Jens
  -Oprindelig meddelelse-
  Fra: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED]
  Sendt: 14. april 2005 03:32
  Til: development-axapta@yahoogroups.com
  Emne: RE: [development-axapta] Rename dimensions [further info]



  hi

  It seems to be working for EDTs that do not have more than one member in
the array.

  Unfortunately Dimension has more than one member.

  does not help you I guess

  regards

  harry

  Jens Strandberg <[EMAIL PROTECTED]> wrote:

  Harry,

  I added the field Valid to Dimensions using the EDT "Valid".

  After this I went to the EDT "Dimension", Relations and added ad new
  "related field fixed" relation with this clause "1 == Dimensions.Valid".

  I then changed a few dimensions in order to make them "Valid".

  To my understanding, this should work. However, I still see all
Dimensions;
  valid and not so valid ... :-)

  What did I mess up ?

  Thanks in advance.

  /Jens
    -Oprindelig meddelelse-
    Fra: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED]
    Sendt: 13. april 2005 11:18
    Til: development-axapta@yahoogroups.com
    Emne: Re: [development-axapta] Rename dimensions [further info]



    hi Jens

    I assume that the reason why you want to delete dimensions is because u
  dont want them in lookup. If this is correct then add one more field
called
  valid on dimensions and use this field in defining the 'related field
fixed'
  relation with the extended data type. You achieve your purpose without
  having to delete the dimension values.

    regards

    harry

    Jens Strandberg <[EMAIL PROTECTED]> wrote:

    Hello there,

    Anyone out there who knows how to rename (or merge) dimensions ?

    I need to get rid of old dimensions that will not be used any more. If
  there
    is no way to rename/merge, would Axapta be angry, if I 1) pulled out the
    DeleteActions on table Dimensions, 2) deleted the dimensions and 3) put
in
    the DeleteActions again ?

    The consistency check would probably detect the missing dimensions, but
  they
    haven't been used for 3-4 years.

    Any thoughts or pointers on this ?

    Best Regards,
    Jens


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






    -
    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!?
    Yahoo! Small Business - Try our new resources site!

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






  --
--
  --
    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 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!?
  Tired of spam?  Yahoo! Mail has the best spam protection around
  http://mail.yahoo.com

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







--
  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 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] Rename dimensions [further info]

[Jens Strandberg]

Harry,

I added the field Valid to Dimensions using the EDT "Valid".

After this I went to the EDT "Dimension", Relations and added ad new
"related field fixed" relation with this clause "1 == Dimensions.Valid".

I then changed a few dimensions in order to make them "Valid".

To my understanding, this should work. However, I still see all Dimensions;
valid and not so valid ... :-)

What did I mess up ?

Thanks in advance.

/Jens
  -Oprindelig meddelelse-
  Fra: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED]
  Sendt: 13. april 2005 11:18
  Til: development-axapta@yahoogroups.com
  Emne: Re: [development-axapta] Rename dimensions [further info]



  hi Jens

  I assume that the reason why you want to delete dimensions is because u
dont want them in lookup. If this is correct then add one more field called
valid on dimensions and use this field in defining the 'related field fixed'
relation with the extended data type. You achieve your purpose without
having to delete the dimension values.

  regards

  harry

  Jens Strandberg <[EMAIL PROTECTED]> wrote:

  Hello there,

  Anyone out there who knows how to rename (or merge) dimensions ?

  I need to get rid of old dimensions that will not be used any more. If
there
  is no way to rename/merge, would Axapta be angry, if I 1) pulled out the
  DeleteActions on table Dimensions, 2) deleted the dimensions and 3) put in
  the DeleteActions again ?

  The consistency check would probably detect the missing dimensions, but
they
  haven't been used for 3-4 years.

  Any thoughts or pointers on this ?

  Best Regards,
  Jens


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






  -
  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!?
  Yahoo! Small Business - Try our new resources site!

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







--
  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 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] Rename dimensions [further info]

[Jens Strandberg]

Harry,

Very good suggestion, thanks !

I will investigate this further.

/Jens
  -Oprindelig meddelelse-
  Fra: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED]
  Sendt: 13. april 2005 11:18
  Til: development-axapta@yahoogroups.com
  Emne: Re: [development-axapta] Rename dimensions [further info]



  hi Jens

  I assume that the reason why you want to delete dimensions is because u
dont want them in lookup. If this is correct then add one more field called
valid on dimensions and use this field in defining the 'related field fixed'
relation with the extended data type. You achieve your purpose without
having to delete the dimension values.

  regards

  harry

  Jens Strandberg <[EMAIL PROTECTED]> wrote:

  Hello there,

  Anyone out there who knows how to rename (or merge) dimensions ?

  I need to get rid of old dimensions that will not be used any more. If
there
  is no way to rename/merge, would Axapta be angry, if I 1) pulled out the
  DeleteActions on table Dimensions, 2) deleted the dimensions and 3) put in
  the DeleteActions again ?

  The consistency check would probably detect the missing dimensions, but
they
  haven't been used for 3-4 years.

  Any thoughts or pointers on this ?

  Best Regards,
  Jens


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






  -
  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!?
  Yahoo! Small Business - Try our new resources site!

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







--
  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 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] Rename dimensions

[Jens Strandberg]

Thanks Jason,

My mistake. I was referring to the dimensions Department, Cost centre,
Purpose.

/Jens
  -Oprindelig meddelelse-
  Fra: Jason Dykeson [mailto:[EMAIL PROTECTED]
  Sendt: 13. april 2005 09:33
  Til: development-axapta@yahoogroups.com
  Emne: RE: [development-axapta] Rename dimensions



  Jens,

  I am not sure which dimensions you mean, but if you mean item dimensions
  then go to:

  Inventory Management/Set up/Dimensions/ Dimensions Groups
  At Item dimensions you can go to the last tab page.
  There you can rename Color and Size.

  Regards,

  JasonD

  -Oorspronkelijk bericht-
  Van: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Verzonden: woensdag 13 april 2005 8:00
  Aan: [EMAIL PROTECTED] Com (E-mail)
  Onderwerp: [development-axapta] Rename dimensions



  Hello there,

  Anyone out there who knows how to rename (or merge) dimensions ?

  Best Regards,
  Jens






  Yahoo! Groups Links















--
  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 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] Rename dimensions [further info]

[Jens Strandberg]

Hello there,

Anyone out there who knows how to rename (or merge) dimensions ?

I need to get rid of old dimensions that will not be used any more. If there
is no way to rename/merge, would Axapta be angry, if I 1) pulled out the
DeleteActions on table Dimensions, 2) deleted the dimensions and 3) put in
the DeleteActions again ?

The consistency check would probably detect the missing dimensions, but they
haven't been used for 3-4 years.

Any thoughts or pointers on this ?

Best Regards,
Jens


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













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] Rename dimensions

[Jens Strandberg]

Hello there,

Anyone out there who knows how to rename (or merge) dimensions ?

Best Regards,
Jens












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] Configuration - Coverage plan by dimension

[Jens Strandberg]

Hello there,

We are currently migrating to Axapta 3.0 SP3 from scratch. During our
implementation we go through a lot of interesting features; also some that
we would like to twist a little...

Some of our item numbers (item type = item) comes with a default
configuration. Let's say that we have "Item X", which exists as
configuration A and B.

Config A and B are interchangeable; i.e. if we cannot buy config A, we will
go for config B.

Now, in our BOM, we need 200 pcs of Item A, config A. The master scheduling
tells us to issue a purchase order, but for some reason we are not able to
buy config A, and therefore we buy config B.

Next, when we run our maste plan, we are still instructed to buy config A
and cancel the purchase order for config B.

I am looking for a way to convince Axapta, that config B is just as good as
config A. However, to the best of my knowledge, if an item belongs to a
dimension group, where "configuration" is active, Axapta will always keep a
coverage plan per dimension. You are not even able to change this setting -
which from a logical point of view is - logic ... :-)

Now, I was thinking: There must be a method somewhere in Axapta (InventDim,
InventDimParm, InventDimSetup etc.), where you can programatically change
this behaviour, so that coverage by dimension is overruled... (just as with
warehouse) ?

Has anyone faced similar challenges ?

Any input would be greatly appreciated. Thanks in advance !

Best Regards,
Jens













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] TransactTxt: NO ---> FormLetterRemarks

[Jens Strandberg]

Herbert,

Thanks for your answer.

Oops, I made a mistake. I was looking for a way to manipulate
FormLetterRemarks, not TransactTxt.

If you lookup Sales Ledger / Setup / Forms / Form notes you are able to
setup a text for each form that you choose.

Now let's say that I want to use the following text :

"This is line 1,
 this is line 2."

and I want to have line 1 displayed in bold, but not line 2.

Is this possible ? Are the any "formatting codes" that you could use, eg.
"This is line 1" ?

If not, any workarounds ?

Thanks in advance !

/Jens
  -Oprindelig meddelelse-
  Fra: Leberbauer, Herbert - News [mailto:[EMAIL PROTECTED]
  Sendt: 9. februar 2005 14:48
  Til: development-axapta@yahoogroups.com
  Emne: AW: [development-axapta] TransactTxt



  Hi Jens,

  I don't know which text-field you mean, but most of the text-fields in
  Axapta can only have ONE format, e.g. everything bold, or nothing.

  Herbert

  | -----Ursprüngliche Nachricht-
  | Von: Jens Strandberg [mailto:[EMAIL PROTECTED]
  | Gesendet: Mittwoch, 09. Februar 2005 14:22
  | An: [EMAIL PROTECTED] Com (E-mail)
  | Betreff: [development-axapta] TransactTxt
  |
  |
  |
  | Hello there,
  |
  | Is there any way to format the text in TransactTxt, e.g.
  | partially bold, partially Italics, the rest normal ?
  |
  | Ax 3.0 SP3
  |
  | Best Regards,
  |
  | Jens
  |
  |
  |
  |
  |
  |
  |
  | Yahoo! Groups Links
  |
  |
  |
  |
  |
  |
  |





    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] TransactTxt

[Jens Strandberg]

Hello there,

Is there any way to format the text in TransactTxt, e.g. partially bold,
partially Italics, the rest normal ?

Ax 3.0 SP3

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] Restricting the "Rename" option

[Jens Strandberg]

Hello there,

I was wondering where to restrict the "Rename" feature found in Record Info,
where you can rename the current key ?

We are sharing the table CustTable for a handful of companies, and I would
not like the user to accidentally rename a customer.

The rename feature is disabled (=gone) for users; any way to do the same for
other tables ?

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] Company Accounts using the same Number Sequence

[Jens Strandberg]

Hello there,

I have 4 company accounts (A,B,C,D) that will be sharing the same CustTable;
through a Table Collection and a virtual company account. I have several
other company accounts that will operate "normally".

Is there any way to setup a number sequence for CustTable; only to be used
by those companies attached to the virtual company account ?

If not, I would probably need to let Axapta figure out the highest number
used and then suggest this number + 1, right ?

Thanks in advance !

Ax 3.0, SP3

Best Regards,
Jens










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] Additional info on Purchase Orders

[Jens Strandberg]

Hello there,

I need to put information about Under-delivery and Over-delivery on each
printed purchline in the PurchPurchaseOrder report.

Since the tables VendPurchOrderJour / VendPurchOrderTrans do not contain
this information, initially stored in PurchLine, I am looking for the right
way to include this information.

Would you suggest:

a) to put the fields into VendPurchOrderJour / VendPurchOrderTrans, populate
these from PurchLine and then use these fields in the report ?
b) to create a method that will lookup the related PurchLine and retrieve
the information and then use this method in the report ?
c) something completely different :-)

Any input would be greatly appreciated. Thanks in advance !

Best Regards,

Jens













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.

SV: [development-axapta] Label File Updating

[Jens Strandberg]

Hello there,

Did you remember to restart the AOS after updating ?

To the best of my knowlege, changes to labels are only written to the label
file during AOS shutdown.

/Jens
  -Oprindelig meddelelse-
  Fra: pkpeterson652 [mailto:[EMAIL PROTECTED]
  Sendt: 4. januar 2005 16:40
  Til: development-axapta@yahoogroups.com
  Emne: [development-axapta] Label File Updating




  I have a client that is operating in a two-tier and three-tier
  environment with multiple languages. We have a custom label file
  that contains customer defined labels for reports. We seem to have a
  problem coordinating changes made to the custom label file between
  two-tier and three tier environments. The development activity is
  happening in a two-tier environment. When the labels are added to
  the label file and the report is changed to reference these labels
  everything seems to be OK in two tier. When a three-tier client runs
  the report with the new labels in it does not find the labels or the
  labels are totally missing from the label file after a while. I
  believe that there is some caching of the label file going on.
  1. Does anyone have a recommended procedure for updating custom
  label files?
  2. Can someone explain to me what caching is taking place?









--
  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 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] Display bug in Axapta Calendar ?

[Jens Strandberg]

Hello there,

I stumbled across some strange behavior in Axapta, and I was wondering if
there is a solution.

If you click on any date field, you are presented with a calendar displaying
current month. I have noticed that there is a week 53, but no week 1.
Instead, current week is displayed as week 2.

Where did week 1 go ?

Can you guys reproduce ?

The problem persists on our "live" system, our development system and our
test system; all individual installations. Also, I have the problem on my
local Axapta.

My Outlook displays week 1 just fine ...:-(

Axapta 3.0 SP3.

Best Regards,
Jens










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] Setting TitleField1 and TitleField2

[Jens Strandberg]

Hello there,

I am having some problems setting TitleFields in the table ConfigTable.

When in a Sales or Purchase Order, I would like to display ConfigId and
Name, when the user clicks on the Configuration field.

I have changed the TitleFields in ConfigTable to ConfigId and Name, but
Axapta will always use ItemId and ConfigId.

I have no problems in other tables, e.g. Warehouse.

Any input, known bugs ?

Any help would be greatly appreciated. Thanks in advance.

Axapta 3.0 SP3

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.

SV: [development-axapta] data import error

[Jens Strandberg]

Hi,

You will experience this if you are trying to import tables, that are shared
in your application. That could be the definition group itself.

/Jens
  -Oprindelig meddelelse-
  Fra: Danny Gaethofs [mailto:[EMAIL PROTECTED]
  Sendt: 7. december 2004 22:26
  Til: [EMAIL PROTECTED]
  Emne: [development-axapta] data import error




  Dear all,

  Running axapta 3.0 sp3.

  I have exported data import/export definitions from my development
  database.

  When importing my data import/export definition groups into a test
  database I get an error message. The message says "not enough rights
  to insert the data or the imported file only contains shared tables".

  When importing the dat/def-file using the import wizard it works
  fine.

  The problem I have is that it seems impossible now to import other
  data using the definition groups. I get the message New table are
  available which have not been included in your group XXX.

  I seem not be able to solve this. Whatever I try, created new
  company, use the admin login, ... It certainly will be a small thing
  that I am overlooking.

  Anyone aware of this problem and knows how to solve it?

  regards,
  Danny








    Yahoo! Groups Sponsor

    Get unlimited calls to

    U.S./Canada





--
  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] Decimal, delimiter problems on AOS

[Jens Strandberg]

A small misprint... :-)

Running AOS: Default display
Running AOS/Citrix: Default display
Running Axapta in 2-tier mode: Custom display
  -Oprindelig meddelelse-
  Fra: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Sendt: 6. december 2004 11:27
  Til: [EMAIL PROTECTED] Com (E-mail)
  Emne: [development-axapta] Decimal, delimiter problems on AOS



  Hello there,

  We are having some problems displaying numbers correctly.

  Default, Axapta would display one million as "1,000,000.00" (let's call
that
  default display)

  However, we need to switch "," and ".", so that "1.000.000,00" (let's call
  that custom display)

  The settings on the AOS server looks just fine, but still I am quite sure,
  that AOS is the problem.

  We are running Ax 3.0 SP3 on Oracle.

  Running AOS: Default display
  Running AOS/Citrix: Default display
  Running AOS in 2-tier mode: Custom display

  All above scenarios use the same client.

  If I run Axapta on SQL locally: Custom display

  Checking the settings on AOS (Control panel and AxConfig) reveals no
  difference from my "own", local setup.

  Any hints would 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] Decimal, delimiter problems on AOS

[Jens Strandberg]

Hello there,

We are having some problems displaying numbers correctly.

Default, Axapta would display one million as "1,000,000.00" (let's call that
default display)

However, we need to switch "," and ".", so that "1.000.000,00" (let's call
that custom display)

The settings on the AOS server looks just fine, but still I am quite sure,
that AOS is the problem.

We are running Ax 3.0 SP3 on Oracle.

Running AOS: Default display
Running AOS/Citrix: Default display
Running AOS in 2-tier mode: Custom display

All above scenarios use the same client.

If I run Axapta on SQL locally: Custom display

Checking the settings on AOS (Control panel and AxConfig) reveals no
difference from my "own", local setup.

Any hints would 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.

SV: [development-axapta] XP SP2

[Jens Strandberg]

Hello there,

I have had no problems with Axapta 3.0 SP3 on XP SP2...

/Jens
  -Oprindelig meddelelse-
  Fra: Don Price [mailto:[EMAIL PROTECTED]
  Sendt: 3. december 2004 14:49
  Til: [EMAIL PROTECTED]
  Emne: [development-axapta] XP SP2



  Hi,

    Does anyone know off-hand if XP SP2 crashes/breaks any versions of
  Axapta? Like 2.5 and 3.0 specifically.

    I'd like to put on my machine, but I can't take a risk of breaking my
  various copies of Axapta.

  Thanks,
  Don


  [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] Intrastat (probably DK only)

[Jens Strandberg]

Hello there,

Which Intrastat groupings should primarily be used in Axapta ?

SITC = Standard International Trade Classification
BEC = Broad Economic Categories

or something else ?

I trust that these values go into the Axapta table IntraStatItemCode ?

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.

SV: [development-axapta] Virtual Company Accounts

[Jens Strandberg]

Andreas,
 
Shared tables are - in my opinion at least - beneficial to the accounting
department, when you run centralized book-keeping for many companies. This
is the case here.
 
It would be nice sometimes to have features and setup's that _all_ users
will be happy about ... :-)
 
Best Regards,
Jens

-Oprindelig meddelelse-
Fra: Gahr, Andreas [mailto:[EMAIL PROTECTED]
Sendt: 25. november 2004 10:26
Til: [EMAIL PROTECTED]
Emne: AW: [development-axapta] Virtual Company Accounts



Hi Jens,

you could use record level security to filter the required custtable records
and use a dimension therefore. But what would be the benefit of the shared
table then?

Regards
Andreas Gahr

-Ursprüngliche Nachricht-
Von: Jens Strandberg [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 25. November 2004 10:03
An: [EMAIL PROTECTED]
Betreff: RE: [development-axapta] Virtual Company Accounts




Thanks for all the feedback regarding this issue.

Any "real life" experience with the fact that bringing many customers into
one shared table may confuse users ?

Example:

Company A: 25 customers
Company B: 800 customers
Company C: 175 customers

After putting these customers into a shared table, all companies will see
1.000 customers. I am quite sure that company A (previously with 25
customers) will see this new approach as very annoying. I am also quite sure
that this question will arise: "How can we see "our" customers only?".

Any hints as to accomplish this - apart from adding "Primary Company",
"Secondary Company" etc. in CustTable - or to add a new table, where we
"link" companies with customers - and use this for querying... ?

Thanks in advance !

Best Regards,
Jens
  -Oprindelig meddelelse-
  Fra: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Sendt: 24. november 2004 22:15
  Til: [EMAIL PROTECTED] Com (E-mail)
  Emne: [development-axapta] Virtual Company Accounts



  Hello there,

  Our Axapta installation holds 12 company accounts. We are in the process
of
  putting all our customers into one CustTable, and in doing so we will make
  use of "virtual company accounts".

  I have been testing the setup, and it works just fine.

  However, it seems that you can have - let's say 10 - company accounts
using
  CustTable as a shared table, while the last 2 can actually have their
"own"
  CustTable. I was pretty surprised that this was possible.

  I was under the influence that shared tables would cover ALL company
  accounts. Am I missing something here, or is it really possible to have
some
  company accounts share tables (e.g. CustTable), while others - in the same
  application - have their "own" (e.g. CustTable) ?

  If it is possible; should I be worried ?. :-)

  Running Axapta 3.0 SP3 on a central Oracle 9...

  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/
<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 Links













Yahoo! Groups Sponsor  

ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=129e5it54/M=298184.5639630.6699735.3001176/D=gr
oups/S=1705006764:HM/EXP=1101462704/A=2434971/R=0/SIG=11eeoolb0/*http://www.
netflix.com/Default?mqso=60185400> click here  
 
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
:HM/A=2434971/rand=902748923>   


  _  

Yahoo! Groups Links


*  To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<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
<http://docs.yahoo.com/info/terms/> . 




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










Yahoo! Groups Sponsor


  Get unlimited calls to 	U.S./Canada  












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] Virtual Company Accounts

[Jens Strandberg]

Thanks for all the feedback regarding this issue.

Any "real life" experience with the fact that bringing many customers into
one shared table may confuse users ?

Example:

Company A: 25 customers
Company B: 800 customers
Company C: 175 customers

After putting these customers into a shared table, all companies will see
1.000 customers. I am quite sure that company A (previously with 25
customers) will see this new approach as very annoying. I am also quite sure
that this question will arise: "How can we see "our" customers only?".

Any hints as to accomplish this - apart from adding "Primary Company",
"Secondary Company" etc. in CustTable - or to add a new table, where we
"link" companies with customers - and use this for querying... ?

Thanks in advance !

Best Regards,
Jens
  -Oprindelig meddelelse-
  Fra: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Sendt: 24. november 2004 22:15
  Til: [EMAIL PROTECTED] Com (E-mail)
  Emne: [development-axapta] Virtual Company Accounts



  Hello there,

  Our Axapta installation holds 12 company accounts. We are in the process
of
  putting all our customers into one CustTable, and in doing so we will make
  use of "virtual company accounts".

  I have been testing the setup, and it works just fine.

  However, it seems that you can have - let's say 10 - company accounts
using
  CustTable as a shared table, while the last 2 can actually have their
"own"
  CustTable. I was pretty surprised that this was possible.

  I was under the influence that shared tables would cover ALL company
  accounts. Am I missing something here, or is it really possible to have
some
  company accounts share tables (e.g. CustTable), while others - in the same
  application - have their "own" (e.g. CustTable) ?

  If it is possible; should I be worried ?. :-)

  Running Axapta 3.0 SP3 on a central Oracle 9...

  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] Virtual Company Accounts

[Jens Strandberg]

Hello there,

Our Axapta installation holds 12 company accounts. We are in the process of
putting all our customers into one CustTable, and in doing so we will make
use of "virtual company accounts".

I have been testing the setup, and it works just fine.

However, it seems that you can have - let's say 10 - company accounts using
CustTable as a shared table, while the last 2 can actually have their "own"
CustTable. I was pretty surprised that this was possible.

I was under the influence that shared tables would cover ALL company
accounts. Am I missing something here, or is it really possible to have some
company accounts share tables (e.g. CustTable), while others - in the same
application - have their "own" (e.g. CustTable) ?

If it is possible; should I be worried ?. :-)

Running Axapta 3.0 SP3 on a central Oracle 9...

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.

RE: [development-axapta] Joining two customers into one

[Jens Strandberg]

Danny,

I did some testing too, and it actually works just fine. All you have to do
is to customize the script, so that it will delete duplicate records.

This script worked for me:

static void mergeCustomers(Args _args)
{
    custAccount AccountRemove;
    custAccount AccountMerged;
    custTable   custSource;
    custTable   custMerged;
    SalesJournalAutoSummary SJAS;
    GatewayOrgRef   GOR;
    smmBusRelTable  SBRT;
    SalesPrintCopies    SPC;    // Added

    AccountRemove   = "AccountSource";
    AccountMerged   = "AccountDestination";

    ttsbegin;

    delete_from SJAS
    where SJAS.CustAccount == AccountRemove;

    delete_from GOR
    where GOR.RefType == SysActionRefTypes::Cust &&
  GOR.RefId   == AccountRemove;

    delete_from SBRT
    where SBRT.CustAccount == AccountRemove;

    delete_from SPC
    where SPC.CustAccount == AccountRemove;

    custSource  = CustTable::find(AccountRemove,true);
    custMerged = CustTable::find(AccountMerged,true);

    custSource.merge(custMerged);

    ttscommit;

}

/Jens
  -Oprindelig meddelelse-
  Fra: Danny Gaethofs [mailto:[EMAIL PROTECTED]
  Sendt: 18. november 2004 19:19
  Til: [EMAIL PROTECTED]
  Emne: RE: [development-axapta] Joining two customers into one



  Preston,

  After reading this discussion I did some test on the
  CustTable. I am working on a generic conversion tool
  in my spare time. The merge method could solve a few
  problems I encountered.

  I however have a question, if the merge method
  encounters duplicate records in one of the children it
  is trying to merge an error is thrown and the merge is
  aborted.

  This happens with the table SalesJournalAutoSummary in
  which records are created for each customer.

  How are you dealing with these duplicate records?
  I assume you have identified these situations and deal
  with them before executing the merge. Is that correct?


  regards,
  Danny Gaethofs


  --- "Preston A. Larimer" <[EMAIL PROTECTED]> wrote:

  >
  > Correct Jens, if you take the job as is and run it
  > on the demo data for two
  > customers you should see all transactions, Invoices,
  > picking list, sales
  > orders, etc. moved to the destination customer.  It
  > works well, MBS just
  > hasn't had the time to work out the logic for
  > cleaning up those tables where
  > a decision has to be made on records to discard and
  > keep in situations like
  > I mentioned earlier.
  >
  >
  >
  > -Preston
  >
  >
  >
  >   _
  >
  > From: Jens Strandberg [mailto:[EMAIL PROTECTED]
  > Sent: Thursday, November 18, 2004 6:37 AM
  > To: [EMAIL PROTECTED]
  > Subject: RE: [development-axapta] Joining two
  > customers into one
  >
  >
  >
  >
  > Preston,
  >
  > Thanks.
  >
  > Let me get this right: The merge method does it all,
  > i.e. handle CustTrans,
  > SalesOrders, CustInvoiceJour etc. etc. ?
  >
  > If this is the case it would be fairly simple, I
  > guess...
  >
  > /Jens
  >   -Oprindelig 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 on the website in use
  > at a client, and they use
  >   it to merge customers frequently,  the manual
  > processing only has to be
  > done
  >   on those tables where you would have to choose one
  > version over another,
  > for
  >   instance if you had an external price set for item
  > X on both customers,
  >   which one to keep, we usually choose to delete the
  > records for the
  > customer
  >   being merged so the external price for the merged
  > to customer would be the
  >   one kept.
  >
  >
  >
  >   -Preston
  >
  >
  >
  > _
  >
  >   From: Jens Strandberg [mailto:[EMAIL PROTECTED]
  >   Sent: Thursday, November 18, 2004 3:27 AM
  >   To: [EMAIL PROTECTED]
  >   Subject: SV: [development-axapta] Joining two
  > customers into one
  >
  >
  >
  >
  >   Preston,
  >
  >   Thanks for the direction. I guess the tricky part
  > is to include all
  >   references, when you do this (CustTrans,
  > CustInvoiceJour etc...)
  >
  >   If the "Rename" option was just enhanced a bit,
  > this would be the right
  >   approach.
  >
  >   /Jens
  >
  >
  > -Oprindelig meddelelse-
  > F

RE: [development-axapta] Joining two customers into one

[Jens Strandberg]

Preston,

Thanks.

Let me get this right: The merge method does it all, i.e. handle CustTrans,
SalesOrders, CustInvoiceJour etc. etc. ?

If this is the case it would be fairly simple, I guess...

/Jens
  -Oprindelig 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 on the website in use at a client, and they use
  it to merge customers frequently,  the manual processing only has to be
done
  on those tables where you would have to choose one version over another,
for
  instance if you had an external price set for item X on both customers,
  which one to keep, we usually choose to delete the records for the
customer
  being merged so the external price for the merged to customer would be the
  one kept.



  -Preston



    _

  From: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 18, 2004 3:27 AM
  To: [EMAIL PROTECTED]
  Subject: SV: [development-axapta] Joining two customers into one




  Preston,

  Thanks for the direction. I guess the tricky part is to include all
  references, when you do this (CustTrans, CustInvoiceJour etc...)

  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 is a basic job for doing this, it may need altered for the
    customer specific use, but should be a good starting point for you.

    -Preston



    http://www.axaptalink.com/index.php?option=content
    <http://www.axaptalink.com/index.php?option=content
  <http://www.axaptalink.com/index.php?option=content&task=view&id=52&task=v
>
  &task=view&id=52&task=v
  iew&id=52





  _

    From: Jens Strandberg [mailto:[EMAIL PROTECTED]
    Sent: Wednesday, November 17, 2004 3:18 PM
    To: [EMAIL PROTECTED] Com (E-mail)
    Subject: [development-axapta] Joining two customers into one





    As you probably know standard Axapta does not allow you to join two
  customer
    (or supplier) records; i.e. if you have added customer A and later on by
    mistake added the same information as customer P, you cannot combine
these
    two - moving all related records from customer P to customer A.

    The only option you have is to change the primary key for a given
  customer,
    which is not very useful in this case.

    As I see it, the only way to join two customers into one is to develop
  some
    piece of code that would do the trick for you.

    Now, it would be easy to create such a script, if we could just see how
  the
    changing of the primary key is done. However, this is hidden well inside
    Axapta.

    I was wondering if any of you guys would have some ideas and pointers to
    this issue. Also, if you happen to know a solution to solve this, this
  would
    be very interesting piece of information.

    Thanks in advance.

    /Jens









    Yahoo! Groups Sponsor



    ADVERTISEMENT

    <http://us.ard.yahoo.com/SIG=12909o10m/M=298184.5584357.6650215.3001176/
D=
  gr
    oups/S=1705006764:HM/EXP=1100812158/A=2434970/R=0/SIG=11edksnhv/*http:/w
ww
  .n
    etflix.com/Default?mqso=60185402> click here



    <http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=group
s/
  S=
    :HM/A=2434970/rand=450057254>



  _

    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!
    <http://docs.yahoo.com/info/terms/>  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

  <http://us.ard.yahoo.com/SIG=129qdli4k/M=298184.5584357.6650215.3001176/D=
gr
  oups/S=1705006764:HM/EXP=1100852883/A=2434970/R=0/SIG=11edksnhv/*http:/www
.n
  etflix.com/Default?mqso=60185402> click here



  <http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=g

RE: [development-axapta] Joining two customers into one

[Jens Strandberg]

Holger,

I agree that if you choose to do this manually, you should be a detective.

However, if you could just extend the "Rename" functionality, this could be
done easily.

I also agree that financial transactions may not be altered when posted.
However, as I see it you actually change the records even with a simple
"Rename".

I would not want to do this on database level only, since this would be a
source of errors. I spoke to a MBS project manager recently about this
issue, and the functionality of merging/joining two customers has actually
been on the to-do list for a long time. Unfortunately, the functionality has
been stripped from the various updates due to last minute changes - just as
in real life ... :-)

Given the fact that MBS has considered the functionality, I would suspect
that we are indeed allowed to merge customers; probably with some sort of
logging and/or auditing mechanism.

You have made me think twice ... :-)

/Jens
  -Oprindelig meddelelse-
  Fra: Holger K. Pedersen [mailto:[EMAIL PROTECTED]
  Sendt: 17. november 2004 22:56
  Til: [EMAIL PROTECTED]
  Emne: RE: [development-axapta] Joining two customers into one



  Making the change of all fields referencing the Account is fairly easy,
seen
  from the database point of view, but the business processes triggered by
  changes must also be complied. This is a detectives work to figure out.
This
  is probably the reason you can't do what you want, since nobody has spent
  the time to make it work. It would cost a fortune to do it completely.

  The financial transactions are not allowed to change when posted. The same
  considderations might apply to other tables as well.

  You can fake the data, going to the database level, doing some UPDATEs on
  the rows referencing the given AccountNum, but you should make sure, the
row
  is not used by other tables in the whole database.

  I don't think you should try to do it, unless you know exactly what
  consequences it has.

  I hope this makes you think twice... :o)


  >From: "Jens Strandberg" <[EMAIL PROTECTED]>
  >Reply-To: [EMAIL PROTECTED]
  >To: "[EMAIL PROTECTED] Com (E-mail)"
  ><[EMAIL PROTECTED]>
  >Subject: [development-axapta] Joining two customers into one
  >Date: Wed, 17 Nov 2004 21:18:28 +0100
  >
  >
  >
  >As you probably know standard Axapta does not allow you to join two
  >customer
  >(or supplier) records; i.e. if you have added customer A and later on by
  >mistake added the same information as customer P, you cannot combine
these
  >two - moving all related records from customer P to customer A.
  >
  >The only option you have is to change the primary key for a given
customer,
  >which is not very useful in this case.
  >
  >As I see it, the only way to join two customers into one is to develop
some
  >piece of code that would do the trick for you.
  >
  >Now, it would be easy to create such a script, if we could just see how
the
  >changing of the primary key is done. However, this is hidden well inside
  >Axapta.
  >
  >I was wondering if any of you guys would have some ideas and pointers to
  >this issue. Also, if you happen to know a solution to solve this, this
  >would
  >be very interesting piece of information.
  >
  >Thanks in advance.
  >
  >/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.

SV: [development-axapta] Joining two customers into one

[Jens Strandberg]

Preston,

Thanks for the direction. I guess the tricky part is to include all
references, when you do this (CustTrans, CustInvoiceJour etc...)

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 is a basic job for doing this, it may need altered for the
  customer specific use, but should be a good starting point for you.

  -Preston



  http://www.axaptalink.com/index.php?option=content
  <http://www.axaptalink.com/index.php?option=content&task=view&id=52&task=v
iew&id=52





    _

  From: Jens Strandberg [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, November 17, 2004 3:18 PM
  To: [EMAIL PROTECTED] Com (E-mail)
  Subject: [development-axapta] Joining two customers into one





  As you probably know standard Axapta does not allow you to join two
customer
  (or supplier) records; i.e. if you have added customer A and later on by
  mistake added the same information as customer P, you cannot combine these
  two - moving all related records from customer P to customer A.

  The only option you have is to change the primary key for a given
customer,
  which is not very useful in this case.

  As I see it, the only way to join two customers into one is to develop
some
  piece of code that would do the trick for you.

  Now, it would be easy to create such a script, if we could just see how
the
  changing of the primary key is done. However, this is hidden well inside
  Axapta.

  I was wondering if any of you guys would have some ideas and pointers to
  this issue. Also, if you happen to know a solution to solve this, this
would
  be very interesting piece of information.

  Thanks in advance.

  /Jens









  Yahoo! Groups Sponsor



  ADVERTISEMENT

  <http://us.ard.yahoo.com/SIG=12909o10m/M=298184.5584357.6650215.3001176/D=
gr
  oups/S=1705006764:HM/EXP=1100812158/A=2434970/R=0/SIG=11edksnhv/*http:/www
.n
  etflix.com/Default?mqso=60185402> click here



  <http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=groups/
S=
  :HM/A=2434970/rand=450057254>



    _

  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!
  <http://docs.yahoo.com/info/terms/>  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] Joining two customers into one

[Jens Strandberg]

James,

My thoughts exactly. It is the same approach that we use in our current
legacy system (developed in-house), so I have kind of figured that this
would be the way to go.

However, I was told that the "Rename" part is not available in any method,
but is hidden inside Axapta. This "show stopper" is very effective... :-(

/Jens
  -Oprindelig meddelelse-
  Fra: James Flavell [mailto:[EMAIL PROTECTED]
  Sendt: 18. november 2004 02:23
  Til: [EMAIL PROTECTED]
  Emne: RE: [development-axapta] Joining two customers into one



  How about using the same concept that is in the 'Rename' because I believe
  this uses the EDT to find every table and record in the database, just in
  your code delete the customer table record, the rest should be pretty much
  the same I would think.

  Never tried it but its an idea for you :)

    -Original Message-
    From: Jens Strandberg [mailto:[EMAIL PROTECTED]
    Sent: 18 November 2004 05:18
    To: [EMAIL PROTECTED] Com (E-mail)
    Subject: [development-axapta] Joining two customers into one




    As you probably know standard Axapta does not allow you to join two
  customer
    (or supplier) records; i.e. if you have added customer A and later on by
    mistake added the same information as customer P, you cannot combine
these
    two - moving all related records from customer P to customer A.

    The only option you have is to change the primary key for a given
  customer,
    which is not very useful in this case.

    As I see it, the only way to join two customers into one is to develop
  some
    piece of code that would do the trick for you.

    Now, it would be easy to create such a script, if we could just see how
  the
    changing of the primary key is done. However, this is hidden well inside
    Axapta.

    I was wondering if any of you guys would have some ideas and pointers to
    this issue. Also, if you happen to know a solution to solve this, this
  would
    be very interesting piece of information.

    Thanks in advance.

    /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

    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] Joining two customers into one

[Jens Strandberg]

As you probably know standard Axapta does not allow you to join two customer
(or supplier) records; i.e. if you have added customer A and later on by
mistake added the same information as customer P, you cannot combine these
two - moving all related records from customer P to customer A.

The only option you have is to change the primary key for a given customer,
which is not very useful in this case.

As I see it, the only way to join two customers into one is to develop some
piece of code that would do the trick for you.

Now, it would be easy to create such a script, if we could just see how the
changing of the primary key is done. However, this is hidden well inside
Axapta.

I was wondering if any of you guys would have some ideas and pointers to
this issue. Also, if you happen to know a solution to solve this, this would
be very interesting piece of information.

Thanks in advance.

/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] Report problem.

[Jens Strandberg]

Hello there,

I have this strange problem in some (simple) reports. Let's say that I wish
to list certain fields from table InventTrans. I would only be interested in
information from PO's.

I could then include physical date, transrefid (=PO number), qty etc. Also,
I would like to display the field PurchName from the PO. I then add
PurchTable as a new data source and setup the proper relations.

The problem: The FIRST line in the report does not display the PurchName
info. The rest of the lines display the value properly.

Any obvious pointers that I have missed ? Thanks in advance !

Best Regards,
/Jens













Yahoo! Groups Sponsor


  Get unlimited calls to 	U.S./Canada  












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.

SV: [development-axapta] Running Excel macros from Axapta through COM ?

[Jens Strandberg]

Thanks for your reply.

The Excel stuff is set up properly and works just fine, when I run the macro
inside Excel.

However, doing the "Run" on the COM object in Axapta tells me, that this
cannot be done... :-(

Any additional input ?

Best Regards,
Jens

-Oprindelig meddelelse-
Fra: Amund [mailto:[EMAIL PROTECTED]
Sendt: 16. september 2004 14:08
Til: [EMAIL PROTECTED]
Emne: Re: [development-axapta] Running Excel macros from Axapta through
COM ?


Inside VBA this would be something like: Application.Run
"Workbook.xls!Macroname"

 From Axapta you can use: .Run("Workbook.xls!Macroname");

In general you may do what you want inside the macro recorder in Excel (or
Word, or..) and use the resulting VBA-code almost as-is in Axapta.

Amund



Thu, 16 Sep 2004 13:50:36 +0200 skrev Jens Strandberg
<[EMAIL PROTECTED]>:

> Hello there,
>
> I am using COM to display data from Axapta in Excel. Is there a way to
> tell
> Excel to run a certain macro once the data has been moved to Excel ?
>
> 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.







Yahoo! Groups Links








 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] Running Excel macros from Axapta through COM ?

[Jens Strandberg]

Hello there,

I am using COM to display data from Axapta in Excel. Is there a way to tell
Excel to run a certain macro once the data has been moved to Excel ?

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.

SV: [development-axapta] Re: Strange records in table CustInvoiceJour

[Jens Strandberg]

Jaime,

Thank you very much for your valuable input.

/Jens
  -Oprindelig meddelelse-
  Fra: jaimesq [mailto:[EMAIL PROTECTED]
  Sendt: 30. august 2004 09:25
  Til: [EMAIL PROTECTED]
  Emne: [development-axapta] Re: Strange records in table CustInvoiceJour


  Hello:

  It is an error that has been corrected in sp3.

  This wrong invoices are Free Text Invoices.
  When you print a free text invoice not posted, a register is
  provisionaly created in CustInvoiceJour and then at end is deleted.
  But in your version (wrong) at end is not deleted.

  To correct it delete directly from CustInvoiceJour.

  Regards,
  Jaime


    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

[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


<http://us.ard.yahoo.com/SIG=129v40u2g/M=295196.4901138.6071305.3001176/D=gr

oups/S=1705006764:HM/EXP=1093592977/A=2128215/R=0/SIG=10se96mf6/*http://comp
  anion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
  :HM/A=2128215/rand=803094132>

    _

  Yahoo! Groups Links


  *  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
  <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
  <http://docs.yahoo.com/info/terms/> .




  [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.

SV: [development-axapta] Initial values in SalesLine.

[Jens Strandberg]

Girish,

Thanks for the clarification.

/Jens
  -Oprindelig meddelelse-
  Fra: Girish Bhatkal [mailto:[EMAIL PROTECTED]
  Sendt: 2. juli 2004 10:14
  Til: [EMAIL PROTECTED]
  Emne: RE: [development-axapta] Initial values in SalesLine.


  Hi Jens,

 All the methods in axapta are given an appropriate name and are
available
  in the appropriate place.

  In all the tables if you need to insert a list of field records from
another
  table then go to the table (in your case salesline) and then check for
  initfrom... here you have init methods for different tables and each are
  called in different cases. when the records from salesTable has to be
  inserted then it calls initfromSalesTable.
 similarly you can see such methods on other tables also like on
  salesTable you have initfromCustTable.
  So it is important that whenever you add or modify any method then
  add/modify in the appropriate method and appropriate place.

  cheers,
  Girish
    -Original Message-
    From: Jens Strandberg [mailto:[EMAIL PROTECTED]
    Sent: 02 July 2004 07:48
    To: [EMAIL PROTECTED] Com (E-mail)
    Subject: [development-axapta] Initial values in SalesLine.


    Hello there,

    Whenever you prepare a new SalesLine, certain values are copied from
    SalesTable to the SalesLine form, e.g. reservation, delivery date,
    over/underdelivery etc.

    This happens before the insert. However, I can't find the method that
does
    the trick  :-(

    Any suggestions ?

    Thanks in advance.

    Best Regards
    Jens Strandberg



  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] Initial values in SalesLine [NEVER MIND]...:-)

[Jens Strandberg]

Found it ! (Class SalesLineType.initFromSalesTable...)


Previous mail:

Hello there,

Whenever you prepare a new SalesLine, certain values are copied from
SalesTable to the SalesLine form, e.g. reservation, delivery date,
over/underdelivery etc.

This happens before the insert. However, I can't find the method that does
the trick  :-(

Any suggestions ?

Thanks in advance.

Best Regards
Jens Strandberg











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] Initial values in SalesLine.

[Jens Strandberg]

Hello there,

Whenever you prepare a new SalesLine, certain values are copied from
SalesTable to the SalesLine form, e.g. reservation, delivery date,
over/underdelivery etc.

This happens before the insert. However, I can't find the method that does
the trick  :-(

Any suggestions ?

Thanks in advance.

Best Regards
Jens Strandberg











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.

SV: [development-axapta] Decimals in Axapta

[Jens Strandberg]

James,

Thanks for your suggestion; it works just fine when putting data from
PriceDiscTable into SalesLine/PurchLine.

I have changed from 0. to 0.0001; that's it.

Still, doing a simple job multiplying two numbers will only display 2
decimals... :-(

/Jens
  -Oprindelig meddelelse-
  Fra: James Flavell [mailto:[EMAIL PROTECTED]
  Sendt: 30. juni 2004 02:37
  Til: [EMAIL PROTECTED]
  Emne: RE: [development-axapta] Decimals in Axapta


  Have you set the number of decimals to round to on the currency code? (I
  think you want 0.0001 and not the default 0.0100) as I guess this is
applied
  inside the priceDisc.price() 

    -Original Message-
    From: Jens Strandberg [mailto:[EMAIL PROTECTED]
    Sent: Wednesday, June 30, 2004 2:09 AM
    To: [EMAIL PROTECTED] Com (E-mail)
    Subject: [development-axapta] Decimals in Axapta


    Hello there,

    I am having some difficulties with decimals in Axapta.

    It seems that Axapta will always use 2 decimals - everywhere...

    A simple job like "(100 * 100.1)" will return a value of 10010.00; i.e.
2
    decimals. Similarly, if you multiply 2 4-decimal values, Axapta will
also
    return only 2 decimals.

    Another example:
    Take a look at the initFromPriceDisc method of the table SalesLine:

    void initFromPriceDisc(PriceDisc priceDisc)
    {
    ;
    this.salesPrice = priceDisc.price();
    this.priceUnit  = priceDisc.priceUnit();
    this.salesMarkup    = priceDisc.markup();
    this.confirmedDlv   = this.salesTable().deliveryDate;

    if (priceDisc.deliveryDays())
    this.confirmedDlv = max(systemdateGet() +
  priceDisc.deliveryDays(),
    this.confirmedDlv);
    }

    this.salesPrice will always return 2 decimals, even though I have
modified
    the EDT (actually created a new one that extends the original one) to
hold
  4
    decimals.

    If I - for testing purposes - change to "this.SalesPrice =
  4.5678;",
    this will return all 4 decimals.

    All I want is to have the unit prices in SalesLine and PurchLine reflect
  the
    relevant price in PriceDiscTable. Please note that all fields
(SalesPrice,
    PurchPrice etc.) have been setup to accept 4 decimals, but something
goes
    wrong in the above method.

    What am I missing here... ?

    Thanks in advance.

    Best Regards,
    Jens

    Ax_30_SP1



  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] Decimals in Axapta

[Jens Strandberg]

Hello there,

I am having some difficulties with decimals in Axapta.

It seems that Axapta will always use 2 decimals - everywhere...

A simple job like "(100 * 100.1)" will return a value of 10010.00; i.e. 2
decimals. Similarly, if you multiply 2 4-decimal values, Axapta will also
return only 2 decimals.

Another example:
Take a look at the initFromPriceDisc method of the table SalesLine:

void initFromPriceDisc(PriceDisc priceDisc)
{
    ;
    this.salesPrice = priceDisc.price();
    this.priceUnit  = priceDisc.priceUnit();
    this.salesMarkup    = priceDisc.markup();
    this.confirmedDlv   = this.salesTable().deliveryDate;

    if (priceDisc.deliveryDays())
    this.confirmedDlv = max(systemdateGet() + priceDisc.deliveryDays(),
this.confirmedDlv);
}

this.salesPrice will always return 2 decimals, even though I have modified
the EDT (actually created a new one that extends the original one) to hold 4
decimals.

If I - for testing purposes - change to "this.SalesPrice = 4.5678;",
this will return all 4 decimals.

All I want is to have the unit prices in SalesLine and PurchLine reflect the
relevant price in PriceDiscTable. Please note that all fields (SalesPrice,
PurchPrice etc.) have been setup to accept 4 decimals, but something goes
wrong in the above method.

What am I missing here... ?

Thanks in advance.

Best Regards,
Jens

Ax_30_SP1











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] SalesLine --> CustPackingSlipTrans (continued)...

[Jens Strandberg]

Hello there,

Thanks to everyone who has suggested a solution.

Putting code in the initFromSalesLine method in CustPackingSlipTrans works
fine.


Any hints on assuring that "MyField" is negative, when
SalesLine.SalesDeliverNow is negative, otherwise positive ?

--- apart from doing

this.MyField    = (salesline.MyField * (SalesLine.SalesDeliverNow /
abs(SalesLine.SalesDeliverNow)));

in the above method ?


Thanks in advance.

Best Regards,
Jens

 --- In [EMAIL PROTECTED], "Jens Strandberg"
<[EMAIL PROTECTED]> wrote:
> I have added a new field to table SalesLine, in which a value is
being
> entered prior to issuing a packing slip. The same field has been
added to
> CustPackingSlipTrans.
>
> Where do I arrange for CustPackingSlipTrans.MyField to be
populated by
> SalesLine.MyField ?
>
> Thanks in advance !
>
> /Jens



[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.

SV: [development-axapta] User modifications.

[Jens Strandberg]

Thanks :-)

-Oprindelig meddelelse-
Fra: Sergey Siroklin [mailto:[EMAIL PROTECTED]
Sendt: 24. juni 2004 10:04
Til: [EMAIL PROTECTED]
Emne: RE: [development-axapta] User modifications.


axusr.aod && axusp.aod 

  -Original Message- 
  From: Jens Strandberg [mailto:[EMAIL PROTECTED] 
  Sent: Thu 24.06.2004 11:30 
  To: [EMAIL PROTECTED] Com (E-mail) 
  Cc: 
  Subject: [development-axapta] User modifications. 
  
  

  Hello there, 
  
  In which files are user modifications stored in Axapta ? 
  
  I am thinking of modifications of forms (adding new fields, hiding
existing 
  ones, moving fields etc.) 
  
  Thanks in advance.. 
  
  Best Regards, 
  Jens 
  
  
  
  
   Yahoo! Groups Sponsor
  
  
  Yahoo! Groups Links 
  
  
  
  
  
  



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




Yahoo! Groups Sponsor  

ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=1298fb9la/M=298184.5022502.6152625.3001176/D=gr
oups/S=1705006764:HM/EXP=1088154178/A=2164339/R=0/SIG=11e2d64in/*http://www.
netflix.com/Default?mqso=60183348> click here  
 
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164339/rand=775366451>   


  _  

Yahoo! Groups Links


*  To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<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
<http://docs.yahoo.com/info/terms/> . 




[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] change decimals for price in live envt

[Jens Strandberg]

Hello there,

We did the exact same thing in SalesLine, PurchLine and PriceDiscTable.
However, we did not want to change the related EDT's (PriceCur, AmountCur),
since the 3 (4 in our case) decimals would also show up everywhere in
General Ledger.

Instead we created a new EDT with 4 decimals that extends AmountCur.

We did not have any problems with the database in doing so.

/Jens
  -Oprindelig meddelelse-
  Fra: Girish Bhatkal [mailto:[EMAIL PROTECTED]
  Sendt: 22. juni 2004 12:50
  Til: Axapta developers
  Emne: [development-axapta] change decimals for price in live envt


  Hi guys,
    our client wants to allow upto 3 decimals when entering the purchase
  price. i know that i can do the same by making the change on the extended
  data type(EDT).  should i make the No of decimals to 3 on EDT PurchPrice
or
  i also need to change it on PriceCur  or amountCur or Amount.

 our client is live since last 6 months and have many transactions in
the
  live database and now i want to change the decimals , i just want to make
  sure if i need to change something else or run any function after changing
  the decimals.

 Did any of you guys change the no of decimals to be allowed on the live
  system with live data and did anyone have any problems?

  thanks.

  Girish



    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] User modifications.

[Jens Strandberg]

Hello there,

In which files are user modifications stored in Axapta ?

I am thinking of modifications of forms (adding new fields, hiding existing
ones, moving fields etc.)

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] Use of Decimals...

[Jens Strandberg]

I would appreciate some input on this:

I have introduced a new Extended Data Type, which is defined as a Real with
4 decimals.

Having changed PriceDiscTable.Amount, SalesLine.SalesPrice and
PurchLine.PurchPrice all fields display 4 decimals as desired. However, when
looking up a given price in PriceDiscTable, Axapta returns only 2 decimals.

Example:

PriceDiscTable.Amount = 1.2345 would trigger a SalesLine.SalesPrice and/or
PurchLine.PurchPrice of 1.2300.

You are in fact able to overwrite the suggested values to the correct value
of 1.2345, but that was not the idea, as you may have guessed.

I suspect that a calculation that involves a 2-decimal number is causing
this.

Could someone please point me in the right direction ?

Thanks in advance !

/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] SalesLine --> CustPackingSlipTrans.

[Jens Strandberg]

I have added a new field to table SalesLine, in which a value is being
entered prior to issuing a packing slip. The same field has been added to
CustPackingSlipTrans.

Where do I arrange for CustPackingSlipTrans.MyField to be populated by
SalesLine.MyField ?

Thanks in advance !

/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] Misc. charges, Sales Order

[Jens Strandberg]

Hello there,

Is there any way to display the mics. charges line-by-line on the sales
order (confirmation, delivery note, invoice etc.) as opposed to just having
the total amount shown at the bottom of the page ?

Thanks in advance...

Best Regards,

Jens Strandberg










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] Using routes with purchased parts

[Jens Strandberg]

Hello there,

I am working on this rather simple setup:

The company issues a sales order for 100 pcs of part X. Since this is a
purchased part, we immediately issue a purchase order based on the sales
order line; i.e. 100 pcs of part X.

Now, we would like to be able to work with some kind of default route, when
we receive part X. This route could contain reception, re-packaging, control
and shippping. Therefore we  issue a works order based on the same sales
order line. Needless to say - we naturally end up with 200 pcs on-hand (100
from the purchase order and 100 from the works order).

All parts in InventTable are of item type BOM (in order to use routes) with
no BOM lines.

Is there any work-around (or just a plain simple solution) which will enable
me to track routes and jobs and NOT getting the required qty's doubled ?
Would I need to use BOM line(s) containing the purchased part(s) as in a
real production environment ?

Ax 3.0, SP1.

Any help is much appreciated... Thanks in advance!

Best Regards,
Jens Strandberg










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.

SV: [development-axapta] Posting Movement Journals

[Jens Strandberg]

Hello 
James,
 
Thanks 
for your answer. I am actually not loading in data directly in SQL. Everything 
happens through Axapta import based on *.def and *.dat file.
 
One 
interesting thing, though: I noticed that if I use the Copy function to put 
all imported lines into another journal, I am able to post the - new - journal 
without any problems. Does that ring a bell ?
 
Thanks 
in advance.
 
/Jens

  -Oprindelig meddelelse-Fra: James Flavell 
  [mailto:[EMAIL PROTECTED]Sendt: 15. marts 2004 
  00:55Til: [EMAIL PROTECTED]Emne: RE: 
  [development-axapta] Posting Movement JournalsI think 
  you need other tables...I believe InventTrans is created for journallines 
  and if you dont have that then you will get the error you describe.Direct 
  data import to SQL is not recommended, should always go via Axaptaimport 
  script and fire off all the code that usually gets done with a 
  manualentry.-Original Message-From: Jens 
  Strandberg [mailto:[EMAIL PROTECTED]Sent: Monday, March 15, 2004 8:02 
  AMTo: [EMAIL PROTECTED] Com (E-mail)Subject: 
  [development-axapta] Posting Movement JournalsHello 
  there,I was wondering if anyone could give me a hint regarding 
  Movement Journals.Let's say that I import 1 line into the Movement 
  Journal with all necessaryinformation. When I validate, no errors are 
  found. However, when I post, Iget this 
  error:Error  Posting - Journal\Journal: 
  1\Voucher: 10015_062\Line No: 1,00  
  Cannotreceive quantity 9,00, as stock transactions with status 
  'Ordered','Arrived' or 'Registered' are 
  insufficient.Error  Posting - 
  Journal\Journal: 1  The journal is not posted and 
  the updateis cancelled.If I enter the same line manually, i.e. 
  with the same pieces of information,I can post without problems.I 
  have checked the above information in InventJournalTrans with the 
  SQLServer Enterprise Manager, and both lines (imported line and 
  manuallyentered line) are 100% alike.Do I have to populate other 
  table(s) in order to import and post ?Thanks in advance.Axapta 
  3.0 SP1Best regards,Jens StrandbergYahoo! 
  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.

SV: [development-axapta] Posting Movement Journals

[Jens Strandberg]

Hello 
Harry,
 
Thanks 
for your reply. I will investigate further...
 
However, I was under the impression that Axapta does not create records 
in InventTrans, until the actual posting takes place. Am I missing something 
here ?
 
Thanks 
in advance.
 
/Jens

  -Oprindelig meddelelse-Fra: Deshpande, Harry 
  [mailto:[EMAIL PROTECTED]Sendt: 15. marts 2004 
  02:26Til: '[EMAIL PROTECTED]'Emne: RE: 
  [development-axapta] Posting Movement Journals
  hi 
  Jens!
   
  Compare the lines in table InventTrans. Field 
  TransChildRefId is creating the problem.
   
  regards
   
  harry
   
  
-Original Message-From: Jens Strandberg 
[mailto:[EMAIL PROTECTED]Sent: Monday, March 15, 2004 7:02 
AMTo: [EMAIL PROTECTED] Com 
(E-mail)Subject: [development-axapta] Posting Movement 
JournalsHello there,I was wondering if 
anyone could give me a hint regarding Movement Journals.Let's say 
that I import 1 line into the Movement Journal with all 
necessaryinformation. When I validate, no errors are found. However, 
when I post, Iget this error:Error  
Posting - Journal\Journal: 1\Voucher: 10015_062\Line No: 
1,00  Cannotreceive quantity 9,00, as stock 
transactions with status 'Ordered','Arrived' or 'Registered' are 
insufficient.Error  Posting - 
Journal\Journal: 1  The journal is not posted 
and the updateis cancelled.If I enter the same line manually, 
i.e. with the same pieces of information,I can post without 
problems.I have checked the above information in InventJournalTrans 
with the SQLServer Enterprise Manager, and both lines (imported line and 
manuallyentered line) are 100% alike.Do I have to populate other 
table(s) in order to import and post ?Thanks in 
advance.Axapta 3.0 SP1Best regards,Jens 
Strandberg







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] Posting Movement Journals

[Jens Strandberg]

Hello there,

I was wondering if anyone could give me a hint regarding Movement Journals.

Let’s say that I import 1 line into the Movement Journal with all necessary
information. When I validate, no errors are found. However, when I post, I
get this error:

Error  Posting - Journal\Journal: 1\Voucher: 10015_062\Line No: 1,00  Cannot
receive quantity 9,00, as stock transactions with status 'Ordered',
'Arrived' or 'Registered' are insufficient.
Error  Posting - Journal\Journal: 1  The journal is not posted and the update
is cancelled.

If I enter the same line manually, i.e. with the same pieces of information,
I can post without problems.

I have checked the above information in InventJournalTrans with the SQL
Server Enterprise Manager, and both lines (imported line and manually
entered line) are 100% alike.

Do I have to populate other table(s) in order to import and post ?

Thanks in advance.

Axapta 3.0 SP1

Best regards,
Jens Strandberg










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.