Mark,
We build Purchase Orders daily, and order items from our vendors daily (we sell printer ctgs and paper to businesses, so the products are repeatedly bought and sold daily and weekly). Costs can change daily or weekly, and with some of our margins being as low as 2 or 3%, it's important that our sales reps have exact cost information so we can adjust pricing daily or weekly. So, each night, the Purch!ItemCost values from that day are automatically posted to the Inventory file's LastCost field.
Purch pulls the ItemCost from the Inventory database!LastCost field. The ItemCost is confirmed with the vendor when the PO is verbally placed. If the cost has changed from the last time, then that new cost is entered into the PO. That night, the PO Line items are posted to the Inventory database LastCost fields, so the new cost is reflected the next day.
I wrote a bunch more description, but deleted it (I doubt anyone's THAT interested).
Bottomline, I'd like to use one LineItem database as a subform for both the PO and the SalesOrders databases. It would include cost and price fields, but I would just hide the price field via programming in the PO subform, and gray-dim the Cost field in the Order database subform so it can be viewed but not directly altered via the Orderscreen.
So we could enter a new cost in a real-time PO, and have that new cost instantly hit the Inventory!ItemCost field, and thus be available instantly when a Sales Order is placed 30 seconds after the PO Item is confirmed, or when a new price record is created in the Pricing database (instead of with QA, where the updated cost doesn't show up until the next day, after batch posting is done at night via macro posting routines).
By the same token, in Orders, when I enter an Item number in the LineItem subform, it should pull that specific client price for that item (said price might be unique to that client) into the price field of the line item. It should also pull in the ItemCost from the Inventory cost field. If the Item Cost is realtime updated, then I might see that the standing Price from the Pricing database is now too low. I'd like to be able to enter a new price on the fly into the Price field, and upon saving that line item, have the new Price be updated into (via programming) the Client's Pricing record for that Item.
So, the goal is: A) enter costs in the PO LineItem subform during a PO transaction and have everyone see the new cost instantly from the Inventory, Purch, Pricing, and SalesOrder databases. B) enter a new price in the SalesOrder LineItem subform during an Order entry and have everyone see the new price instantly from the Orders or Pricing databases.
... I thought I had read (and observed in my initial playing around with designing some forms) that if a natural link line item database was used for subform for a PO, then that subform couldn't be used for the Orders database, or any other database.
|