Hi
InventTransAdjust is the correct class.
Updating inventory and ledger has to be in a single loop (i.e. post ledger, get voucher numbers and use them while updating inventory costs), this is absolutely essential since Axapta stores all the updates (GL code wise) to the costAmountPosted and CostAmountAdjustment field in various tables (this is how Axapta will reverse inventory closing).
One potential problem that you have is the ledger - physical and financial voucher button on InventTrans this relies heavily on the voucher numbers. However, this should not be a dead end, must be some way to solve this issue.
I guess you will also have to make sure that you are not adjusting transactions that have been previously closed.
Last but not the least, Axapta has some amazing programming hidden behind all these classes and it is completely flexible, so it is certainly possible to do what you want to do.
Hope this helps.
Regards
harry
_____
From: matiazo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 7 December 2004 7:33 a.m.
To: [EMAIL PROTECTED]
Subject: [development-axapta] Add cost to inventory and recalculate issues
Hello everybody,
We've been working with Axapta for about one year and we're currently
developing one little module do add some direct and indirect cost
based on Ledger Accounts using a cost month closing journal and job
(splitting direct cost for salary for example into the orders that
have time appointment in the month, and indirect costs like
Administrative cost based in total hours appointed in the orders,
then update de inventory and after, the ledger), there's no problem
with this.
But we need to add this cost to the inventory, we're currently
researching to use the InventTransAdjust class that fills the field
adjust for a specified inventTrans voucher.
This is the most correct way to do this?
Another question is, as we use de average cost, and our issues was
with the previous cost, does the Inventory month closing will adjust
all the issues for the goods??? For example, the cost of a semi-
manufactured good will change with this (as we add´s up the cost with
InventTransAdjust), and consequently the cost of finish manufactured
good have to change to production order cost + semi- manufactured
cost (the new one with that InventTransAdjust adjustment) + the
amount that we add up to the order with InventTransAdjust.
Example:
Production Order 1 : semi manufactured have to be adjusted in $10 due
administrative and other direct costs (this process its ok, no
problem with that) + std Axapta cost ( not touched, BOM cost + cost
of work centers, already in the inventory when the production order
was finished) = $100
Production Order 2 : finish manufactured good 1 have to be adjusted
in $33 due administrative and other direct costs (this process its
ok, no problem with that) + std Axapta cost ( not touched, BOM cost +
cost of work centers, already in the inventory when the production
order was finished) = $120
Finish good 1 120 + 10 + 33
|
| - semi manufactured 100 + 10
As it is, all the issues for finish good 1 has to be corrected in 43
when we run the inventory month closing and adjust.
And the issues for semi manufactured have to be corrected in 10.
This can be tested if we purchase some raw material, product some
semi manufactured good with it, product another finish good with the
semi- manufactured good then sell it. Turn back on purchase invoice
for the raw material and adjust the cost with the misc. charges
function, all the cost tree has to be changed.
Does Axapta do this???
Thanks
Rodrigo Matiazo
[EMAIL PROTECTED]
Cadia Consulting do Brasil Ltda.
Av. Eng. Luis Carlos Berrini, 1091 2º andar
Edifício A R S Cep. 04571-010 - Brooklin - SP
Tel. (55-11) 5505-0173
Fax. (55-11) 5505-0659
www.cadia-consulting.com.br
Yahoo! Groups Sponsor
ADVERTISEMENT
click here <http://us.ard.yahoo.com/SIG=1290ivaeb/M=298184.5639630.6699735.3001176/D=groups/S=1705006764:HM/EXP=1102446859/A=2434971/R=0/SIG=11eeoolb0/*http:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=:HM/A=2434971/rand=209236200>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
Harry Deshpande
Senior Consultant
CGNZ Middle Market Solutions
Website: www.middlemarketsolutions.com
Ph +64 29 277 5133
Fax +64 9 358 1018
CGNZ Limited and its predecessor organisations (Cap Gemini Ernst & Young, and Ernst & Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world's leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices. Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies. The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions. Find out more about what we do at http://www.middlemarketsolutions.com/
CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. The opinions expressed are not necessarily those of CGNZ.
CGNZ accepts no liability for any loss, damage or consequence, whether caused by our own negligence or not, resulting directly or indirectly from the use of this email and attachments.
--------------------------------------------------------
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
