Search results for query: *

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.

Macola Progression 7.9.310 There are items that are getting into the IM Transactions table (IMINVTRX_SQL) and in G/L (IMDISFIL_SQL) but they are not posting to subledger. Transaction and inventory wise the $ add up but it shows variance on the G/L. Is there a staging table for things that are...

Progression 7.9.310 what is the dist_type reference in the IMDISFIL_SQL table? Found no help in the Macola help menus. I noticed when we did a normal negative inventory trx the two accounts (credit and debit lines) had a dist_type of 1 and then 2. However when we changed it to a Receipt Trx it...

Thank you very much for your help on this. It does nothing and throws no error just leaves the item in finished goods and ignores the two sided transaction to return the money to raw materials. I have a meeting with their developers today and will let you know what they say.

Thank you. Would that start_jrnl_hist_no be the next number I would use for the IMXXXX number for the IMINVTRX_SQL transaction? The costs are set at model year and I am pulling that data from a SQL query. We don't use serial, lot, or bin. 1. I am trying to reverse the error that the Wisys...

Thank you! So if I wanted to automate an inventory transaction with an offsetting G/L transaction I would just need the code to update the IMINVTRX_SQL for the part moving and then the IMDISFIL_SQL for the debit/credit of the accounts?