Importing Reorder Quantities (Sage 300) - Spreadsheet Fields

Can anyone tell me what the fields mean in these two sheets for importing reorder quantities (see image links below)? I know what to put for the min, max, location, item number, periods, and reorder point. Are any of these fields not necessary to fill out when importing?

/resized-image/__size/640x480/__key/communityserver-discussions-components-files/140/pastedimage1790264682278v1.png

/resized-image/__size/640x480/__key/communityserver-discussions-components-files/140/pastedimage1790264701437v2.png

Parents
  • 0

    The Reorder_Quantities tab needs

    ITEMNO

    LOCATION (leave blank if you are setting reorder info for all locations)

    ORDERFOR (1 = specific location, 2 = all locations)

    DTLCOUNT (the number of related records on the details tab)

    Reorder_Quantities_Details

    ITEMNO

    LOCATION (leave blank if you are setting reorder info for all locations)

    PERIODSTRT (set to m/d/1900 for each season start date.  Use 1/1/1900 only if you aren't using seasonal data.)

    MINLEVEL, MAXLEVEL,REORDERQTY, SALESPROJ 

    ORDERFOR (1 = specific location, 2 = all locations)

    The relation between the two is ITEMNO and LOCATION and the detail count is the number of seasonal periods (at least 1)

    The optional fields tab is required and needs the title record but does not need any data.

  • 0 in reply to Rob Saunders

    Thank you! What exactly does the number of related records on the details tab mean? I intend to update the reorder quantities once a quarter and start over, so would the DTLCOUNT then just always be 1?

  • 0 in reply to olivia west

    The screenshot below shows an item with 2 seasonal periods.  DTLCOUNT would be 2 for this import because you would have two rows in the details tab for item A11030 and Location 1.  The first would have a PERIODSTRT of 5/1/1990 and the second would have 6/1/1990.

Reply Children
No Data