Cost changes at year end

We notice that we have transactions still with old unit costs, after we have 
updated item costs as part of year end.  What is the correct way to have 
these tranasctions update unit cost to the new cost? example - we create 
invoice when unit cost was 10.00 then at year end we recost the item to 
12.00.  we post the item after year end and the invoice still shows 10.00. 
Our receivables account picks up the 2.00 difference. 
0
Utf
8/11/2010 12:10:03 AM
greatplains 29623 articles. 6 followers. Follow

0 Replies
962 Views

Similar Articles

[PageSpeed] 4

Reply:

Similar Artilces:

Change 2007 excel Autofilter back to 2003?
Does anyone know if there is a way to change excel's 2007 autofilter functionality back to like excel 2003 autoflilter use to work? I need to quickly bring up like values and compare other columns based upon the filtered values and the extra clicking of the check boxes is driving me nuts! If it helps any (and if you haven't thought about it yet), you can click the "(Select All)" entry twice to remove your current selections. -- Rick (MVP - Excel) "jonnybrovo815" <jonnybrovo815@discussions.microsoft.com> wrote in message news:36837406-1...

How i change headers in different sections Microsoft Publisher 20.
I am trying to make a school newspaper using the Microsoft Publisher 2007. Anad i heed to have different headers in different sections, i cannot do that. The newspaper is going to be about 32 pages. Are you using one of the templates? What template? What happens when you try to change the headers? -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Vasso" <Vasso@discussions.microsoft.com> wrote in message news:A0F7FA6B-21AB-4C28-A191-2B4742E63FCA@microsoft.com... >I am trying to make a school newspaper using the Mi...

Changing Average Cost GP 9.0 Error
When we try to change the average cost information for an item per the documentation, (tools >> utilities >> inventory >> change average cost), we get this message. "Use the Inventory Adjust Costs window to change the cost of one or more reciepts. The average cost of an item is recalculated when teh changes are proceses" We would like to change it without using the Inventory Adjust Costs window because there are no recent purchases and receipts of the particular item in question Would anyone have any suggestions? The average cost is the aver...

Prevent change to refs in second worksheet when drag cells in firs
I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among different locations in the primary calendar worksheet. I have a second worksheet that needs to list those cell values in a fixed configuration, e.g. the value in Sheet1!A1 needs to always appear in the cell of Sheet2!G10. Sheet2!G10 contains the formula: “Sheet1!$A$1”. If the user drags Sheet1!A1 to Sheet1!A3, the formula in Sheet2!G10 gets automatically updated to “Sheet1!$A$3”. I have tried all combos of locking and protecting to prevent this updating. Is there a way to do this? Try referencing the other shee...

How can I change default setting in Office start-up?
I need to change the default setting on my Word, Excel and PPT programs (MS Office 2004) so when they open they aren't at, for example, Word 11.3.0, rather at Word 11.2.3. I mac OSX, a G5. When I do a control click on any of those programs, go to "get info" and then choose the 11.2.3 that I want to open with, it does it no problem. When I click "change all" it doesn't change the default -- the 11.3.0 is always the default despite that I'm trying to change all. How do I fix this? BTW this whole problem started when someone at the genius bar deleted one of the...

Change owner of a template in P12
Hi, is there any possibility to change the owner of a template? Usually project owners can be changed in the Project Center of Project Server 2007, but templates are not shown in the Center - or am I mistaken in that point? Background: A user created a template on the server and is thus the owner of the template. But we would like to change this owner to be another user. Thanks for your suggestions! The template owner, which has no meaning in the grand scheme of things, is always the person who saved the template to the server. If you want to change the owner, then dele...

Cant Change AutoCorrect List
I am using Office 2007 B2 TR, and I have found a problem with the AutoCorrect functionality. I removed some entries from the autocorrect list (the wingding smilies specifically), but it doesn't actually remove them. Every time I go back and write a new email, they are back. I have tried through the message options, through the general outlook options, and through the autocorrect smart-tag options. No matter how I try to get rid of those autocorrect entries, they keep coming back. Is there some magical way to get rid of them, or is this just a bug in the TR? Thanks in advance, - Art...

Microsoft Office Icons Change...
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I changed the basic icons that came with the office programs, but once I use one of the programs such as Word, the icon changes back to the default one. Even after I quit the program it stays as the default icon. Only when I manually change it does it use the new (better looking) icons I have, but only if I haven't used the program before.... Any ideas? On 6/25/09 2:07 AM, in article 59b7718d.-1@webcrossing.caR9absDaxw, "grantbiz@officeformac.com" <grantbiz@officeformac.com> wrote: > Version: 2...

Counting Consecutive Years
I'm trying to count the maximum number of consecutive years that an individual has made a gift to our institution. I have a range of 35 years to consider and all my information resides in one table. It doesn't matter when the last giving year was as long as s/he give 'x' number of consecutive years before that (with 'x' being a user-defined parameter). I will also want to know the minimum and maximum values for that range. I'm using Access 2003 and know very little Visual Basic. Any help would be appreciated. If the fields are like: Name YearContribution ...

How do I create a Cost Volume Profit Graph in Excel?
I was wondering if I could get some help on how to create a CVP graph in Excel 2007. A cost volume profit shows how costs, revenues, and profits vary with volume (sales). You can either plot total cost, or fixed and variable costs, which add up to total costs. One way to show this is to make a break-even chart. Put unit sales (number of items sold) in the first column, fixed costs in the second (which are a constant), variable costs in the third column (these are typically a straight line through zero), and in the fourth insert formulas that sum fixed and variable costs to make total ...

How do I change the default paper size (and units) in Publisher?
I've got the printer set to A4, but no matter how many times i change the options in Publisher - everytime Publisher loads it resets to Letter/Inches. vIQleS wrote: > I've got the printer set to A4, but no matter how many > times i change the options in Publisher - everytime > Publisher loads it resets to Letter/Inches. ================================= Go to Control Panel and carefully check the Preferences and or Default settings for your printer. There may be more than one place to change paper size. -- ******John Inzer******** **MS Picture It! MVP** *****Digital I...

Changing Slide Advnacing timing
Thanks for your attention. I have a PowerPoint presentation with more than 30 slides. Initially I set the slide advancing to AUTOMATICALLY AFTER 00:05 secs for each slide. Rest of the Slide Transition settings for each slide are different. Now I wish to reduce the timing to 00:03 secs without changing other setting. (clicking APPLY TO ALL SLIDES changes the Slide Transition settings in all slide to identical as the one I am working on). 1. Is there a way to do this easily without having to go to each slide individually? 2. If there is a way, can it be used to change ...

Change default "SaveAs" to *.msg rather than *.html
Hi!, Using Outlook 03, I regularly need to save emails and prefer to save as *.msg so the attachments are contained within the one file. How can you change the default SaveAs command to Save as Type in a *.msg format (rather than *.html) so the type is already *.msg without having to use the pull down? Thank you Troy Outlook provides no way to change that. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "TroyB" <boeky72@hotmail.com>...

change column name from letters to numbers?
I'm importing a 3rd party CSV file into Excel and then comparing some of the contents to a printed spec. Each numbered field in the spec corresponds to a column in the work sheet. I'd like to change the column headers from letters to numbers. Is that possible? Tools-->Options, General tab. Check the R1C1 Reference Style. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Jerry" <jerry@nowhere.com> wrote in message news:OoyPef$eFHA.3048@TK2MSFTNGP12.phx.gbl... > I'm importing a 3rd party CSV file into Excel and then comparing ...

Can you change the way quick parts and/or auto text displays?
Is there a way to change the look of the drop down menu for quick parts and auto text so it does not take up so much space? Something like it looked in 2003? Assuming that you have discovered the building block organizer - see http://gregmaxey.mvps.org/Buiild_Employ_Custom_BB_Gallery.htm Like 2003 it ain't! -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<&...

How do you change the way email addresses are displayed? John Doe.
How do you change the way a recipent of an emails name is displayed in an email? I want to only show "John Doe" and not "John Doe (Email):<John Doe@xxx.com>" Displayed where and in what version of Outlook? -- Russ Valentine [MVP-Outlook] "dmoors" <dmoors@discussions.microsoft.com> wrote in message news:540E8B6B-2F78-4541-9116-3A79F4A5D52B@microsoft.com... > How do you change the way a recipent of an emails name is displayed in an > email? I want to only show "John Doe" and not "John Doe (Email):<John > Doe@xxx.com>&q...

Excel cut/Paste Problem: Year changes after data is copy and paste
I am using Excel 2003, and here is the problem. I have an Excel sheet that contains financials. Different departments need different sections of the data, so I copy and paste out only those sections they need and paste it into a new Excel sheet. The colums are broken up into dates, and formated to show date-year (Dec-05). For some reason, when I copy and paste sections, the date will change, for example Dec-05 will change to Dec-01. I have to go thru and manually correct all the dates. Can anyone tell me what is causing this? . .. maybe the cells in the New worksheet are preset to a c...

Changing of range (Address) to (Cell)
Hi people I have encounter a problem with the use of range From a recorded macro, it's listed this way ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2,A24:M28"), PlotBy:=xlRow And I edit it to this way ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2," & Cells(StartX, StartY), Cells(LastX, LastY)), PlotBy:=xlRow And obviously VBA compiler won't let me go this easily, it happen to give an "evil-comment" on my source range, May i know how can i solve this Thank You Hi Kaiyang, Try this, assuming the...

Net change and percentage of change
Hi, I have a list of parts that have had price increases. One column has the old price the other has the new price. I need to show the difference, whether it is positive or negative and the percentage of the increase or decrease. The difference is not a problem. The problem lies in calculating the percentage. I don't how to do that. Can someone tell me? Thanks, Richard =(B1-A1)/B1 "Richard" wrote: > Hi, > > I have a list of parts that have had price increases. One column has the old > price the other has the new price. I need to show the difference, whethe...

problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change the text of some sentences of an opened word file, but the problem is when I change the text of a sentence which located before a table, it will be moved to the first cell of the table. My code is as follow: void myMethod( long startingSentenceNumber, const char *toBeSearched, const char *replacement, bool replace ) { Range currentSentenceRange; Selection sentenceSelection; Sentences sentencesList = m_document.GetSentences(); long sentencesCount = sentencesList.GetCount(); CString replacementCStr(...

Don't change text to numbers
I want to replace the character "-" into "." in cells formatted as text eg 0060-1003 must become 0060.1003 i already unchecked in error checking : numbers stored as text if i do it manually it is ok but because i want to do it by replace to . and then it becomes 601003 How can i prevent this -- Message posted from http://www.ExcelForum.com Use a temporary "helper-column (a new inserted column)" let's say Column B: and in Cell B1 enter =SUBSTITUTE(A1,"-",".") where A1 has your 0060-1003. Copy B1 down, then Copy B:B to B:B & u...

Fiscal Year Close
v7.5 Great Plains There is a user that went ahead and posted a large number of transactions (not posted to GL, but sitting in batches there - only posted in in POP/SOP with a tie in to Inventory) that are dated _after_ the projected fiscal year close. Are these recoverable? Or do they all have to be voided (with adjustments to inventory) and re-entered from scratch? I think your best bet is to delete the unposted batches in GL and enter returns to negate the transactions in POP and SOP. -- Charles Allen, MVP "YCI" wrote: > v7.5 Great Plains > > There is a us...

remove white space without changing plot size
Now I know the white space can be removed by draging plot area but without changing the size of plot I like to remove the white space. Is that impossible ? Not impossible, but it is hard to maintain the plot area size. You have to first make the outer chart area rectangle as small as you need, then make the plot area as large as you need. You'll probably have to cycle through resizing of the two rectangles a few times. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ pm wrote: > Now I know t...

EXCEL Decimal changes during WORD Merge
Why does Excel change 16 cents into .1599999 in a merge process Have not had this problem until we upgraded to 2003????? I have tried different cell formats in Excel Number - currency - accounting - custom - all with the 2 decimal places text - but rather not lose numeric functions (am re-entering figures by hand and using text format today to finish merged letters - - ugghhh!) Help? I have had a similar problem in previous versions of Excel as well, not just Office 2003. Is the data in Excel coming from an outside source like a non Microsoft database query? I run into this probl...

Getting rid of the location of the messages change message?
I'm currently running Outlook XP and Exchange 5.5. I created mandatory user profiles for the end users. Basically their desktop and all their settings are replaced with a generic one every time they reboot. They click on an outlook profile every time they log in from the mandatory users profile. When they click on the outlook profile file (outlook.prf), they will get a message every time saying " The location messages are delivered to has changed for this user profile. To complete this operation, you may need to copy the contents of the old Outlook folders to the new Outlook folde...