RE: [Axapta-Knowledge-Village] Invoice account vs order account in AR.
Hi Hennie Potgieter Did you get the solution to the query mentioned below? If yes, do share with me, as i see it an interesting scenario. My thoughts on it, assuming that i have understood the scenario correctly. 4 things can work in tandem. GL Account with Account Type as 'Total' Customer Groups Invoice Account Customers To have a Umbrella account for all the Customers, one can link all the Customer Groups to a particular GL Account. This will enable one to get all the Customer transactions in one single GL account. Now, say for instance, one has 10 different customers. Out of which 5 are dealing with Raw Material. This can be grouped under one Single Customer Group. But in turn, there are some similarities between 3 customers that are dealing with Raw Material and 2 other customers ( from the remaining 5 customers), which can have a common Invoice account. If this is near to the solutiion that i am trying to suggest, this will enable one to Report at Head office level (GL account), will also enable to Report at Customer Group Level as well as at Invoice account level and at each customer level. Regards Nihar Saraiya, Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Friday, May 26, 2006 6:02 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invoice account vs order account in AR. Hi, We need to implement the concept of an umbrella account in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the umbrella account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [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 http://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business +finance+coursew2=Business+to+business+financew3=Small+business+financ ew4=Business+finance+consultantw5=Business+finance+magazinew6=Busines s+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w Business to business finance http://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Bus iness+finance+coursew2=Business+to+business+financew3=Small+business+f inancew4=Business+finance+consultantw5=Business+finance+magazinew6=Bu siness+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA Small business finance http://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+ finance+coursew2=Business+to+business+financew3=Small+business+finance w4=Business+finance+consultantw5=Business+finance+magazinew6=Business +finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw Business finance consultant http://groups.yahoo.com/gads?t=msk=Business+finance+consultantw1=Busi ness+finance+coursew2=Business+to+business+financew3=Small+business+fi nancew4=Business+finance+consultantw5=Business+finance+magazinew6=Bus iness+finance+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA Business finance magazine http://groups.yahoo.com/gads?t=msk=Business+finance+magazinew1=Busine ss+finance+coursew2=Business+to+business+financew3=Small+business+fina ncew4=Business+finance+consultantw5=Business+finance+magazinew6=Busin ess+finance+schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg Business finance schools http://groups.yahoo.com/gads?t=msk=Business+finance+schoolsw1=Busines s+finance+coursew2=Business+to+business+financew3=Small+business+finan cew4=Business+finance+consultantw5=Business+finance+magazinew6=Busine ss+finance+schoolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA YAHOO! GROUPS LINKS * Visit your group
RE: [Axapta-Knowledge-Village] Invoice account vs order account in AR.
In your case the invoice account is not a great solution because as you stated all the A/R transactions are against the invoice account. You can change the setting for the invoice address to go to the order account instead of the invoice account but the transactions are still against the invoice account. Instead, You may want to implement some other type of grouping (maybe a financial dimension or a custom group) and modify the report. Maurice Cohen Senior consultant Advanced Systems Integration Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 Phone (949) 597-2170 Fax (949) 597-0720 Cell (949) 533-5966 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Friday, May 26, 2006 6:18 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invoice account vs order account in AR. Hi, We need to implement the concept of an umbrella account in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the umbrella account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [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 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] Invoice account vs order account in AR.
Hi depends what is the usually practice for online checking. If it is to treat each company separate then don't use invoice account but rather add a grouping field and create invoice reports and statement based on this. But if the majority of online enquiries require the data to be consolidated then use the invoice account. Which ever way will require some modifications so its just a matter of being clear what the majority of online views required so as to minimize how many modifications you have to do. All the best James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Maurice Cohen Sent: 26 May 2006 23:47 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Invoice account vs order account in AR. In your case the invoice account is not a great solution because as you stated all the A/R transactions are against the invoice account. You can change the setting for the invoice address to go to the order account instead of the invoice account but the transactions are still against the invoice account. Instead, You may want to implement some other type of grouping (maybe a financial dimension or a custom group) and modify the report. Maurice Cohen Senior consultant Advanced Systems Integration Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 Phone (949) 597-2170 Fax (949) 597-0720 Cell (949) 533-5966 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Friday, May 26, 2006 6:18 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invoice account vs order account in AR. Hi, We need to implement the concept of an umbrella account in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the umbrella account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [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 Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links 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.