Dynamics Community Forum Thread Details

How to read data BY USING VBA FOR PO LINE ITEMS IN GREAT PLAINS 2018

I have to update the Purchase order grid in GP. so on every line item which user selects on a PO, the system should display the message for a order quantity to the user that the Minimum order quantity for this line item is Y units for this specific vendor.In this regard, I want to use ITEM VENDOR MAINTENANCE WINDOW IN GP WHICH HAS MINIMUM ORDER QTY FIELD. Note that User enters the PO manually. We use PO generator as well to create PO based on qty.

Now the user wants that whenever they enter a Purchase order manually in GP, The system should give some intimation to the user that this vendor has minimum acceptable order quantity for this Line Item . I have never used VBA before, Can you help me please? will appreciate the efforts of anybody..

Down below is the VBA Code I am trying to do this but getting error of TYPE MISMATCH. In this code, I have to apply If check that if MINORQTY (minimum order quantity in table IV00103) Is 0 then dont display message but if Min order quantity is nonzero then MSGBOX should display the minimum order quantity. Can any body help how to do this as I am completely new for VBA

Thank you so much for your cooperation.

Categories:

Development / Customization / SDK

Quick Links

Leaderboard