Sage 100

Hello, I've tried to create a VI Import job for BM_BillDetail. But, that table is not an option. I see BM_BillHeader is an option, so I've selected that. I've picked the following Data values... H.BillNo, H.Revision, L.LineKey, L.ComponentItemCode…

i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…

HI I am new to scripting and am trying to create a script for a client that will bring in the extended item description into t

Hi there, I have a script tied to Table Post-Write event, which executes a stored procedure in SQL Server to pull data from BM_BillDetail whenever a change occurs. I'm mighty confused because whether i use Table Post-Write or Pre-Write event, the query…

Hello and thank you in advance for your help and advise. I am trying to create a program that uses the BOI to insert a RMA at the time of arrival. The issue I am running into is the BOM is set to "inactive" in Bill of Materials Maintenance. What…

I am trying to add the Finished Product Bin Location to a Crystal Reports Picking Sheet form. Can anyone assist?

When we view items in Item Maintenance, we would also like to see the BOM's listed on the Header. We want to see exactly how we calculated the price directly on IM and not have to open another module, then revert back ti IM. We have a lot of items that…

Hello, We use MAS version 4.4. We manufacture some items that have more than the allowed nine bill option categories. As a result, our engineers are experimenting with combining multiple options in a single bill option category. For instance, if customers…