Sage 100

 View Only
  • 1.  Added a UDF_shipperaccountno in AR_Customer would

    Posted 05-03-2012 13:40
    Added a UDF_shipperaccountno in AR_Customer would like it to carry over to S/O_Orderheader & S/O_invoiceHeader. Not showing up anywhere.


  • 2.  RE: Added a UDF_shipperaccountno in AR_Customer would

    Posted 05-03-2012 13:44
    do you want to display on screen or have the udf field as part of the header file. if the latter, you need to add another udf in the so_header and link to the ar_cusotmer field.


  • 3.  RE: Added a UDF_shipperaccountno in AR_Customer would

    Posted 05-03-2012 13:50
    First map your AR_Customer UDF to the Sales Order in the User Define FIelds Data Sources panel. Chose CustomerNo as the Data Source and your UDF as the column. Then follow the help files. Search on keyword MAP and look for the detailed instructions for mapping invoice detail to history. (S/O is similar to the A/R instruction)


  • 4.  RE: Added a UDF_shipperaccountno in AR_Customer would

    Posted 05-03-2012 14:23
    What you wish to do is pretty common. You'll need to follow Dan's advice and create udf's in each appropriate table if you want the shipper account # to flow to the invoice data entry and invoice history tables.


  • 5.  RE: Added a UDF_shipperaccountno in AR_Customer would

    Posted 05-03-2012 19:11
    You can take this a step farther by if you have multiple ship to codes. In addition to adding the UDF in the AR customer master, you can also add it to the Ship To table. Then have your SO header UDF pull from both fields. Also, don't forget to circle back by adding the AR Invoice History Header UDF to the SO Header UDF in case you create the SO from a copy from the Invoice History. Finally, are you using this field to populate the WorldShip records?


  • 6.  RE: Added a UDF_shipperaccountno in AR_Customer would

    Posted 05-03-2012 19:17
    Yes, They are using Starship and they would like to see this field and map it to the customer's UPS account so they can be billed by UPS


  • 7.  RE: Added a UDF_shipperaccountno in AR_Customer would

    Posted 05-03-2012 19:27
    Several of my clients do this now. They love it.