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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IMINVTRX bld_qty Field

prog_0927

Programmer
Jan 3, 2022
62
US
Progression 7.9.310

We are having an issue where the overall parent number of the Prod Order is randomly being added as 2 in the IMINVTRX table. The money isn't right, it just takes the overall cost of the parent number and moves it to bulk issue (no other trx happen). When we look in IMINVTRX table it shows qty of 2 for the overall parent number and for the ones that error there is a build_qty of 1. We are trying to backtrack that field to where it points to and what it is looking at to become a value of 1 in there.
 
Last edited:
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".

Code:
 SELECT sysobjects.name, syscolumns.colid, syscolumns.name, systypes.name, syscolumns.xoffset, syscolumns.isnullable, syscolumns.length
 FROM   (sysobjects sysobjects 
 INNER JOIN syscolumns syscolumns ON sysobjects.id=syscolumns.id) 
 INNER JOIN systypes systypes ON syscolumns.xtype=systypes.xtype
 WHERE  syscolumns.name LIKE '%bld%'
 ORDER BY sysobjects.name, syscolumns.colid
 
Sorry, build_qty on the IMINVTRX table. I have been looking at way too many tables today. :)
 
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 it to bulk issue

Bulk_issue is also not a field in IMINVTRX. Bulk_issue_fg is a Y/N field in the BMPRDSTR and IMORDBLD. So how does "money" enter into the picture here?

Please take the time to fully explain what is happening..
 
My apologies. The quantity is 2 for the transaction quantity only in the IMINVTRX table after the Prod Order is closed (we are not entering a qty of 2 in the Macola process to run the close of the production order). 1 of the 2 that are in the transaction qty in the IMINVTRX table (boat with several dozen components both bulk and not bulk) processes correctly and goes out of WIP and into the labor and other accounts as expected. However, the 2nd one is sent to our WIP variance as a whole and not processed (the entire amount). This is only happening on 1 x boat model and happened 8 times over the past week (all other 7 boat models are not having this issue).
 

Part and Inventory Search

Sponsor

Back
Top