RE: [Axapta-Knowledge-Village] Re: External Item - Sales Order

2005-03-29 Thread Preston A. Larimer 










Rick if you’re going further down
this path, this code sample might give you hand. It first searches the
inventTable for the ItemID first, and if not found it searches the external
Item table.

 

-Preston

 

 

inventTable getInventRec(externalItemID
_itemID, custAccount _acct)

{  //Get the inventory record for the
externalItemID

 

 

    inventTable inventTable;

 

    select firstonly inventTable

    where inventTable.ItemId ==
_itemID;

    if(!inventTable)

    inventTable =
CustVendExternalItem::findExternalItemId(

   
ModuleInventPurchSalesVendCustGroup::Cust,

    _acct,

    _itemid).inventTable();

    return inventTable;

}

 









From: rickhardy22 [mailto:[EMAIL PROTECTED]

Sent: Tuesday, March 29, 2005 9:27
PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject:
[Axapta-Knowledge-Village] Re: External Item - Sales Order



 


Preston,

Thanks for your response.  I thought that was
the case but I just 
wanted to be sure that there was not this
functionality out of the 
box before I would start looking into the
modification.  Thanks for 
your help!

Rick
--- In Axapta-Knowledge-Village@yahoogroups.com,
"Preston A. 
Larimer" <[EMAIL PROTECTED]> wrote:
> Rick,
> 
>  
> 
> The external Item number is usually used when
creating orders via 
an
> external interface such as Commerce gateway,
or EDI.  When using 
the Sales
> form in Axapta it is assumed that you will be
using your internal 
item
> number so the logic that would do an external
item ID look up is 
not present
> on that form, it would be a fairly simple
modification to add a 
section of
> code on the modified method of the external
item ID field that 
would perform
> the lookup and populate the standard item id
, or present an item 
not found
> error.
> 
>  
> 
> -Preston 
> 
>  
> 
>   _  
> 
> From: rickhardy22 [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, March 29, 2005 1:12 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] Re:
External Item - Sales Order
> 
>  
> 
> 
> The extenal item number is on the general tab
on the sales order 
> lines.  What I would expec is if I enter
the external item number 
in 
> this field then it should pull Axaptas (our)
item number?  What 
I'm 
> trying to avoid is having to reference our
item number at all.
> 
> If I enter our item number the external item
number does get 
filled 
> in, but the reverse does not happen.
> 
> --- In Axapta-Knowledge-Village@yahoogroups.com,
UserM1837 
> <[EMAIL PROTECTED]> wrote:
> > You can take an order using the
customer's external item 
number.  
> Just make sure that after you have done the
set up for the 
customer 
> external item number in the accounts
receivable that on the sales 
> order form, you have a field to enter the
external item id.  Your 
> form should have two fields one for the item
number (yours) and 
> another field for the external item Id such
that if you enter the 
> item number it will pull up the customer
external item number and 
> the reverse is also true.
> >  
> > Thanks
> > 
> > rickhardy22 <[EMAIL PROTECTED]> wrote:
> > 
> > So there is no way we can take an order
using a customers 
external 
> > item number id?  We just need to
know that their item cross 
> > references to our item?  This seems
like a very poor solution...
> > 
> > --- In Axapta-Knowledge-Village@yahoogroups.com,
hakan "köse" 
> > <[EMAIL PROTECTED]> wrote:
> > > 
> > > 
> > >    This customer
number could be seen only in picking
> > > list with that way. You should
still type the axapta
> > > number when you create a sales
order ..
> > > 
> > > 
> > > 
> > > --- Rick Hardy <[EMAIL PROTECTED]>
wrote:
> > > > Francisco,
> > > > 
> > > >  
> > > > 
> > > > Thanks for the response, but
when I do this and I go
> > > > to the sales order
> > > > form and try to enter the
external item number on a
> > > > sales order to that
> > > > particular customer I get the
message that the item
> > > > does not exist in
> > > > the item table?
> > > > 
> > > >  
> > > > 
> > > > Rick
> > > > 
> > > >  
> > > > 
> > > >   _  
> > > > 
> > > > From: Francisco Orozco
[mailto:[EMAIL PROTECTED] 
> > > > Sent: Monday, March 28, 2005
3:31 PM
> > > > To: Administrator
> > > > Cc: Rick Hardy
> > > > Subject: Re:
[Axapta-Knowledge-Village] External
> > > > Item - Sales Order
> > > > 
> > > >  
> > > > 
> > > > Of course, go to Accounts
Receivable, SetUp, Forms,
> > > > Form Setup, Item
> > > > Number =set it to BOTH, then
go to the customer
> > > > form, select the
> > > > customer, then go to SetUp
Button, then click on
> > > > External Item
> > > > Description. and enter as many
ITEMS codes and
> > > > descrptions for this
> > > > particular customer., it
should do it.
> > > > 
> > > > Kind Regards
> > > > 
> > > > Francisco Orozco
> > > > 
> > > >  
> > > > 
> > > > 
> > > > 
> > > > - Original Message -
> > > > From: rickhardy22 
> > > > To: Axapta-

RE: [Axapta-Knowledge-Village] Re: External Item - Sales Order

2005-03-29 Thread Preston A. Larimer 










Rick,

 

The external Item number is usually used
when creating orders via an external interface such as Commerce gateway, or
EDI.  When using the Sales form in Axapta it is assumed that you will be using
your internal item number so the logic that would do an external item ID look
up is not present on that form, it would be a fairly simple modification to add
a section of code on the modified method of the external item ID field that
would perform the lookup and populate the standard item id , or present an item
not found error.

 

-Preston 

 









From: rickhardy22
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 29, 2005 1:12
PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject:
[Axapta-Knowledge-Village] Re: External Item - Sales Order



 


The extenal item number is on the general tab on
the sales order 
lines.  What I would expec is if I enter the
external item number in 
this field then it should pull Axaptas (our) item
number?  What I'm 
trying to avoid is having to reference our item number
at all.

If I enter our item number the external item
number does get filled 
in, but the reverse does not happen.

--- In Axapta-Knowledge-Village@yahoogroups.com,
UserM1837 
<[EMAIL PROTECTED]> wrote:
> You can take an order using the customer's
external item number.  
Just make sure that after you have done the set up
for the customer 
external item number in the accounts receivable
that on the sales 
order form, you have a field to enter the external
item id.  Your 
form should have two fields one for the item
number (yours) and 
another field for the external item Id such that
if you enter the 
item number it will pull up the customer external
item number and 
the reverse is also true.
>  
> Thanks
> 
> rickhardy22 <[EMAIL PROTECTED]> wrote:
> 
> So there is no way we can take an order using
a customers external 
> item number id?  We just need to know
that their item cross 
> references to our item?  This seems like
a very poor solution...
> 
> --- In Axapta-Knowledge-Village@yahoogroups.com,
hakan "köse" 
> <[EMAIL PROTECTED]> wrote:
> > 
> > 
> >    This customer number
could be seen only in picking
> > list with that way. You should still
type the axapta
> > number when you create a sales order ..
> > 
> > 
> > 
> > --- Rick Hardy <[EMAIL PROTECTED]>
wrote:
> > > Francisco,
> > > 
> > >  
> > > 
> > > Thanks for the response, but when I
do this and I go
> > > to the sales order
> > > form and try to enter the external
item number on a
> > > sales order to that
> > > particular customer I get the
message that the item
> > > does not exist in
> > > the item table?
> > > 
> > >  
> > > 
> > > Rick
> > > 
> > >  
> > > 
> > >   _  
> > > 
> > > From: Francisco Orozco
[mailto:[EMAIL PROTECTED] 
> > > Sent: Monday, March 28, 2005 3:31
PM
> > > To: Administrator
> > > Cc: Rick Hardy
> > > Subject: Re:
[Axapta-Knowledge-Village] External
> > > Item - Sales Order
> > > 
> > >  
> > > 
> > > Of course, go to Accounts
Receivable, SetUp, Forms,
> > > Form Setup, Item
> > > Number =set it to BOTH, then go to
the customer
> > > form, select the
> > > customer, then go to SetUp Button,
then click on
> > > External Item
> > > Description. and enter as many
ITEMS codes and
> > > descrptions for this
> > > particular customer., it should do
it.
> > > 
> > > Kind Regards
> > > 
> > > Francisco Orozco
> > > 
> > >  
> > > 
> > > 
> > > 
> > > - Original Message -
> > > From: rickhardy22 
> > > To: Axapta-Knowledge-Village@yahoogroups.com
> > > Subject: [Axapta-Knowledge-Village]
External Item -
> > > Sales Order
> > > Date: Mon, 28 Mar 2005 19:51:48
-
> > > 
> > > 
> > > I was hoping somebody could help me
out with
> > > external item numbers.  
> > > We have customers that would like
to use their own
> > > part numbers for 
> > > ordering - which seems like a great
fit for customer
> > > external item 
> > > numbers.  Is it possible to
use the external item
> > > number on the sales 
> > > order lines for ordering purposes?
> > > 
> > > Thanks for you help...
> > > 
> > > Rick
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Sharing the knowledge on Axapta. 
> > > 
> > > 
> > > 
> > > 
> > > -- 
> > > 
> > >
> >
___
> > > Sign-up for Ads Free at Mail.com
> > > http://www.mail.com/?sr=signup
> > >
> >  bannercode=adsfre
> > > ejump01> 
> > > 
> > > 
> > > 
> > > Sharing the knowledge on Axapta. 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Yahoo! Groups Sponsor
> > > 
> > > ADVERTISEMENT
> > > click here
> > >
> > 
> 
 76/
> > >
> > 
> 
D=groups/S=1705001380:HM/EXP=1112131683/A=2593423/R=0/SIG=11el9gslf/*
> htt
> > >
p:/www.netflix.com/Default?mqso=60190075> 
> > > 
> > >  
> > >
> >  M=298184.6018725.7038619.3001176/D=group
> > >
s/S=:HM/A=2593423/rand=570584611> 
> > > 
> > >  
> >

Re: [Axapta-Knowledge-Village] Re: External Item - Sales Order

2005-03-29 Thread UserM1837 



You can take an order using the customer's external item number.  Just make sure that after you have done the set up for the customer external item number in the accounts receivable that on the sales order form, you have a field to enter the external item id.  Your form should have two fields one for the item number (yours) and another field for the external item Id such that if you enter the item number it will pull up the customer external item number and the reverse is also true.
 
Thanksrickhardy22 <[EMAIL PROTECTED]> wrote:
So there is no way we can take an order using a customers external item number id?  We just need to know that their item cross references to our item?  This seems like a very poor solution...--- In Axapta-Knowledge-Village@yahoogroups.com, hakan "köse" <[EMAIL PROTECTED]> wrote:> > >    This customer number could be seen only in picking> list with that way. You should still type the axapta> number when you create a sales order ..> > > > --- Rick Hardy <[EMAIL PROTECTED]> wrote:> > Francisco,> > > >  > > > > Thanks for the response, but when I do this and I go> > to the sales order> > form and try to enter the external item number on a> > sales order to that> > particular
 customer I get the message that the item> > does not exist in> > the item table?> > > >  > > > > Rick> > > >  > > > >   _  > > > > From: Francisco Orozco [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 28, 2005 3:31 PM> > To: Administrator> > Cc: Rick Hardy> > Subject: Re: [Axapta-Knowledge-Village] External> > Item - Sales Order> > > >  > > > > Of course, go to Accounts Receivable, SetUp, Forms,> > Form Setup, Item> > Number =set it to BOTH, then go to the customer> > form, select the> > customer, then go to SetUp Button, then click on> > External Item> > Description. and enter as many ITEMS codes and> > descrptions for this> > particular customer., it should do
 it.> > > > Kind Regards> > > > Francisco Orozco> > > >  > > > > > > > > - Original Message -> > From: rickhardy22 > > To: Axapta-Knowledge-Village@yahoogroups.com> > Subject: [Axapta-Knowledge-Village] External Item -> > Sales Order> > Date: Mon, 28 Mar 2005 19:51:48 -> > > > > > I was hoping somebody could help me out with> > external item numbers.  > > We have customers that would like to use their own> > part numbers for > > ordering - which seems like a great fit for customer> > external item > > numbers.  Is it possible to use the external item> > number on the sales > > order lines for ordering purposes?> > > > Thanks for you help...> > > > Rick>
 > > > > > > > > > > > Sharing the knowledge on Axapta. > > > > > > > > > > -- > > > >> ___> > Sign-up for Ads Free at Mail.com> > http://www.mail.com/?sr=signup> >>  > ejump01> > > > > > > > > Sharing the knowledge on Axapta. > > > > > > > > > > > > Yahoo! Groups Sponsor> > > > ADVERTISEMENT> > click here> >>  >> D=groups/S=1705001380:HM/EXP=1112131683/A=2593423/R=0/SIG=11el9gslf/*htt> > p:/www.netflix.com/Default?mqso=60190075> > > > >  > >>  > s/S=:HM/A=2593423/rand=570584611> > > > >  > > > >   _  > > > > Yahoo! Groups Links> > > > *  To visit your group on the web, go to:> > > >> http://groups.yahoo.com/group/Axapta-Knowledge-Village/> >    
 > > *  To unsubscribe from this group, send an email to:> > > > [EMAIL PROTECTED]> >> subject=Uns> > ubscribe> > >     > > *  Your use of Yahoo! Groups is subject to the Yahoo!> > Terms of> > Service  . > > > >  > > >     > __ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site!> http://smallbusiness.yahoo.com/resources/Sharing the
 knowledge on Axapta. 
		Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site! 


Sharing the knowledge on Axapta.








Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

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