Recent content by prog_0927

We found the problem transaction for Monday. All but one line of the PO was received (5 of 6 total lines), and it shows they were vouched when we look at the individuallybut the money only moved on 2 of the 5 lines received during the posting process.

I have not, that is where we are at, trying to determine where the out of balance took place. We are struggling to find it in the tables or existing crystal reports we have.

We moved it to an offset account to troubleshoot. We were out of balance yesterday for AP only and today for AR and AP. Thank you for your quick reply.

Progression. thank you for your quick reply!

7.9.310 We have 2 x days in a row that we are out of balance in AR and AP. Not seeing any issues with the SQL connection on either day, event logs and performance is great. Where do i begin troubleshooting this? What DB tables can i look at for issues (and what am I looking for). Did ticket...

No we were not. we think it was receiving issue and then adjusted/issued. If I find something out I will be sure to let you know!

Thank you for the response! We do not use Receiving Inspection, do you know what the SQL would like for identifying these? I can correct the qty_inv = qty_inv via SQL, just trying to make sure I understand all the report parameters used to pull the data; also, does this just affect what is on...

Progression 7.9.310 We have an issue with Received not Invoiced on how to clear these out that shouldn't be on there. If we back out it appears that is just takes it out of inventory and if just mark it as history it doesn't seem to move the dollar amount (correct me if I am wrong on those two...

Correct, that same tag was counted twice (each had 2 x rows in the DB) but when there are two, at least from what we are seeing, it posts both numbers counted (sum) which will differ from the frz_qty. The SQL will find any item numbers that have more than 1 x row; if there are any, the posting...

Figured it out! I did a SQL pull on the TAGHST table and found duplicates there that caused the issue Here is the SQL query if anyone is interested (change to your count date and your location as needed in script below; this pulls any rows with a count of > 1 which will need looked...

Progression 7.9.310 We ran a variance report of anything < .01 or > .01 prior to posting the tags from yesterday's count. The posting amount was off by a significant amount versus the variance report. We didn't see but one duplicate tag that we can account for, any thoughts on this? We are...

"*CUSTOMER*" should work.

Macola Progression 7.9.310 Is there a limit on how many days the inventory tag count process can be open? Online I have seen 1 x day, 2 x days, and then "several" days. I thought remember hearing there was a limit because they had to be posted within a certain timeframe, not sure though. Thanks,

That was it! thank you very much! The init_fg is supposed to be set with NULL in there and the post process looks for that NULL. It then goes by account in the process and when that account is finished it sets the NULL value to Y. Any values set to Y are ignored so we were also able to go back...

Thank you for the response! I am looking and these transactions all have "Y" on the int_fg, even the ones that we had issue with. In the G/L Setup the "Interface To G/L Journal Trx File is not checked.