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...
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.
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...
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...
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.
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...
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?
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...
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!
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...
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...
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...
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...
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...
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.
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.
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...
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!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.