Re: [Axapta-Knowledge-Village] Unit of Measure conversion -- URGENT Pls. FOR POSTED TRANSACTIONS.

Hi Khan, When you receive the goods, all the costs are calculated by inventory unit. All inventory transactions are calculated at time you post the transaction and will not be changed. So if you change the UOM conversion, i think there is no changes when you close your stock. THanks Khue

Re: [Axapta-Knowledge-Village] Company Account ID Change

Hi, Why don't you duplicate the current company into another company with new ID and name then delete the old one? Hope this help. Khue From: AX Consultant consultan...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, July 1, 2009

Re: [Axapta-Knowledge-Village] Error while posting the movemnet journal.

Hi , I think you need to take a look at inventory model group. It seems like Register require is activated. Hope this help. Khue Trinh From: Trinadh Sura trin...@b2bsoftech.com To: development-axapta development-axa...@yahoogroups.com Cc:

Re: [Axapta-Knowledge-Village] Re: Urgent Querry

with this Thanks in Advance Regards Visti On Thu, Nov 6, 2008 at 10:22 AM, kbi kbi [EMAIL PROTECTED] com wrote: Hi There, This can be handled by Item Dimension in standard AX, and you can create just 1 item with different dimensions set up... standard item dimensions are: configuration

Re: [Axapta-Knowledge-Village] Inventory Dim Warehouse

Hi there, You can set up WH-FG and WH-Plan as the supplying warehouse. Go to warehouse breakdown, and set the main warehouse and check the refill check box. when you have a sales order on WH-FG, AX will generate a planned Production order of WH-Plant and a planned transfer order from WH-Plant

Re: [Axapta-Knowledge-Village] InventDim mapping in Axapta

Hi, InventDim is a table which holds a combined KEY of storage dimensions (Site, warehouse, location, pallet, batch and serial number). That is why you can't find wahouse Id in trasactional table like sales, purchase, invent trans. THere are some static method of InventDim table like find,

Re: [Axapta-Knowledge-Village] Cannot read text formatted numbers from excel cell

it seems like the the value in excel is considered as a double value; please try value().double Or you can try format it as a text. hope this help Khue - Original Message From: turkkanarda [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, February 2, 2008

Re: [Axapta-Knowledge-Village] Quantity in GL Postings

what you see in Inventory movement is the inventory transaction which contain cost amount, this is not the GL transaction. Once data poisted to GL, there is no point to see the quantity .. hope this help - Original Message From: twotankstim [EMAIL PROTECTED] To:

Re: [Axapta-Knowledge-Village] Need Help : Urgent...

Hi Tonz, WHen is it happen? with any form/table or just one? Regards, Khue - Original Message From: axaeffect [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, July 24, 2007 3:31:16 PM Subject: [Axapta-Knowledge-Village] Need Help : Urgent... Hi all, I

Re: [Axapta-Knowledge-Village] Cost Price

Hi , In Axapta, the cost price is base on your model. Standard or Non Standard. The cost price of standard cost can be retrieve on the Item Master (InventTableModule table, ModuleType = Invent) But if you are running FIFO or LIFO or Avg... then you should check the table InventSum, InventDim.

Re: [Axapta-Knowledge-Village] Summary update !!!

Hi , This is a feature allow you to summary many orders into one posting. For example: you have 2 sales order from 2 customer accounts but have the same invoice account. Then you can select 2 orders, and post to invoice. The system then will post 2 orders to 1 invoice. Hope this help. Thanks

Re: [Axapta-Knowledge-Village] Uploading Opening Balances

Hi Vivek, We can use AX 100% for the opening balance upload. GL: via General Journal (ledger account type) AR: via General Journal (customer account type) AP: via General Journal (vendor account type) Inventory: via PL Journal. Hope this help. Khue - Original Message From: vivek

Re: [Axapta-Knowledge-Village] Sorting

Hi Vishal, It not possible for user to sort base on the display fields in reports or forms. But you can try to make a view then use view as datasource in your reports. Hope this help. Thanks. Khue - Original Message From: Agus Riyadi [EMAIL PROTECTED] To:

Re: [Axapta-Knowledge-Village] Printing reports in pdf format

Do you have Adobe Acrobat to installed on the Server/Client? Any license issue? THanks. Khue - Original Message From: Chaminda Kothalawala [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Sunday, May 20, 2007 11:39:21 AM Subject: Re: [Axapta-Knowledge-Village]

Re: [Axapta-Knowledge-Village] Printing reports in pdf format

Hi Chamida, This is normal in AX3... espacially when AX resize the report layout to fit the paper. From my experience, you should design your report control, layout,... with a fixed size. Thanks. Khue - Original Message From: chamindakothalawala [EMAIL PROTECTED] To:

Re: [Axapta-Knowledge-Village] Process add-on

Hi There, You can find the process manfufacturing add-on information from the website of microsoft. This add-on comes from Full Scope. I think it is quite attractive for food-beverage, steel manufacturing... with a lot of functionalities such as co-product and by-product, TQM, FEFO inventory

Re: [Axapta-Knowledge-Village] Invoice arrived before PO received

using Ax 3.0. I just simulated some cases, not the real case. Thanks. Thang - Original Message From: kbi kbi [EMAIL PROTECTED] com To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Thursday, May 3, 2007 9:10:29 PM Subject: Re: [Axapta-Knowledge- Village] Invoice arrived before PO

Re: [Axapta-Knowledge-Village] Invoice arrived before PO received

and Invoice posting, but if I use your way, how can I check the posting and connection. Please show me how to check. Thanks. kbi kbi [EMAIL PROTECTED] com wrote: Hi Thang, You receive invoice but not yet paid, correct? Because you may want to check your goods before paying money to the customer

Re: [Axapta-Knowledge-Village] Invoice arrived before PO received

Hi Thang, You receive invoice but not yet paid, correct? Because you may want to check your goods before paying money to the customer. Then: 1. When received Invoice 1st May: Dr Account Payable -- Cr Unvoucher Invoiced Can you use AP/Payment/Invoice Journal or Invoice Register 2. When PO goods

Re: [Axapta-Knowledge-Village] Classes with Ax Prefix

Hi, These classes are used for AIP programming. You can for example use the class AxPurchTable to create a purchase order from X++ code with inheritance of business logics of Axapta. I would recommend to use these class for your programming purpose. Regards, Khue - Original Message

Re: [Axapta-Knowledge-Village] Localisation patch For China

Hi, Of course the patch is there. You can contact Tectura for the demonstration. www.tectura.com Thanks. - Original Message From: L Kalaiarasi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, April 25, 2007 2:21:37 PM Subject: [Axapta-Knowledge-Village]

Re: [Axapta-Knowledge-Village] Printing to a local network printer through RDP - Dynamics client

Hi Akash, If you connect via RDP to a machine called COMPUTER A, then this computer need to reach your printer via network. You may contact your network administrator for assistance. Hope this help. Thanks - Original Message From: Akash [EMAIL PROTECTED] To:

Re: [Axapta-Knowledge-Village] Diffrent Purch Order ID

Hi Febin, I don't think Axapta Standard can handle this. We have a customer who is running Axapta and they have: ##_2006 for sales order created in 2006 since 2007, they need to create a new sequence number ##_2007 for sales order created in 2007 But you can not run 2 number sequence at

Re: [Axapta-Knowledge-Village] Inventory OBs

Hi Faiqa, I always use PL for import the opening balance not sure that you use Movement journal to have integration with GL on your OB import. INVENTDIMID problem: I think can you import data into InventJournalTable, InventJournalTrans... Then you can write a small job to read through the

Re: [Axapta-Knowledge-Village] Re: printing multiple invoices

Quick additional input of Steeve: if you remove the reset() then you have to reset some global variable manually to get correct invoicing data... regards, Khue - Original Message From: Steeve Gilbert [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday,

Re: [Axapta-Knowledge-Village] how to convert Real value as a string?

Hi Siva, I have tried to use this code. But there is a problem with large amount like 3,000,000,000. This is a bug from data type integer range Do you have any good point to solve this? Thank you very much Khue - Original Message From: Siva kumar [EMAIL PROTECTED] To:

Re: [Axapta-Knowledge-Village] Disable a field on the form

Hi, If you use code, you can try this: purchParmTable_ds.object(fieldnum(PurchParmTable, ApprovedBy)).visible(false); Different from disable form controls: it will disable all the fields (not only one control) which have data source PurchParmTable and data field ApprovedBy. Hope this help

Re: [Axapta-Knowledge-Village] Suggestion Required From Database Masters

Hi, I think you can try using the MS SQL Server Data Transformation Service. Regards, Khue- Original Message From: amit bansal [EMAIL PROTECTED]To: My Group axapta-knowledge-village@yahoogroups.comSent: Thursday, December 29, 2005 4:38:36 PMSubject: [Axapta-Knowledge-Village] Suggestion

Re: [Axapta-Knowledge-Village] Axapta programming version control

Hi, I think you can try this link. We have found it very interesting. http://www.axdata.dk/www_dk/PDF_formater/VSSIntegration_v4.pdf Regards - Original Message From: Andrew Staples [EMAIL PROTECTED]To: Axapta-Knowledge-Village@yahoogroups.comSent: Wednesday, December 28, 2005 1:56:48

Re: [Axapta-Knowledge-Village] Exporting Table

which table do you want to export? some of table can not find on the list, such as DataArea table... Do you have MorphX or X++ liencese??? If you have, then just go to tabe browser and copy data to excel file. regards, khuehello world [EMAIL PROTECTED] wrote:Hi, I checked the

Re: [Axapta-Knowledge-Village] Insert a new Image

Hi Andreas, I don't remember exactly, but you can open AOT, go to form/SysImage from or something like that and add new image as aa resource in AOT. Andreas Rudischhauser [EMAIL PROTECTED] wrote:Hi,does anyone know how to use a new pic as a resource? Yahoo! Personals

[Axapta-Knowledge-Village] Convert MS Word to PDF file

Hi, I need to convert a Word document to PDF file by using X++. Has any body got experience with this? THanks alot for your help Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your

Re: [Axapta-Knowledge-Village] Report Page Break

Hi, If you can override the fetch method of the report. Just add 1 line element.newpager()before sending datasource A. If you don't want to override the method fetch, Then you can override method executesection of body of datasource A. Then type element.newpage() before the super(). Hope this

Re: [Axapta-Knowledge-Village] Number days of a month

hi, try usingnested functions: dayOfMth(dateEndMth(systemDateGet())); hope this helpAlfonso Collados Arroyo [EMAIL PROTECTED] wrote: Hi all: Is there any function that calculates the number of days in a month? Thanks you --This

Re: [Axapta-Knowledge-Village] Company Info table

Of course, it just get the current company info because of dataAreaId column. To list all, you can try this: public static void listCompaniesInfo(){ DataArea dataArea; CompanyInfo companyInfo; ; while select dataArea where dataArea.isVirtual == false{ select companyInfo; //do somthing }

RE: [Axapta-Knowledge-Village] Replace char in string

Hi, Personally, I think you can find many many usefull functions (somtime can be duplicated) from class call Global. Take a look at that class. Have anice day.Alfonso Collados Arroyo [EMAIL PROTECTED] wrote: Thanks, but I found a function: strreplace(Text,Char to Replace,Replace Char

Re: [Axapta-Knowledge-Village] upper limit of open cursors

Stefan, You can go to configuration screen, Database tab, then key in the Max. open cursor. regards, Khue Stefan Heidkamp [EMAIL PROTECTED] wrote: Hi all,we use Axapta 3.0 SP3. Lately we get the following error sometimes:'Microsoft Business Solutions-Axapta's upper limit of open cursors has

RE: [Axapta-Knowledge-Village] upper limit of open cursors

of course, this problem is caused by some programming tech. (I think someone used recursive programming).Jesper Kehlet [EMAIL PROTECTED] wrote: I would take a serious look at the code. It sounds like there is a customization in there that is keeping too many open cursors, and maybe it's not

Re: [Axapta-Knowledge-Village] Documentation needed

hello, try this link: www.axaptalink.com http://mbsonline.org http://www.axapta-links.com have a good day.martin_morsing [EMAIL PROTECTED] wrote: Hello group,While documenting an Axapta solution I need a whole lot of documentation / White Papers etc. on Axapta.Currently I look for * Batch job

Re: [Axapta-Knowledge-Village] X++ Training

me too, please notify me if you know. thanks friendsbigjwman [EMAIL PROTECTED] wrote: I am planning to purchase Axapta for my company. It's going to require a fair amount of programming to meet our needs. Since I will be purchasing the source code, where can I get training to become familiar