enable customer id field on standard PO's

(0) Share

Report

Posted on by Community Member

I have a customer who wants to enter their customer's shipping address in the standard PO. When they select standard PO, the customer ID field in the Purchasing vendor detail entry window is disabled. I added the window and customerid field to VBA and tried doing this

CustomerID.enabled = true

but GP throws an error saying

Run Time error 1003: Unsafe operation. This operation could compromise the integrity of the application.

How do I enable this field so user can select a customer and then select an address for this customer as the shipping address.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

GPDavid 2,250 on at

Like (0)

Report

The Customer ID field is only available for drop-ship (and blanket drop-ship) Purchase Orders. Is this what your customer is trying to accomplish (i.e. shipping product from vendor directly to the customer entered in the Customer ID field), or are they trying to use Customer ID field for different reason? David

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

[quote user="Hamza Josh"]I have a customer who wants to enter their customer's shipping address in the standard PO. When they select standard PO, the customer ID field in the Purchasing vendor detail entry window is disabled. I added the window and customerid field to VBA and tried doing this
CustomerID.enabled = true

but GP throws an error saying

Run Time error 1003: Unsafe operation. This operation could compromise the integrity of the application.

How do I enable this field so user can select a customer and then select an address for this customer as the shipping address.
[/quote]You can't and you shouldn't and for what it's worth, this is where knowing the application's functionality helps a lot before you start working on code.

IF YOU MUST enter a Standard PO -- and the only reason I can think of why you want to do this is because a) your customer is a broker and pays his vendor on behalf of his customer, b) as a brokerage, he bills his customer charging some sort of commission -- then you can use the free form text fields next to the Ship To address in the PO. If you really need to be a customization, the only one I can think of here is adding a lookup button so you can choose a customer to fill in the free form string fields (that default with your customers ship to address location).

Other than that, that's why the SOP to POP functionality is for or the drop ship POs in POP.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

THey are trying to ship directly from vendor to customer. THey are also using manufacturing series and using Drop Ship PO's somehow screws up thier costing on receiving so they use Standard PO's but it is not practical to enter every customer's address as their ship to address.

Any ideas how to resolve this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Mariano, Got it. I will try to add another field on the form and use that field rather than customer ID field. I was trying to take a shortcut as all the logic I require is built in there, just need to enable the customer ID field :)

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

[quote user="Hamza Josh"]Mariano, Got it. I will try to add another field on the form and use that field rather than customer ID field. I was trying to take a shortcut as all the logic I require is built in there, just need to enable the customer ID field :)[/quote]
Actually, I feel you did not get it. Since you are looking up addresses, you will want to add a button that will allow you to call the Customer Address lookup window. When an address is selected, the information returned would be all the address and contact fields.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am a newbie, would you be able to actually give me some sample code i would need. How would I have the customer address lookup window show up? How would I have the customer ID filled in based on some field on the form? Once i get that, how do i return the address and contact fields and populate the address field of the PO?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have a button which opens the address lookup window but it is empty with NO address ID's.I do have a field to hold the customer ID. How do i pass the value of that field to this window. I am using execute sanscript function as below.

Temp1 = "open form 'Address_Lookup';"
I = objGPApp.ExecuteSanscript(Temp1, Temp2)

How do I make it show address ID's of a particular customer and when one of the ID's is selected, How do I get that information and make it the ship to address on the PO? Any help would be appreciated.

Was this reply helpful? Yes No