Anniversary Storage Inv
Anniversary Storage Invoicing
Table of Contents
Anniversary Storage Invoicing 2
Anniversary Storage Invoicing
Task Description
Team Logisco in Little Rock has the need to create storage invoices based upon the date of receipt for at least one of their accounts. This need was then designed to become part of base WDLS. The process 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
Processing Summary
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 lotted) are 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.
Exit Points
SISTYLE.
- Add choices:
- SIP14RAV Print Storage Invoice (Aniv) Overlay
- SIP14RV Print Storage Invoice (Anniversary)
- Setup:
- Select either of the two new choices
Menu Options
No new or changed menu options.
Work with Options
STW01R – Change option SIP10C to SIP01R
??? – Change option SIP12C to SIP02R.
Web Scripts
None
Error Messages
None
Files Used
SIP60P – All anniversary invoices are stored in different members the same as SIP10P. You will want to query this file during any research. It contains the aging dates.
Setup Instructions
Storer Setup: Change the cut off to “V”
Operational Procedures
All current operational steps were not affected.