[Axapta-Knowledge-Village] Re: Urgent: Exchange Adjustment
I know that what I am doing 100% wrong by deleting some transactions in Transtables which I shouldnot be doing.. You've got that part right! I cannot tell you what tables you need to look for, but the best way was to look at the vouchers (look at the audit trail for example) that was posted for the exchange adjustments and then reverse them manually! Good luck! --- In Axapta-Knowledge-Village@yahoogroups.com, Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Hi, I mistakenly ran Exchange Adjustments under AP---Periodics--- Exchange Adjustment... I troied to figure it out what and tables it updated , but I am not sure if I am complete I cleaned up some entries in LedgerTrans VendTrans VendSettlemnt LedgerBalanceTrans LedgerBalancdDim Or How can I revert back?? I would like to know what and all tables are touched. I know that what I am doing 100% wrong by deleting some transactions in Transtables which I shouldnot be doing.. But I need to know which tables will be updated.. I couldn't figure it completely for a momement.. Can some help me Please?. Thanks, Subbu SDBC - Do you Yahoo!? The all-new My Yahoo! Get yours free! Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/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] Re: Project Certification - Integration
I have just completed the project exam and I also have not found any real documentation on integration. Expect questions like transfering production costs, items costs, customer payments for project invoices, what ledger accounts to use ect. I just relied on experiennce and setup from other modules! Good luck! Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, mcredington [EMAIL PROTECTED] wrote: I am studying to take the Axapta certification exam on projects. I know there is a section on integration with the rest of the system (ie transfering production costs, coverage) but have found no information on this is the standard project course. Does anyone have any suggestions on where to find this information? Thanks. Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/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] Re: PROJECT MODULE INTERNAL PROJECT COST CAPITALISING
This issue has been fixed by hotfix HF30SP3_002. After applying the postings is corrected. Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, jesse [EMAIL PROTECTED] wrote: Dear Eddie, Thanks for your reply. What happens if i want to capitalise my cost for my project? That is the reason why i selected Balance under Journalising in Project Group. If i select Profit and Loss under journalising the system post the correct transactions but not in the case when i select Balance. Thanks Regards, Ng Eng Han --- In Axapta-Knowledge-Village@yahoogroups.com, jesse [EMAIL PROTECTED] wrote: Dear all, Have anyone tested on Axapta Project module with Internal Project type? The reason why I am asking this is because according to Axapta Advance Project Guide for Internal Cost Project with WIP, system is able to post cost to Balance account when posting cost journal. Eventually when cost need to be moved from balance account and into profit and loss, user can use the Post Cost script (found in Project/Periodic/Time and Material) and system will post cost amount from Balance to Profit and Loss. However when I tried this on the system and select the cost to be posted to profit and loss system is unable to generate the correct transaction. The result i obtain is as per the attached file. My Settings: Project/Setup/Posting/Project Group Project Type : Internal Journalising : all costs are set to Balance Cost Posting : Cost - profit and loss account WIP Cost - balance sheet account Upon Post Cost journal system performed the below transaction: DB WIP COST (balance sheet account) CR Accrual (offset account specified in journal) When performing Post Cost (Project/Periodic/Time and Material) Somehow the system is unable to created the below correct transactions : DB COST (PL) CR COST CAPITALISED (Balance Sheet) instead system generated the below transaction : DB COST CAPITALISED (Balance Sheet) CR COST CAPITALISED (Balance Sheet) Anyone have any idea why system is acting this way? Did i setup the setting wrongly? Thanks Regards, Jesse Jesse Your problem is that you need to set the Post Cost to ProfitLoss under Journalizing on the project group. Regards Eddie - Do you Yahoo!? Yahoo! Mail - You care about security. So do we. 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/
[Axapta-Knowledge-Village] Re: Settlement reversal
Hallo Hennie We've had a similar problem and this was a reply from technet (maybe you've seen this!): No LedegrTrans was found Hi In the beginning of the reversal of CustTrans or VendTrans, a check is made to see if there exist any LedgerTrans with the same vouchernumber as the CustTrans or VendTrans. If no LedgerTrans is found, the reversal is stopped. Your error-text shows that it has no voucher-number when it tryes to find a matching LedgerTrans, which means that a voucher-number is missing in your CustTrans. The code that performes this is: Class.Method CustVendReversePosting.updateNow Class.Method CustVendReversePosting.validate Table.Method LedgerTrans.existVoucher and The voucher numbers must match Basically the voucher number on custtrans record must match the one in ledgertrans (also the transdate must be the same) this is how it determines the connection. (And it is the only way!) So Yes, if your import facility utilizing journals does not maintain the original voucher numbers (described above) you'll have no means of unsettle these transactions automatically, but still your customer can manually post new transactions and this way have more or less the same result. We experienced this on transactions that was imported as opening balances and given manual voucher numbers. Please let me know if you found a solution, because we are still without one! Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Hennie Potgieter [EMAIL PROTECTED] wrote: Hi, I have a serious problem and hope someone can help.. When doing closed transaction editing in Sales Ledger, I select a payment and Axapta then selects all corresponding invoices. I then click reverse to unlink the payments and invoices in the settlement. Axapta then gives me an error message saying: Voucher does not exist. Reversal cannot be executed. I checked table.CustSettlement and it shows that the transaction is indeed reversible and the voucher numbers exist as expected. Any ideas? Hennie Potgieter -* 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] Re: PROJECT MODULE INTERNAL PROJECT COST CAPITALISING
--- In Axapta-Knowledge-Village@yahoogroups.com, jesse [EMAIL PROTECTED] wrote: Dear all, Have anyone tested on Axapta Project module with Internal Project type? The reason why I am asking this is because according to Axapta Advance Project Guide for Internal Cost Project with WIP, system is able to post cost to Balance account when posting cost journal. Eventually when cost need to be moved from balance account and into profit and loss, user can use the Post Cost script (found in Project/Periodic/Time and Material) and system will post cost amount from Balance to Profit and Loss. However when I tried this on the system and select the cost to be posted to profit and loss system is unable to generate the correct transaction. The result i obtain is as per the attached file. My Settings: Project/Setup/Posting/Project Group Project Type : Internal Journalising : all costs are set to Balance Cost Posting : Cost - profit and loss account WIP Cost - balance sheet account Upon Post Cost journal system performed the below transaction: DB WIP COST (balance sheet account) CR Accrual (offset account specified in journal) When performing Post Cost (Project/Periodic/Time and Material) Somehow the system is unable to created the below correct transactions : DB COST (PL) CR COST CAPITALISED (Balance Sheet) instead system generated the below transaction : DB COST CAPITALISED (Balance Sheet) CR COST CAPITALISED (Balance Sheet) Anyone have any idea why system is acting this way? Did i setup the setting wrongly? Thanks Regards, Jesse Jesse Your problem is that you need to set the Post Cost to ProfitLoss under Journalizing on the project group. Regards Eddie - Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. 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/