[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/
Re: [Axapta-Knowledge-Village] Re: Intercompany Sales Order and Purchase Order
Thanks. It solves the problem ! vshan12_rao [EMAIL PROTECTED] wrote: Hi,You need to set the customer code as an external code in the Vendor Master. Under the Gateway /Organisation/Partners setup Set the Handling Vendor Numbers to 'External'-- In Axapta-Knowledge-Village@yahoogroups.com, "thehbiz" [EMAIL PROTECTED] wrote: did you set your intercompany relationship under Basic/Setup/Gateway/Organisation? This is the starting point for setting Possible actions where for each ction you have to set the External code for Customer and Vendor. --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng [EMAIL PROTECTED] wrote:Hi all,When i want to create a Intercompany Sales Order the following messeage appears and the system stops me from creating Sales Order. " Conversion of Customer code was not specified" May i know is there any setting i miss out? Thanks in advance.Best Regards,Jack Koh__ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.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. 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.
[Axapta-Knowledge-Village] Intercompany Sales Order and Purchase Order
Hi all, When i wantto create a Intercompany Sales Order the following messeage appears and the system stops me from creating Sales Order. " Conversion of Customer code was not specified" May i know is there any setting i miss out? 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Problem Initializing database
Hi all, I'm using Axapta V3 SP2 2 tier and SQL 2000 which is running on SP3a . After i've installed Axapta immeadiately when i open the application, the following problem arises: Problem initializing database "The Program is unable to load and execute the class 'SqldatabaseInit', which is essential in order to identify the database vendor , and load the appropriate SQL system variables. This can be caused by insufficient access rights to the SQL Database, a missing corrupted application file, or syntax error(s) within the class itself." Thus i was uable to get into the system and compile the application. Can anyone advise on solving the problem? Thousand 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile
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 looking at the posted transaction you can determine which account to be used. ppcheah70 [EMAIL PROTECTED] wrote: Hi allI 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 system use the posting profile what is the recommad account to use.Regardspp.cheahSharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Axapta will be phased out after 2 years?
Hi all, I heard a news from my friends working in MBS Canada that Axapta will be phased out after 2 years. May I know is this true or just another grapewine? __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 Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Customer Data Import to Axapta Document Handling
Hi all, Ihave a question about master data import. Nowour customer decided to use document handling on customer master because there are no field to input long name (100 bytes) in customer master. Can we import customer master data to customer master and document handling? Or is there anyway i can import the name? Please let me know. 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Customer Data Import to Axapta Document Handling
Hi HK, Thanks for your detail explanation. :)Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, Before doing all what is described below, does your customer installation,wants the 100 char Nameon some formsor they want it to be on Forms and printed on all external documents ? The answer to this questioncould define what solution you want to adopt. You may have an additional field added which suits your requirement, or probably you will have to do the following Pre-reqs, (I hope you must have setup these prior in your implementation) 1. Activate the Document Handling for Customer Master 2. Create a Document type of type Note, may be you can create a new just for Customer master called "Long Name". Import the Customer Name in DocuRef table, remember that you will need the following to import A) The Table Id for Customer Master B) The RecId for Customer as DocuRef table links the Notes and keeps references by the Master table recid. Also if you are using CRM then you will need the BusRel field to be populated. HK. Koh Meng [EMAIL PROTECTED] wrote: Hi all, Ihave a question about master data import. Nowour customer decided to use document handling on customer master because there are no field to input long name (100 bytes) in customer master. Can we import customer master data to customer master and document handling? Or is there anyway i can import the name? Please let me know. 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. Do you Yahoo!?Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: AW: [Axapta-Knowledge-Village] How to allocate the miscellaneous charges to the item cost after PO is posted?
Hi Tau, I tried to do the miscellaneous charges allocationto posted PO by accessingInquiriesbutton Invoice Misc. Charges Adjustment but i was unable to set up the Misc. Charges Code. May i know what is the reason? Thanks in advance. [EMAIL PROTECTED] wrote: Hi Jack, in Axapta 3.0 SP3 go to: Accounts payable / Purchase order. Select your PO (Status is invoiced) Button Inquiries / Invoices Select your invoice, then button Misc. Charges / Adjustment. That's all Mit freundlichen Grüßen / Yours sincerely / Med venlig hilsen Thomas Aulbert Berater / Consultant Columbus IT Partner Deutschland GmbH Oeynhausener Straße 48-54 32584 Löhne, Deutschland tel +49 5732 902-0 fax +49 5732 902-599 mailto:[EMAIL PROTECTED] http://www.columbus-it.com Our journey is together! -Ursprüngliche Nachricht-Von: mchiat [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 4. Januar 2005 09:35An: Axapta-Knowledge-Village@yahoogroups.comBetreff: [Axapta-Knowledge-Village] How to allocate the miscellaneous charges to the item cost after PO is posted?Hi all,Can axapta allocate the miscellaneous charges (landed costs, packing slip duty, etc) on top of the item costs after PO is posted? What i know is that axapta will only allocate the miscellaneous charges to the item cost before PO invoice is posted.Thanks in advance.Best Regards,Jack Koh Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. 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: AW: AW: [Axapta-Knowledge-Village] How to allocate the miscellane ous charges to the item cost after PO is posted?
Hi Tau, I'm using SP3 and i was unable to fill in the Misc Charges Code in the adjustment form under PO Inquiries Invoice Misc. Charges button adjustment. I tried to set up the Misc. Charges Code by going to Main Table but was unable to see it in the drop-down in the adjustment form. May i know anything goes wrong? Thanks. [EMAIL PROTECTED] wrote: Whats your Service-Pack? Is it 3? As far as I know this will work only in SP3. Are you able to fill in the code for the Misc. Carges or what is your exact problem. Please describe it a little bit more, that will help me to investigate your problem. . Looking forward to your answer Tom -Ursprüngliche Nachricht-Von: Koh Meng [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 4. Januar 2005 17:51An: Axapta-Knowledge-Village@yahoogroups.comBetreff: Re: AW: [Axapta-Knowledge-Village] How to allocate the miscellaneous charges to the item cost after PO is posted? Hi Tau, I tried to do the miscellaneous charges allocationto posted PO by accessingInquiriesbutton Invoice Misc. Charges Adjustment but i was unable to set up the Misc. Charges Code. May i know what is the reason? Thanks in advance. [EMAIL PROTECTED] wrote: Hi Jack, in Axapta 3.0 SP3 go to: Accounts payable / Purchase order. Select your PO (Status is invoiced) Button Inquiries / Invoices Select your invoice, then button Misc. Charges / Adjustment. That's all Mit freundlichen Grüßen / Yours sincerely / Med venlig hilsen Thomas Aulbert Berater / Consultant Columbus IT Partner Deutschland GmbH Oeynhausener Straße 48-54 32584 Löhne, Deutschland tel +49 5732 902-0 fax +49 5732 902-599 mailto:[EMAIL PROTECTED] http://www.columbus-it.com Our journey is together! -Ursprüngliche Nachricht-Von: mchiat [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 4. Januar 2005 09:35An: Axapta-Knowledge-Village@yahoogroups.comBetreff: [Axapta-Knowledge-Village] How to allocate the miscellaneous charges to the item cost after PO is posted? Hi all,Can axapta allocate the miscellaneous charges (landed costs, packing slip duty, etc) on top of the item costs after PO is posted? What i know is that axapta will only allocate the miscellaneous charges to the item cost before PO invoice is posted.Thanks in advance.Best Regards,Jack Koh Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - You care about security. So do we. 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.
[Axapta-Knowledge-Village] Minimum Average Quantity in Item Master form
Hi all, Can anyone tell me what is the usage of minimum average quality field in Item Other Minimum Average Quantity field? The explanation for the field is " In this field you specify the quantity to be used as minimum in average settlements when inventory is closed. You should only specify a value in the field if the company account uses the inventory model Average or Average Date (Weighted average) specified in the Inventory forecast model field in Inventory model groups. If you have selected one of the models but have not filled in a value in the Minimum average quantity field or in Minimum average quantity, so that the field is given the value 0, the program will settle the quantity with the default 1." I really don't have any idea of how to use the field. Can anyone enlighten me on this? Thank you and Merry X'Mas to all of you ! 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 Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Item Alternative in Axapta
Hi all, I've a question here. The scenario is: I've Item A with qty of 10 and I've set the alternative item for Item A to be Item B if there is insufficient qty for Item A (Use = Nothing in Inventory under Item form Other ). Now i've a Sales Order which wants to ship 11 units of Item A. The system will immediately change Item A to Item B once it finds that Item A has no sufficient qty. How can i make the system to ship out 10 units of Item A and the extra 1 qty to be Item B? Is there any setting i overlook? Thousand thanks in advance and merry christmas to u all. :) 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 Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Posting Errors !
Hi Jim and Girish, Hurray ! I managed to solve the problem already ! The problem is caused by the fields in the DB whereby in the Excel template it appears to be 2 decimal points but in DB it becomes 2 decimal points. One thing i need to ask is: Why in Excel template i've already formatted the amount fields to be 2 decimal points but in DB it appears differently. Anyway really thanks for your help ! If next time u all have a chance tovisit Malaysia please let me know soIcan be your tourist guide. :) Jim Jo [EMAIL PROTECTED] wrote: Hi Meng, Did you try the manual process thatI suggested for the lines marked red aafter the validate journal ??? Regs JimKoh Meng [EMAIL PROTECTED] wrote: Hi Jim and Girish, Attached is my posting errors. The thing i find it strange is that my GL Journal has 1005 lines but only certain lines got this error. Appreciate for any feedback. Jim Jo [EMAIL PROTECTED] wrote: Hi Girish, Thats true that you have said. But really I ahve not gone though these tables :). Yep you are rit that when you use the general journal for opening balances before go live .. after the import you will get a lot of validation errors.buti dont find it really good to ask the user to enter the transactions manually when they have junk of data!. If you are very sure that your credit/ debit balances then the error is mainly of data that has been caused by axaptas excel import. Belive me I just did the same 3 days back .. yep after the excel import to the lines there were a lot of errors .. but I was able to get rid of all those errors in less than 2 hours. Some of the clues that I got I have already posted. hope you have read that. This may not be the right way to do it, but am sure this is the easiest way to do it!. Amount too little is a strange error, it has nothing to do with your setup. I got the same error. What i did was ,identified the line, jus modified the line , then again reset it back to the original. After that validate again . .ERROR is gone. I really suspect this is cuz of some update that didnt happen during the import. But you did a modify something got updated and it all went right!! . I would liek to investigate what happened , but always as usuall there is not time for that. New new issues comes up daily. Fun trouble shooting all.!! Jack please keep posted of errors !! if you still have. Would be able to give some suggestions !!! Regards Jim Girish B [EMAIL PROTECTED] wrote: Hi Jim, May be you could import the transactions directlyand post but I had tried in a few times and keptgetting errors.When I see the LedgerjournalTransDaily table, I seethat there is one more table in the datasourceCustVendPaymJournalFee . I dont know exactly whatis saved in this table because when I checked itthrough the table browser it shows empty. When I check the way the line is createdmanually the system uses the LedgerJournalEngine(class) to check and calculate the data for theLedgerJournalTrans table. I remember I had used thesame way to populate the table. If we can successfully post after importing thelines then it would be the best thing. Jack, if you succeed in posting the journals dolet us know what else you needed to do to solve theproblem, it would be useful to all of us.Cheers,Girish--- Jim Jo [EMAIL PROTECTED] wrote: How many of your vouchers are marked red ??? Is it possible for you manually modify and save those vouchers from axapta? If so do this. For ex if the credit amount of the voucher is 100. delete the 100 and save. Then again enter the 100 and save. Then do a validate again. This is a data error caused on import. I had faced the same errors. Hope it helps Jim Koh Meng [EMAIL PROTECTED] wrote: Hi Jim, Thanks for your prompt reply. I've check the transaction total using sql and i find the total debit and credit are balance and tally to each other. Actually what does 'amount too little' mean? I've checked those vouchers marked in red and i found all the vouchers are ok and they have the same values with those posted vouchers (i checked it at the backend). I really don't have any idea what's turn out to be wrong. Please help. Jim Jo [EMAIL PROTECTED] wrote: Seems like your vouchers does not balance .. credit and debit must balance in a double entry system! check that first. And the amount too little is jus another data error. You have to identify the vouchers which are marked red. Then jus modify and save the vouchers. That will do !. If you still have problems do lemme know! Regards Jim. Koh Meng [EMAIL PROTECTED] wrote: Hi all, I'm in the midst of doing GL data migration using Axapta Excel Template (LedgerJournalTable and LedgerJournalTrans). After I loaded the GL Opening Balances into General Journal and tried to do the posting, an error message threw out and stopped me from posting (see attached). Can anyone help me to solve it? Thousands thanks in advance. Best Regards, Jack Koh - Do you Yahoo
Re: [Axapta-Knowledge-Village] Posting Errors !
Hi Jim, Thanks for your prompt reply. I've check the transaction total using sql and i find the total debit and credit are balance and tally to each other. Actually what does 'amount too little' mean? I've checked those vouchers marked in red and i found all the vouchers are ok and they have the same values with those posted vouchers(i checked it at the backend). I really don't have any idea what's turn out to be wrong. Please help. Jim Jo [EMAIL PROTECTED] wrote: Seems like your vouchers does not balance .. credit and debit must balance in a double entry system! check that first. And the amount too little is jus another data error. You have to identify the vouchers which are marked red. Then jus modify and save the vouchers. That will do !. If you still have problems do lemme know! Regards Jim.Koh Meng [EMAIL PROTECTED] wrote: Hi all, I'm in the midst of doing GL data migration using Axapta Excel Template (LedgerJournalTable and LedgerJournalTrans). After I loaded the GL Opening Balances into General Journal and tried to do the posting, an error message threw out and stopped me from posting (see attached). Can anyone help me to solve it? Thousands thanks in advance. Best Regards, Jack Koh Do you Yahoo!?Yahoo! Mail Address AutoComplete - You start. We finish. Sharing the knowledge on Axapta. ATTACHMENT part 2 application/msword name=Posting Errors.doc Do you Yahoo!?Yahoo! Mail Address AutoComplete - You start. We finish. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Consistency Check in Axapta
Hi all, I remember there is a function called Consistency Check which resides in GL, AP and AR module for Axapta 2.5 which is to check the data inconsistencies in the system. Just wonder where is that fuction in Axapta 3.0. I could not locate the fuction at all. Best Regards, Jack Koh Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Multiple accounting book
Hi all, Just for curiosity. Do u know what is operations layer used for? From what i know Current layer is the default layer for posting whereas Tax layer is used to post any tax-related transaction. Any feedback is much appreciated. Thanks Sun Fen [EMAIL PROTECTED] wrote: Hi Ferry, You can determine the posting using the posting layer. Set the posting layer at Journal name setup. You can see the balances for each book using the Chart of accounts-Setup-Balance. Any transactions related to that book can be seen from most general ledger journals inquiries and reports by selecting the posting layer under the select button. For fixed asset, you can set the value models based on the book also. Regards, Sun Fen - Original Message - From: Ferry Sentoso Nugroho To: [EMAIL PROTECTED] Sent: Thursday, September 09, 2004 5:57 PM Subject: [Axapta-Knowledge-Village] Multiple accounting book Hi... Does anybody have experience on doing multiple accounting bookin Axapta? Any feedbackwill be appreciated. Thanks. regards, Ferry SN.Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Shop for Back-to-School deals on Yahoo! Shopping. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
