Open Forum

Expand all | Collapse all

Negative Unit Cost - Purchase Requisition

  • 1.  Negative Unit Cost - Purchase Requisition

    Posted 14 days ago
    Hello everyone:

         When creating a Purchase Requisition, is there a way to add a line item with a negative unit cost ? The purpose is to itemize a discount and have it reflect on the PO when receiving. We're using GP2018.

    Thanks!
    Fenel A.



    ------------------------------
    Fenel Aldajuste
    City of Plantation
    Plantation FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Negative Unit Cost - Purchase Requisition

    GPUG ALL STAR
    Posted 14 days ago
    GP does not support negative unit costs on requisitions or POs for that matter. There two options the way I see it:

    Option 1 - Customize it!

    1. You can track the discount using an Extender window field, if you have Extender (from eOne, the developers of SmartList Builder) then get that popped into the PO manually, but at least it will be there for reference for the buyers to deal with.

    2. You can create a VBA customization, by creating a VBA form to capture the Requisition Number and the Discount Amount and store it in the DUOS. You can then use additional code on the POP Entry window to recall on the PO. Just keep in mind that VBA customizations are not compatible with Web Client.

    3. Create a Dexterity customization, which will work in similar ways to the VBA customization. Dexterity is the tool used to write Microsoft Dynamics GP.

    4. My friend @David Musgrave won't let me live if I don't tell you about his GP Power Tools product​. In Power Tools you could add a simple dialog that captures the discount, then recall it via a trigger on the PO form as well - very similar to Dex and VBA.

    Option 2 - Go the accounting route

    1. Create a credit memo for the discount (Purchasing > Transactions > Transaction Entry). Note which Requisition / PO it belongs to in the description. That way the accounting folks will now what to apply it to.

    2. Do your normal PO/Receiving/Invoicing process and post. When the invoice is posted. Accounting will then apply the credit memo accordingly per the instructions in the description.

    ------------------------------
    Mariano Gomez Bent, MVP, Dynamics Credentialed Professional
    Director of Technology
    Mekorma
    ROSWELL GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Negative Unit Cost - Purchase Requisition

    Posted 11 days ago
    Thanks for the detailed answer, Mariano. I appreciate it. I have Dex and VBA experience. I'll talk to the end-user and then decide the best approach if it's critical.

    Thanks again!! 


    ------------------------------
    Fenel Aldajuste
    City of Plantation
    Plantation FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role