Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Feature/Opt Config

Status
Not open for further replies.

randva

Technical User
Jan 19, 2005
105
US
Macola 7.5.102e , Pervasive.SQL

I set up a few Feature/Option items in Macola. Everything works ok for Order Entry. However, at invoicing Macola issues out both the parent part number qtys and the component part number qtys. Can anyone tell me what I have set up wrong?

Thank you in advance for any suggestions.
 
What do you mean by issues ?
I think this is normal behavior. A F/O item can't be stocked thus the you are really issuing out the stock at the lower level items. Qty Sold will be on the Top Level only, usage will both be at the top level and the component level.
 


By "issues out" I mean Macola subtracts the number shipped from the quantity on hand for that item.

I see that the original F/O items are set up as stocked and controlled. Is there a way to change this now that they are set up and have usage?

Thank you for your help.
 
I am also unclear on what you want. If you ship an item and it is a stocked item, of course the qty on hand will decrease.

What is wrong with this scenario?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 

dgillz:

Thank you for your reply. The qty on hand of the F/O item is decreased. But the component qtys on hand are also decreased.

Since I have a cost set up for the F/O item as well as the components, Macola has in effect double hit the inventory value when that order ships.

For example:

F/O shows 0 on hand with cost of $200
2 components of F/O item show 1 each on hand with cost of $100 each.

We invoice an order with the F/O item above.

After posting, Macola shows:

F/O on hand -1 (with cost of $200, for extended cost = -$200)

Components on hand 0 each, (with cost of $100 each, gives an extended cost of $0)

The net effect of shipping decreased inventory by $400. It should decrease by $200.

I believe that changing the F/O item to non-stocked will fix this issue. Is there a way to change an item to non-stocked after it has been set up?

Again, thank you for any help.
 
To do it through Macola, the qty on hand, qty on order, qty backordered, and qty allocated has to be 0 and there can't be any open sales orders, open production orders, open purchase orders or open shop floor orders in those modules for that item.

In your case, you will need to do an inventory trx to set the qty back to 0. Delete any open orders you may have for that item and then you can go into the item master file and uncheck the stocked flag.

Kevin Scheeler
 
Are you actually producing the item in POP or SFC? This is what should increase the qty on hand of the FG nd decrease the qty on hand of the components?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top