webERP Forum

Full Version: Check Number in Reconciliation
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

I added Check Numbers to 4.14.1 to help with reconciliation.


Not too sure if we did this in the latest version...
Paul, is this similar to this other thread?

If so, I'll have to check. I seem to remember that, but there is not a commit note at the other thread as I typically would have added.

I did not find a specific change to the two files referenced in the other thread for checks, but based on the image, there is an area that looks similar where I know a similar change was applied, but might have been different column data. I'm probably thinking of something else (UOM additions, perhaps?) to a similar-looking layout.

Can you attach your two scripts here?
I'll try to take the diff of those.
Yes -- Sorry about not digging deeper.

Since I use 4.14.1 I have to get chequeno from the gltrans table. In 4.15.0 we have added chequeno to the banktrans and supptrans tables so my script may be of little use.

In the attached script I have also made a few small changes in an effort to fix broken table cell positions in 4.14.1.

As you can see I used a second query instead of a JOIN...
Reference URL's