The Data Model – How data flows in Streamline

> > > > > > > > Time > > > > > > > >

Orderline & Deadline
    1. The orderline is open until deadline, which may be set individually by item or item group, or generically.
    2. Before deadline, Customers and yourself may use the Cart and Standing Order to place and amend orders. Not after deadline.
    3. Deadline must be set generically. This is the latest (generic) cut off point in the day
      [Production > Settings]
    4. An item or item group may have an individual deadline and it must be before the generic.  Therefore, the generic must be after all individual deadlines: [Items > Master Catalogue > Edit Item > Deadline]
The Snapshot
    1. Snapshots only happen once a day
    2. They trigger at Order Deadline, (if set to automatic)
      [Production > Settings] & [Production > Snapshots]
    3. They generate Unprocessed Invoices, given a customer’s current price and quantity ordered.
      [Finance > Invoices > Unprocessed]
    4. Snapshots lock the orderline according to the [production time] of the item:
      0 for next day,
      1 for day after, etc.
      [Items > Master Catalogue > Edit Item]
Unprocessed Invoices*
  1. After snapshot, data goes to Unprocessed Invoices
  2. Customers, Cart and Standing Order can no longer make changes to items that have gone into production
  3. Use Late Orders to create an invoice for a customer who does not have an Unprocessed Invoice
    [Production > Cut & Shape > Late Orders]
  4. Use Pick and Pack to amend quantities for items already on order
    [Distribution > Pick & Pack]
  5. Use Unprocessed Invoices to add items to an existing invoice
    [Finance > Invoices > Unprocessed]
  6. Only items that are in production are on the Unprocessed Invoice.

    If the invoice contains items with different production times, it further populates every day with items that go into production.
Published Invoices
  1. On publish, invoices are instantly posted to the customer’s invoice library.
  2. Published Invoices are ready to be exported to accounting.
    [Finance > Invoices > Published > More > Export to accounting]
  3. No changes can be made to a Published Invoice.  This is prudent accounting: the customer has downloaded it and posted it to their books. Discrepancies would lead to problems.
  4. Use credits or a new invoice (Late Order) to make amendments to a Published Invoice

*Unprocessed Invoices

Snapshots populate Unprocessed Invoices.

Items whose production time expires are added to the Unprocessed Invoice, using the valid price for the customer at the time of the snapshot.  

Prices and quantity are subject to change at all times, therefore we use snapshot time (order deadline) to lock the two.

An Invoice may have two or more items with different production times, therefore, an Unprocessed Invoice is subject to change, from one day to another, as items with different production times are added on different days.


Monday’s snapshot locks production times and generates Unprocessed Invoices as follows:

0 for Tuesday

1 for Wednesday

2 for Thursday

So, an Unprocessed Invoice generated for Thursday on Monday only has the 2’s.  On Tuesday, we will add the 0’s and on Wednesday the 1’s.

To see what is locked from customers go to Finance > Unprocessed Invoices.