AW: [Axapta-Knowledge-Village] Master Planing problem

Hi Gökhan, if you add lines to a BOM journal, and want the quantity to be deducted from the (Prod)BOM, then you have to refer to the corresponding Lot ID. The easiest think would be to select the lot ID, then the item id etc. are inserted automatically. Change the quantity as required. Because yo

AW: [Axapta-Knowledge-Village] How to pass empty value for date i n SQL-statement?

Please try   priceDiscTableX.ToDate == datenull()   Hope this helps,   Annette  -Ursprüngliche Nachricht-Von: nttrehn [mailto:[EMAIL PROTECTED]Gesendet: Donnerstag, 27. Januar 2005 12:08An: Axapta-Knowledge-Village@yahoogroups.comBetreff: [Axapta-Knowledge-Village] How to pass e

AW: [Axapta-Knowledge-Village] Inventory Closing Whitepaper

Hi Jason,   please, send it to me too!   Thanks a lot!   Annette   Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette TheißenSystem Software Entwicklung__Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 HannoverPhone: +49/511/94996-0 - Fax:

AW: RE : RE : [Axapta-Knowledge-Village] Activate debugger

Or you might set up a fat client on a 3-tier solution ...   -Ursprüngliche Nachricht-Von: Preston A. Larimer [mailto:[EMAIL PROTECTED]Gesendet: Freitag, 3. September 2004 16:26An: [EMAIL PROTECTED]Betreff: RE: RE : RE : [Axapta-Knowledge-Village] Activate debugger

AW: [Axapta-Knowledge-Village] Number Sequence for network is not initialised

This should apply to your case, too. Hope this helps!     -Ursprüngliche Nachricht-Von: Theissen, Annette Gesendet: Mittwoch, 11. August 2004 08:32An: '[EMAIL PROTECTED]'Betreff: AW: [Axapta-Knowledge-Village] Number Sequence for Network not In itialized Hi Peter,

AW: [Axapta-Knowledge-Village] Currency Convertion issues

The base Currency is set in the CompanyInfo sheet. I hope it's not a live company you are working on ;-)   Annette   Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette TheißenSystem Software Entwicklung__Viscom AG - Carl-Buderus-Str. 9-15

AW: [Axapta-Knowledge-Village] Rename Value

Hi Joel,   check out the table function RenamePrimaryKey!   Hope this helps,   Annette   Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette TheißenSystem Software Entwicklung__Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 HannoverPhone: +

AW: [Axapta-Knowledge-Village] CRM Module Help Needed

Hi Bob,   in the EmplTable, there are at least two datasets that are assigned to you (filter for your UserID in EmplTable.UserID). When deleting the userID on all EmplTable datasets but one, you should be able to use CRM ... or at least progress to the next error message ;-)   Hope this

AW: [Axapta-Knowledge-Village] how i could realize a purchase enq uiry in axapta?

Hi,   check out the field purchase type. It may be set to Quotation.   On Quotations, you may only book the 'orders' (Buchung -> Bestellung), the title of the print out will change to quotation automatically.   Still, that does not provide you with a workflow to somehow automatically crea

AW: [Axapta-Knowledge-Village] Number Sequence for Network not In itialized

Hi Peter,   set the number sequence in HumanResources / Network / Setup / Parameters.   Bye, Annette Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette TheißenSystem Software Entwicklung__Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 Han

AW: [Axapta-Knowledge-Village] SQL Select in axapata (X++)

Please try maxof instead of max:   select maxof(IDNumber) from myTable;   Bye, Annette   Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette TheißenSystem Software Entwicklung__Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 HannoverPhone:

AW: [Axapta-Knowledge-Village] Production order (works order) Pic king List, warehouse locations

Hi,   if I understand correctly, you do not want to specify a default issue location in the item setup, but want Axapta to use the WMSLocation for the BOM, where the OnHand quantities actually are!?   This is no standard feature, you will have to program that yourself - at least that's wh

AW: [Axapta-Knowledge-Village] Re: Automatic Execution of Product ion Order

om. Or Is it an independent settingI would be highly obliged if you could kindly answer the above questions. Have a nice week ahead. Rajendra--- In [EMAIL PROTECTED], "Theissen, Annette" <[EMAIL PROTECTED]> wrote:> Hi,>  > for your first problem, in the par

AW: [Axapta-Knowledge-Village] Automatic Execution of Production Order

Title: Nachricht Hi,   for your first problem, in the parameters of reporting as finished, check out the settings - 'Automatic Route Consumption' ... in your case it probably should be set to Always. - 'End-mark route' ... in your case it probably should be checked.   These are the sett

AW: [Axapta-Knowledge-Village] Syntax help

Title: Nachricht Hi,   I am not sure, I am getting your question correctly, because you cannot group by a sum But maybe this example might help:       InventTable tabItem;    ;       while select sum(NetWeight) from tabItem    group by ItemGroupID    where tabItem.ItemType =