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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: prog_0927
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. prog_0927

    Received Not Invoiced Question

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

    Variance Report Pre-post Not Matching Posting

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

    Macola inventory Tag count Process How Many Days Open??

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

    G/L Subledger

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

    dist_type on IMDISFIL_SQL

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

    Journal Source SQL Table

    Macola Progression 7.9.310 What is the table name that holds journal entries? Thanks,
  11. prog_0927

    G/L Receipt Trx Inventory Transaction

    Progression 7.9.310 When you do a POP order and there is a trx against G/L, when you look at the Inventory Transaction History report it shows the account, debit and credit amount of the item going into Raw materials from WIP. What SQL table is that? I have looked in all the G/L tables I could...
  12. prog_0927

    Status on APOPNHST_SQL Table

    Mascola Progression 7.9.310 what does are the status column meaning on that table? I see a "V" and an "R" on the table but was unable to get the meaning going through the Macola help menu.
  13. prog_0927

    Status of Order

    Progression 7.9.310 We had a order that would not show up doing a Power Inquiry by PO in Macola. There was nothing at all seen as different from what we could see in SQL. However, when we opened the order in Macola and hit save (no locked errors or anything) we were then able to see it in the...
  14. prog_0927

    G/L Transaction Detail Report Stopping

    Progression 7.9.310 We are having an issue with the G/L Detail Transaction report not fully opening when we do Print to File, we need the full file (not break it up) for audit. The report is 7MB, which I know is large but PDF only shows about 1/4 of what we need for the year when doing Print to...
  15. prog_0927

    Freight Per Line

    Sorry for delays responding to responses, my notifications were getting deleted. I have Macola Progression 7.9.310 and I am trying to find the table that shows the freight amount on the line. I see it rolled up on the header but not sure where the billing screen pulls that from when it is marked...
  16. prog_0927

    AR Aging Report Not Matching

    7.9.310 We are running the aging report and the reference match the apply-to and zero-out but they still show on the report. When we look in customer history view it shows the data correctly. Is there a file validation or something we do? We did a support ticket and they want to rebuild the...
  17. prog_0927

    Move Bulk of Orders to Closed Status

    Using Progression 7.9.310. We have a lot of old orders that need to be moved to the "L" Closed status in our active header/lines. Is there any repercussion to changing the status on the headers to "L" via SQL? Or is there a way to do this via Macola in bulk (don't want to do one-by-one, there is...
  18. prog_0927

    oeordlin_sql shipped_date questions

    Progression 7.9.310. I have been reading and had a few questions about shipped_dt. When there is a date present on a line item, is that enough to allow it to be moved to "Shipped" status and invoiced and moved to the OELINHST table, or are there other checks that are involved? We are attempting...
  19. prog_0927

    Default Item Location Missing on File

    Progression 7.9.310: we are troubleshooting the posting issues we have had lately and found that some items on the Item Master do not have "Default Location Set". I checked Item Maintenance in Macola for Location and Item Master and do not see a field for Default Location. Additionally, although...
  20. prog_0927

    cus_item_no and OECUSITM_SQL

    Progression 7.9.310 We are using the Wisys SDK and are attempting to use the cus_item_no field on the OELIN to INSERT a unique ID. We can see it working, changing the cus_item_no via the OECUSITM maintenance app in Macola and SQL updates reflect in the Macola app as well. My question is, is...

Part and Inventory Search

Back
Top