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!

Search results for query: *

  1. dgillz

    ODBC vs ADO incorrectly defining fields

    Click on database, verify database and see if it updates the field type.
  2. dgillz

    IMINVTRX bld_qty Field

    If it happens again please post here. I'd like to get into this in detail.
  3. dgillz

    IMINVTRX bld_qty Field

    Did you ever get this resolved?
  4. dgillz

    IMINVTRX bld_qty Field

    Ok please clarify: >We are having an issue where the overall parent number of the Prod Order is randomly being added as 2 in the IMINVTRX table. So are you saying the ord_no is 2? If not please elaborate. > The money isn't right, it just takes the overall cost of the parent number and moves...
  5. dgillz

    IMINVTRX bld_qty Field

    There is no iminvtrx_sql.bld_qty field in Macola. In fact there is no filed called bld_qty anywhere in the Macola database. Run this SQL to find everywhere a given field name appears, You won;t find "bld_qty". SELECT sysobjects.name, syscolumns.colid, syscolumns.name, systypes.name...
  6. dgillz

    Over Receive and Effects on Qty On Ord

    Rich, You can run any Macola report and many processes on a schedule at 3am while everyone is asleep if you want to. This includes reset allocations and reset qty on order. It is called deferred processing and it has been there ever since Progression came out in 1997. Give me a shout if you...
  7. dgillz

    Over Receive and Effects on Qty On Ord

    First off, the items must have controlled flag checked at the item master level in order for Macola to maintain a Qty Allocated or a Qty on Order. Secondly, reset qty on order does nothing except print a report unless you have the "reset Inventory Trx" checkbox selected. On the receiving side...
  8. dgillz

    Item Master and Location Limits?

    There is no limit except your SQL Server Database size. That said, why on earth are you adding 200k items?
  9. dgillz

    Macola designer and flex code

    What version of Macola? Progression, ES or Macola 10? And what specific release? Examples: Progression 7.9.340 or Macola 10 9.8.500.
  10. dgillz

    Posting Out of Balance

    The other thing I would do is run file validation reports in Macola and fix EVERY error. Are you familiar with these reports?
  11. dgillz

    Posting Out of Balance

    OK Can you recreate this issue in a test company?
  12. dgillz

    Posting Out of Balance

    I have a couple of crystal reports that will find where - as in what transaction(s) - the out of balance took place, but it will not really troubleshoot it much beyond that point. Have you gotten this far at least?
  13. dgillz

    Posting Out of Balance

    he/she said 7.9.310
  14. dgillz

    Posting Out of Balance

    You are seriously out of balance with both? As in you post from subledger and it will not let you because the entry is out of balance? If not, please explain.
  15. dgillz

    Need Progression 7.7.000 Update files

    SQL 2000? Are you serious? If you upgrade to a newer version of SQL I can help you. Please, please tell me you are not running SQL 2000.
  16. dgillz

    Database Location Help

    Do you have a record or group selection formula? If se comment them out ans see if it returns records.
  17. dgillz

    Received Not Invoiced Question

    Sorry for the late reply. What I described will not correct inventory. Presumably these vouchers debited inventory, as did the PO receipt itself. So the correcting entry, assuming no purchase price variance, is debit accrued receipts and credit inventory. You may also have fixed asset...
  18. dgillz

    Variance Report Pre-post Not Matching Posting

    Sorry for the later reply. Is this something you can reproduce?
  19. dgillz

    Received Not Invoiced Question

    This happens when the AP voucher is entered without using the PO and Receiver. You should look at the "Force use of Receiver" checkbox in AP Setup or this issue will perpetuate itself. But in order to clean up existing invalid data on the Received Not Invoiced report, you need to update the...
  20. dgillz

    Variance Report Pre-post Not Matching Posting

    Can you elaborate on exactly what a duplicate tag means? Do you literally mean the same tag number more than once? I am facing a similar dilemma right now and we do not know what is causing this.

Part and Inventory Search

Back
Top