AnnivOverview
Anniversary Storage Invoicing Overview
Table of Contents
Anniversary Storage Invoicing Overview 2
Anniversary Storage Invoicing Overview
Overview
Anniversary storage invoicing creates storage invoices based upon the date of receipt of an item. It allows for a rolling 30-day window by item and lot to accurately invoice storage for all product that was in the warehouse past each 30-day cycle.
This process uses the past period balance file as a starting point as to what was on hand at the end of the billing period. The ability to support non-standard closers is supported by using this method. Although the non-standard closers are supported, you cannot have a mid-month cutoff date.
When the process is invoked, the balance records for the previous period are used to determine what was in the warehouse. From that date, each item and lot (if applicable) is aged. For quantities that were received within the past 30 days, they are deducted from the balance record. The result is the total on-hand inventory that needs to be billed storage. Of the remaining quantity, each date of receipt is broken down. For example, if the ending balance is 100 on 10/31, 25 were received on 10/6, 25 on 9/15, and 50 on 8/26, 75 will be invoiced.
The invoice will be broken down to read:
| ItemX | 75 | $0.10 | $7.50 |
|---|---|---|---|
| Fr: 10/15 – 11/14 | 25 | $0.10 | $2.50 |
| Fr: 10/26 – 11/25 | 50 | $0.10 | $5.00 |
Once the on-hand balances are taken care of, the process will go back and see what shipped in the prior period. The order detail file is examined by item and ship date. It is read backwards and each day that the item is shipped, the total quantity is aged. This is done by starting with the on-hand balance (Balance record) and adding to that the quantity shipped. The total quantity is aged and only the quantity that was shipped is considered. This then continues through the whole period. For example, if 100 were in stock on 10/31 and 10 shipped on 10/20, and 20 on 10/15, then we would first age 110 as of 10/31 to get the age of 10. If the 10 were over 30, or any portion of it, then it is invoiced. On 10/15, the process will age 130 and only consider the 20 that shipped.
Just to add some complexity to this process, the cutoff date of the previous storage needs to be considered. If the product were received on 4/19, then the 20 that were shipped on 10/15 in the above example would NOT be invoiced. It was invoiced on the previous months’ storage invoice and should not be considered.