Sage 100

 View Only

  • 1.  Product Line Change in Item - Need to Effect Change in PO's

    Posted 04-11-2019 21:21
    ​​I need to change a number of product lines and delete old ones in Item Maintenance.  No problem with that.  SO's automatically reflect the new product lines for the items.  However, PO's don't.  VI doesn't even give Product Line as a selection.

    Is there any way to make PO's line item's Product Lines to reflect the new Product Lines in Item Maintenance?  It looks like I need a script for this.

    Anyone had gone through this before?


    ------------------------------
    Cynthia Hay
    Hughes Systems Group, LLC
    ------------------------------


  • 2.  RE: Product Line Change in Item - Need to Effect Change in PO's

    Posted 04-12-2019 02:03
    Edited by Alnoor Cassim 04-12-2019 02:10
    Assuming I'm not missing something blaringly obvious, for PO lines, ProductLine is marked as Read Only in the dictionary. I have several old posts on how to remove that attribute so it's available for V/I import but this doc here by @Kelly Sappington very nicely puts it altogether (thank you Kelly!). It would also apply to PO Rcpt Detail lines in case you have open ROG or ROI batches. Also if you decide to go the script route, prolly you will need to do SetValueNoValidate instead of SetValue

    ​How_To_Add_Fields_to_a_VI_Import_File_REV



    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 3.  RE: Product Line Change in Item - Need to Effect Change in PO's

    Posted 04-12-2019 11:32
    Awesome, thanks Alnoor, I will give it a try.  (Somehow, I didn't find any old post at all.  Must have had the wrong wording.)


    714/240-2056 (cell)



    ------Original Message------

    Assuming I'm not missing something blaringly obvious, for PO lines, ProductLine is marked as Read Only in the dictionary. I have several old posts on how to remove that attribute so it's available for V/I import but this doc here by @Kelly Sappington very nicely puts it altogether (thank you Kelly!). It would also apply to PO Rcpt Detail lines in case you have open ROG or ROI batches. Also if you decide to go the script route, prolly you will need to do SetValueNoValidate instead of SetValue

    ​How_To_Add_Fields_to_a_VI_Import_File_REV



    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


  • 4.  RE: Product Line Change in Item - Need to Effect Change in PO's

    Posted 04-12-2019 11:43
    You probably have already considered the obvious inventory GL balances by PL, but if you have different Purchases Clearing accounts by PL, any PC amounts after your change will have to be moved to the correct account by GLJE...similar to IM balance updates.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Product Line Change in Item - Need to Effect Change in PO's

    Posted 04-16-2019 14:23
    Alnoor's tip worked perfectly.

    Thanks, Kevin for the reminder on GL.  The client doesn't have GL by PL but it's a good point to discuss with them anyways, so that all departments are aware of the possible impact.


    714/240-2056 (cell)



    ------Original Message------

    You probably have already considered the obvious inventory GL balances by PL, but if you have different Purchases Clearing accounts by PL, any PC amounts after your change will have to be moved to the correct account by GLJE...similar to IM balance updates.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------


Related Content