SeedCodeComplete3

Inventory Transactions

Inventory Transactions

SeedCode Complete uses 3 types of Inventory transactions.

1. Shipments associated with Invoices.
2. Receiving associated with Purchase Orders
3. Adjustments made from the Inventory layout

These transactions are written to the Inventory Transaction table to give detailed history of an item's activity and how the current On Hand qty has been achieved.

Shipments

Shipments are entered on the Invoices layout by selecting the Shipments Panel and then clicking on "new shipment". This allows for multiple shipments per invoice. Partial qtys can be entered and the "open" qtys will be tracked for subsequent shipments. Existing shipments can be edited by clicking on their portal row on the main shipments panel. When Shipments are Saved, the items' On Hand Quantities are updated/debited (see below).

Editing A Shipment

Receiving

Receiving is vert similar to Shipments, but works on POs and incoming items.

Editing Receiving

On Hand Quantities

When an Inventory Transaction record is created in SeedCode Complete it serves as a "queue" to update the Item's On hand Quantity. When a Shipment Or Receipt is Saved, the transaction record has been created, but the On hand Quantity is not updated yet. Instead the Save routine calls a script in the SeedCode Complete file called Update Item Inventory From Transactions This script loops through all the new/open transaction records and attempts to update the On Hand quantity. Potentially, the Item record may be open and this attempt will generate a record lock error. In this case the transaction is left "open" and will try to make the edit the next time it is run.

Unless you are running a high volume operation with lots of folks submitting transactions at the same time, this most likely won't come up as the Control File script runs very fast. It's also adaptable for PSOS (Perform Script On Server) which should make record locking even less likely.

If you are running a high volume operation you may also want to have the Update Item Inventory From Transactions script running on a server schedule to pick up any that may have been locked the first time.

Regardless, these locked transactions do not fall through the cracks! and are reflected in the calculation fields QtyReceived and QtyShipped which affect the QtyAvailable field.

(855) SEEDCODE
[email protected]
Follow us: