Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before. Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled. Our…
I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?
Hello All,
I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
We have a client who has a customer who wants a packing list for the items that are in each box shipped for the order and not the whole order on the packing list. Does anyone have a similar issue?
Hello Everyone!
I am looking for a quicker and easier way to ascertain the last total unit cost of an item in a specific warehouse. Our organization has multiple warehouses and sometimes landed freight charges vary for different items based on their…
We have some items where the Sales UOM is EACH and standard is KG. When adding these items to a sales order, the sales quantity shows as EACH however the price is coming over as the standard price x the KGs per EACH. This only occurs for a handful of…
I'd like to modify the order in which lines are displayed in the secondary grid in the Sales Order Module (Sales Order Entry).
We have several UDF's in that grid, but I am having trouble seeing the list of fields within that secondary grid. Using customizer…
Hello all,
I wrote a script with the goal to delete sales orders with a specific condition. So I can delete sales orders just fine its just that when the orders are deleted the cancel reason code is not flowing to history it is staying blank. I am…
First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…
I've used DeactivateProcedure on scripts running within Sage, but not on external scripts. I'm working on a script that requires me to disable procedures in SO Entry. I've tried a few variations, but I'm getting "Object doesn't support this property or…
I'm preparing my upgrade from v2019 to Sage 100c Advanced v2021 with PU1 (due to Scanco Operations Mgmt compatibility) and notice KB articles referring to slow performance issues with STANDARD and PREMIUM. But nothing with ADVANCED.
Does anyone know…
Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…
We are running 2019 100c Advanced. From time to time when entering a new SO the Order Total on the Totals tab is zero, while the total on the Lines tab is correct. Oddly, the system allows the SO to be saved in this condition! To correct the imbalance…
We have a process synchronization from our online store into Sage using the SData API. We had a glitch that caused a large number of empty Sales Order batches to be created. There are no invoices on these batches, so I was wondering if there was a way…
I am currently using Sage 100 and Trucommerce Transaction Manager. Our current setup is incomplete. Transaction Manager sees what state the sales order is shipping to and then assigns the appropriate warehouse code so that the order will ship from the…
I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…
We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
A SAGE100 Premium VS. 2020 has occasional missing S/O order header records.
The order lines are still there.
The order is completely there in order history.
The order has NOT been invoiced.
Anyone seen this?
Hey All,
Just received our upgrade from Mas90 4.3 to Sage 100 2019 a couple of weeks ago! Woohoo. One thing I'm trying to sort out is how to eradicate Phantom Users. I'll explain:
We are having trouble fixing some valuations in Sales Order Entry…
I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit).
The client will have an issue with the Freight amount not saving on the Total tab.
I will go in and recreate the customized…
Most but not all Backorder lines are incorrectly calculated based on the Order Qty but should be Backorder Qty. As a test, I copied the Live company into a test company at the end of our shipping day just before running Daily Sales Reports and Updates…
I'm getting this error if I leave off the sales order number. I want to be able to enter the sales order invoice without a preexisting sales order. All the code seems to work and the data is being input into Sage, however the tax fields never populate…
