Sage 100

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

Please clarify what the physical process is (not the accounting or Sage 100 process) of splitting component quantities.. Using your example, does a 1250 unit bale get issued from raw material and sent for coloring then returned from the coloring vendor in 5 smaller bales?.. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------


Original Message:
Sent: 07-15-2024 12:30
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

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


Original Message:
Sent: 07-15-2024 11:50
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 11:18
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

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


Original Message:
Sent: 07-13-2024 10:02
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Raw material is shipped directly from the supplier to the Dyer vendor, where the client pays for the raw material at that time (received into a Sage 100 warehouse for the Dyer).  When the client wants a batch of dyed material, they send a PO to the Dyer (who already has the inventory) with weight and color.  The Dyer then processes the request, using the inventory they already have (...sitting in a separate Sage 100 warehouse), and ships the colored raw material to the client.

Edit:

Batch level inputs.  The output lots of Dyed material represent the physical containers of dyed material, with each shipped "bale" having it's own weight at time of shipping.

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


Original Message:
Sent: 07-15-2024 15:13
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Please clarify what the physical process is (not the accounting or Sage 100 process) of splitting component quantities.. Using your example, does a 1250 unit bale get issued from raw material and sent for coloring then returned from the coloring vendor in 5 smaller bales?.. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 12:30
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

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


Original Message:
Sent: 07-15-2024 11:50
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 11:18
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

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


Original Message:
Sent: 07-13-2024 10:02
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

I see the conditioned weight is 1250 and the baled weight is 245, 285, 275, 290, and 150.  What causes the 1250 to get broken down into the 245, 285 etc bales?  Are these different color dyes?

Raw material is shipped directly from the supplier to the Dyer vendor, where the client pays for the raw material at that time (received into a Sage 100 warehouse for the Dyer).  When the client wants a batch of dyed material, they send a PO to the Dyer (who already has the inventory) with weight and color.  The Dyer then processes the request, using the inventory they already have (...sitting in a separate Sage 100 warehouse), and ships the colored raw material to the client.

Edit:

Batch level inputs.  The output lots of Dyed material represent the physical containers of dyed material, with each shipped "bale" having it's own weight at time of shipping.

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


Original Message:
Sent: 07-15-2024 15:13
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Please clarify what the physical process is (not the accounting or Sage 100 process) of splitting component quantities.. Using your example, does a 1250 unit bale get issued from raw material and sent for coloring then returned from the coloring vendor in 5 smaller bales?.. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 12:30
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

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


Original Message:
Sent: 07-15-2024 11:50
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 11:18
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

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


Original Message:
Sent: 07-13-2024 10:02
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

1250 is the raw material input for that inventory component. 

(In one set of Bill recipes it could be... 900lbs of one component and 150lbs of another component, with 985 lbs of dyed output... the input weights never match the total output weights).

The bale quantities are the outputs, with sub-lot quantities based on the multiple physical containers of shipped dyed material. 

Each batch of bales are for the same color / dyed item code output.

I see the conditioned weight is 1250 and the baled weight is 245, 285, 275, 290, and 150.  What causes the 1250 to get broken down into the 245, 285 etc bales?  Are these different color dyes?

Raw material is shipped directly from the supplier to the Dyer vendor, where the client pays for the raw material at that time (received into a Sage 100 warehouse for the Dyer).  When the client wants a batch of dyed material, they send a PO to the Dyer (who already has the inventory) with weight and color.  The Dyer then processes the request, using the inventory they already have (...sitting in a separate Sage 100 warehouse), and ships the colored raw material to the client.

Edit:

Batch level inputs.  The output lots of Dyed material represent the physical containers of dyed material, with each shipped "bale" having it's own weight at time of shipping.

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


Original Message:
Sent: 07-15-2024 15:13
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Please clarify what the physical process is (not the accounting or Sage 100 process) of splitting component quantities.. Using your example, does a 1250 unit bale get issued from raw material and sent for coloring then returned from the coloring vendor in 5 smaller bales?.. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 12:30
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

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


Original Message:
Sent: 07-15-2024 11:50
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 11:18
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

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


Original Message:
Sent: 07-13-2024 10:02
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Thanks again for the help Doug.  At this point, I'm pushing the client towards buying PM... which does these kind of calculations automatically.  Cost to script something will likely be more than the PM cost, and PM will be a better solution overall.

1250 is the raw material input for that inventory component. 

(In one set of Bill recipes it could be... 900lbs of one component and 150lbs of another component, with 985 lbs of dyed output... the input weights never match the total output weights).

The bale quantities are the outputs, with sub-lot quantities based on the multiple physical containers of shipped dyed material. 

Each batch of bales are for the same color / dyed item code output.

I see the conditioned weight is 1250 and the baled weight is 245, 285, 275, 290, and 150.  What causes the 1250 to get broken down into the 245, 285 etc bales?  Are these different color dyes?

Raw material is shipped directly from the supplier to the Dyer vendor, where the client pays for the raw material at that time (received into a Sage 100 warehouse for the Dyer).  When the client wants a batch of dyed material, they send a PO to the Dyer (who already has the inventory) with weight and color.  The Dyer then processes the request, using the inventory they already have (...sitting in a separate Sage 100 warehouse), and ships the colored raw material to the client.

Edit:

Batch level inputs.  The output lots of Dyed material represent the physical containers of dyed material, with each shipped "bale" having it's own weight at time of shipping.

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


Original Message:
Sent: 07-15-2024 15:13
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Please clarify what the physical process is (not the accounting or Sage 100 process) of splitting component quantities.. Using your example, does a 1250 unit bale get issued from raw material and sent for coloring then returned from the coloring vendor in 5 smaller bales?.. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 12:30
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

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


Original Message:
Sent: 07-15-2024 11:50
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 11:18
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

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


Original Message:
Sent: 07-13-2024 10:02
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Yes, these are fun and challenging.  It's probably best to have production entry.  There are a lot of requirements and I am sure I don't fully understand the process.

My last post on this topic. From a simple perspective, not knowing all of the costs, processes, ingredients / components it seems like you could:

1. Inventory Adjustment to remove qty 1250 of item 123456 of raw material from the warehouse when the inventory is sent for dying.
2. Create a PO for the bales that will come back from dying. In your example there will be five line items, all with the same item code. During receipt of goods allocate the fees and assign a lot# for these "components".  I understand this isn't all of the costs.
3. Use Bill of Materials Production Entry to add additional costs and or ingredients to each of the bales and create a final lot#.

Thanks again for the help Doug.  At this point, I'm pushing the client towards buying PM... which does these kind of calculations automatically.  Cost to script something will likely be more than the PM cost, and PM will be a better solution overall.

1250 is the raw material input for that inventory component. 

(In one set of Bill recipes it could be... 900lbs of one component and 150lbs of another component, with 985 lbs of dyed output... the input weights never match the total output weights).

The bale quantities are the outputs, with sub-lot quantities based on the multiple physical containers of shipped dyed material. 

Each batch of bales are for the same color / dyed item code output.

I see the conditioned weight is 1250 and the baled weight is 245, 285, 275, 290, and 150.  What causes the 1250 to get broken down into the 245, 285 etc bales?  Are these different color dyes?

Raw material is shipped directly from the supplier to the Dyer vendor, where the client pays for the raw material at that time (received into a Sage 100 warehouse for the Dyer).  When the client wants a batch of dyed material, they send a PO to the Dyer (who already has the inventory) with weight and color.  The Dyer then processes the request, using the inventory they already have (...sitting in a separate Sage 100 warehouse), and ships the colored raw material to the client.

Edit:

Batch level inputs.  The output lots of Dyed material represent the physical containers of dyed material, with each shipped "bale" having it's own weight at time of shipping.

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


Original Message:
Sent: 07-15-2024 15:13
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Please clarify what the physical process is (not the accounting or Sage 100 process) of splitting component quantities.. Using your example, does a 1250 unit bale get issued from raw material and sent for coloring then returned from the coloring vendor in 5 smaller bales?.. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 12:30
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

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


Original Message:
Sent: 07-15-2024 11:50
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 11:18
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

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


Original Message:
Sent: 07-13-2024 10:02
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

They used to do something similar in the past (IA plus RoG...), but the IA of the raw materials breaks the data links required to write a report that they want (tracing raw materials, through the Dyeing process, through subsequent production entries, to sale). 

They track the metrics manually in Excel now, which is time consuming, so we want to change transaction strategy to something that allows data flow of the lot quantities, through proper production transactions.  I wrote queries, so the data flow / linking works if they do BM production, but the calculations / production entry transactions are too time consuming. 

Now I'd preparing to demo how PM will work.  Fun.

Yes, these are fun and challenging.  It's probably best to have production entry.  There are a lot of requirements and I am sure I don't fully understand the process.

My last post on this topic. From a simple perspective, not knowing all of the costs, processes, ingredients / components it seems like you could:

1. Inventory Adjustment to remove qty 1250 of item 123456 of raw material from the warehouse when the inventory is sent for dying.
2. Create a PO for the bales that will come back from dying. In your example there will be five line items, all with the same item code. During receipt of goods allocate the fees and assign a lot# for these "components".  I understand this isn't all of the costs.
3. Use Bill of Materials Production Entry to add additional costs and or ingredients to each of the bales and create a final lot#.

Thanks again for the help Doug.  At this point, I'm pushing the client towards buying PM... which does these kind of calculations automatically.  Cost to script something will likely be more than the PM cost, and PM will be a better solution overall.

1250 is the raw material input for that inventory component. 

(In one set of Bill recipes it could be... 900lbs of one component and 150lbs of another component, with 985 lbs of dyed output... the input weights never match the total output weights).

The bale quantities are the outputs, with sub-lot quantities based on the multiple physical containers of shipped dyed material. 

Each batch of bales are for the same color / dyed item code output.

I see the conditioned weight is 1250 and the baled weight is 245, 285, 275, 290, and 150.  What causes the 1250 to get broken down into the 245, 285 etc bales?  Are these different color dyes?

Raw material is shipped directly from the supplier to the Dyer vendor, where the client pays for the raw material at that time (received into a Sage 100 warehouse for the Dyer).  When the client wants a batch of dyed material, they send a PO to the Dyer (who already has the inventory) with weight and color.  The Dyer then processes the request, using the inventory they already have (...sitting in a separate Sage 100 warehouse), and ships the colored raw material to the client.

Edit:

Batch level inputs.  The output lots of Dyed material represent the physical containers of dyed material, with each shipped "bale" having it's own weight at time of shipping.

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


Original Message:
Sent: 07-15-2024 15:13
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Please clarify what the physical process is (not the accounting or Sage 100 process) of splitting component quantities.. Using your example, does a 1250 unit bale get issued from raw material and sent for coloring then returned from the coloring vendor in 5 smaller bales?.. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 12:30
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

Thanks Doug, but I don't see how that helps with splitting the inventory component quantities.  They need both the fee amounts and component inventory to be proportionally allocated.  Each Dyed Lot# is a production entry, flowing component costs (and fees) into the finished goods.

They used to play with the Product Line GL accounts (adjustment account changed to a clearing account), do an IA to remove the raw material from inventory, and then receive the Dyed material using Landed Cost to proportionally allocate the $ amounts (fee and inventory value through that clearing account), but the IA broke lot traceability... which is the request that started the project.

They want to trace finished goods back to the original raw material purchases so they can compare purchased weights of a natural product (wool) to how much was produced from those weights (plus the associated revenue)... and the transaction path flows through the dying process.

We need a Production entry for each finished goods lot# with the component inventory (lot valuation) flowing into the finished goods, proportionally.  Using RoG and Landed Costs only helps to split the fees, not the raw materials.

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


Original Message:
Sent: 07-15-2024 11:50
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Set up a "coloring" item code (component) with a valuation of lot.  Add the coloring item as a component  to the BOM. Don't enter a production entry until the coloring items are received back from the vendor.  When the coloring items are received, assign a lot number to each quantity (bale weight) and then use landed cost to allocate the coloring fee based on the bale weight.  After the receipt of goods is updated then enter the production entry to allocate the coloring lots components to production.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 07-15-2024 11:18
From: Kevin Moyes
Subject: BM batch inputs, with multiple lot outputs

They actually get the invoice and know the inputs / outputs before physically receiving the goods.  Here are the basic calculations (with up to two material inputs and two fee types, but the math is the same... just applied to more items). 

• Yellow cells are inputs; green numbers are the calculated amounts. 
• Rounding numbers at the bottom are currently added / subtracted manually because we want the quantities / amounts of the multiple production entries to match the batch inputs, exactly.

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


Original Message:
Sent: 07-13-2024 10:02
From: Doug Higgs
Subject: BM batch inputs, with multiple lot outputs

Is the challenge to get the correct cost of the outsourced coloring process added to the inventory?  Can you provide a basic example of the manual calculations they currently use?  Do they or could they create the production entry to get the known costs into the outsourced warehouse before the outsourced costs are added?  if so, could they then put the items from the outsourced warehouse on a PO and then use landed cost to add/allocate the coloring costs during the receipt of goods process?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles