Precisely Speaking
May 21, 2012, 07:24:31 PM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: So what's news with you? Tell us about it in "Getting To Know You"!
Home
Help
Calendar
Login
Register
Precisely Speaking
>
Application Support
>
Activant/Prelude Support
>
ORD.AUTO.SPLIT.UPD Updating /QPI (Q.PN.HIST)
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: ORD.AUTO.SPLIT.UPD Updating /QPI (Q.PN.HIST) (Read 408 times)
precisonline
President/Chief Technologist
Administrator
Rock Star
Posts: 1532
ORD.AUTO.SPLIT.UPD Updating /QPI (Q.PN.HIST)
«
on:
May 19, 2011, 08:12:29 AM »
I've been chasing an issue with /QPI for what has seemed to be an excessively long time, and now that I've found the solution I'd like to bounce this off other Prelude users to see if you've seen the same thing?
We have a customer with a slightly customized version of /QPI that calculates conversion trends for quote lines. We noticed that under certain circumstances, the Q.PN.HIST file was not being updated properly. For example, if someone changed the selling warehouse on the quote header, all of the quote lines xref'd in Q.PN.HIST would be tied to the original selling warehouse, and not the current selling warehouse. More of a problem, however, if someone did a line split and quoted a product with quantities out of more than one location, only the first line would be updated into Q.PN.HIST. As a result the open quantity and the conversion trends calculations we added were coming up incorrect. (That's actually how we discovered the problem; the quote conversion trend numbers weren't making sense.)
I've checked version 21 and I'm not seeing where split lines (created via ORD.AUTO.SPLIT.UPD) are being updated into Q.PN.HIST, so this looks to be a problem even in the current release. Can anyone else confirm this? Or is it just not an issue for most folks?
Logged
-Kevin
Accidents "happen"; success, however, is planned and executed.
CKilgore
Professional
Posts: 20
Re: ORD.AUTO.SPLIT.UPD Updating /QPI (Q.PN.HIST)
«
Reply #1 on:
June 01, 2011, 02:07:20 PM »
We have had similar problems with /QPI (and our custom versions of it). My notes say that running /QUOTE.BUILD.XREF will fix the issues (at least the ones we have). Does this rebuild correct the problem you are having?
Logged
Chris Kilgore
Brake Supply Co., Inc.
Prelude ADS Version 20.2
precisonline
President/Chief Technologist
Administrator
Rock Star
Posts: 1532
Re: ORD.AUTO.SPLIT.UPD Updating /QPI (Q.PN.HIST)
«
Reply #2 on:
June 01, 2011, 02:31:50 PM »
It should, but the problem is having the time to run the rebuild every day.
Logged
-Kevin
Accidents "happen"; success, however, is planned and executed.
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Getting To Know You
=> Announcements
=> Big Thoughts / Cool Ideas
=> Rants & Raves
-----------------------------
Application Support
-----------------------------
=> Red Leaf
=> Activant/Prelude Support
=> Summit Support
=> Avante Support
=> PRC Support
-----------------------------
Training and Education
-----------------------------
=> Connect!
=> U2 Programming Questions
=> SB+ Programming Questions
=> Web Programming Questions
=> Business Intelligence / MITS
=> PC / Hardware / Miscellaneous Support
Loading...