Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamVT
Starting Member
1 Post |
 Posted - 2006-05-31 : 13:09:12
|
| Greetings, We currently use GP 8.00 with the SQL Server 8.0. We are trying to develop a view based on manfacturing orders - when a finished good is placed on hold and then calculating the componet parts that are on hold. The calculation runs fine, we multiply end quanity x componet quanity found on the BOM. But we are not getting the correct componet item numbers to display. Here is the syntax we are using: SELECT DISTINCT TOP 100 dbo.BM010115.QUANTITY_I, dbo.WO010032.ENDQTY_I, dbo.WO010032.ENDQTY_I * dbo.BM010115.QUANTITY_I AS QTY_REQHOLDMO, dbo.BM010115.CPN_I, dbo.WO010032.MANUFACTUREORDER_I, dbo.WO010032.ITEMNMBR, dbo.WO010032.MANUFACTUREORDERST_IFROM dbo.TEC_MOSumm RIGHT OUTER JOIN dbo.WO010032 ON dbo.TEC_MOSumm.ITEMNMBR = dbo.WO010032.ITEMNMBR RIGHT OUTER JOIN dbo.BM010115 ON dbo.WO010032.BOMCAT_I = dbo.BM010115.BOMCAT_IWHERE (dbo.WO010032.MANUFACTUREORDERST_I = 4) We have tried several different types of joins but still no luck. The upshot is we need to know that when a finished good is placed on hold, - how many of its componet parts are placed on hold. Any assistance you can provide will be appreciated. Sam |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-31 : 18:07:27
|
| I doubt that anyone here knows enough about the Great Plains database to answer the question.If you want help with this, you will need to post the table structures, the relationships between the tables, and enough about the meaning of the data in each column for someone to be able to help you. Also, a sample of the data and the expected results would be helpful.This may explain what is be needed a little better.http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxCODO ERGO SUM |
 |
|
|
|
|
|
|
|
Help with Great Plains Query