tag:blogger.com,1999:blog-7144297722159423617.post7266601297079927394..comments2024-02-05T03:31:31.327-06:00Comments on Redbeard's Blog: HITB Quanity On Hand vs. Inventory Transaction History IssueAnonymoushttp://www.blogger.com/profile/09322326253271593170noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7144297722159423617.post-80598947010386400382015-09-30T10:33:03.398-05:002015-09-30T10:33:03.398-05:00Joseph - the SEE30303.SEQNUMBR field is a long int...Joseph - the SEE30303.SEQNUMBR field is a long integer formatted field used to link to the DTA10200.SEQNUMBR, if the client uses MDA (Multi Dimensional Analysis). In the case laid out in my post above MDA was not in use, so the SEQNUMBR was incremented.Anonymoushttps://www.blogger.com/profile/09322326253271593170noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-21115940216354827882015-09-30T08:40:00.618-05:002015-09-30T08:40:00.618-05:00Hi Harry -- thank you. Just one more question: wh...Hi Harry -- thank you. Just one more question: what makes the SEQNUMBR field in SEE30303? Is this just taking an incrementing by 1 field that looks at the max number of item records and adds one to it?joseph c markovichhttps://www.blogger.com/profile/09625320443300491237noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-45571203292627266962015-09-29T22:42:10.731-05:002015-09-29T22:42:10.731-05:00Indeed Joseph, it is. As you can see from my post,...Indeed Joseph, it is. As you can see from my post, this is the most common scenario, when reconcile does not work. Feel free to use the query above as an template for the fix.Anonymoushttps://www.blogger.com/profile/09322326253271593170noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-53461907167693084512015-09-29T21:16:42.508-05:002015-09-29T21:16:42.508-05:00Hi Harry -- ran your script above and it is showin...Hi Harry -- ran your script above and it is showing the transaction that is in IV30300 but not in SEE30303. Ran reconcile and did not fix anything. Is this where I am going to have to add a record to the SEE30303 table?joseph c markovichhttps://www.blogger.com/profile/09625320443300491237noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-60212519657939370022015-09-29T15:31:29.154-05:002015-09-29T15:31:29.154-05:00Harry, you are a genius. THANK YOU!Harry, you are a genius. THANK YOU!joseph c markovichhttps://www.blogger.com/profile/09625320443300491237noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-80187768866648652912015-08-18T14:27:21.436-05:002015-08-18T14:27:21.436-05:00Dang, I wish I'd found this three hours ago! T...Dang, I wish I'd found this three hours ago! Thanks for posting, Harry!Anonymoushttps://www.blogger.com/profile/07969852467250737056noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-67828883390823809742015-06-10T11:19:18.289-05:002015-06-10T11:19:18.289-05:00The IV00101 table is the Inventory Item Master tab...The IV00101 table is the Inventory Item Master table, and is a company level table. The query should be pointed at the company level in SQL Server Managemetn Studio to achieve the desired results.Anonymoushttps://www.blogger.com/profile/09322326253271593170noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-44836254460146763042015-05-28T13:15:56.863-05:002015-05-28T13:15:56.863-05:00Thanks Harry
Excelent Information
I have this er...Thanks Harry<br /><br />Excelent Information<br /><br />I have this error why?<br />Msg 208, Level 16, State 1, Line 5<br />Invalid object name 'IV00101'.Anonymoushttps://www.blogger.com/profile/11360035469922998858noreply@blogger.com