Sage 500

Where can I find more info on the fields in the BOM's? I'm looking to find what certain fields mean and how they get populated. Specifically the Set Fix & Set Var fields. I can see them in the Explore view, but is this data coming from the Data Import…

I have a Closed work order that is still showing a quantity in the "Qty on WO" field (timInventory.QtyOnWO). I see it when i look at Explore\Inventory view. I've looked at the two previous WO for the same part and there was no issue that I can see and…

If you specify both a Lead Time formula & Projected lead time in the Maintain Inventory, which does MRP consider? I did a average lead time calculation based on the last 15 months using the PO date vs the Receipt date and was going to update the Projected…

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. …

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

Has anyone ever seen an invoice that was paid/closed, but still has a balance? we have a weird situation with an AP voucher that was paid via wire(manual payment). On the payment side (via insight query), everything looks fine. it's applied to multiple…

When Generating the Payment list for a specific supplier, the 8 invoices are picked but with 0 Value, All invoice are stil, open and hold indicator is BLANK. How do i get the invoice to populate on the payment list?

I am new to Sage 500 - How can I find the G/L distribution on a previously paid A/P invoice?

During PayPal's smoke testing for TLS 1.2 support yesterday we began receiving this error processing credit cards in Sage Mas 500. Is there a way to resolve this in our version of Sage 500 (Version 7.40.1.0)?

Does anyone have current documentation from Sage showing where their Silver support plan changed from 20 cases per year to 5? Our support was changed and we did not receive notification of this change from Sage or our business partner. I can't find anything…

Ok, I'm running Sage MRP against our system and I have found a issue with unit of measure. We have a base unit of measure of EA . We sell in units of "72 cel" which are set up properly to the best of my knowledge as 72 each's. However, when the MRP is…

Can someone answer this inventory question? I have a PO for inventory qty of 1,000 each at a cost of $5,000.00. It was received at qty of 1000 and a cost of $5,000.00. The inventory invoice can in at a qty of 1000 and a cost of $4,000.00. The AP person…

Hi, I posted same question under a different category, I tried to simplify it here. We currently receive thousands of payments (cash receipts) that need to be applied to open invoices as cash receipts payments from our customers; this is taking us forever…

Hi, We are having a big issue in which we are receiving thousands of transactions from website customers from different sites including amazon.com. One problem is that every transaction is creating a new customer number, so we are receiving thousands…

Hello, We are looking to restructure our Credit Card Payables process. Currently we enter a voucher to a Credit Card Vendor and pay it through the AP that way. We can continue to do that if we can get a decent transactions download that can be easily…

Is there a way to pull the date the period end processing was complete within a table in Sage? We are trying to see the date we actually closed out the period - but we cannot locate where to find this data. I'm sure it's within a table somewhere but unable…

Curious if anyone can share any details of anything discussed at Sage Summit regarding Sage 500...

We have been using Data Porter for a number of years without issue - just recently some users are receiving the error "No detail records attached to this row" - I cannot figure out what the issue is.

I'm in Finance / Accounting at an international consulting firm. We're trying to find a way to accrue revenue at a project level without having to record credit memos and reversing debit memos that would actually impact accounts receivable. We're therefore…

We have made a return for credit on a purchase order, that was in error. We now have the return sitting in the Clearing accounting waiting for the Credit Invoice to arrive. We need to reverse the Return on Credit. Besides creating an Invoice, posting…

Our AP department continues to put invoices into the incorrect batch (ex February invoices in a January batch). Is there a way to prevent that? If not, is there a way to search to see if it has happened? Is there a way to fix it without making a journal…

I have posted a standard CM Check transaction and when I went to reconcile the bank account, the amount showed up in my DEBIT column (as though I had made a deposit instead of a CM Check). Looking at the G/L detail for the batch, the system recorded improperly…

We are a manufacturing facility using Sage 500. We have never used the pricing available and we are in the process of re-implementation. I need better understanding of contract pricing. If I set up contract pricing for customer X. How is that information…

Hello. We sometimes encounter a sales order line that is not available to be pulled into an RMA from the Select Lines button. What are the scenarios that would cause this to happen? Allow Returns is checked in Maintain Item for the item. It would…

We are currently using Sage 500 ERP 2014. A number of years ago we purchased the MRP module and have yet to implement it. We are doing the discovery now to see how MRP will fit into our business and what processes we may need to change. We are an…