4Site
Support Request System
View Patch #50.028.010
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02687 -
Missing trndtl records when you receive Credit stock PO after voucher
Symptoms:
This problem only occurs if the PO has the same stock number on more than 1 line. 1. The stocwhse.valbalance is updated only by the value on the last voucher line with the stock number on it 2. The voucher transactions have the invt control acct on the first line for the stock but the variance acct on all subsequent lines.
Solution:
The problem was the rVoLine collection loaded the valbalance and varbalance for each line but if the first line's stock updated stocwhse.valbalance then the next line for that stock was still using the original value in it's calculations. So the final update of stocwhse.valbalance was the last line's value only. So the change I did was: After it updates stocwhse it now loops through all other lines in the collection and looks for the same stock number. If it finds it then it updates valbalance and varbalance with the current value from the current line's update. So the next time a line with that stock is encountered it will have the most recent value. It also had to do the same thing when it setup the reverse receipt accruals - separate code that updated valbalance The 2nd part of the bug was trndtl was created incorrectly. When it setup rVoLine it was exiting the For Next loop after the first stock number. I removed the Exit For to force it through the loop for each line so that the accounts get setup for every occurrence of the stocid.
Browse Patches
Find a Patch
Return to Request System Menu