Sage 100

I have a long-time customer on Sage 100 v2020. They use BOM and Production Entry as their quick & dirty mfg system.

For the most part, this works well unless they have to substitute a component on an item they are building.

They tell me they've tried both (a) options and (b) revisions.

The problem that they run into is once the item has been made from BOM Production entry -- AND they've made a substitution of a component from the standard bill - they lose visibility of what that component was that was swapped into the standard BOM.

In their case, it may be a particular model of camera.

The business problem comes when the customer calls in 3 to 5 years and the company then is trying to remember whether any substitution was made on that particular item that was built from BOM.

I have another customer in a similar line of business - they get around this by primarily using kits which they explode on the invoice. This gives visibility on exactly what was sold. I believe in this case the BOM is lengthier and not as easy to turn into a kit so I don't see kitting as a workaround here.

Any thoughts on the least complex way to resolve this and give some visibility into these final builds? Am I overlooking something easy that we could adjust the Sage BOM process for?

TIA



------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Thinking of this only because I helped another reseller with a client who wanted to be able to put in a production entry and print a report comparing the total sales prices of the components with the price of the FG on a sales order.
Had them use the SO number as the production entry number and tied that way.  

Could apply here, too - invoice will tell you SO number, then look up Prod Entry in history using that number.  If multiple items on an order, could A,B,C, prod entry number until you are up to using the entire 7 digits of your SO numbers.

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Tennessee Software Solutions
269-445-1625
------------------------------

I like that idea! 
Now they'll probably come back and say that sometimes they don't make it for a specific order and it goes into inventory before being sold.
At that point maybe turning the item into a lot valuation and assign a lot number that matches the production entry number?

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Yeah, I see a pattern here - sounds good!

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Tennessee Software Solutions
269-445-1625
------------------------------

Original Message:
Sent: 07-23-2021 14:04
From: Wayne Schulz
Subject: BOM Production Entry - Tracing Either Options or Revision - to Finished Good

I like that idea!
Now they'll probably come back and say that sometimes they don't make it for a specific order and it goes into inventory before being sold.
At that point maybe turning the item into a lot valuation and assign a lot number that matches the production entry number?

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Lot / serial valuation links back to a production entry.  From there you can see what was consumed in that batch (as long as you keep the history).  Number your lots / serial #'s for the SO if you want to make that easier to sort through.
​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------