Open Forum

Expand all | Collapse all

Buy One (or more) get one free

  • 1.  Buy One (or more) get one free

    NAVUG ALL STAR
    Posted Apr 09, 2021 10:16 AM
    Edited by Lewis Rosenberg Apr 09, 2021 11:06 AM
    Hello D365UGBC/NAVUG Community,

    Just wondering, how do you handle Buy One Get One Free or Buy x Get one free situations for sales orders?


    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    www.apifishcare.com
    ------------------------------------------------------------------------
    D365UG-BC/NAVUG All-Star
    D365UG-BC/NAVUG Board of Advisors, Chairperson Emeritus
    D365UG-BC/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------
    ------------------------------


  • 2.  RE: Buy One (or more) get one free

    NAVUG ALL STAR
    Posted Apr 12, 2021 04:13 PM

    Lewis,

    Out of the box is not possible. I know LS Retail has the ability but you need there ISV/APP. Here is the code someone once wrote to make this work:

    "Quantity Disc. %" := 0;
    IF Type = Type::Item THEN BEGIN
    IF (Quantity = "Quantity Invoiced") AND (CurrFieldNo <> 0) THEN
    CheckItemChargeAssgnt;
    GetSalesHeader;
    IF SalesHeader."Allow Quantity Disc." AND "Allow Quantity Disc." THEN BEGIN
    ItemSalesQtyDisc.SETRANGE(Code,"Quantity Disc. Code");
    ItemSalesQtyDisc.SETRANGE("Minimum Quantity",0,ABS("Quantity (Base)"));
    IF ItemSalesQtyDisc.FIND('+') THEN
    "Quantity Disc. %" := ItemSalesQtyDisc."Discount %";
    END;
    END;
    VALIDATE("Quantity Disc. %");

    Hope this helps.
    Thanks,
    Steve


    ------------------------------
    Steven Chinsky
    Manager
    Wipfli
    Mansfield MA
    NAVUG/BC Programming Committee Member
    NAVUG All-Star, Granite Award Recipient, MCP, DCMP
    ------------------------------



  • 3.  RE: Buy One (or more) get one free

    NAVUG ALL STAR
    Posted Apr 12, 2021 07:47 PM
    Thanks Steve,

    One thought I had was to create a new item AA which was item A sold as a pair with a cost of a single A.
    An alternative is to manually manipulate the cost upon order entry or manually add a line with a 100% discount, but he idea is to avoid any manual entries.


    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    www.apifishcare.com
    ------------------------------------------------------------------------
    D365UG-BC/NAVUG All-Star
    D365UG-BC/NAVUG Board of Advisors, Chairperson Emeritus
    D365UG-BC/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------
    ------------------------------



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