[SAP]
[Background]
material documents - system documents that log material movements.
material movements - any sales, transfer or purchase transactions involving materials.
materials - goods used for business operations.
[/Background]
1. What is the run date? Is it today? Is it in the past? If so, find the closest record of the closing balance.
2. How many days difference is the run date from the closest record? Take note of the dates.
3. Fetch all the material documents within the date range. Add / subtract them to the stock balance.
Sounds simple? My user wanted such a report in 3 days. I once took 1 month to write it; 2 more months to iron out the bugs.
Q&A
===
q1. Wasn't this one of your proudest work? Why are there still bugs in it? *snickers*
a1. ... Well, it's cleaner now.
q2. The current state can only show either normal stock or consignment stock in a single execution. Your user wanted to merge the normal stock and consignment stock report generation together. Are you going to do it for her?
a2. Well, looking at that I have like ONE day left before Monday and the other report is far from finished, I say she can take it or leave it. The report is completed, for all that it matters to me. Just run in twice in 2 different modes! Sheesh!
a3. Isn't that slow?
q3. Combining the two functions together will still take the same amount of time...
a4. Are you unstable?
q4. No, why?
a4. Nothing...
No comments:
Post a Comment