GL Different from Inventory Report

We are having a problem with our GL not matching our inventory reports. We 
have gone line item by line item between both reports and everything appears 
to match correctly. The only thing we can think of that we did differently 
this month was we changed our overhead and labor rates the last week of the 
month. Our Sales are posted daily but we back flush work orders at the end of 
the month - could the timing of work orders being back flushed at the end of 
the month (at a different cost than the standard due to the rate change) and 
sales orders being posted each day cause the two reports to not be in sync?
0
Matthewm1 (6)
3/9/2007 6:29:11 PM
greatplains 29623 articles. 6 followers. Follow

3 Replies
668 Views

Similar Articles

[PageSpeed] 1

Hello Matthew,

Are you using manufacturing module ???

francisjk
Francis J. Kariyannappally
Certified Dynamics GP consultant


"Matthewm" wrote:

> We are having a problem with our GL not matching our inventory reports. We 
> have gone line item by line item between both reports and everything appears 
> to match correctly. The only thing we can think of that we did differently 
> this month was we changed our overhead and labor rates the last week of the 
> month. Our Sales are posted daily but we back flush work orders at the end of 
> the month - could the timing of work orders being back flushed at the end of 
> the month (at a different cost than the standard due to the rate change) and 
> sales orders being posted each day cause the two reports to not be in sync?
0
francisjk (19)
3/11/2007 9:28:00 AM
We are using GP 7.5 and Horizons Manufacturing Suite 7.5
Any help would be great! Thanks!

Matt


"francisjk" wrote:

> Hello Matthew,
> 
> Are you using manufacturing module ???
> 
> francisjk
> Francis J. Kariyannappally
> Certified Dynamics GP consultant
> 
> 
> "Matthewm" wrote:
> 
> > We are having a problem with our GL not matching our inventory reports. We 
> > have gone line item by line item between both reports and everything appears 
> > to match correctly. The only thing we can think of that we did differently 
> > this month was we changed our overhead and labor rates the last week of the 
> > month. Our Sales are posted daily but we back flush work orders at the end of 
> > the month - could the timing of work orders being back flushed at the end of 
> > the month (at a different cost than the standard due to the rate change) and 
> > sales orders being posted each day cause the two reports to not be in sync?
0
Matthewm1 (6)
3/12/2007 12:26:11 PM
Hello Mathew,

Your question is not clear to me. If you have matched both reports line item 
by line item then where is the difference ?!!! 

Are you using GP inventory or Horizon ? Which costing method you have 
implemented for inventory, Standard or Current?
What is the valuation method ?

Regards

Francis

"Matthewm" wrote:

> We are using GP 7.5 and Horizons Manufacturing Suite 7.5
> Any help would be great! Thanks!
> 
> Matt
> 
> 
> "francisjk" wrote:
> 
> > Hello Matthew,
> > 
> > Are you using manufacturing module ???
> > 
> > francisjk
> > Francis J. Kariyannappally
> > Certified Dynamics GP consultant
> > 
> > 
> > "Matthewm" wrote:
> > 
> > > We are having a problem with our GL not matching our inventory reports. We 
> > > have gone line item by line item between both reports and everything appears 
> > > to match correctly. The only thing we can think of that we did differently 
> > > this month was we changed our overhead and labor rates the last week of the 
> > > month. Our Sales are posted daily but we back flush work orders at the end of 
> > > the month - could the timing of work orders being back flushed at the end of 
> > > the month (at a different cost than the standard due to the rate change) and 
> > > sales orders being posted each day cause the two reports to not be in sync?
0
francisjk (19)
3/12/2007 12:45:07 PM
Reply:

Similar Artilces:

Compare records in multiple sheet -> report
Hi! I have a workbook consisting of ten sheets. To simplify my question let�s say that the three first columns of every sheet denotes the spatial coordinates x,y,z and the fourth column is a scalar value. Some x,y,z-triplets exist in all 10 sheets, some exists in only a few sheets, if the triplet exists, then also the scalar value of the 4th column exists. What I would like to do is to find all unique x,y,z-triplets and show them in the first column of a new sheet. In columns 2-11, I would like to show the scalar value(from the corresponding x,y,z-triplet of course) in column 4 in s...

Count column difference
Hi Using MSExcel 97. I have two columns of data e.g. A1: A4, containing values 5,10, 3, 6 B1:B4, containing values 3, 8, 7, 4 I wish to perform a count (e.g. in C5) of the number of rows where the value in column A exceeds the respective value in column B (in this case count = 3, as A1>B1, A2>B2, and A4>B4). Just cannot get my formula right. Tried using an array (but difficult when comparing the difference between two columns), and COUNT. Thanks in advance for any suggestions. Wizzy ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.co...

Forms in two differant views
Is there a way to use the same sub form showing two differant views within the same Main Form. For example: Can I show on one tab a datasheet view and on the other a regular form view. -- Rose Hi Rose, Create a button on your form and under the "OnClick" event put 'Me.DefaultView = Datasheet Alternatively you could use a checkbox If me.checkbox1 = 0 then Me.DefaultView = 2 ' Datasheet Else Me.DefaultView = 0 'Single Form End if me.repaint This should flick the form between datasheet and form views. HTH, Nick. "Rose" wrote: > Is there a way to use t...

How to create web-based reports from RMS database.
The reports available in RMS is not specific enough for my apparel retail store. I need sell the through rate, average sale, sales/sf, return rate, discount analysis, all broken down by date, week, month, year, category, supplier, and then compare against last year's numbers. I want to create my own web-based reports accessing RMS's SQL database. Does anyone have a template of data access web page so all I have to do is change the SQL statement in getting to the right database table? mas wrote: > The reports available in RMS is not specific enough for my apparel retail > ...

Error while trying to access reports
Hi all, I have a user who is Admin and gets this error when she clicks on the report icon: Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the r...

Create Pivot Table Reports
I just finished installing Analysis Cube on the server, everything seemed working fine until when I try to create the Pivot Table Report (Tools->Analysis Cubes->Create Pivot Table Reprots). After I called up the pre-defined 'Definition ID' and click on the Excel icon, a message popped up saying " The WHTemplate.XLT file was not found." Anybody have any idea what that is, and how to resolve it?? Thanks. 1.) There are two pieces of software. Did you install both the server piece, and the client piece? 2.) Is Excel installed on the machine, on which you'r...

Delivery Status Notification (DSN) different if sent from outside
When my users mailboxes are full above quota and not accepting any more mail, the sender receives a differently worded DSN depending on whether they sent email to that user from an internal account (one that is part of the exchange org) or an external account (not part of the Exchange organization). The one sent to the a user that is external is much less human friendly and is causing me a problem with some scirpted automation in my app. Is there a way to make the text the same for both? Examples pasted below: Here is the if sender is internal: Your message did not reach some or all o...

Run two copies of Outlook with different profiles
Hello! I'm trying to run two copies of Outlook with different (outlook)profiles at the same time. Normally i can choose the profile with the /profile switch, but if there is already a copy of outlook running, this switch seems to be ignored. Any ideas how to handle this are welcome. Regards, Reinhard "Reinhard" <reinhard.spieker@bkvibro.de> wrote in message news:60a7e218.0311190408.6523100b@posting.google.com... > Hello! > > I'm trying to run two copies of Outlook with different > (outlook)profiles at the same time. > > Normally i can choose the p...

GL Posting date is missing or invalid error message
Hello, When trying to post a Sales order through Sales transactions entry window, we get an error message 'General ledger posting date is invalid or missing' The dates seem correct. The fiscal periods are all set up correctly. This happens whether we try to post an individual transcation or a batch. The batch looks like it is posting, but all the posting reports have zero mamounts in them & the batch still sits there even after posting as if it has never been posted. We are running GP 8.00g34 What is causing this & how do we fix it? Thanks Did you recently change your pos...

Reports not availble on ssms
Hello Gurus, Here is a situation I have versions of SQL from 2000 to 2008 in both the 2005 and 2008 version of ssms I can not see the report section when right clicking on a database in SSMS. However I can view these reports when I RDC into the server using the exact same windows credentials?? Is there something missing on my client tool that would cause this? or What?? help! Wisord *** Sent via Developersdex http://www.developersdex.com *** ...

Date range for a report
Hi I am trying to run a query and can't seem to nail down the right code. We use the access database to track files, incoming/outgoing correspondence dates etc. I am trying to run a query that show me files with dates in a follow up field of -60 days to +7 days, so essentially any follow ups missed in the last 2 months and up coming in the next week. This report is run on a weekly basis. Appreciate any help Thanks Assuming that the follow up field is actually a date/time data type, try this in the criteria: Between Date() - 60 and Date() + 7 -- Jerry Whittle, ...

Report Server Error 09-28-07
After uninstalling MSCRM from my server, I tried installing it again. This has led me to the problem of the report server. I'm using the default server name http://<servername>/reportserver and it's still not realizing that it is actually there and fully running. I've checked the Services section of my server and also checked the individual server status. Both are running within normal parameters. Before the uninstall, the report server was running properly and CRM recognised that it was actually there. Any ideas? ....reed Is this SQL Server 2000 or 2005 SRS? 1. Fo...

not repeating text boxes in reports with columns
Hello, I am trying to create a report with columns without repeating certain text boxes. Here is an example of what I would like to create: [Date] "Month1" [Date] "Month2" [Date] "Month3" [Product] "Product1": [quantity] [value] [quantity] [value] [quantity] [value] [Product] "Product2": [quantity] [value] [quantity] [value] [quantity] [value] [Product] "Product3": [quantity] [value] [quantity] [value] [quantity] [value] [Product] "Product4": [q...

Access SSRS Throug SSMS not Report Manager
Without giving someone membership into the "BUILTIN\Administrators" group, how would one enable a user to be able to access SSRS through SSMS? SSMS >> Connect >> Reporting Services >> {Server Name} I'm currently getting the error below: TITLE: Connect to Server ------------------------------ Cannot connect to {servername}. (removed the server name) ------------------------------ ADDITIONAL INFORMATION: A connection to the computer cannot be established. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ Acces...

different versions in visio ole-object?
hello i have some problems printing a word document which includes some visio drawingns. In word i can see the visio object like i edited it but when printing the word-document, a completly old version of the visio object is printed out. The printed object is older that 2 weeks. I tryed printing the document from other PC without changes. I tryed copying the ole-object into an other word dokument (copy/paste) without changes. Printing the document from wordpad works great .... I also opened the visio object (doublecklick in word) and edited the object, saved the file and exited back to wo...

Crystal Reports help
We are currently using GP 8.0 and Crystal Reports 10. We will be running most of our reports through Crystal because you can do so much more than with the Report Writer. I am looking for a good reference book for Crystal 10 (this is the first version I have ever used) any suggestions? You can get books on Crystal 10 in any large bookseller. One thing you won't get is how to use Crystal with Great Plains. There was some training materials available. You will want to consult the Great Plains SDK for help on the tables to use. JO wrote: > We are currently using GP 8.0 and Crystal R...

script error running reports from home pages, why??
I'm not a GP user/expert, we recently installed GP2010. Since then one user has said, "When I try to run reports from the home pages, I am getting this script error and cannot run any reports." The error is: Line 47 Char 5 Error The system cannot find the file specified Code 0 URL: file:///C:/Users/username/AppData/Local/Temp/tmp/AE8.tmp I have received differing responses to this issue: 1) enable the Run command on the Start menu of our XenApp server for the regular domain users, which I view as a big security risk 2) "the UserData folder does not exist in the %ap...

Difference 05-21-04
What is the difference between CRM standard and professional? -Johnny Johnny wrote: > What is the difference between CRM standard and professional? > > -Johnny Does it have anything to do with Outlook integration? -- - I am Johnny! Your Internet penpal. I have a scooter, how about you? "Johnny" <alphascooter-verizon@yahoo.com> wrote in message news:evfBJNwPEHA.3708@TK2MSFTNGP10.phx.gbl... > Johnny wrote: > > > What is the difference between CRM standard and professional? > > > > -Johnny > Does it have anything to do with Outlook inte...

Item number/location code does not exist in inventory error
I'm using eConnect to do an SOP transaction and it has been working for months but with a new customer and a new site I'm getting an error. The error is: "Item number/location code does not exist in inventory". The same transactions are still working with other customers on other sites so it seems like it must be a set up issue in GP. The customer and site look like they're configured the same as the ones that work so I'm stumped. Does anyone know what the issue might be? Thanks, Matt Have you confirmed that the item number has been assigned to the new sit...

Counting in a Report
I have the following entered for the Control Source in a group header text box on my report: =Abs(Sum([CountOfGoal])) Now in the footer of my report I want to add the result of those text boxes in another text box. What should I enter for the Control Source of that text box? Thanks, CEV "CEV" <chadv@advancebkg.com> wrote in message <evr8e50dpb@enews1.newsguy.com>: > I have the following entered for the Control Source in a group header > text box on my report: > > =Abs(Sum([CountOfGoal])) > > Now in the footer of my report I want to add the re...

Report header below page header
I want a report heading on the first page - but I would like it to be below the page header (so that my page header is identically positioned on all pages). Alternatively I want a part of my page header only displayed on the first page. How can this be made? -- Diane I expect you could create a new Group Header section on a constant like: =1 Display the header for this group. It will display only once and will be positioned below the first Page Header section. -- Duane Hookom Microsoft Access MVP "DianePDavies" wrote: > I want a report headin...

Graphic report in Report writer
Hi, I have modified the Short SOP invoice form to a graphic report. My issue is when I print the report on screen all the fields display correctly as modified. But when printing on paper most of the fields do not display correctly. What I see is that on the place where data should be printed some strange characters are displayed. I tried to print on different printers and different workstations, but still this issue remains. Also at the client site the same issue remains. Does anybody have an idea of how this should be solved? Looking forward for an solution, -- Elaine ...

Multiple Accounts held at the SAME Institution with DIFFERENT logons
I am trying to sync Money 2006 to my Banc of America Investment Services accounts. I have two accounts with two DIFFERENT logons, an IRA and a regular brokerage. Money will sync fine to one or the other, but I can't set it up to sync to both because when I click on Online Services it is already setup so I can't add a different login, etc. -- Daniel Blackmon Project Lead - Software Engineer Worldwide Environmental Products Inc. In microsoft.public.money, Daniel wrote: >I am trying to sync Money 2006 to my Banc of America Investment Services >accounts. I have two accounts w...

feature difference btw 2000 & 2003
X-No-archive: yes I currently have Outlook 2000 and wanted to know if its worthwhile to upgrade to outlook 2003 ? I only use the mail portion of outlook and don't use calendar or any of the other options. Is 2003 more compatible with WinXP ? Thanks, Chris If you are just strictly e-mail (no calendar, contacts, tasks, .etc) then you are missing a good portion of what Outlook 2003 is bringing to the table. However some of things that you might like in Outlook 2003 are: 1) Better security. (bots, pictures, .etc that load from the web in html are blocked by default) 2) Cool new ...

Weekly Resource Utilization Report without Timesheet module?
We are considering dropping the timesheet module of PWA 2007 and was wondering if we would still be able to get a report out that would detail the number of hours used by a resource by project task and by week. My gut feel is that it should be able to, but not sure there are any canned reports that is available for this purpose within Resource Center or Project Center. Kahuna: you can get this from the OLAP cube using the MSP_Project_Timesheet cube. Understand that Project Managers can change actual work values in projects unless you lock down the system. So, your decision mus...