Sage 100

Hi - I'm trying to figure out if scripting is a viable option when trying to calculate/analyze data for exploded kit components or if I should turn this over to my Development Team for full custom programming. I have a set of scripts that connect to IM_ItemWarehouse, calculates and displays the Qty Available, and then sets the Backorder Qty on each line as needed with a pop-up message as each line item is entered. Neither of these scripts work for exploded kit items though, and I am wondering if this would require just some small tips to make work or if the effort is beyond my beginner skills? Any opinions, or samples that someone would be willing to share for me to incorporate if it's pretty easy? Thanks in advance!

------------------------------
Amber Prayfrock, Blytheco
------------------------------

Kudos to you for asking the question! Several cases of scripts that should have been custom programming but the scope was not understood or the question was not asked.

These are the questions for you to better understand if a mod is needed. Sorry for all the questions.

1. You're in S/O Entry, right?
2. Are you using B/M or I/M Sales Kits?
3. What event is your script currently firing off of?
4. Do you intend to Set or Ignore the Qty Avail and Backorder calcs for a component?
5. Do you intend to Suppress the pop-up message for a component?
6. Are the BOMs or kits ever ordered from stock (component's DON'T explode)?
7. Is JobOps / Op Mmgt involved where "hidden" but present work ticket lines could exist?

Depending on your answers, here are some Details fields you can potentially use:

SalesKitLineKey

• Set with a value if on a component and ExplodedKitItem = N
• Set with a value if on a Bill / Kit parent line and ExplodedKitItem = Y
• Set to blank/null otherwise

ExplodedKitItem

• Set to Y if a Bill / Kit parent and SalesKitLineKey has a value
• Set to No if:
  • On a component line
  • On an unexploded Bill / Kit parent
  • On an item not associated with a bill or kit, regardless of explosion

StandardKitBill

• If B/M integrated and using a Standard or Kit bill then Y. It means it's a bill parent regardless if components exploded.
• If B/M is NOT integrated or I/M Sales Kits used or item has nothing do with bills or kits, then N.

 

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

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA
------------------------------