Hi James The Method you are looking for is on InventSum I can't remember the name but I have the code some were if you need them.
Jakob --- James Flavell <[EMAIL PROTECTED]> wrote: > 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 > Closing > > > I 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 Closing > > > I 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 Closing > > > My 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 Closing > > > yep .. 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/close > > hope 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 Closing > > > Hi all .. > === message truncated === _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/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/