Thanks
Jim
So average cost is always applied (but yes if it is within the same batch and all items in the batch are purchased at the same price then average will be actual :) )
But does anyone know in the programming where it is possible to change so
that at the time of invoice posting the following can be
done:
If
actual is known then take actual cost
If
actual is not known then take zero cost (rather than
average)
Which
class is the averaging code being done or called from?
Thanks
James
-----Original Message-----
From: Jim Jo [mailto:[EMAIL PROTECTED]
Sent: 17 September 2004 16:28
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Inventory ClosingI think you can turn off average cost using the standard cost. But in this case the cost is considered known !. The cost is a standard .. and profit and loss on issue and reciept can be tracked from the accounts!.If its not stanndard cost , axapta always uses an average cost on every sales !.Right ?Jim
Van Den Langenbergh Gunther <[EMAIL PROTECTED]> wrote:If financial inventory is on (inventory dimension) average cost is not per item but per batch (I think this is what you mean by "actual cost").The only way to not have awp (temporary is to use standard cost (inventory model group)
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: donderdag 16 september 2004 15:56
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Inventory ClosingI guess you know by now why it is average if you dont already have the stock purchased but if you already have it purchased I believe it takes the actual cost (cant total remember right now but I believe so) right!?? Maybe I am thinking of the case when batchnumber is part of financial inventory and all of a batch is priced the same and so average cost of the batch is basically still the same as the actual cost (can someone confirm does Axapta ALWAYS do average cost at time of sales invoice even if actual cost is known???)BTW can anyone tell me is it possible and where to turn off the average cost ... my customer would prefer zero cost to be posted if the actual cost is not known (or alternatively the estimated sales cost to be based on the purchase line amount the sales is reserved against).Thanks
James-----Original Message-----
From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED]
Sent: 16 September 2004 19:01
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Inventory ClosingMy personal recommendation:recalculate every day (interesting for adjusted production calculations and because of performance => closing will be faster)closing (= recalculate and close) can be done monthly
From: Jim Jo [mailto:[EMAIL PROTECTED]
Sent: donderdag 16 september 2004 11:58
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Inventory Closingyep .. thanks ...but whats the frequency that you recommend for a recalculation run ... i suspect if the transaction volume is high then you have to run it daily ???? wrong ????jim
Van Den Langenbergh Gunther <[EMAIL PROTECTED]> wrote:Hi Jim,temporary (before closing or recalculation) your value will be wrong in many cases:f.i.suppose you buy and invoice 100 pieces of an item at $20 a piece. (there is no history before this point)later you buy again 100 pieces at $40 a piece but they are only received , not invoiced.First thing: AWP is always used temporary (before recalculation/closing)You sell 50 pieces.You could think that temporary 50 pices are drawn at $30 (because of temporary AWP)This is not true. When "physical value" is off (inventory model group) these 50 will be drawn at $20 because the last 100 don't have financial price (because no invoice), so it doesn't add to the AWP for the moment.If you recalculate/close after the last 100 are invoiced it will correct the AWP to $30 and so also the issue of 50 pieces.Try it for for many examples, it is always a case of: "stock can be issued before all financial value is known, so it is issued a a wrong price".So you see that recalculation is necessary also if you chose AWP.So the rule is: invoice prices (for purchases) and cost calculation (for production) sets the financial value for incoming stock and because you could have issue transactions before you know the definite price for stock you will always have to recalculate/closehope this helps,greetz,Gunther Van den Langenbergh (Belgium)
From: Jim Jo [mailto:[EMAIL PROTECTED]
Sent: donderdag 16 september 2004 8:10
To: [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] Inventory ClosingHi all ..
May be this could be a foolish !
Correct me if am wrong !
Costing method used - FIFO !
From my understandin when you do a recalculation Axapta adjusts the inventory values of those items which were drawn from the inventory on average cost price to the cost price by lot id.
Jus curious .. why cannot it be done while doing the transaction itself.
And if you use the weighted average costing method there wont be any settlements proposed when you do a recalculation.
Please comment !
Regards
Jim.
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
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.