Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Enterprise Resource Planning & Manufacturing
Lawson S3 Procurement
IC44 Current Days Stock On Hand
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
393
Members:
0
Total:
393
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Procurement
IC44 Current Days Stock On Hand
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Stedy1
New Member
Posts: 1
10/25/2013 1:14 PM
I am trying to determine the data set that is used to calculate Average days of use for an item that is used calculating Current Days Stock On Hand in the IC44 form. How many days back is the calculation going to get the total amount used of an item and what transactions types are also used in the calculation.
JonA
Veteran Member
Posts: 1162
10/25/2013 2:06 PM
Lawson
divides the total usage for the previous and current periods by the number of days in the previous period plus the number of days in the current period up to the current (system) date. Total usage means all issues, adjustments, receipts, and transfers.
Stephanie
Veteran Member
Posts: 86
12/19/2013 2:41 PM
Hello, I think I found the below formulas in a Lawson document somewhere but I can't be sure at this point. We utalize crystal reports an have modified this formula to take in available quantity (SOH - Allocated), for a more accurate estimated DOH.
Current Status Displays the current quantity information of the item selected at the particular location.
Current Average Daily Usage:
*Outflows this Period + *Outflows Last Period/
Number of Days This Period + Number of Days Last Period
* = IssuesQty + SalesQty + TransfersOutQty, which are viewable on IC49.1 (Usage History)
Current Days Supply on Hand:
Item Location Quantity Available/
Current Average Daily Usage
Current YTD Turn Rate:
*YTD Sales Qty + YTD Issues Qty/
Average Stock On Hand (**ITL-AVG-SOH-QTY)
* = YTD sales and issues quantity, viewable on panel IC49.1
** = ITL-AVG-SOH-QTY, viewable in the ITEMLOC/DBICITL table
This doesn't display very nicely on here but it's not giving me an option to attach a document. I can share this section of our manual with you if you'd like or the crystal - just let me know your email.
JonA
Veteran Member
Posts: 1162
12/19/2013 8:49 PM
You can't attach a document using Quick Reply. You have to click the Add Reply button which takes you to the more robust reply function.
Me
Veteran Member
Posts: 96
5/19/2020 9:09 PM
I'm trying to find the field for days on hand. Does that exist anywhere within the database?
Jeff N
Advanced Member
Posts: 32
5/21/2020 5:11 PM
It may be ICHISTORY and ITEMLOC. I think you may need to make sure IC135 has been run to update the averages.
You are not authorized to post a reply.