Does anyone know the sql behind the Inventory Transaction History Report? I am attaching a screen shot.
I am manually entering an Issue (doctype=I) into the macola database, instead of entering it through the Macola application. I have successfully entered a transaction into the IMINVTRX_SQL table, and that record shows up in the attached report. I entered the cooresponding debit/credit into the GLTRXHST_SQL table, thinking that these would be the child records that would show up as "disbursements" in this report. However, they do not show and I instead get the message "No distributions on file". Does anyone know the sql behind this Inventory Transaction History Report so that I can see where it is trying to find distributions? Or can someone explain which tables need to be populated for these child records if the GLTRXHST_SQL table is not what should be used?
I realize entering records directly in the database is opening a can of worms. My hands are a bit tied on that, as my customer is trying to use an outside application to insert these records and I have limited knowledge of Macola.
I am manually entering an Issue (doctype=I) into the macola database, instead of entering it through the Macola application. I have successfully entered a transaction into the IMINVTRX_SQL table, and that record shows up in the attached report. I entered the cooresponding debit/credit into the GLTRXHST_SQL table, thinking that these would be the child records that would show up as "disbursements" in this report. However, they do not show and I instead get the message "No distributions on file". Does anyone know the sql behind this Inventory Transaction History Report so that I can see where it is trying to find distributions? Or can someone explain which tables need to be populated for these child records if the GLTRXHST_SQL table is not what should be used?
I realize entering records directly in the database is opening a can of worms. My hands are a bit tied on that, as my customer is trying to use an outside application to insert these records and I have limited knowledge of Macola.