Deactivating "Sales Quantity Shortage Options" on order entry 2

[markajem]

GP Enterprise 6

When entering a sales order is there any way to deactivate the popup screen "Sales Quantity Shortage Options" in SOP setup? It gets very bothersome because we will always list the item on the order even if we do not have it in stock and will always want to overide the shortage. This slows the order entry person down terribly becuase sometimes it takes time for it to come up and by then they are 3 items ahead and find that they have now to reenter those 3 items. If we could deactivate this then we wont have this problem.

Thanks
Mark

 

[mnla2z]

From the f1 help
Go to setup-sales-sales order proc. Then choose Invoice, and select your document
Use this field to determine how the invoice will be allocated. You can allocate by line item or by document and batch.

If you select Line Item, items will be allocated as they're entered on the invoice. If a quantity shortage exists for an item, you'll be required to enter the quantity shortage options as you enter the items.

If you select Document/Batch, you can allocate entire documents or batches using the Sales Allocation-Fulfillment Options window. This option allows faster data entry because items aren't checked for quantity shortages until the entire document or batch is allocated.

Best regards,
MG

 

[winthropdc]

You can use VBA or Dexterity to automate the selection on the pop up window.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[Dukester0122]

David,

I've been planning on writing a code for this because my users are also complaining.

Do you have the script available? Would appreciate if you could post it.

Thanks,

Duke

 

[winthropdc]

Duke

I am going to assume that you want to do this with VBA. So below is what you need.

Get the window open and add the window, the Quantity Shortage Option field and the OK Button to VBA.

Go to the VBA editor and add the following code to the SalesQuantityShortageOption module in the Great Plains project:


Option Explicit

Private Sub QuantityShortageOptions_AfterGotFocus()
QuantityShortageOptions.Value = 2
OK = 1
End Sub

Private Sub Window_BeforeOpen(OpenVisible As Boolean)
OpenVisible = False
End Sub

Select Debug >> Compile Great Plains. From now on you will not see the window and it will always select Override Shortage (which is the 2nd option).

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[markajem]

Duke, thanks for the helpful code. I will run it by my MIS Director. Another question Duke, will this change only effect a particular user, or is the change global. I have just found out that 1 of the 3 users require that screen to come up for more information for their job.

Thanks
Mark

 

[Dukester0122]

Thanks Dave. Yes, I'll do it with VBA.

 

[winthropdc]

Mark

It was me, not Duke who posted the code. This change would be per workstation as the DYNAMICS.VBA file is stored per machine.

You could export the package once the code is entered and install it on the other workstations.

You can also copy the DYNAMICS.VBA as long as all the machines have GP install in the same folder and you have not referenced external DLLs. If you have referenced external DLLs then only if the DLLs and all other references are in the same locations on all machines, copying the VBA files can work.

For your one user you can add the UserID field from the Toolbar to VBA and then check for that user in your script so that the same code can be installed on all workstations.

PS: If you like the code.... click the thank me link.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[Dukester0122]

Tweak your code a little bit to make it work. Was getting Compile error.

Here's the final code:

Option Explicit

Private Sub SalesQuantityShortageOption_AfterGotFocus()
End Sub

Private Sub Window_AfterActivate()
QuantityShortageOptions.Value = 2
OK = 1
End Sub

Private Sub Window_BeforeOpen(OpenVisible As Boolean)
OpenVisible = False
End Sub


Now you can thank me for the code.

 

[winthropdc]

As long as it works..... Thanks Duke.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[Dukester0122]

Just teasing Dave....Anyone upgraded to ver8.0? Can you give us any feedback.