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!

  • Congratulations Mike Lewis 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. prog_0927

    G/L Subledger

    That was it! thank you very much! The init_fg is supposed to be set with NULL in there and the post process looks for that NULL. It then goes by account in the process and when that account is finished it sets the NULL value to Y. Any values set to Y are ignored so we were also able to go back...
  2. prog_0927

    G/L Subledger

    Thank you for the response! I am looking and these transactions all have "Y" on the int_fg, even the ones that we had issue with. In the G/L Setup the "Interface To G/L Journal Trx File is not checked.
  3. 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...
  4. 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...
  5. prog_0927

    Journal Source SQL Table

    Thank you very much for your help on this. It does nothing and throws no error just leaves the item in finished goods and ignores the two sided transaction to return the money to raw materials. I have a meeting with their developers today and will let you know what they say.
  6. prog_0927

    Journal Source SQL Table

    Thank you. Would that start_jrnl_hist_no be the next number I would use for the IMXXXX number for the IMINVTRX_SQL transaction? The costs are set at model year and I am pulling that data from a SQL query. We don't use serial, lot, or bin. 1. I am trying to reverse the error that the Wisys...
  7. prog_0927

    Journal Source SQL Table

    Thank you! So if I wanted to automate an inventory transaction with an offsetting G/L transaction I would just need the code to update the IMINVTRX_SQL for the part moving and then the IMDISFIL_SQL for the debit/credit of the accounts?
  8. prog_0927

    Journal Source SQL Table

    Thank you for the response. I don't see anything in the GLGENTRX_SQL and we have not posted yet today. What is the source (SQL table) of the jnl_src in the IMNINVTRX_SQL table? I see there is a systjnlhst_sql that looks like the jnl_src but I don't see where the non history table for that one...
  9. prog_0927

    Journal Source SQL Table

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

    G/L Receipt Trx Inventory Transaction

    Just an update, took a while to get the answer but Wisys does not support a negative BOM for the creation of POP orders. Thanks for everyone's replies!
  11. prog_0927

    G/L Receipt Trx Inventory Transaction

    Thanks for the reply. Correct, qty_per_par and it set to -1. It is set to Y-issue components with G/L Distributions. It debits WIP and credits Raw on Release of the Production order. After order is issued and then closed it credits WIP back that amount and puts the -1 item back in the inventory...
  12. prog_0927

    G/L Receipt Trx Inventory Transaction

    Thanks again @dgillz! We don't use the options under Macola and to account for this, we set the par_per_qty for the parts that are standard on the BOM and that needs removed to a -1. When a non-standard item (different part number) is added as an option, it issues it out at issue, we get an...
  13. prog_0927

    G/L Receipt Trx Inventory Transaction

    Thank you. Unless I am looking at the wrong thring, I don't see the actual transactions in there, more of a setup table. We do the backflush in Macola but then when the POP is closed it credits the WIP account back from the Raw Materials if done in Macola but not in Wisys. We only create the...
  14. prog_0927

    G/L Receipt Trx Inventory Transaction

    Thank you for the quick reply. Yes, we are receipting the same account, sorry forgot to mention that. I am seeing the WIP flag is set to Y. We are creating the POP orders through Wisys grid and the order is going through okay and releasing the order is fine, it debits WIP and credits Raw...
  15. 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...
  16. 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.
  17. prog_0927

    Status of Order

    Thanks for the info, audit trails, no orphan records, etc. produced no results. I have added this to the rebuild schedule I do now for other tables. I really appreciate the feedback and sorry for the delay in responding.
  18. 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...
  19. prog_0927

    G/L Transaction Detail Report Stopping

    We have been doing this way for a few years and everyone appears a bit confused by it as well. We are only running 1 x year at a time. I will try the CR and let you all know what happens. Thanks for the replies!
  20. prog_0927

    G/L Transaction Detail Report Stopping

    Trial Balance is what we are running, sorry about that. We are getting a hard stop at 552 pages and I was told that we were able to run this for previous audits. The row count: gltrxfil_sql = 1,617,559 gltrxhst_sql = 7,578,050 we were running it for all of 2022, show detail checked, defaults...

Part and Inventory Search

Back
Top