Our customer who needs the POS also needs some some significant other work. The key challenge is moving some critical processing they now do in 3 aging independent Access programs completely or mostly into MAS 200.
One of the program functions generates the pricing for the mixed-feed products they produce and sell retail. We could treat the feed product as either IM items or Misc Items. For now, consider Misc Items only, capturing the 3 account codes and description. (Do NOT worry about PO or inventory costing issues for now.)
The price of each Misc Item is a function of several cost factors, including ingredient costs. the price also consider several overhead elements, entered more like Kentucky Windage than anything else. One possibility is setting up a scheme to update these in an interface which enters the values into a UDT with ProducCode as the row, and the several factors in the columns.
The question is, what might be the most user-friendly interface to that table? We doubt that a straight Custom Office form will be acceptable to them. But if we do an Excel/Access interface, must we import the data to the UDT via VI, or can we use BOI coding to read and write to it? (We would use scripting to update the $$$ values in the Common Item table from this UDT.)
Thanks for your thoughts!