FrontAccounting forum — Manufacturing dashboard issue

Re: Manufacturing dashboard issue

2017-11-07T15:03:45Z

Ah @notrinos, you are persistent

As you said yourself, what about Item Adjustments (ST_INVADJUST) should be included.

Just to eliminate misunderstandings it is easier to just exclude ST_CUSTDELIVERY and ST_CUSTCREDIT.

So we have committed this as a rerun.

But thanks for the discussion. It is a refreshment to do a little thinking

/Joe

Re: Manufacturing dashboard issue

2017-11-07T14:49:32Z

As you mentioned we are only interested in the produced numbers.
I think the flowing is ok :

$sql .= "AND s.mb_flag='M' AND m.type = ".ST_WORKORDER." ";

Re: Manufacturing dashboard issue

2017-11-07T14:38:16Z

Not much. It will be added if it is a positive adjustment and subtracted if it is a negative adjustment.

I guess we have taken care of all options now, right?

/Joe

Re: Manufacturing dashboard issue

2017-11-07T14:33:29Z

And even location adjustments can cause the wrong statistics

Re: Manufacturing dashboard issue

2017-11-07T14:32:15Z

It should be ok to make location transfer. It will be included with plus and minus. Remember it is a total of all locations.

/Joe

Re: Manufacturing dashboard issue

2017-11-07T14:29:19Z

No @Joe, what about location transfer ?

Re: Manufacturing dashboard issue

2017-11-07T14:23:24Z

@notrinos, Well

Look at my explanation in my former post. We are only interested in produced items (minus ev. disassemblies).
All deliveries and credits are of no interest for us. Isn't that right?

$sql .= "AND s.mb_flag='M' AND m.type <> ".ST_CUSTDELIVERY." AND m.type <> ".ST_CUSTCREDIT." ";

I have double checked this and it works.

I will rerun a commit now.

/Joe

Re: Manufacturing dashboard issue

2017-11-07T14:15:52Z

Which transaction can make m.qty < 0 AND m.type = " .ST_ CUSTCREDIT . " ? @apmuthu

seems $sql .= "AND s.mb_flag='M' AND m.qty > 0 AND m.type <> ".ST_CUSTCREDIT." "; is working.

Re: Manufacturing dashboard issue

2017-11-07T14:13:29Z

No, I guess it should just be:

$sql .= "AND s.mb_flag='M' AND m.type <> ".ST_CUSTDELIVERY." AND m.type <> ".ST_CUSTCREDIT." ";

Right? We are only interested in the produced numbers.

/Joe

Re: Manufacturing dashboard issue

2017-11-07T13:58:57Z

Should it not be:

$sql .= " AND s.mb_flag='M' AND (
                     (m.qty > 0 AND m.type <> " . CUSTCREDIT . ") OR 
                     (m.qty < 0 AND m.type = " . CUSTCREDIT . ")
                   )" ;

Re: Manufacturing dashboard issue

2017-11-07T13:53:02Z

No, I guess not. We will have to replace the line with:

$sql .= "AND s.mb_flag='M' AND m.qty > 0 AND m.type <> ".CUSTCREDIT." ";

Right?

Joe

Re: Manufacturing dashboard issue

2017-11-07T13:41:43Z

Does this account for returns / rejects where negative qty will get lost?

Re: Manufacturing dashboard issue

2017-11-07T13:29:16Z

Fixed. Committed to Repo.

/Joe

Re: Manufacturing dashboard issue

2017-11-07T12:28:18Z

Of course it should. Will fix this later. Thanks for detecting this.

Joe

Manufacturing dashboard issue

2017-11-07T11:32:51Z

I'm not sure this is a bug, Top 10 Manufactured Items in fiscal year just confuses me on it's presents.

Once I create a work order then manufacturing dashboard shows:
_________________________________________________
| Items | Amount | Quantity |
|-------------------------------------------------------------------|
|AP Surf Set | 366.00 | 1.00 |
|-------------------------------------------------------------------|

After item is sold the table shows

_________________________________________________
| Items | Amount | Quantity |
|-------------------------------------------------------------------|
|AP Surf Set | 0.00 | 0.00 |
|-------------------------------------------------------------------|

1. Does this widget just present on hand manufactured items ?
2. Should it be changed to all manufactured items includes sold item?

If 1 : this does not make sense much
If 2 : Line 275 of dashboard.inc need to change to $sql .= "AND s.mb_flag='M' AND m.qty > 0 ";