Current Work – Enter HuskyBuy Purchased Materials as Misc Costs in FAMIS

There is a feed from KFS that contains the following fields:
  • Document/Notification Id (Column A)
  • Document Description (Column B)
  • Organization Document Number (Column C)
  • Requisition # (Column D)
  • Requisition Status Description (Column E)
  • Chart/Org (Column F)
  • Suggested Vendor (Column G)
  • Date Created (Column H)
  • Chart Code (Column I)
  • Account Number (Column J)
  • Organization Code (Column K)
  • Ledger Document Type (Column L)
  • Total Amount (Column M)
  • Route Log (Column N)
FAMIS Configuration – Create the HUSKY BUY Cost Type (Navigate to configuration) HuskyBuyMiscCosts10.08.00 AM
FAMIS Configuration – Create the HUSKY BUY Cost Type (Create HUSKYBUY Cost Type) HuskyBuyMiscCosts10.09.50 AM
FAMIS Configuration – Create the HUSKY BUY Cost Type (Configure HuskyBuy Cost Type Attributes)  HuskyBuyMiscCosts11.01.02 AM
 FAMIS Configuration – Create the HUSKY BUY Cost Type  (Configure HuskyBuy Cost Type Accounts)
This ensures that HuskyBuy misc costs created in FAMIS will default to the Misc Cost Acct Group with the object Code=6940		  HuskyBuyMiscCosts10.55.44 AM
 Entering MISC COSTS into FAMIS – Click MISC COSTS Quickpick
 Enter the data from the identified column into the identified FAMIS Field:

  1. Cost Type is Automatically Generated
  2. Cost Type = “HUSKYBUY”
  3. WO NUMBER = Organization Document Number (Column C)
  4. Trans Date = Date Created (Column H)
  5. Description = Document Description (Column B) {Note: the description field defaults to “Materials Purchased Via HuskyBuy”.  This should be deleted
  6. Rate = Total Amount (Column M)
  7. UM is Defaulted to EA
  8. Quantity = “1”

Save the data on the form to activate the Accounts… Button and the Attributes tab

  HuskyBuyMiscCosts10.24.24 AM
 Click the Accounts… Button. The default fields will be populated as shown.  Click the Accounts button.  HuskyBuyMiscCosts10.55.44 AM
 Enter the data from the identified column into the identified FAMIS Field:

  1. KFS Account = Account Number (Column J)

Click the OK button

  HuskyBuyMiscCosts10.44.06 AM
 Click the Attributes Tab.  Enter the data from the identified column into the identified FAMIS Field:

  1. Document ID = Document/Notification Id (Column A)
  2. Requisition # = Requisition # (Column D)
  3. Requisition Status = Requisition Status Description (Column E)
  4. Vendor = Suggested Vendor (Column G)

Save the data on the form.

  HuskyBuyMiscCosts11.33.43 AM
The Miscellaneous Cost is now properly associated with the Work Order HuskyBuyMiscCosts10.28.27 AM
FAMIS Data Model – Tables relevant to HuskyBuy loader process HuskyBuy Loader ERD - New Page