Open Forum

Expand all | Collapse all

Purchase order line items

  • 1.  Purchase order line items

    Posted Feb 07, 2019 11:01 PM
    I have a situation related to PO lines created with PO generator and manual lines entered using the purchase order entry where company and/or address info is not the same on all the PO lines.

    The example is this:
    PO Generator is run and a list of PO's are created.
    If I add a PO line on a PO created with PO Generator, the Company Name (CMPNYNAM) field is blank.
    The PO Lines created with PO Generator has a Company Name in the (CMPNYNAM) field.

    Any idea why the lines added to a PO that was created with PO Generator have a blank Company Name?

    Does anyone know where the Company Name is supposed to come from for PO's entered manually?


    Jeff Roe
    Kele Inc
    Bartlett TN

  • 2.  RE: Purchase order line items

    Posted Feb 08, 2019 01:13 PM
    In the old days before PO Generator there were two types of PO.  (Even before Blanket POs when Intellisols APOP ruled the purchasing earth)
    PO = Standard
    PO = Drop-Ship.
    For the Dropship Type it was important to identify the Company Name for the Customer that the PO was to be drop shipped when the Customer was selected. Hence CMPANYID field was created to store the name of the Drop-Ship Customer

    So for all manual entry POs DROP-SHIP type  CMPANYID = Company Name from Customer Card RM00101 and the Line address data is from the Customer
    And for all manual entry POs STANDARD  type,  CMPANYID = blank and the line address data is from the Site ID (there is no Company Name on the Site ID)

    Now along came PO Generator. The creative developers added a x-reference table POP40800 to associate each SiteID with the CompanyAddresses Setups.
    When the PO is generated, they populated the Line address data with the CompanyAddress data not the SiteAddress data and filled in the CMPANYID field from the CompanyAddress associated in POP40800 with the SiteID. In the PO Generator Suggested Preview, the Ship To Address is a Company Address ID that popped in there based on the table and the SiteID for the item

    So for Standard POs manually created, the line address data comes from the SiteID.  No CMPANYID
    For Standard POs created by PO Generator, the line address data comes from the CompanyAddress associated with the SiteID. CMPANYID is populated.

    Now if you manually add a new line to a PO Generated PO the next line with be populated with the same CompanyAddress data and CMPANYID is populated OK
    But if you add a new line to the PO generated PO and you CHANGE the siteID, then the new line will be populated with SiteAddress data and CMPANYID will be blank because a manual PO line does not use the POP40800 cross reference table. Only the site ID

    Its enough to make your head hurt!

    Oh and if you have not completed the POP40800 X-Reference table for Company Address to Site IDs, then the PO generator will default to the Primary Display Company Address data as the Ship To.

    Here is the cross reference to associate SiteIDs (warehouses) with Company Addresses:

    Thaddeus Suter
    Retus, Inc

  • 3.  RE: Purchase order line items

    Posted Feb 08, 2019 01:46 PM
    Got it.

    Sometimes you gotta love the consistencies and standards.


    Jeff Roe
    Kele Inc
    Bartlett TN

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