[Axapta-Knowledge-Village] How to turn on the AOT in AX2009.CTP3 image
Hi all, Do you have any idea turn on the AOT in AX2009.CTP3 image? The AOT is disabled and i couldn't find anyway to turn on the AOT (the license information shows the AOT is included). Thanks in advance. Best Regards, Jack
Re: [Axapta-Knowledge-Village] Update remaining quantity in PO
Hi Olivia, The purchase quantity is the quantity used in the purchase order whereas the inventory quantity is the 'converted' quantity which is used after the purchased item(s) put into stock. For instance, if item A has the purchase quantity in box and inventory quantity in pcs (which is defined in the item master) and 1 box = 12 pcs. Therefore, when u raise the PO, let say 2 boxes of Item A the system will automatically convert the purchase quantity to 24 pcs for inventory quantity. --- On Mon, 7/21/08, Olivia Devi [EMAIL PROTECTED] wrote: From: Olivia Devi [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Update remaining quantity in PO To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, July 21, 2008, 8:09 AM Hi all, I've got a question regarding function Update remaining quantity in Purchase order. There are Purchase quantity and Inventory quantity. Could anyone please explain to me what's the difference? What does Inventory quantity for? Thanks,
[Axapta-Knowledge-Village] Insert a space between existing Voucher Numbers
Hi all, Will appreciate your help on how to insert a space in between existing voucher numbers, e.g. from 'AP-OP001' to 'AP-OP 001'. My code is as follows but it doesn't work. Appreciate your valuable input. static void remove_VoucherSpace (Args _args) { LedgerJournalTable _ledgerJournalTable ; LedgerJournalTrans _ledgerJournalTrans ; str txt; //txt ='APOP ' ; ttsbegin; while select forupdate _ledgerJournalTrans where _ledgerJournalTrans .Voucher == 'APOP*' { if (LedgerJournalTable ::find(_ledgerJo urnalTrans. JournalNum) .JournalName like 'AP-OP') { _ledgerJournalTrans .Voucher = 'APOP '; _ledgerJournalTrans .update() ; } } ttscommit; info(strfmt( Update completed as of %1, systemdateget( ))); }
Re: [Axapta-Knowledge-Village] Re: Axapta certification
Hi, I did check with the MBS Certification center in US but they mentioned we need to pass the exam as of the latest version (i.e. V 4.0) in order to get the master title. Now the master title has been replaced by Dynamics AX professional title, which requires you to pass at least 4 AX papers. Best regards, Jack Vivek [EMAIL PROTECTED] wrote: Hi, I had the same question and MBS clarified that we can get master certification with a mixture of 3.0 and 4.0 certifications. Any other such questions you can mail to [EMAIL PROTECTED] Thanks Vivek From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sent: Thursday, November 08, 2007 2:44 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Digest Number 1658 http://groups.yahoo.com/group/Axapta-Knowledge-Village;_ylc=X3oDMTJlYXRhaHB kBF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4MARzZWMDaGRyBHN sawNocGgEc3RpbWUDMTE5NDUxMzI2MA-- Axapta Knowledge Village 1a. 4a. http://groups.yahoo.com/group/Axapta-Knowledge-Village/message/16055;_ylc=X 3oDMTJzNmlwMmw3BF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4M ARtc2dJZAMxNjA1NQRzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMTk0NTEzMjYw Re: Axapta certification Posted by: abhay jain mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] http://profiles.yahoo.com/abhay_jain29 abhay_jain29 Wed Nov 7, 2007 10:21 pm (PST) Hi Pramod For being a certified in Axapta u need to write a exam from any of the prometric examination centres. You can find centres from internet. Exam fee is Rs 2100 aprox. 4.0.. is the latest version in Axapta so, its better to pass this certification. But remember Knowledge is must if you want to be a Axapta Proffessional. Regards Abhay Jain samuel pramod mailto:samuelpramod%40yahoo.com [EMAIL PROTECTED] wrote: Hi , What is the criteria to become Axapta certified master. All certifications to be in same version i.e Axapta 4.0 or Axapta 3.0 only or we can have combination of versions i.e some from 3.0 and some from 4.0. Thanks in advance.. Best Regards, Pramod __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com http://mail.yahoo.com [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com http://mail.yahoo.com [Non-text portions of this message have been removed] Back to top mailto:[EMAIL PROTECTED] Reply to sender | mailto:[EMAIL PROTECTED] 0certification Reply to group | http://groups.yahoo.com/group/Axapta-Knowledge-Village/post;_ylc=X3oDMTJzdD Nya3ZxBF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4MARtc2dJZA MxNjA1NQRzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMTk0NTEzMjYw?act=replymessageNum= 16055 Reply via web post http://groups.yahoo.com/group/Axapta-Knowledge-Village/message/15406;_ylc=X 3oDMTM4M3F1OXIwBF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4M ARtc2dJZAMxNjA1NQRzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxMTk0NTEzMjYwBHRwY0lkAzE1N DA2 Messages in this topic (4) 5. [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Anybody tries Demand Planner on AX4?
Hi, May i know anyone of you already tried the Demand Planner on AX4? Any issue encountered so far? From: Jack - Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Filter Records Function
Dear all, The Filter Records function allows user to set up the filtering criteria. However, can i make the the system automatically filter the records (like vendors) when user logs in without using Record Level Security (RLS) function? Best Regards, Jack Koh - Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] How to enable permanent viewing of the inventory dimension fields in the Sales Order line / Journal line?
Hi all, May i know how to enable permanent viewing of the inventory dimension fiels in the sales order lines / journal lines? i know i can set the fields to be visible in the form setup but the setting will be cleared once i delete the usage data. I tried to drag the fields from the datasource to the form design but there are still some controls imposed to make the fields activated / de-activated. Any advise?? Is there any method i've to modified so as to make the inventory dimensions visible? (without the need to set the inventory dimension using the inventory button). Thanks in advance. Best Regards, Jack Koh - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Re: Reconciling Inventory to General Ledger
Hi Steve, Can you import this job and run. In my case the problem is solved after the job is run. Please let me know if u're having the problem again. Note: Pls change the company acccount from ccw to your company account's name in the job. :) Best Regards, Jack Koh stv_bradford [EMAIL PROTECTED] wrote: Thanks Jack I'll very grateful for this help. Steve. --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Steve, I've the same problem also for the Physical Inventory by Inventory Dimension Report (which i use to reconcile to GL stock). What i heard from my programmer is that the financial voucher for the return transactions does not update correctly into inventtrans table and corresponding with the inventtransposting table. He is now in the progress of coming out the bug fix. I'll send to u once i got the fix. Hope Microsoft can take the necessary action to resolve the issue. From: Jack Koh stv_bradford [EMAIL PROTECTED] wrote: In AX Release 3, SP 3, with Inventory hotfixes applied we use the standard report Physical Inventory by Item Group to reconcile the Inventory valuation to the GL. This is done by adding the two columns Inventory Value and Posted Physical Value, and comparing this with the balance in the Inventory Control accounts in the GL. There seems to be bugs in this report however which make the report give wrong information when a Purchase Order or Ssles Order delivery is made, and then reversed on the same line. The report will always pick up the reversal entry even though it has been made at a date later than that at which the report is run. I have two questions: 1 Has anyone else come accross this issue, and 2 Is there another way of generating a report that will validate the balance in the GL? I know about the GL reconciliation reports, but thay are a tool to identify differences, not a valaidation report. Many thanks Steve Bradford Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Re: Reconciling Inventory to General Ledger
HERE is the job: static void Woof_PatchInventFinancialVoucher(Args _args) { InventTransPosting _InventTransPosting; InventTrans _InventTrans; InventTrans _InventTrans2; int matchphys; int matchother; container c; int i; ; if (curext() != ccw) return; ttsbegin; while select forupdate _InventTrans order by Voucher where _InventTrans.DateFinancial != datenull() _InventTrans.Voucher == join _InventTransPosting where _InventTransPosting.InventTransPostingType == InventTransPostingType::Financial _InventTrans.ItemId == _InventTransPosting.ItemId _InventTrans.InventTransId == _InventTransPosting.InventTransId _InventTrans.Voucher != _InventTransPosting.Voucher _InventTrans.DateFinancial == _InventTransPosting.TransDate _InventTrans.VoucherPhysical== _InventTransPosting.Voucher { _InventTrans.Voucher = _InventTrans.VoucherPhysical; _InventTrans.update(); } ttscommit; ttsbegin; while select forupdate _InventTrans order by InventTransId where _InventTrans.DateFinancial != datenull() _InventTrans.Voucher == { matchphys = 0; matchother = 0; c = connull(); while select _InventTransPosting order by Voucher where _InventTransPosting.InventTransPostingType == InventTransPostingType::Financial _InventTrans.ItemId == _InventTransPosting.ItemId _InventTrans.InventTransId == _InventTransPosting.InventTransId _InventTrans.Voucher != _InventTransPosting.Voucher _InventTrans.DateFinancial == _InventTransPosting.TransDate { if (_InventTrans.VoucherPhysical == _InventTransPosting.Voucher) { matchphys++; } else { select firstonly _InventTrans2 where _InventTrans2.Voucher == _InventTrans2.VoucherPhysical _InventTrans2.ItemId == _InventTransPosting.ItemId _InventTrans2.InventTransId == _InventTransPosting.InventTransId _InventTrans2.Voucher == _InventTransPosting.Voucher _InventTrans2.DateFinancial == _InventTransPosting.TransDate; if (_InventTrans2) { if (strcmp(_InventTransPosting.Voucher, _InventTrans.VoucherPhysical) = 0) { matchother++; c = conins(c, matchother, _InventTransPosting.Voucher); } } } } if (matchphys) { _InventTrans.Voucher = _InventTrans.VoucherPhysical; _InventTrans.update(); } else if (matchother == 1) { info(! + : + _InventTrans.InventTransId + : + _InventTrans.ItemId + : + _InventTrans.VoucherPhysical + : + conpeek(c, 1)); _InventTrans.Voucher = conpeek(c, 1); _InventTrans.update(); } else if (matchother 1) { for (i = 1; i = matchother; i++) { info(int2str(i) + : + _InventTrans.InventTransId + : + _InventTrans.ItemId + : + _InventTrans.VoucherPhysical + : + conpeek(c, i)); } _InventTrans.Voucher = conpeek(c, 1); _InventTrans.update(); } else { info(_InventTrans.InventTransId + : + _InventTrans.ItemId + : + _InventTrans.VoucherPhysical + : + _InventTrans.Voucher + : + _InventTransPosting.Voucher); } } ttscommit; } Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Steve, Can you import this job and run. In my case the problem is solved after the job is run. Please let me know if u're having the problem again. Note: Pls change the company acccount from ccw to your company account's name in the job. :) Best Regards, Jack Koh stv_bradford [EMAIL PROTECTED] wrote: Thanks Jack I'll very grateful for this help. Steve. --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Steve, I've the same problem also for the Physical Inventory by Inventory Dimension Report (which i use to reconcile to GL stock). What i heard from my programmer is that the financial voucher for the return transactions does not update correctly into inventtrans table and corresponding with the inventtransposting table. He is now in the progress of coming out the bug fix. I'll send to u once i got the fix. Hope Microsoft can take the necessary action to resolve the issue. From: Jack Koh stv_bradford [EMAIL PROTECTED] wrote: In AX Release 3, SP 3, with Inventory hotfixes applied we use the standard report Physical Inventory by Item Group to reconcile the Inventory valuation to the GL. This is done by adding the two columns Inventory Value and Posted Physical Value, and comparing this with the balance in the Inventory Control accounts in the GL. There seems to be bugs in this report however which make the report give wrong information when a Purchase Order or Ssles Order delivery is made, and then reversed on the same line. The report will always pick up the reversal entry even though it has been made at a date later than that at which the report is run. I have two questions: 1 Has anyone else come accross this issue, and 2 Is there another way of generating a report that will validate the balance in the GL? I know about the GL reconciliation reports, but thay are a tool to identify differences, not a valaidation report. Many thanks Steve Bradford Sharing the knowledge on Axapta. Visit
Re: [Axapta-Knowledge-Village] Reconciling Inventory to General Ledger
Hi Steve, I've the same problem also for the Physical Inventory by Inventory Dimension Report (which i use to reconcile to GL stock). What i heard from my programmer is that the financial voucher for the return transactions does not update correctly into inventtrans table and corresponding with the inventtransposting table. He is now in the progress of coming out the bug fix. I'll send to u once i got the fix. Hope Microsoft can take the necessary action to resolve the issue. From: Jack Koh stv_bradford [EMAIL PROTECTED] wrote: In AX Release 3, SP 3, with Inventory hotfixes applied we use the standard report Physical Inventory by Item Group to reconcile the Inventory valuation to the GL. This is done by adding the two columns Inventory Value and Posted Physical Value, and comparing this with the balance in the Inventory Control accounts in the GL. There seems to be bugs in this report however which make the report give wrong information when a Purchase Order or Ssles Order delivery is made, and then reversed on the same line. The report will always pick up the reversal entry even though it has been made at a date later than that at which the report is run. I have two questions: 1 Has anyone else come accross this issue, and 2 Is there another way of generating a report that will validate the balance in the GL? I know about the GL reconciliation reports, but thay are a tool to identify differences, not a valaidation report. Many thanks Steve Bradford Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Value ## is not found in the Map during Excel Import
Hi all, I tried to preview the data under Data Export / Import using Excel Import, the following message come out Value ## is not found in the Map However i still manage to import the data into Axapta. Can someone tell me what's going on? Best Regards, Jack Koh - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Document Handling - Create Excel worksheet via COM
Dear Somnath, In fact the purpose i'm using the document handling function in this way is to copy certain information from salestable and salesline, for instance to copy SalesId, CustName and the ordered items for a particular order, to another FORMATTED document template in Excel form. The user is only able to do so when they're accessing the Sales Order form and select which particular order to be transferred to a template. The problem now is i am not able to transfer all the saleslines for a particular order to the template, only one line can be transferred. somnath jana [EMAIL PROTECTED] wrote: Dear Koh, I don't think, Axapta does not support u from document management for your specific purpose, as u have not any option to select the sales order for sales line(s). Here the purpose is different in document management. I don't know what is your actual purpose. I am confident, that from document management, u can't fullfil your requirement, what i understood is. I think its better to use export/import. That's your choise. Thanks and regards Somnath Jana Koh Meng Chiat [EMAIL PROTECTED] wrote: Dear Somnath, Actually i'm now making use of the Document Handling function under Basic module Setup Document Management Document Type whereby i can define the attachment type. After i've define the document type and i open the Sales Order and click on document handling button and select the document type i've defined earlier, the sales header is able to transferred to the Excel, however, only one salesline can be transferred even though there are multiple saleslines in my order. Any feedback is much appreciated. Best Regards, Jack Koh somnath jana [EMAIL PROTECTED] wrote: Hi ! Assume that u may select only sales line table on data definition group and have type standard. Use crioterion on table setup form from criteria button give the sales order no. save it and export it. Thanks... Snj Koh Meng Chiat [EMAIL PROTECTED] wrote: Dear all, I've set up the a document type which make use of the job Create Excel worksheet via COM which is able to transfer data from SalesTable and Salesline to the Excel template. My query is, now my Salesline has multiple lines and when i use the document handling function the system is only able to transfer the last line of the Salesline table ( ONE line only) to the Excel template, not all the Saleslines. Can anyone shed some lights on it? Could someone also explain to me the hard return in the Document Type setup means? What is that index used for? Thank you. Best Regards, Jack Koh - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Celebrate Earth Day everyday! Discover 10 things you can do to help slow
[Axapta-Knowledge-Village] Document Handling - Create Excel worksheet via COM
Dear all, I've set up the a document type which make use of the job Create Excel worksheet via COM which is able to transfer data from SalesTable and Salesline to the Excel template. My query is, now my Salesline has multiple lines and when i use the document handling function the system is only able to transfer the last line of the Salesline table ( ONE line only) to the Excel template, not all the Saleslines. Can anyone shed some lights on it? Could someone also explain to me the hard return in the Document Type setup means? What is that index used for? Thank you. Best Regards, Jack Koh - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Document Handling - Create Excel worksheet via COM
Dear Somnath, Actually i'm now making use of the Document Handling function under Basic module Setup Document Management Document Type whereby i can define the attachment type. After i've define the document type and i open the Sales Order and click on document handling button and select the document type i've defined earlier, the sales header is able to transferred to the Excel, however, only one salesline can be transferred even though there are multiple saleslines in my order. Any feedback is much appreciated. Best Regards, Jack Koh somnath jana [EMAIL PROTECTED] wrote: Hi ! Assume that u may select only sales line table on data definition group and have type standard. Use crioterion on table setup form from criteria button give the sales order no. save it and export it. Thanks... Snj Koh Meng Chiat [EMAIL PROTECTED] wrote: Dear all, I've set up the a document type which make use of the job Create Excel worksheet via COM which is able to transfer data from SalesTable and Salesline to the Excel template. My query is, now my Salesline has multiple lines and when i use the document handling function the system is only able to transfer the last line of the Salesline table ( ONE line only) to the Excel template, not all the Saleslines. Can anyone shed some lights on it? Could someone also explain to me the hard return in the Document Type setup means? What is that index used for? Thank you. Best Regards, Jack Koh - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Why there is no marking function in the Transfer Journal?
Hi all, May i know why there is no marking function in the Inventory Transfer Journal? Best Regards, Jack Koh - Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] What's the most appropriate way to do PO adjustments? (Urgent! Please help)
Hi all, I think most of you have encountered that the following problem before: Scenario: Purchase qty 100 per item costs 20 Costing Method : FIFO Common mistakes: 1. Received qty 120 at cost 20 (at packing slip posting) 2. Received qty 100 but wrongly post the cost at 10 (at packing slip posting) 3. Received qty 100 but invoiced qty 120 at cost 20 4 Received qty 100 and invoiced qty 100 but at cost 10 5. Received qty 120 and invoiced qty 120 at cost 20 I know we can do the adjustment in the wrongly posted purchase order line (e.g. put a negative qty to adjust out the qty if posted excess qty ath packing slip) but it is only applicable to adjust the packing slip transaction. If the line is also invoice posted then the adjustment will result in the invoice and packing slip transactions being adjusted at the same date (will this have impact on FIFO costing???). If a new negative line is being created in the purchase order then we have to use Marking function to tag the return cost price to the cost price we intend to make adjustment. If not, the system will post the return cost price at Weighted Average cost and the difference between the return cost is posted to Purchase Consumption account. Moreover, if the Invoice is being posted in a wrong amount but packing slip is posted correctly, is it advisable to use GL journal for adjustment? Will this cause discrepancy between the physical and financial cost? Should i reverse the transaction totally (both invoice and packing slip) and re-post again? There is one thing i also hope someone can shed some lights : The FIFO costing method in Axapta is based on the POSTING DATE (meaning the date the user post the transaction) or TRANSACTION DATE (the date which is input by the users, i.e. packing date/invoice date) ? For what i've discovered is that Axapta is using POSTING DATE. May i know what's the underlying logic for that? Hope the feedback may also help to clear some doubts of Axapta implementers. Thanks in advance. Best Regards, Jack Koh - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] How to import the User Menu from other environment
Hi all, I've created the user menu from File New User Menu and now i want to import that user menu to another environment. May i know i can i do it? I just can't find any function that can export out the user menu. Any help is appreciated. Thanks in advance. Best Regards, Jack Koh - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Will service item being included in the Inventory Closing??
Hi all, Just curious if the service items are included in the inventory closing. Can anyone shed some lights on it? Thank you. Best Regards, Jack - Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Counting journal bug ?
Hi Jens,Can you check on the counting group (and the counting code in the counting group) attached to the item in the item master file? If i not not mistaken if you leave the counting group blank for theitemthen the quantity with zero stock on hand will be included in the counting journal. Jens Strandberg [EMAIL PROTECTED] wrote: Hi there,I was wondering if anyone has experienced this strange behaviour; runningAxapta 3.0 SP3.If I let Axapta create an on-hand counting journal based on warehouse, batchnumber and location, a lot of empty lines are included, i.e. lines with anOn-hand qty of 0.In my case, 7.147 journal lines are produced, but only 527 lines are with aquantity.In the past, I have also produced counting journals based on warehouse andlocation - with the same result - empty lines.Has this been reported as a bug, is there a work-around or am I just missingsomething ?Thanks in advance./Jens Yahoo! Photos Showcase holiday pictures in hardcover Photo Books. You design it and well bind it! Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Inventory value of charged items
Thanks Sun Fen. Really appreciate that. Chen Sun Fen [EMAIL PROTECTED] wrote:Hi Koh Meng,This report is used for service item type. This is useful when you try to reconcile service amount with ledger amount. This report is used because service is not included in inventory value. However, there is still amount that you need to reconcile with ledger. Try to create, lets say a purchase order with item type service and it will come out on your report. Regards, Sun Fen From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Koh Meng ChiatSent: Monday, January 09, 2006 8:27 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Inventory value of charged items Hi all,Can anyone tell me how to use this report? Just couldn't get the report being generated from the system.Best Regards,Jack Koh Yahoo! Photos Showcase holiday pictures in hardcoverPhoto Books. You design it and well bind it! Yahoo! Photos Showcase holiday pictures in hardcover Photo Books. You design it and well bind it! Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] How to use Settlement Type : Designated Transactions in the Sales Order header
Hi all,Can anyone tell me how to use the Settlement Type: Designated Transactions in the Sales Order header?It seems no difference with the Settlement Type: None. Thanks in advance.Best Regards,Jack Koh Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Inventory value of charged items
Hi all,Can anyone tell me how to use this report? Just couldn't get the report being generated from the system. Best Regards,Jack Koh Yahoo! Photos Showcase holiday pictures in hardcover Photo Books. You design it and well bind it! Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Export out all the security keys for a given user group into Excel
Hi all, Is that possible to export out all the security keys for a given user group into Excel? May i know how to perform the export? Thanks in advance. Best Regards, Jack Koh Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Re: Not able to do RAF
Hi all, Forgive my ignorare. Can someone tell me what's RAF journal?"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi Pritam Your conclusion is correct. Please visit my site www.systomatics.biz and read thediscussion on InventMovement class where I have (tried to)explain the logic. **In my case I think when user has deleted un-posted RAF journal child reference has not got removed.** This is a bug in standard system and (me thunks) it happens because of different cachelookup property on the journal header and journal lines. This happens even with BOM journals.I tried to log this call but wastoldit cannot be logged since it cannot be replicated. Right now the only solution is to stop allowing users from deleting the journal linesfrom the header. If they want to delete a journal, then click on lines toopen the lines form, delete the lines and then delete theheader. Simple modification (just change the delete action from cascade to restricted) regards harry Pritam [EMAIL PROTECTED] wrote: = Checkbox "automatic addition" on inventory parmaeters is checked.= Item or warehouse is not marked for quarantine.= There is no customization done.I think this is the bug as Herry and Gokhan have mentioned.When users make on Production Order with qty 70 it creates one Inventory Transaction line.When users post one RAF journal with qty 5 it splits 70 into 65 and 5. The status of 70 is Ordered and status of 5 is received.When users create one more RAF journal with qty 9 it splits 65 into 56 and 9. The status of 56 is Ordered and has no Inventory reference, status of line with qty 9 is also Ordered but Inventory Reference is filled as "Report as finished Journal".In my case I think when user has deleted un-posted RAF journal child reference has not got removed.I have checked the code of RAF update. While picking up transaction lines Axapta picks up lines having no reference. Hence quantity do not balance and throws error.Please suggest any solution to stop this ? Or suggest if above conclusion is wrong. I am using Axapta 3.0 with service pack 3.0Thanks in advancePritam Karkhanis--- In Axapta-Knowledge-Village@yahoogroups.com, "Harry \(Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi 1. The problem with the deletion of RAF journal.. Did you delete the RAF that has been posted ? If yes, then Axapta will keep the child references. If you are deleting RAF that has not been posted then Axapta should remove the child references (in reality it sometimes does not, this is a bug in standard axapta). 2. Splitting of the inventtrans. Do you have any transactions that are registered etc? is the checkbox "automatic addition" on inventory parameters checked? 3. second line of 65 where you do not have any reference number is serious. Have you done any modifications? 4. I am stumped as to why you should get an error while posting a quantity of zero? Can you reproduce this in standard system? May be the problem will go away when you fix the above problem (number 3) regards harry Gokhan Can [EMAIL PROTECTED] wrote: v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);} We faced the same kind of error a lot of times. When you create a RAF journal and delete it or we could not find actually after which action ; Axapta split inventtrans in to 2 lines and Keep RAF referance on Inventtrans ( TransChildRefID and TransChildRefType ) and this is dangling referance.When you delete that Referance from inventtrans probably the problem will be fixed but I am asking the same question does anybody know what is the real action Cause this error bucause we opened and indicent but could not tell the real reason so we could not fix the bug. Gokhan- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-[EMAIL PROTECTED] On Behalf Of Pritam Sent: Monday, September 26, 2005 2:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Not able to do RAF Dear gurus I am facing below problem in Axapta. I have a Production Order of quantity 70. It has one RAF journal with good quantity 5. So when I check Inventory-Transaction I think it should show 2 lines as follows.. (1) Ordered = 65 (2) Raf = 5 But in my case it shows 3 lines (1) Ordered = 9 (2) Ordered = 56 (2) Raf = 5 For the first Line which is having quantity 9, Inventory reference columns (Inventory reference Number) are filled. Second line has no reference attached. When I try to do RAF without any quantity to update Production Order's status from Route Consumption to RAF I get below error "Quantity ordered cannot be reduced, as there are not enough open inventory transactions with the Ordered status. The items are Purchased, Received or Registered" This happens because while updating status to RAF, records got picked up with status Ordered and having blank reference fields. Axapta
[Axapta-Knowledge-Village] How to use physical posting in Inventory Management Module Periodic
Hi all, Can anyone tell me when and how to use physical posting in inventory management module periodic. I just couldn't find any document / help file for that function. Thanks a lot. Best Regards, Jack Koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Post estimates peridically in Inventory Parameters
Hi all, Just wonder how to use the post estimates peridically in Inventory Parameters (Inventory Management Setup folder Parameters). I've tested the fuction. If I checked that function system won't post any ledger transaction if my packing slip is posted. It seems like the function works in the same way as post packing slip in ledger in AR / AP parameters. Cany anyone shet some lights on it? Thanks a lot. :) Best Regards, Jack Koh __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Variance in Workcenter
Hi all, May i know how to use the variance button in the workcenter form? Is that for me to create a different date from what is stipulated for the workcenter? I tried to run the job scheduling and the system just follows the workcenter's date instead of the variance date. Anything goes wrong? Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hh9pe0o/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123732328/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] SAP Business One or Microsof Axapta
Hi all, I've been working in Axapta for couple of years and now thinking to change the product line. There are few offers for me now and i'm now thinking to choose SAP to be my next career advancement. Any advice? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hak4mtd/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123475398/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Is Axapta certified by any professional body?
Hi all, Question from one of my prospects: Is Axapta certified by any professional body like ACCA, IACW, ISO etc?? This will be great if we as a consultants can show to our potential clients that Axapta is a great product and is being recognised and certified by some Professional bodies. Appreciate for any feedback. Thanks in advance. Best Regards, Jack Koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Citrix Server Login
Hi all, I've set up a Citrix Server in my office LAN and tried to login remotely using Citrix client program using dial up connection and VPN. Just curious why the 1st time i login Citrix will take quite long to load the Axapta Application but much more faster in second / subsequent login. Is that anyway i can make the 1st login to be faster? Thanks in advance. Best Regards, Jack __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] How to avoid a gap in Number Sequence?
Hi all, I think most of you have probably have encounter this before. Once the user creates a new voucher, say in General Journal lines, a new number will be assigned by the system automatically according to the number sequence setup. If the user deletes the voucher transaction before posting, the voucher number will be cached in the system for reuse. (Note: I found out the clean up function in number sequence form is not really working properly, does anyone encounter the same problem?) A senario given as follows: User A creates a new voucher number 10 in GL journal lines. Subsequently when User B create a voucher in the lines again, the number will be 11. If User B deletes the voucher before posting, the voucher number 11 will be stored in the system so that when User C creates a new transaction in the line, number 11 will be reused. However, sometimes instead of number 11 being picked up, the system will assign 12 to the voucher number, causing a gap in the voucher number. This will create problem when a system audit is performed, one may doubt about the completeness and integrity of the transactions as the voucher number is not continuous. Can anyone explain on this? Thanks in advance. Best Regards, Jack Koh __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Group and print Multiple Deliver Orders into one Sales Invoice
Hi John, Thanks a lot. Really appreciate your advice. :D Best Regards, Jack --- John Studevant [EMAIL PROTECTED] wrote: Hi Jack, As I understand it, depending on how you set the a/r parameters summary update tab, multiple packing slips will be invoiced on the same invoice. Please see the attached document for sugested settings. Jack Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi John, Thanks for your prompt reply.:D I know Axapta can handle multiple orders into one invoice but in most of the circumstances, the invoice itself can contain multiple PACKING SLIPS. May i know how can i group them into once invoice? Thanks in advance. Best Regards, Jack Koh --- John Studevant [EMAIL PROTECTED] wrote: Yes, please look at the accounts receivable parameters Summary update tab. Base on the summary update paraeteres you set Axapta will summerize multiple orders into one invoice. Jack Studevant Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all, What i know is Axapta can group and print multiple Sales Orders into one Sales Invoice. Does anyone knows can Axapta group and print multiple Delivery Orders into one Sales Invoice for the same invoice account? Thanks in advance. Best Regards Jack Koh - Yahoo! Mail Stay connected, organized, and protected. Take the tour Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Group and print Multiple Deliver Orders into one Sales Invoice
Hi all, What i know is Axapta can group and print multiple Sales Orders into one Sales Invoice. Does anyone knows can Axapta group and print multiple Delivery Orders into one Sales Invoice for the same invoice account? Thanks in advance. Best Regards Jack Koh Yahoo! Mail Stay connected, organized, and protected. Take the tour Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Group and print Multiple Deliver Orders into one Sales Invoice
Hi John, Thanks for your prompt reply.:D I know Axapta can handle multiple orders into one invoice but in most of the circumstances, the invoice itself can contain multiple PACKING SLIPS. May i know how can i group them into once invoice? Thanks in advance. Best Regards, Jack Koh --- John Studevant [EMAIL PROTECTED] wrote: Yes, please look at the accounts receivable parameters Summary update tab. Base on the summary update paraeteres you set Axapta will summerize multiple orders into one invoice. Jack Studevant Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all, What i know is Axapta can group and print multiple Sales Orders into one Sales Invoice. Does anyone knows can Axapta group and print multiple Delivery Orders into one Sales Invoice for the same invoice account? Thanks in advance. Best Regards Jack Koh - Yahoo! Mail Stay connected, organized, and protected. Take the tour Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report
Hi Harry, Just want to check. Where / how can i analyze the variances between Inventory and GL? Can i break down the variances into its detail transactions? Thanks in advance. Best Regards, Jack Koh --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Try this run the same report as of a date less than the go live date say 1 Jan 1990 and see if the physical inventory report prints this amount? regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Harry, Yes. We're currently facing some problems as the discrepancies between inventory on hand and GL inventory are hard to trace. For example, if there is a difference of 1511.02 between inventory and GL, how can one identifies the causes of the differences? Do appreciate your valuable advice. :) Thanks in advance. --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi The way our client does this is that he reconciles the total of physical value with the gl balance as of a particular date. are u facing any problems with this? regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Harry, Thanks for your prompt reply. Just curious how should the user perform Inventory reconciliation with GL. The steps should it be: 1. Print out Pyhsical Value by Item Group Report in Inventory Management Module as of closing date (ideally month end) 2. Print out Ledger Transaction List in General Ledger Module. OR Print out Reconciliation report (GL Reports Reconciliation Inventory)?? 3. Compare both reports and find out the unreconciling items?? Appreciate your valuable advice. Best Regards, Jack Koh Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi 1. Yes 2. known value is invoice updated SO/PO, costed production orders etc. Anything before that is floating. (I hope). regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all, 2 questions: 1. Can i use Pyhsical Value by Item Group Report to reconcile with my GL stock? I think most of you had encountered this before as there is no specific report in inventory module which can help to reconcile with your GL. (Note: The inventory reconcilation report does not provide sufficient information in terms of GL stocks and stock value in inventory) 2. What is the Known Value column in Physical Value by Item Group Report? Appreciate any help. Thanks in advance. Best Regards, Jack Koh Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - 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!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - 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. === message truncated === __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report
Hi, I've tried to use the Reconciliation Report in GL. But it still impossible to reconcile the GL balance with the Physical value by item group report. Any idea? --- Steve Wright [EMAIL PROTECTED] wrote: Try this menu... General Ledger Reports Reconciliation. You will find Inventory in there. S. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Koh Meng Chiat Sent: Thursday, 23 June 2005 3:57 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report Hi Harry, Just want to check. Where / how can i analyze the variances between Inventory and GL? Can i break down the variances into its detail transactions? Thanks in advance. Best Regards, Jack Koh --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Try this run the same report as of a date less than the go live date say 1 Jan 1990 and see if the physical inventory report prints this amount? regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Harry, Yes. We're currently facing some problems as the discrepancies between inventory on hand and GL inventory are hard to trace. For example, if there is a difference of 1511.02 between inventory and GL, how can one identifies the causes of the differences? Do appreciate your valuable advice. :) Thanks in advance. --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi The way our client does this is that he reconciles the total of physical value with the gl balance as of a particular date. are u facing any problems with this? regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Harry, Thanks for your prompt reply. Just curious how should the user perform Inventory reconciliation with GL. The steps should it be: 1. Print out Pyhsical Value by Item Group Report in Inventory Management Module as of closing date (ideally month end) 2. Print out Ledger Transaction List in General Ledger Module. OR Print out Reconciliation report (GL Reports Reconciliation Inventory)?? 3. Compare both reports and find out the unreconciling items?? Appreciate your valuable advice. Best Regards, Jack Koh Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi 1. Yes 2. known value is invoice updated SO/PO, costed production orders etc. Anything before that is floating. (I hope). regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all, 2 questions: 1. Can i use Pyhsical Value by Item Group Report to reconcile with my GL stock? I think most of you had encountered this before as there is no specific report in inventory module which can help to reconcile with your GL. (Note: The inventory reconcilation report does not provide sufficient information in terms of GL stocks and stock value in inventory) 2. What is the Known Value column in Physical Value by Item Group Report? Appreciate any help. Thanks in advance. Best Regards, Jack Koh Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com === message truncated === __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report
Hi Harry, Thanks for your prompt reply. Just curious how should the user perform Inventoryreconciliation with GL. The steps should it be: 1.Print out Pyhsical Value by Item Group Report in Inventory Management Module as of closing date (ideally month end) 2.Print out Ledger Transaction List in General Ledger Module. OR Print out Reconciliation report (GL Reports Reconciliation Inventory)?? 3. Compare both reports and find out the unreconciling items?? Appreciate your valuable advice. Best Regards, Jack Koh "Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi 1. Yes 2. known value is invoice updated SO/PO, costed production orders etc. Anything before that is floating. (I hope). regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all,2 questions: 1. Can i use Pyhsical Value by Item Group Report toreconcile with my GL stock? I think most of you hadencountered this before as there is no specific reportin inventory module which can help to reconcile withyour GL. (Note: The inventory reconcilation reportdoes not provide sufficient information in terms of GLstocks and stock value in inventory)2. What is the "Known Value" column in Physical Valueby Item Group Report? Appreciate any help.Thanks in advance.Best Regards,Jack Koh Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.comSharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. 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.
Re: [Axapta-Knowledge-Village] Need to know, How have MBS-Axapta Certify
Hi, I've passed Finance, Trade Logistics, Project and Production. Thinking to take installation and configuration next month. My advice is, certification does give you some goodies and certainly will increase your market value when you seek for axapta job. But do involve in practical, real life project. Certification can help you to be in certain extents, but not to be a well-versed consultant. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: lolll... ok.. Did you give an attempt or still thinking if its easy or hard?. OOPS!. Did I give you any useful advice to you ?. ok. I gave couple of times before I pass the exam First attempt is always to know 'How Easy' the exam is.. Hurry up dude. Give a first attemptthen you know the answer by yourself Good Luck, subbu Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi I think the people who are certified will certainly tell you that it is very easy. regards harry Arthitng [EMAIL PROTECTED] wrote: Hey, for MBS AXAPTA Certify. Is its easy or not? Who is have certify, Please be share your experienend. Thanks. Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - 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. - Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Urgent : Weighted Average Cost Calculation in Axapta
Hi Ali, This is the slide i get from Microsoft Training. Sorry that i just couldn't recall how the system calculate 900.10 (Weighted Avearge) and 909.18 (Weighted Avearage Date) after inventory closing. No matter how i tried i still couldn't get the figure. :( Could anyone shed some lighst on it?? Thanks in advance. --- Ali KESKIN [EMAIL PROTECTED] wrote: Dear Koh, On slide 2, WA method, axapta take account all entries until the Inventory closing date (I dont know what is it your example, but probably it is 5/31/2005). On slide 3, WA-Date method, axapta take account all entries until the transaction date ( In your example it is 5/20/2005). Best regards, Ali KESKIN -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Koh Meng Chiat Sent: Monday, June 20, 2005 5:12 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Urgent : Weighted Average Cost Calculation in Axapta Hi all, Could anyone shed some lights on the weighted average cost calculation(as attached) in Axapta? How does the system calculate 900.10 (Weighted Avearge) and 909.18 (Weighted Avearage Date) after inventory closing? Appreciate if any help is given. Thanks in advance. Best Regards, Jack Koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report
Hi all, 2 questions: 1. Can i use Pyhsical Value by Item Group Report to reconcile with my GL stock? I think most of you had encountered this before as there is no specific report in inventory module which can help to reconcile with your GL. (Note: The inventory reconcilation report does not provide sufficient information in terms of GL stocks and stock value in inventory) 2. What is the Known Value column in Physical Value by Item Group Report? Appreciate any help. Thanks in advance. Best Regards, Jack Koh Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Re: Need to know, How have MBS-Axapta Certify
Hi, I can't give you the questions but to advise you to go through a hard way to study all the study materials. There is no point just to pass the exam but you're not really understand the system. If you need any study material probably i can send to you via email. :) Best Regards, Jack --- shaliaziznew [EMAIL PROTECTED] wrote: hi , i will enter the trade and logistics exam , please if u can help me by sending questions for this exam and also for any othres exams or any advise .. i will apreciate this . best reagrds --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi, I've passed Finance, Trade Logistics, Project and Production. Thinking to take installation and configuration next month. My advice is, certification does give you some goodies and certainly will increase your market value when you seek for axapta job. But do involve in practical, real life project. Certification can help you to be in certain extents, but not to be a well-versed consultant. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: lolll... ok.. Did you give an attempt or still thinking if its easy or hard?. OOPS!. Did I give you any useful advice to you ?. ok. I gave couple of times before I pass the exam First attempt is always to know 'How Easy' the exam is.. Hurry up dude. Give a first attemptthen you know the answer by yourself Good Luck, subbu Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi I think the people who are certified will certainly tell you that it is very easy. regards harry Arthitng [EMAIL PROTECTED] wrote: Hey, for MBS AXAPTA Certify. Is its easy or not? Who is have certify, Please be share your experienend. Thanks. Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - 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. - Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Urgent : Any report can see the difference between Inventory and GL
Hi all, May i know is there any report i can use to track the difference between GL and Inventory? The reconciliation reports in GL are really crappy and the user won't be able to see those difference in detail between these Inventory and GL. Thanks a lot. Best Regards, Jack Koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Definition of Critical On hand inventory
Hi all, Could someone tell me what is the meaning of critical on hand inventory?? Thanks in advance. Best Regards, Jack Koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/