[Axapta-Knowledge-Village] setup fixed exchange rate in sales order

2005-03-29 Thread lie felicia
Hi, all I really need help to know how to use fixed exchange rate in tab price / discount when creating sales order. cause i've inserted number in fixed exchange rate box but seems nothing happen, means that nothing change with the price each for that SO. I'm looking forward for the answer

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

2005-03-29 Thread k
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

[Axapta-Knowledge-Village] Regarding Axapta Installation

2005-03-29 Thread vlnarasimhan2004
Hello, We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members. What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be

[Axapta-Knowledge-Village] Regarding Axapta Installation

2005-03-29 Thread vlnarasimhan2004
Hello, We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members. What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be

Re: [Axapta-Knowledge-Village] Regarding Axapta Installation

2005-03-29 Thread Frank Werner-Vohrer
Hello, there are a few question before you can talk about installation. What kind of enviorment do you want to have? A 2-tier or 3-tier? Zhe first thing you have to install is the SQL-Server Frank Werner-Vohrervlnarasimhan2004 [EMAIL PROTECTED] wrote: Hello,We need to install Axapta in our

[Axapta-Knowledge-Village] Re: Regarding Axapta Installation

2005-03-29 Thread vlnarasimhan2004
Hi, We need 3-tier environment. regards Lakshmi Narasimhan --- In Axapta-Knowledge-Village@yahoogroups.com, Frank Werner-Vohrer [EMAIL PROTECTED] wrote: Hello, there are a few question before you can talk about installation. What kind of enviorment do you want to have? A 2-tier or

RE: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-29 Thread Varden Morris
Hi Chea, Just execute this command again: select _tblSales; VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Chea

Re: [Axapta-Knowledge-Village] Re: Regarding Axapta Installation

2005-03-29 Thread panda arabinda
Dear Sir 1. Regarding server and client configuration If you will go to the below link you will come to know that the system configuration required as per your requirement. http://www.fujitsu-siemens.com/solutions/strategic_partners/microsoft/axapta_sizing.html 2. Regarding

Re: [Axapta-Knowledge-Village] Re: Regarding Axapta Installation

2005-03-29 Thread Varden Morris
If you do not intend to use a lot more than 15 users 2-tier would be the recommendation for better performance. If you are thinking about security and scalability then 3-tier is the better choice. The order in which you install the server, application, client and database is not relevant as

Re: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-29 Thread Ricardo Cortés
Hi, I want to upload General Journals, the header and its lines, so the tables that I want to upload are ledgerjournaltable and ledgerjournaltrans. This tablea are going to be added through an interface made in .Net, but my problem is asign the RecId. I'm using mssql, I hope some can help

AW: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-29 Thread Leberbauer, Herbert - News
Hi Ricardo, am I hearing "LedgerJournalTable" and "LedgerJournalTrans"? If yes, do you use the Class "LedgerJournalEngine" too? I recently had to do something with inserting records into those two tables: I found out, that it's working smoother if you use the Class LedgerJournalEngine

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

2005-03-29 Thread rickhardy22
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

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

[Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)

2005-03-29 Thread Anton Tjiptadi
Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - ---

[Axapta-Knowledge-Village] Posting Profile - Inventory (Purchase Order)

2005-03-29 Thread ppcheah70
Hi all I am working on below posting profile. Purchase Order (Consumption) Path : Inventory Mgt/Setup/Posting/Posting-Purchase Order Can anyone advice me when does system use the posting profile for 'Consumption' what is the recommad account to use. Regards pp.cheah

Re: [Axapta-Knowledge-Village] Posting Profile - Inventory (Purchase Order)

2005-03-29 Thread Abin
consumption account is used on return Items. Accountto use-- You must determineany PL account. Abin.ppcheah70 [EMAIL PROTECTED] wrote: Hi allI am working on below posting profile. Purchase Order (Consumption)Path : Inventory Mgt/Setup/Posting/Posting-Purchase OrderCan anyone advice me when

[Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile

2005-03-29 Thread ppcheah70
Hi all I am working on below posting profile. Purchase Order (Consumption) Path : General Ledger/Setup/Fixed Asset/Posting Profile/Disposal (buttom)/Sale or Scrap. Either select sale or scrap buttom; in 'Post Value' column may find 'Acquisition value' 'Sale value'. Pls advice me when does

RE: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)

2005-03-29 Thread Agus Riyadi
Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis Services SP3 installed. Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 9:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject:

Re: [Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile

2005-03-29 Thread Koh Meng
Hello Poh Poh, Jack here. The acquisition account is the balance sheet asset acquisition account (in original purchase price) whereas the sales value is a PL account / disposal account used to calculate the gain / loss on disposal. Do try to create a disposal transaction andpost itthen by

Re: [Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile

2005-03-29 Thread Sun Fen
Hi Cheah, When you use the disposal sale/scrap, it means that you are reversing previous transactions such as acquisitionadjustments, depreciation adjustments etc, and also take into account the gain/loss of disposal. You can find a perfect example if you look at the demo data for WELD value

Re: [Axapta-Knowledge-Village] Posting Profile - Inventory (Purchase Order)

2005-03-29 Thread Sun Fen
Hi Cheah, Try the following and you will understand when consumption account is used. 1. Make sure standard cost price is unchecked in the inventory model group. (if checked, standard cost price accounts will be used instead of consumption) 2. Create and invoice a purchase order. see the item

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

2005-03-29 Thread Preston A. Larimer
Rick if youre 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

[Axapta-Knowledge-Village] Account number for transaction type does not exist ???

2005-03-29 Thread SAS
Dear All, We get this error Account number for transaction type ' ' does not exist , when we do update costing on production order . Do we miss something on parameter setup posting Inventory management ? thx Sas Yahoo! Groups Sponsor ~-- What

[Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table)

2005-03-29 Thread Anton Tjiptadi
Hi Agus, thanks for your reply, but I guess I can't try it 'cause my company didn't buy the 'OLAP' things hahaha --- In Axapta-Knowledge-Village@yahoogroups.com, Agus Riyadi [EMAIL PROTECTED] wrote: Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis

RE: [Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table)

2005-03-29 Thread Agus Riyadi
Hi Anton, A workaround is creating another table with array column. Create code to populate data to the new table. Using form/report, change the label appearance of each array in the runtime, based on the data that you want to be displayed as column name. If someone have a better workaround, I