Sage 500

I'm trying to close lines on a open purchase order and it says I can't. I tried using the Receipt of Invoice and it will not pull over that purchase order. Does anyone have any ideas?

Does anyone using Sage 500 have a Build Your Own kitting function at fulfillment? I'm exploring the opportunity to offer customers an option to choose the items to include in a multi-pack gift set and pass along in a pick ticket for kitting and fulfillment…

We are setup for inventory adjustments to use the replacement value, this value is incorrect. Can we change it to use the average cost?

Even after closing out MAS and reopen and try to post again we get the same error.

Can somebody take a look at their database, and verify the following? I'm on Sage 500 2016 January 2018 MU (i.e. 7.70.6.0). tciCarton contains CartonKey, but it is NOT a primary key, nor are any constraints. As a result, I've got a few duplicate…

This may come down to being internally defined, but I am looking for examples of how you handle your RMA's as far as tracking in the Sage 500 system. By design, we originally had a Service Warehouse where all RMA's were receiveing into the default bin…

I am trying to corect a serial number on an item and when I use the "Lot/Serial Correction" Utility the "Serial Number" fields are greyed out and not available to make changes. No changes have previously been made for the item I am trying to change. …

I have the following scenario: 1 warehouse 2 locations 2 bins I need for Sales Order "A" to pick from location 1/Bin1 and Sales Order "B" to pick from location 5/Bin 89. Can I setup the system to do this automatically? Is there something on…

Looking to export work order shipping reports to an excel template file or see if this is possible? We currently barcode a significant amount of inventory and want to be able to convert workorder #'s and locations to barcodes One thought was to export…

We have cost tiers will zero quantity that have small balances in material costs. What is the best way to zero out these balances?

We have a warehouse that is not setup to track items at the Bin level - can this warehouse be changed to track at the Bin level?

What is the difference between the tran date in the timinvttran table and the trandate in the invttranlog table? Pete Gentile The Robbins Company

We sell bins of mixed product to big box retailers. We purchase and inventory those bins as 1 item number, but the stores will only order the individual eaches that make up the bin. For example, Bin D is equal to 100 Part A 200 Part B 300 Part…

In a lot of cases we prepay our vendors for all or a portion of the goods. The invoice is received and partial or all of the payment is made prior to the goods being shipped. We use purchase orders within the inventory process. How do I put in the invoice…

When I go into Explore Inventory and search for all lots that are open, there are a dozen lots with 0 quantity. How can I close the lots? I tried to create a SO but it wouldn't let me because the quantity is 0.