Sage 100

Have a client requesting if the following is doable. I am not sure if scripting could handle this. Any ideas? ""We would indicate the cost markup % as the Item pricing method for each part number, but I want Mas to enter on the SO/Invoice using a base multiplier of FIFO (our valuation) which would be variable based on the tier as it exists at them time of SO Entry and eventual billing. With the way FIFO costing changes due to a volatile raw material, it is difficult to maintain accurate cost in the field Mas currently looks at to use any pricing method. I need Mas to look at what cost tier it is pulling from and bill accordingly at the indicated pricing method. Note: this is not for all items. Just selected items right now; but if this can work, it may very well become useful across many more items and/or product lines.

They are out of their mind ... the FIFO tier isn't even known until the Sales Journal is posting, so this would not even be possible.

I know Jane, but had to ask. Wasn't sure if someone had figured out some alternative. Just trying to figure out a potential alternative during invoicing.

If they really want to be driven even further out of their minds, they could switch to lot valuation and reserve the lots at the time the sales order is placed...