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

[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-Knowledge-Village@yahoogroups.com > > > > Subject: [Axapta-Knowledge-Village] External Item - > > > > Sales Order > > > > Date: Mon, 28 Mar 2005 19:51:48 -0000 > > > > > > > > > > > > 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 > > > > > > > <http://mail01.mail.com/scripts/payment/adtracking.cgi? > > bannercode=adsfre > > > > ejump01> > > > > > > > > > > > > > > > > Sharing the knowledge on Axapta. > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Sponsor > > > > > > > > ADVERTISEMENT > > > > click here > > > > > > > > > > <http://us.ard.yahoo.com/SIG=129i12l9f/M=298184.6018725.7038619.30011 > > 76/ > > > > > > > > > > D=groups/S=1705001380:HM/EXP=1112131683/A=2593423/R=0/SIG=11el9gslf/* > > htt > > > > p:/www.netflix.com/Default?mqso=60190075> > > > > > > > >  > > > > > > > <http://us.adserver.yahoo.com/l? > > M=298184.6018725.7038619.3001176/D=group > > > > 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] > > > > > > > <mailto:[EMAIL PROTECTED] > > subject=Uns > > > > ubscribe> > > > >         > > > > *      Your use of Yahoo! Groups is subject to the Yahoo! > > > > Terms of > > > > Service <http://docs.yahoo.com/info/terms/> . > > > > > > > >  > > > > > > > > >             > > > __________________________________ > > > Do you Yahoo!? > > > Yahoo! Small Business - Try our new resources site! > > > http://smallbusiness.yahoo.com/resources/ > > > > > > > > > > > > Sharing the knowledge on Axapta. > > > > > > Yahoo! Groups SponsorADVERTISEMENT > > > > > > --------------------------------- > > 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. > > > > > >             > > --------------------------------- > > Do you Yahoo!? > >  Yahoo! Small Business - Try our new resources site! > > > > > > Sharing the knowledge on Axapta. > > > > > > > Yahoo! Groups Sponsor > > > > ADVERTISEMENT >  > <http://us.ard.yahoo.com/SIG=129uh8270/M=298184.6018725.7038619.30011 76/D=gr > oups/S=1705001380:HM/EXP=1112206367/A=2593423/R=0/SIG=11el9gslf/*http :/www.n > etflix.com/Default?mqso=60190075> click here > > >  > <http://us.adserver.yahoo.com/l? M=298184.6018725.7038619.3001176/D=groups/S= > :HM/A=2593423/rand=110065646> > >  > >   _____  > > 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] > <mailto:[EMAIL PROTECTED] subject=Unsubsc > ribe> >   > *      Your use of Yahoo! Groups is subject to the Yahoo! > <http://docs.yahoo.com/info/terms/>  Terms of Service. Sharing the knowledge on Axapta. 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.