[Axapta-Knowledge-Village] Cost of sales
Hallo all! Does anyone come across the situation where at time of invoice posting, cost of sales needs to be broken down into a material and conversion cost components to be posted on seperate ledger accounts? I know this is not standard Axapta, but if anyone has made modifications or reporting to reflect this I will be clad to hear some opinions. Thanks Eddie 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] Cost of sales
hi Edward It should be possible to do this but I think it will be a big pain. Start out with an empty database and post one invoice and check the records created in inventTransPosting table. This will give you some idea. SalesFormLetter_Invoice - Update now method wil update the debtor part of the transaction. passes control to InventUpd class whichwillcalculate cost of inventory andupdate the inventory side of theledger transaction (with the help of inventmovement - updateLedgerFinancial) and then will insert records into the above table (inventTransPosting). You could also look at keeping the original cost the same and reducing the cost by using the cost amount adjustment field. ie. original cost 100 and you want to split 80 to one gl code and 20 to another gl code. In this case post 100 to the first gl code, -20 in adjustment to the same gl code and +20 again in adjustment to the different gl code. Will give you the net effect as desired. I am quite sure that what you are saying can be done this way. regards harry edwardjosling [EMAIL PROTECTED] wrote: Hallo all!Does anyone come across the situation where at time of invoice posting, cost of sales needs to be broken down into a material and conversion cost components to be posted on seperate ledger accounts? 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.
RE: [Axapta-Knowledge-Village] UPDATING FIXED ASSETS ACQUISITION DATE
Dear Jesse, My solution to update the FA original acquisition date instead of taking the posting date is as follows. Define a definition group with AssetTable, AssetBook en AssetBookTable. Make sure you import the AcquisitionData of each FA in the AssetBook. Import the Excel-sheet with columns like AssetId, AssetGroup, Name, BookId, AssetGroup etc. * Check the depreciations (GL/FA/Value models/Inquiry/Profile) Acquisition journal/Lines/Proposals/Acquisition proposal Post Depreciation journal/Lines/Proposals/Depreciation proposal Post * When you are interested in the column names, please let me know. Your steps 3 and 4 correspond with the above steps 4 and 5. The acquisition dates will be the dates of the Excel-sheet, not the posting dates of step 4 and 5. Regards Otto de Boer -Oorspronkelijk bericht- Van: jesse [mailto:[EMAIL PROTECTED] Verzonden: donderdag 3 maart 2005 9:59 Aan: Axapta-Knowledge-Village@yahoogroups.com Onderwerp: [Axapta-Knowledge-Village] UPDATING FIXED ASSETS ACQUISITION DATE Dear All, I am migrating the Fixed Assets transactions for my company that is going live. I migrated the following the the below sequence: Step 1. AssetTable - to capture asset number and information Step 2. AssetBook - to capture value model, acquisition date, depreciation, etc Step 3. LedgerJournalTrans - to post acquisition cost to GL (posting date 31/12/2004) Step 4. LedgerJournalTrans - to post accumulated depreciation to GL (posting date 31/12/2004) However after I perform step 3 4 my assets acquisition date becomes the posting date of step 3, that is 31/12/2004. Does anyone knows how to update the fixed assets original acquisition date, insteead of taking the posting date of step 3? Thanks. Regards, Jesse Sharing the knowledge on Axapta. 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. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.0 - Release Date: 2-3-2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18-3-2005
[Axapta-Knowledge-Village] CRM Product Builder
Does anybody know why the Axpta CRM does NOT WORK with the PRODUCT BUILDER. Any help will be appreciated. Currently Axapta DOES NOT have the Product Builder activated while quoting from CRM, but from the Sales Orders. Kind Regards Francisco Orozco Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. -- ___Sign-up for Ads Free at Mail.com http://www.mail.com/?sr=signup 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.