[Axapta-Knowledge-Village] AsciIO vs CommaIO

[James Flavell]

Hi,

 

I am struggling with an import script that has been written for a csv file.

 

The issue is some fields in the file such as address have comma in them so
they are provided with quotes around the complete field.

 

The script uses the AsciIO class and then sets the delimiter as comma but
still seems not to treat the quotes correctly (i.e. it still breaks at every
comma in the file).

 

Reading some older posts seems to suggest using CommaIO might solve this?  I
thought the only difference between CommaIO and AsciIO classes was what they
initiated the delimiter different?  If CommaIO is not the answer what should
I be using so the fields within quotes get processed correctly?

 

Thanks

James

 



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

[Axapta-Knowledge-Village] Coloring Form Rows

[Syner P]

Hi,

I am trying to use beackground colors in production form as it is done in 
employee form.
It is working when scrolling up and down. But if I use pageup, pageDown the 
colors are changing in blocks and are not correct.

Any idea ?

Syner




 

Finding fabulous fares is fun.  
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel 
bargains.
http://farechase.yahoo.com/promo-generic-14795097

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

[Axapta-Knowledge-Village] Synchronise error - drop non-existent field

[hkruiniger]

Problem: table definition in AOT specifies a field for which there is 
no column in the actual SQL Server table.  I have turned off the 
config key responsible for this field and now synchronise wants to 
remove it from the table, but gives an error since the column is not 
there to be dropped!  I can't remove it from the table definition in 
the AOT - clicking on "Delete" appears to have no effect at all.

I suppose I could manually add the column to the table, just so that 
synchronise can remove it, but that seems silly.

Any ideas?

(details FWIW:  table is EmplTable, field is ActivateAnswer, switched 
on/off by smmPhone config key)

Hans

[Axapta-Knowledge-Village] Service type items with Serial number dimension

[anishafakir1]

Hi, Please tell me if the following can happen in Axapta.

Can a service type item be set up to have a serial number dimension? 
What is the consequences of this setting? If a stock close is done 
will this item get adjusted/settled? 

My reasoning is if the item is set to type 'service' then it should 
not be affected by the on hand stock reports or stock closing.

The reason for this set up is so certain service items have serialised 
numbering.   

RE: [Axapta-Knowledge-Village] Number of Originals are not specified

[sanam Khan]

Sorry Arijit for the misunderstanding hope you will ignore it. 

 

Regards,

 

Sanam 

 

From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Arijit Basu
Sent: Wednesday, April 04, 2007 1:39 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Number of Originals are not
specified

 

Hi Sanam,
Wasnt my problem :). I only gave the solution :)

On 04 Apr 2007 01:01:42 -0700, sanam Khan <[EMAIL PROTECTED]
 >
wrote:
>
> Hi,
>
> Well all the solutions are fine and they also work in different scenarios.
> Arijit if your problem is not yet resolved then try the query attached to
> the mail and run it in the Query Analyzer against the Axapta database and
> change the names according to your company names in the query.
>
> After running the query then log into the system and check the print
> management settings and then print the PO's and SO's.
>
> Hope it will work.
>
> Regards,
>
> Sanam
>
> From: Axapta-Knowledge-Village@yahoogroups.com


> [mailto:Axapta-Knowledge-Village@yahoogroups.com

]
> On Behalf Of samuel pramod
> Sent: Wednesday, April 04, 2007 10:33 AM
> To: Axapta-Knowledge-Village@yahoogroups.com


> Subject: Re: [Axapta-Knowledge-Village] Number of Originals are not
> specified
>
> Hi,
>
> Setup done by Arijit is the correctand easy way, if you have more
> customers
> , write a job to update the field in customers and vendors, for new
> customers and vendors write code so that this field gets filled at the
> time
> of master creation.
>
> regards
> Pramod
>
> Arijit Basu <[EMAIL PROTECTED] 
  arijit.basu%40gmail.com> > wrote:
> Hi,
> Go to Vendors>Setup>Print Management. The checkbox at the top saying
> "Use Document Setup" should be ticked so as to inherit from the form
> setup. If not then you must specify for each vendor. I had this problem
> once
> and I resolved it this way.
> Hope it helps
>
> Arijit Basu
> http://daxguy.blogspot.com/
>
> On 4/3/07, ajastra_1 <[EMAIL PROTECTED]
   ajastra_1%40yahoo.co.in>
>
> > wrote:
> >
> > Dear Friends,
> >
> > When I am posting in any PO/SO in each posting states such as
> > quotation/confirmation/packing slip/invoice etc when i want to print
> > report every time it shows one warning "Numbers of Originals and Copies
> > are not specified in the print management form" and its not generate
> > report at this level and posting is cancelled .
> > It is already been setup in Form Setup option.
> >
> > Please tell me where I will solve this problem .
> >
> > its urgent requirment to rectify this problem .
> >
> >
> >
>
> --
>
> Arijit Basu
>
> [Non-text portions of this message have been removed]
>
> -
> Now that's room service! Choose from over 150,000 hotels
> in 45,000 destinations on Yahoo! Travel to find your fit.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> 
>

-- 

Arijit Basu

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

 



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

Re: [Axapta-Knowledge-Village] Number of Originals are not specified

[Arijit Basu]

Hi Sanam,
   Wasnt my problem :). I only gave the solution :)


On 04 Apr 2007 01:01:42 -0700, sanam Khan <[EMAIL PROTECTED]>
wrote:
>
>   Hi,
>
> Well all the solutions are fine and they also work in different scenarios.
> Arijit if your problem is not yet resolved then try the query attached to
> the mail and run it in the Query Analyzer against the Axapta database and
> change the names according to your company names in the query.
>
> After running the query then log into the system and check the print
> management settings and then print the PO's and SO's.
>
> Hope it will work.
>
> Regards,
>
> Sanam
>
> From: 
> Axapta-Knowledge-Village@yahoogroups.com
> [mailto:Axapta-Knowledge-Village@yahoogroups.com]
> On Behalf Of samuel pramod
> Sent: Wednesday, April 04, 2007 10:33 AM
> To: 
> Axapta-Knowledge-Village@yahoogroups.com
> Subject: Re: [Axapta-Knowledge-Village] Number of Originals are not
> specified
>
> Hi,
>
> Setup done by Arijit is the correctand easy way, if you have more
> customers
> , write a job to update the field in customers and vendors, for new
> customers and vendors write code so that this field gets filled at the
> time
> of master creation.
>
> regards
> Pramod
>
> Arijit Basu <[EMAIL PROTECTED]   arijit.basu%40gmail.com> > wrote:
> Hi,
> Go to Vendors>Setup>Print Management. The checkbox at the top saying
> "Use Document Setup" should be ticked so as to inherit from the form
> setup. If not then you must specify for each vendor. I had this problem
> once
> and I resolved it this way.
> Hope it helps
>
> Arijit Basu
> http://daxguy.blogspot.com/
>
> On 4/3/07, ajastra_1 <[EMAIL PROTECTED]  ajastra_1%40yahoo.co.in>
>
> > wrote:
> >
> > Dear Friends,
> >
> > When I am posting in any PO/SO in each posting states such as
> > quotation/confirmation/packing slip/invoice etc when i want to print
> > report every time it shows one warning "Numbers of Originals and Copies
> > are not specified in the print management form" and its not generate
> > report at this level and posting is cancelled .
> > It is already been setup in Form Setup option.
> >
> > Please tell me where I will solve this problem .
> >
> > its urgent requirment to rectify this problem .
> >
> >
> >
>
> --
>
> Arijit Basu
>
> [Non-text portions of this message have been removed]
>
> -
> Now that's room service! Choose from over 150,000 hotels
> in 45,000 destinations on Yahoo! Travel to find your fit.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>  
>



-- 


Arijit Basu


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

RE: [Axapta-Knowledge-Village] Number of Originals are not specified

[sanam Khan]

Hi,

 

Well all the solutions are fine and they also work in different scenarios.
Arijit if your problem is not yet resolved then try the query attached to
the mail and  run it in the Query Analyzer against the Axapta database  and
change the names according to your company names in the query.

 

After running the query then log into the system and check the print
management settings and then print the PO's and SO's. 

Hope it will work.

 

Regards, 

Sanam 

 

From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of samuel pramod
Sent: Wednesday, April 04, 2007 10:33 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Number of Originals are not
specified

 

Hi,

Setup done by Arijit is the correctand easy way, if you have more customers
, write a job to update the field in customers and vendors, for new
customers and vendors write code so that this field gets filled at the time
of master creation.

regards
Pramod


Arijit Basu <[EMAIL PROTECTED]  > wrote:
Hi,
Go to Vendors>Setup>Print Management. The checkbox at the top saying
"Use Document Setup" should be ticked so as to inherit from the form
setup. If not then you must specify for each vendor. I had this problem once
and I resolved it this way.
Hope it helps

Arijit Basu
http://daxguy.blogspot.com/

On 4/3/07, ajastra_1 <[EMAIL PROTECTED] 
> wrote:
>
> Dear Friends,
>
> When I am posting in any PO/SO in each posting states such as
> quotation/confirmation/packing slip/invoice etc when i want to print
> report every time it shows one warning "Numbers of Originals and Copies
> are not specified in the print management form" and its not generate
> report at this level and posting is cancelled .
> It is already been setup in Form Setup option.
>
> Please tell me where I will solve this problem .
>
> its urgent requirment to rectify this problem .
>
> 
>

-- 

Arijit Basu

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

-
Now that's room service! Choose from over 150,000 hotels 
in 45,000 destinations on Yahoo! Travel to find your fit.

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

 



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

RE: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT

[Steve Wright]

URL for that screen shot is

 

www.atlasxl.com.au\VendCustBalanceSample.jpg
 

 

http://partner.atlasxl.com.au and signup for a free trial if you're not
already a user.

 

 

 

From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Steve
Wright
Sent: Wednesday, 4 April 2007 3:07 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT

 

I have not seen this in AX...but the attached report (screen shot) shows
the report you're after using Atlas xl. There are a couple of steps to
produce it however total time to build the report...<5 minutes.

Steve

http://partner.atlasxl.com.au and signup for a free trial if you're not
already a user.

From: Axapta-Knowledge-Village@yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.com
 ] On Behalf Of
Dynamics
Freak
Sent: Wednesday, 4 April 2007 8:33 AM
To: Axapta-Knowledge-Village@yahoogroups.com
 
Subject: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT

Hi Guys,

A reporting clarification -

I want to check the balance outstanding for a vendor who is also my
customer.
For this, In the vendor Master, I specify the customer account.Then I
run the Vendor Balances report. 
But the report shows only the Vendor related transactions. Not the
Transactions on the Customer Side?

Is there a different report to run to check the net balance?

Thanks and Regards,

__
8:00? 8:25? 8:40? Find a flick in no time 
with the Yahoo! Search movie showtime shortcut.
http://tools.search.yahoo.com/shortcuts/#news

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

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

 



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

RE: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT

[Steve Wright]

I have not seen this in AX...but the attached report (screen shot) shows
the report you're after using Atlas xl.  There are a couple of steps to
produce it however total time to build the report...<5 minutes.

 

Steve

 

http://partner.atlasxl.com.au and signup for a free trial if you're not
already a user.

 

 

 

 

 

From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Dynamics
Freak
Sent: Wednesday, 4 April 2007 8:33 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT

 

Hi Guys,

A reporting clarification -

I want to check the balance outstanding for a vendor who is also my
customer.
For this, In the vendor Master, I specify the customer account.Then I
run the Vendor Balances report. 
But the report shows only the Vendor related transactions. Not the
Transactions on the Customer Side?

Is there a different report to run to check the net balance?

Thanks and Regards,

__
8:00? 8:25? 8:40? Find a flick in no time 
with the Yahoo! Search movie showtime shortcut.
http://tools.search.yahoo.com/shortcuts/#news

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

 



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