Sage 100

Hi Forum, I am getting an error 0 in Method SETKEYVALUE trying to set the key for Sales Order Lines. Below is the code i have. I can read the key of the Sales Order Header but i cannot read the Lines. 'Get Sales Order Header retVal = o.nSetKeyValue…

I inadvertently created 2 journal entry batches for the daily upload. How do I delete them?

So my trials with this update object continue. I have a console application that simply prints to paperless/updates the SO Sales Journal for any and all SO Invoice batches available. Program works fine when running it manually - prints all necessary reports…

So this is a follow up to a recent post of mine ( https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/168323/so_salesjournal_upd-batch-selection ), but wanted to start a separate thread for the other questions…

Anyone know if its possible to simulate the 'select all batches' UI functionality when selecting batches to post via BOI? I'd like to select multiple batches rather than iterating through all open SO Invoice batches and updating them individually. Thanks…

Hi Forum, I have a BOI script to import AP Invoices. All works fine, except the invoices with multiple lines. I add the total and matches the total of the invoice but i get the message "Out of Balance". I couldn't find anything related to my issue…

Any recommendation on how to fix the setup for bank feeds with Bank Reconciliation module. "Error coming is Sage Bank feeds is not available at this time and cannot process your request. Please try again later. " Tried turning off firewall same issue…

We have an SO line PostWrite script that conditionally adds lines (a service charge, special discount...) which has been working great for years. Now the customer wants to set up exploding kits... which work great, except for lines that qualify for…

Is there a way in Sage 100 where you can search a check number to find which invoices that specific check was applied to? Example scenario- a customer receives a statement and claims that they paid off certain invoices with a previous check that has…

Hello , We are new to using Sage 100 and have a few questions . After our sales people process a sales order we then go into Shipping data entry and then print the invoice. At the end of the day , we then update the register. My question is , how…

Hi Forum, I am having an issue creating a batch, or that's is what i think. the code below is throwing a message. InvoiceNo = "" : BatchNo = "" IF oBatch.nBatchEnabled = 1 Then retVal = oBatch.nSelectBatch(BatchNo) msgBox "retVal: " & retVal…

Hi Forum, Can the username and password be replace vi a variable passed from a VBScript to the batch file. like: Pvxwin32.exe .. \Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION sUser sPassword ABC VIWI00 MANUAL A Customer creates PO and…

Hello, I have used many of the BOI objects without any issues, but when retrieving inventory value with IM_ItemWarehouse_bus, none of the quantity is fetching correctly. It always returns 0 value, I am using ItemCode/WarehouseCode combination to set…

Hello, I accidentally closed the update window and now I can't update my daily sales order transactions. It says "Unable to update S/O transactions while another update is currently in process." We are using Mas 90, version 4.3 Thanks for any help…

Hi All, I'm hoping I'm making a simple mistake in my coding and someone can help me out. Below is a snippet of code where I'm reading serial numbers and importing into Receipt of Goods Entry (with an invoice number, in case it matters). I'm looping…

We currently do not use the feature to batch multiple sales orders on one invoice. I wanted to get an overview of how this is done or if someone has experience in this, could you give me a run down of it. Our SAGE consultant mentioned you can not batch…

Hello, I have tried looking though out the forums for a way to select a batch number to use when trying to import invoices into Sage 100. What I have found was to use SelectBatch and pass the batch number I want to use as the parameter, but when I do…

I like to know if anyone had experienced this I have to delete the record and re-enter the Record to fix.

Hi Forum, When writing to o.oPaymentObj i am getting a message 'B01' not numeric, 'B01' is the WarehoseCode$, there is no Whse code to set in the oPaymentObj. prior to that i do a write to o.oLines.nWrite() and i am not getting any errors. The…

Our AP team reconciled the bank recon in a prior month; however, there were discrepancies and we need to reopen the month in question. I'm not finding solutions on how to reopen a reconciled month. Can anyone assist please?

A PO was issued for inventory items. There were received and have been paid with a credit card. How do I clear the PO? I need to invoice something so the PO closes. I can't invoice it, since I've already paid for it with a credit card. Thanks! …

Is there a way to post an accounts payable invoice to more than one period?

Hi everyone, Currently we apply a customer deposit in the sales order entry (tab 4). Then we record an ar cash recipets entry and debit the cash account and credit customer deposit account. When we invoce the sales order and update the cash account…

We have 3 insurances with Anthem, medical, dental and life. we used to post all three insurance invoices to Anthem (one vender number). now we want to make correction. we try to create another 2 different vendor number for dental and life, how can move…

I am pretty new to Sage, but with previous programs I have used, JEs to cash hit the bank rec so that I can just click them off when they clear the bank. I just took over the bank recs where I work and they have been adjusting the balance in bank code…