Sage 100

Customer getting an error 11 Record XXXXXXX is missing from E:\Sage\ERP_2016\MAS90\MAS_SUN\IMSUN\IM_ItemWarehouse.M4t I don't know how to decipher what he sent me below but I'm wondering what all the references to *memory* might mean? The list goes on and on and on - this is less than a 1/4 of it. I can't duplicate it. Sage 100 Advanced v2016 (he was in Classic mode). Here is the File line output Channel File Name --------------------------------------------- 00006 \\sci02\Sage\ERP_2016\MAS90\SOA\SY0CTL.SOA 32420 \\sci02\Sage\ERP_2016\MAS90\LOCK\_SUN\CI_Item.LCK 32421 E:\Sage\ERP_2016\MAS90\MAS_SUN\CISUN\CI_Item.M4T 32422 \\sci02\Sage\ERP_2016\MAS90\LOCK\_SUN\BM_BillHeader.LCK 32423 E:\Sage\ERP_2016\MAS90\MAS_SUN\BMSUN\BM_BillHeader.M4T 32424 *memory* 32425 *memory* 32426 \\sci02\Sage\ERP_2016\MAS90\LOCK\_SUN\AP_Vendor.LCK 32427 E:\Sage\ERP_2016\MAS90\MAS_SUN\APSUN\AP_Vendor.M4T 32428 *memory* 32429 *memory* 32430 *memory* 32431 \\sci02\Sage\ERP_2016\MAS90\LOCK\_SUN\AR_Customer.LCK 32432 E:\Sage\ERP_2016\MAS90\MAS_SUN\ARSUN\AR_Customer.M4T 32433 *memory* 32434 *memory* 32435 *memory* 32436 \\sci02\Sage\ERP_2016\MAS90\LOCK\_SUN\CI_Item.LCK 32437 E:\Sage\ERP_2016\MAS90\MAS_SUN\CISUN\CI_Item.M4T 32438 *memory* 32439 *memory*

I should mention this is when creating new items then going into the Reorder screen to change the reorder method to None. Of course the item doesn't exist in IM_ItemWarehouse until he goes into the Reorder screen. If you change it to None, the warehouse record isn't created but if you leave it at Economic (default?), when you save it, you will see the warehouse in the warehouse panel at the bottom of the Main tab. Go back in and change it to None and the warehouse record disappears. (This is what I experienced, at least, not him.)

Has the new item been saved? It could be the Reorder screen needs the record to be in the file, not just in memory.

He saved it several different ways. Before, after, etc.

Therese, if I can get the program name and line number that it's giving that error 11, I can better tell you what's going on.

Thanks @MarcosDeLuna - program IM_ItemQuantityInquiry_ui.pvc line 638.

Therese, just verified that it is erroring out trying to read from the IM_ItemWarehouse table. Sometimes, the message is misleading at it;s really doing another table. By looking at the code and testing, I'm unable to replicate as well. If you click on the DEBUG button at the error and type in PRINT ROWKEY$ at the command prompt, I'm curious on what the value it is used to read that table.

I'll let you know!

@MarcosDeLuna it happened again. Here is the initial error and the result of PRINT ROWKEY$. 9400728 is the item number and 002 is the warehouse. Thoughts??

Therese, did the error 92 pop up first after the ACCEPT button was pressed? Just want to make sure which error to track down.

Yes - ""Updated the Reorder to None, hit enter on the window and it gave me the error.

okay. has your client tried this on other workstations? If so, are they getting the same error? Just trying to isolate it. The line number of the program where it's erroring out doesn't makes sense to me yet. Is it possible to send me the client's IM_ITEMQUANTITYINQUIRY_UI.PVC. Would like to compare it with what I have.

Also, any third part enhancements to inventory for this client?

I believe it is only his workstation but he is connected oddly. He's in another building and says this about the connection: ""We are using the satellite direct line of site signal from this building to the other."" They also have ACS's Warehouse Transfer enhancement installed.

Perhaps send him a copy of the SPM and note his type of connection is not recommended :)

I did some research on error 92 on KB. Though it was from a different program, one mentioned something about loosing connection to the network. Another suggested to run MAS90 as administrator (i.e. right click on icon of the workstation and select ""run as administrator"" but it was more of a workaround. Is there an ACS program in the \IM folder called something like IM404_ITEMQUANTITYINQUIRY_UI.PVC? If so, then it could be an ACS issue.

While there are IM404 program files, nothing related to ItemQuantityInquiry.