Sage 100

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…

In Vendor Pricing Maint. there is field called "Pricing Method" What table is this field in and what is the field name under the covers? Thanks

Hello, We have comments on sales order dropship lines that we would like copied to automatically generated purchase orders, if possible. We are unsure how to accomplish this. Is it possible to transfer sales order line item comments to dropship purchase…

I have a PO that I am receiving against. I want to receive part of the line that exists as well as add a new line. The existing line is received as expected. However, when I try to add the new line, it creates a line with the item code and unit cost…

In Item Code Maintenance where you set up the units of measure. What is "SALES" used for? Is it used for sales to an end user, or is it used for the recipes/bill of materials/costed bill sales?

I've been working on a VI Import job for PO receipt of goods, serialized items. I think I am close, but I am running into this error: T Record Invalid or Write Failed. I've scoured the net, Sage City, Knowledgebase for a solution but no luck. Does anyone…

Is there a way to allow non-Admin Sage 100 users the ability to Re-Open Completed PO's? Quite often we get late Invoices or additional quantity received after the PO has automatically been changed to Completed status, due to 10% Completion rule or that…

Hi, We have a lot of master PO's that suppliers ship partials in multiple shipments. Hence we assign a letter to a standard PO for each shipments using the same master PO #. The standard PO draws balance from the master PO (Master/Repeat PO). We are…

How can I access the table object PO_ReceiptReturnMatRqByPO? I need to delete a record from this table which refers to a ghost receipt and locks my PO. There isn't a file with _bus or _svc, so using NewObject returns "NewObject Error 90". When I…

I would like to know if it is possible to only create Po's from a sales order for items we don't have in inventory? If I create a sales order that has lets say three items two that I can pull from our inventory and one that I don't have any in stock…

Sage 100c Advanced 2018 v6.00.10.0 When we update a Receipt of Good Register, even for just a small receipt, it can take 30 minutes or more to update. No other updates in the system take as long Is there a way to refresh the work/crystal files so…

Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…

I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

Is there a way to customize the field "Add Sales Order Customer Detail as a Comment Line" field? Right now it inputs the SO #, Customer #, Name, QTY, and Customer PO#. I only want the SO # and the QTY to be included. Is there anyway of doing this?

Does Sage 100 have the functionality to incorporate invoice and PO approval work flow without 3rd party software or add-in?

For some reason quite often when i do a receipt of goods invoice a few days later the invoice shows for $0 with lines "0" invoiced. I do multiple invoices in batches and i always make sure that the quantity being invoiced matches what we received and…

Once of our employees adjusted the inventory of an item instead of receiving it through Receipt of Goods entry. I now have an invoice for that PO, but don't know if I should just do receipt of invoice? or enter through AP. If I use receipt of invoice…

When I enter the purchase order, I s elect the standard order type as shown below. And the PO already has been issuing invoice and batch also has been run. So now the amount of PO shows as inventory G/L account. But it should be purchase G/L account…

All, I am new to Sage 100 and have been impressed with it so far. I currently have an issue I have been wrangling for a bit now and would like to hear my options on the subject. I would like to know if there is a way to add inventory to a PO. So here…

Hello, I know that when a purchase order is received and completed, the purchase order is gone. Is there a way to reprint the old completed purchase orders? I need the actual purchase order print out look and not the reporting line items like the reporting…

Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…

Hi, I'm trying to figure out why the button to enter multiple purchase orders against one receipt in the receipt of goods is now showing, I've followed the help files and made sure the four fields, dealing with ship via, tax schedule, etc... were…

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#?

In Purchase Order Entry, I see a ton of purchase orders with a status of X (closed) but if I try to use the Create Purchase Order History, none of these are being moved to history. The history files are empty. The closed POs remain in the entry files…

If you do not have the box for "Post AP Invoices" checked in PO Options...how do PO's drop off the PO clearing report?