Search results for query: *

My apologies. The quantity is 2 for the transaction quantity only in the IMINVTRX table after the Prod Order is closed (we are not entering a qty of 2 in the Macola process to run the close of the production order). 1 of the 2 that are in the transaction qty in the IMINVTRX table (boat with...

Sorry, build_qty on the IMINVTRX table. I have been looking at way too many tables today. :)

Progression 7.9.310 We are having an issue where the overall parent number of the Prod Order is randomly being added as 2 in the IMINVTRX table. The money isn't right, it just takes the overall cost of the parent number and moves it to bulk issue (no other trx happen). When we look in IMINVTRX...

we have vendors that do floor kits for our boats that contain 60+ pieces each and there are dozens of options so each individual piece can be sold separately for a parts or warranty order thank you all for the reply!

Thank you all for the reply. I think we will do the deferred processing, sounds like it would be a great idea!

7.9.310 We have a question on what happens on over-received items and the qty on ord. If we over-receive an item and then unreceive it does that fix the qty on ord or does the "Reset Qty on Order" process have to be run to resolve discrepancies? We are seeing incorrect Qty On Ord a lot through...

Progression 7.9.310 We are looking to add a significant number of part numbers per year to the Item Master and Item Location Tables. We are going to go from 1200 parts to 6K parts a year. Have you seen any issues with these tables have 100-200K parts in there (adjusting for moving off...

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,