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 Chriss Miller 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 TomWG

  1. TomWG

    IM Distribution File (IMDISFIL_SQL)

    The id_no is the index(key) from a transaction file which ties to the IM Dist record. Made up of (Source)+(Order_No)+(Control_No)+(Line_No)+(Level_No)+(Seq_No) The jnl_src is a combination of a source pkg prefix(ie IM) and a sequential journal number START_JNL_HIST_NO which it get from the...
  2. TomWG

    Qty On Hand not updating at Invoice Posting.

    Update on this issue. The issue has happend 1 time since 7/15. I am able to catch this with the program I wrote and make the corrections before any damage is done. We have the exact same issue with inventory reciepts. The IM trx is made but the QOH is not updated. Again this is infrequent and...
  3. TomWG

    Qty On Hand not updating at Invoice Posting.

    The items are selected manually. The sales and stocking UOM are the same.
  4. TomWG

    Qty On Hand not updating at Invoice Posting.

    Yes these are stocked items. The setting is B=Bill. There does not appear to be a pattern to which line # or which item # this happens to. I have written a procedure to run after posting to detect these errors and will be better able to find a pattern if one exists. After posting there does...
  5. TomWG

    Qty On Hand not updating at Invoice Posting.

    Macola 7.6.3c ,Pervasive Btrieve 9.5 We have a infrequent,intermittent,and anoying issue. At invoice posting the qty on hand will not be updated. The IM_Trx.,Ar_Dist. and IM_Dist files all appear correct. This has happen randomly and can affect one or more line items on an single invoice, not in...
See more

Part and Inventory Search

Back
Top