Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by prog_0927

  1. prog_0927

    IMINVTRX bld_qty Field

    No, I have been unable to track down what that field is for and how it is populated. The errored production orders all had a build_qty of 1 and each closed order closed 2 x boats. This was sporadic but only for one boat model out of several. We have not had it happen again after that week.
  2. prog_0927

    IMINVTRX bld_qty Field

    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...
  3. prog_0927

    IMINVTRX bld_qty Field

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

    IMINVTRX bld_qty Field

    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...
  5. prog_0927

    Item Master and Location Limits?

    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!
  6. prog_0927

    Over Receive and Effects on Qty On Ord

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

    Over Receive and Effects on Qty On Ord

    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...
  8. prog_0927

    Item Master and Location Limits?

    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...
  9. prog_0927

    Posting Out of Balance

    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.
  10. prog_0927

    Posting Out of Balance

    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.
  11. prog_0927

    Posting Out of Balance

    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.
  12. prog_0927

    Posting Out of Balance

    Progression. thank you for your quick reply!
  13. prog_0927

    Posting Out of Balance

    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...
  14. prog_0927

    Variance Report Pre-post Not Matching Posting

    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!
  15. prog_0927

    Received Not Invoiced Question

    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...
See more

Part and Inventory Search

Back
Top