Sage 100

In 2019 the Lot/Serial Inquiry listed all the transactions in the grid when a Lot/Serial Number was selected. Now, since 2020.1, with the addition of Lot/Serial Traceability, Lot/Serial Inquiry only gives a list of the Item Codes. If you want to see…

Does anyone know of a system setting that will allow me to have work orders be automatically released when I create them in Work Order Entry? Thus, eliminating the need to go into Work Order Transaction Entry to Release them after i create them.

Does SAGE 100 have Canadian/USD conversion (have an A/R in Canadian dollars for Canadian customers and an A/R in USD for US customers)

A finished good item was changed to a kit item. In BOM maintenance the bill number is a finished good number. However, the component used for this kit, has the same item code. I get an error saying "the item code you have entered (SROP7000) is the same…

Need some perspective with what I am seeing in PM. Screen below is from the materials tab of work ticket entry. The first 225 LINES are from the requirements import (CSV file). After that are quantities from inventory transaction entry (materials). Most…

How do you handle purchase orders for non-inventory items. Two examples - 1) the office heater is broken, we call repair shop to fix it - PO needs to be created to match up with billing invoice,do you just use a comment field? But do you still have to…

Customer orders in cases but need to invoice in pounds. Cases may or may not be exact weight, each case may have a different weight. Similarly, order from Vendors is in cases but are invoiced by the vendor in pounds. Again, case may or may not be exact…

I was changing a few Item codes usint the Delete and Change Items Utility. The log report showed that a New Item Code Description was created and the action was a Rename. When I now search for the item, I can see the new name in the search screen, but…

Customer complained with v2021.2 Advanced. Verified in v2022.1 Standard with ABC data. In the above example, sorted by the Promise Date column, the 2nd line should be listed first... but the order list seems to be sorted by day of the month (not properly…

We just created our work order template in our new company. We were able to get the work orders placed and printing but when we tried to close the work order we got an error, Logical end of record reached. How do we fix this?

In our current system, we assign an alphanumeric price level/discount to each customer. Each item also has the same alphanumeric price level A = no discount B = 25% discount C= 30% discount D = 20% discount E = 15% discount We would like…

Can someone please tell me how to easily find a vendor invoice detail lines from a PO number? The reason why i ask is that both the window through the "Receipts" button in Purchase Order History Inquiry and Receipt History Inquiry doesn't seem to capture…

We currently use all the core modules (GL, AP, AR, BR, PR, IM, PO, plus Job Cost and Time Card. I am looking for something, for example - we may have 1-3 jobs at a time (up to 90 days each), each job will have 2-3 work tickets, and each work ticket generates…

On a sales order if Quote is selected the Expire date is automatically changes to 30 days later - great is there a way to make the ship date automatically default to two weeks later then the order date when a Standard order is selected? If so where…

We are testing exploding kits to be able to sell bundled items and have teh cost calculate from the components and the inventory of the individual components reduced with sales of the kits. In our test environment though, neither of these things are happening…

Does anyone have parts inventory for sale that also deals with this confusing "committed" inventory column? Can we shut down committed because it just seems to cause more confusion than for little benfit it gives? Or, how do we deal with this committed…

How is this EZ Import UI launched from CLI / task scheduler instead of having to run an instance of SAGE to access the command and locking the desktop?

Using Production Management->Setup->Work Ticket Template Maintenance and creating a new object: 1) Input unique NEW template number that does not exist in the system 2) choose COPY (from Open Work Ticket) from the Message Box 3) Select existing…

We have a user that has an inventory item that comes in three boxes. When they print a Pick Sheet they want to be able to show the three boxes on the sheet so that the Picker doesn't accidentally only ship one box. We were thinking of using Inventory…

Hi I am trying to create purchase order in sage100c v2021 using PO script but getting error "G/L account is required" while adding item line this is my script in c# and i am referring the table " PO_PurchaseOrder_bus" for PO fields //Purchase Order…

Hi, I am using sage100c 2021 version and i want to add location in SO/SI but i am not able find an option i tried to search on this but didn't get any solution So anyone can suggest me how we can add warehouse option SO/SI? Thank You

We just upgraded to Sage 100 2021 from 4.3. 2 users were receiving error when trying to update inventory items in Inventory module/item maintenance. Reset panels, no customized panels . This fixed the error for 1 user but not the other. The inventory…

Is there a way to take a inventory part number and convert it to a phantom part number?

I can think of a way using VI, but it's a bit laborious. I'm sure a script could be set up to do it, but I would think there is a way within the program to set it up to just keep using the same number from Sales Order Entry in Invoice Data Entry. Probably…

I am looking to utilize sales kits to add and remove parts on sales orders. However I want the sales kit pricing to be a roll up of the part prices and not have to put a price on the sale kit parent part. Individual part prices can change and I don't…