Sage 100

Hello I am currently entering a Purchase Order into a Receipt of goods using BOI but the issue is when we don't receive an order fully it is leaving our items on backorder... Is there a way to get rid of pending backorder through BOI? or is this a bad…

I've got the following scenario: I create a PO with qty 1000 of Item A on it. I receive against the PO at two different times, so I make two Receipts of Goods against said PO. The first receipt I receive 500 of Item A, and add a charge to the…

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

Hello, I'm having rounding problem issue - in configuration I have decimal precision set to 4, in the Sage 100 (2022 version 7.10.0.0) my PO Item is stored correctly. Unit price for one of the items is 37.5950, but when I get date by PO_PurchaseOrderDetails_svc…

I am new to this so please bear with me. I have the following script ( i can only post a portion of the code. The SPAM blocker flagged it as malicious) that is used to update two UDF fields from a .csv file. It is called via a custom application. I am…

Can anyone please help me in creating purchase order in sage. I tried creating it but the line items are not getting inserted and getting the following error "This Purchase Order has no lines and has zero total amounts". ARDivisionNo = WScript…

Hi Team, Can anyone please help me in getting the business object interface for creating Vendor purchase order in sage. Thanks

Hi, I purchased the above mentioned course on Sage university but I was not able to access the material as the payment was pending. Also, I got a auto mail from sage informing that one of their sales person will contact us for payment part, but I…

Hi, I'm trying to write a code to create a new invoice from PO set the key ReceiptType$ set the key ReceiptNo$ call setKey() set PurchaseOrderNo$ set InvoiceNo$ Now i want to add the lines of the po to the receipt. In addition, i want…

Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code: using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…

We regularly import products from overseas and prepay 100% of those purchase orders. Sometimes we end up changing items, leaving us with a credit with that vendor. They typically apply it as a credit on future purchase orders. What is the best practice…

Hello - I am moving current inventory out of 000 to another warehouse number . My question is do I need to go into every open PO and change the warehouse number or change I make a preference change?

Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…

How to get PurchaseOrderNo using PurchaseOrder Details & LineItems data from Sage 100 desktop application using C#? I have using DispatchObject and done login and select company functionality. Can you please help me to get PO detail using C#?

I am having issues setting the Purchase Order lines with a GL Account code or key gathered from a SQL table. It doesn't matter what I try to pass, the system always defaults it to some obscure account code. All other fields I set work except for the GL…

Hi Guys I am trying to get a window to display on purchase order entry which will shows everything we purchased from the vendor in the past. On sales order you have the binoculars to do this but all you have on Purchase Order is Alias Item Lookup…

Is there any possible to view 'Total Quantity Order" on Purchase Order Entry screen. Similar as it shows 'Total Amount" on the bottom of 'Lines' tab.

I am looking (did I mention Desperately) for a solution to this: We key orders and quotes with increasing frequency as the summer approaches and through the summer seasonal business. We sell many BOM standard kits and custom kits with 10 to 50 different…

We have a checkbox UDF in purchase order entry at the lines level called UDF_LINE_COMPLETED, when they check this box I would like to zero out the quantitybackordered field. I have tried this script as a column pre-validate and post-validiate on the UDF…

I would like to check the detail lines within a PO to verify that all the fields have been entered. I'd like to either run the script after the detail line has lost focus or when the user clicks the "Accept" button. Basically I think going to place a…

Greetings, I am trying to use the following: retVAL = oPOOrder.nSetKeyValue("PurchaseOrderNo$", sPONumber) retVAL = oPOOrder.nSetKey() retVAL = oPOOrder.nSetValue("PurchaseOrderDate$", "20140529") retVAL = oPOOrder.nSetValue("OrderType$", "S") retVAL…