POP_Document_Inquiry
(1)
PO
(1)
SLB
(1)
Redisplay_BeforeUserChanged
(1)
PurchaseOrderProcessingDocu
(1)
ID
(1)
Window
(1)
GoTos
(1)
SmartList Builder GoTo
Asked By jpCB
08-Sep-08 03:54 PM
I'm trying to GoTo the PO Document Inquiry window, check the Open Purchase
Orders and Receipts Received checkboxes, then fill in the PO Number From and
To fields. I don't have a clue how to do this. I was able to fill in the From
and To fields, but because the checkboxes aren't checked it doesn't show any
information. I figure I could create a calculated field to fill in the value
for "checked", but don't know what that value is supposed to be.
Any help or direction is appreciated.
1-- Richard L.
Asked By inf
08-Sep-08 08:40 PM
1
--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com
Thanks for your feedback, but it's still not working.
Asked By jpCB
08-Sep-08 09:24 PM
Thanks for your feedback, but it's still not working. I've tried integer and
string for the calculated field, but the window won't open when I
double-click or manually select the GoTo. I've tried the "Set value and run
field script" and just "run field script" but neither work. At least the "run
field script" one allows the window to open.
I guess let me ask this: how *should* one have the Goto check a checkbox?
I'm new to SLB and I can't find decent documentation or examples for GoTos
anywhere.
JP
If this is possible, I'm thinking an Advanced GOTO might work.
Asked By AdamEckrot
09-Sep-08 01:06 AM
If this is possible, I'm thinking an Advanced GOTO might work. Some defaults
are already embedded for Advanced Gotos. The documentation is somewhat
cryptic, but keep poking around.
Does KB 931006 answer your q?
What about KB 929208?
Asked By AdamEckrot
09-Sep-08 01:14 AM
What about KB 929208? That seems to hit the mark with Advanced Gotos and the
POP inquiry window. Good luck in any case. Keep us posted :)
Thinking outside of the box, no pun intended (at least not originally), what
Asked By Zaxxo
09-Sep-08 01:35 AM
Thinking outside of the box, no pun intended (at least not originally), what
about making the form/wind. default to have the boxes checked. Would this be
possible with modifier or extender?
SmartList Builder GoTo
Asked By jpCB
09-Sep-08 08:44 AM
I need something that shows how to handle checkboxes.
SmartList Builder GoTo
Asked By jpCB
09-Sep-08 08:45 AM
I really cannot modify the windows just because of this one SL.
It doesn't appear that Advanced GoTos are even in GP anymore.
Asked By jpCB
09-Sep-08 08:52 AM
It doesn't appear that Advanced GoTos are even in GP anymore. I click the
plus sign in the GoTo window, but there is no option for Advanced Go Tos. I
remember seeing that before, but I wonder if it was removed via SP2 or the
SP2 hotfix?
I still don't understand why a checkbox can't be set via the regular GoTo
task.
JP,You definately just game me new material for my blog with this post.
Asked By MarianoGome
09-Sep-08 01:25 PM
JP,
You definately just game me new material for my blog with this post. Here is
what you need to do for this SLB.
First the macro:
1) Open the Purchase Order Documents Inquiry window
2) Go to Tools > Macro > Record and enter a name for your macro.
3) Click on the checkboxes Open Purchase Orders, Receipts Received, the
click on the Redisplay button. DON'T CLICK ANYTHING ELSE and follow step 4.
4) Go to Tools > Macro > Stop Record
Now the SLB -- I will skip straight to the Go To steps:
1) Open SLB
2) Retrieve the SLB you are working on -- no calculated fields or anything
else needed, just the columns you want to display from Purchase Order Work
3) Click on the Go To button and make sure you have the following steps in
place in the one you were building to open the Purchase Order Documents
Inquiry window.
a) Task Type: Move the focus to a field, Field: Start Vendor ID
b) Task Type: Set the value of a field, Field: Start Vendor ID, Value:
Table.Vendor ID
c) Task Type: Move the focus to a field, Field: End Vendor ID
d) Task Type: Set the value of a field, Field: End Vendor ID, Value:
Table.Vendor ID
e) Task Type: Move the focus to a field, Field: Start PO Number
f) Task Type: Set the value of a field, Field: Start PO Number, Value:
Table.PO Number
g) Task Type: Move the focus to a field, Field: End PO Number
h) Task Type: Set the value of a field, Field: End PO Number, Value:
Table.PO Number
i) Task Type: Run a Macro, Value: (find the file for the macro previously
recorded).
Save and voila! You made my day, something new to blog on!!
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
Oops - looks like I didn't have it in my .set file.
Asked By jpCB
09-Sep-08 03:41 PM
Oops - looks like I didn't have it in my .set file.
The Advanced GoTo was the PO Inquiry window, but I need the PO Document
Inquiry window.
Still looking.
Thanks for the feedback though.
Thanks.
Asked By jpCB
09-Sep-08 03:45 PM
Thanks. I will give it a shot and see what happens :)
Plus, I get to be blogged as the "some guy" that needed a SLB solution.
SmartList Builder GoTo
Asked By jpCB
09-Sep-08 03:55 PM
Problem: if you run the GoTo a second time with the PO Docs Inq window still
open, it toggles the checkboxes back off and actually gives an error for the
Receipts checkbox because it is trying to uncheck a checkbox that is now
disabled because the Open POs checkbox is unchecked.
Back to the drawing board...
Your other option is to limit the Macro to click the Redisplay button and
Asked By MarianoGome
09-Sep-08 04:06 PM
Your other option is to limit the Macro to click the Redisplay button and
create a VBA customization that will enable both checkboxes when the form is
open. I noticed this, but was hoping you could get away with closing the
window always as the Goto would open it always anyways.
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
jp,If you add the Purchase Order Documents Inquiry window to Visual Basic
Asked By MarianoGome
09-Sep-08 04:26 PM
jp,
If you add the Purchase Order Documents Inquiry window to Visual Basic
(CTRL+F11), the Redisplay button, and the Open Purchase Orders and Receips
Received checkboxes to the VBA project (SHIFT+F11), then you can do the
following:
1) Open VBA and locate the PurchaseOrderProcessingDocu (Window) object in
your Project Explorer under Microsoft_Dynamics_GP, double-click to open the
Code Editor window.
2) Copy/Paste the following code:
Private Sub Redisplay_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As
Boolean)
If OpenPurchaseOrders.Value = 0 Then
OpenPurchaseOrders.Value = 1
End If
ReceiptsReceived.Value = 1
End Sub
3) Go to Debug > Compile. Save and close the VBA editor.
This should work flawlessly.
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
JP - AnyView Creator has a Goto function and from it, I have pulled the
Asked By AccountableTechSuppor
11-Sep-08 10:57 AM
JP -
AnyView Creator has a Goto function and from it, I have pulled the following
Goto code for the Purchase Order Processing Document Inquiry Window . See if
this helps:
************************************
CODE START
************************************
in string IN_POP_PO;
open form POP_Document_Inquiry;
if isopen(form POP_Document_Inquiry) then
'Sort By' of window POP_Document_Inquiry of form POP_Document_Inquiry = 1;
run script 'Sort By' of window POP_Document_Inquiry of form
POP_Document_Inquiry;
'All Or Range' of window POP_Document_Inquiry of form POP_Document_Inquiry
= 1;
'Start PO Number' of window POP_Document_Inquiry of form
POP_Document_Inquiry = IN_POP_PO;
'End PO Number' of window POP_Document_Inquiry of form POP_Document_Inquiry
= IN_POP_PO;
'(L) Receipts Received CB' of window POP_Document_Inquiry of form
POP_Document_Inquiry = true;
'(L) Open POs CB' of window POP_Document_Inquiry of form
POP_Document_Inquiry = true;
'(L) Historical POs CB' of window POP_Document_Inquiry of form
POP_Document_Inquiry = false;
run script 'Redisplay Button' of window POP_Document_Inquiry of form
POP_Document_Inquiry;
end if;
************************************
CODE END
************************************
DataBase SmartList Builder GoTo I'm trying to GoTo the PO Document Inquiry window, check the Open Purchase Orders and Receipts Received checkboxes, then fill in the PO Number From and To fields. I don't have a have the Goto check a checkbox? I'm new to SLB and I can't find decent documentation or examples for post. Here is what you need to do for this SLB. First the macro: 1) Open the Purchase Order Documents Inquiry 4. 4) Go to Tools > Macro > Stop Record Now the SLB - - I will skip straight to the Go To steps: 1) Open SLB 2) Retrieve the SLB you are working on - - no calculated fields or anything else Task Type: Move the focus to a field, Field: Start PO Number f) Task Type: Set the value of a field, Field: Start PO Number, Value: Table.PO Number g) Task Type: Move the focus to a field
first occurance for data that comes from four fields. 1. PO Number 2. PO Item 3. PO Line 4. PO Date Since there can be many items coming in on different PO's with different lines on different dates. I need to be great. Thanks Easiest solution would be two queries SELECT [Po Number], [po item], [po line] , Min([po date] as Earliest FROM [Your Table] GROUP BY [Po Number], [po item], [po line] Now use that saved query
of overflow error The SQL is as follows, SELECT DISTINCT [PO Works Order].[PO Works Order ID], [PO Works Order].[PO Item ID], [PO Works Order].[Works Order Number], [divide cost].[Additional info], [divide incoming invoice].[Price Each]+[Material surcharge each]) AS Portion FROM (([PO Works Order] INNER JOIN [divide cost] ON [PO Works Order].[PO Item ID] = [divide cost].[Item ID]) LEFT JOIN [sub incoming overflow, error description: The SQL is as follows, SELECT DISTINCT [PO Works Order].[PO Works Order ID], [PO Works Order].[PO Item ID], [PO
records related to a master record I have two tables - PO and PODetail. The PO table tracks such things as date, po number, vendor, etc. The PODetail table links to the PO table and contains detail information such as item, account number, quantity and paid status. If there is a PO with 5 PODetails, each entry in the detail can have it's own paid status. For example the PO 123 has 5 details and 4 have a paid status status of "no". I have a query that lists all PO's and their status. If a PO has any PODetail records that has at lease one paid of "NO", I would like the query that lists all PO's to list the status of unpaid. If all the PODetail records are paid, then the PO status would be paid. How can I parse the PODetail
DataBase PO amount different on PO Entry screen from printed PO Hi, We have a problem that seems to happen every Purchase Order Entry window, the subtotal on this one particular PO is $590, 776.35. However if we print the PO, the subtotal amount on the printed PO is only $472, 451.66. The only seems to happen on random PO's and we can't figure out why. It's Nathan, What version and service pack of GP? Are there PO's entered manually or imported? Is the PO report modified? Are there typically a lot of changes to the PO's that this happens to? - - Victoria Yudin Dynamics GP MVP
DataBase PO Line Item - Item Type Incorrect A user received a PO but inventory transactions were never created. After looking at the PO, the PO line item has a Item Type of non-inventory. The same item # is on the PO twice and the item type is correct on one of the PO line items. The item is setup as a Sales inventory decided to add the item and entered it on the PO again, forgetting to delete the first, non-inventory line. Frank setting was not marked prior to the entering of the PO, so the item itself is not the exact same item inventory. Perhaps a SQL query of the item on the PO could be compared with the item ID field in the MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com Is PO created through e connect? If PO created through e connect
DataBase PO Approvals We have a customer who says their PO's keep unapproving randomly - when using the PO Approval feature of POP. We have instructed the customer to print the PO's via Print PO Documents and not go back into the PO after it is approved. The user has approval authority upto 1, 000; and they can approve PO's for any user up to their authority. All other and can't really outline a pattern of when the po's unapprove. using the PO Approval feature of POP [sic].< This is not standard POP functionality, rather a part of PO Enhancements. Yes, plenty of ideas: 1) start by downloading and
DataBase Changing Vendor address on already printed PO When I printed a PO from the PO entry screen to the screen to preview I realized I vendor cards but it won't update on the existing PO. Any way to get this to change or than creating a PO in excel? The only way to fix this is to cancel the PO (cancel all PO line quantities) and re-enter the PO with the correct address. Once a PO has been printed, you cannot Void or Delete it. Frank so you know, the vendor address is "frozen" on the PO record at the time you save it - that's why