x Want to participate? Join the group to interact

  • Attach Memo to Journal Entry

    We noticed the ability to attach a memo to a Journal Entry (GL>Process Journal Transaction) but once you post the JE, there is no way to view the file attached to the memo. I noticed there is a report under Common Information > Memo List but it doesn…

  • Errors Editing Recurring Invoice Details

    I receive the below error whenever I attempt to edit any active Recurring Invoice in one of the Companies in Sage 500. This is only recurring in the one company, the STax fields match available records in the SQL database, I am not the only user experiencing…

  • Creating a debit memo in Purchase Order module for returned items on PO

    We had an employee try something new, and entered a bunch of returns using the PO module. These are outstanding in Purchasing Clearing. The credits from the vendor were processed via A/P directly to COGS. I'd like to invoice these returns, and get them…

  • Batches stuck as "in use"

    We have run into an issue a few times with both AP and GL batches. The status changes and is stuck on "in use". We check that there are no users in the batch, but the status gets stuck, we can't delete it or post it. The only resolution we are able to…

  • Does MRP Generation look at Purchase order tables?

    When MRP Generation is running, does it look at the open PO's, what does it look at? Does it look at Header or Detail line tables? Or does it go by the PO Log? Reason for asking is that I see a lot of entries in the PO Log that are not in the Header/Detail…

  • GL Trial Balance Slow

    Recently our GL Trial Balance report became slow. We have a bit over 3.6 million rows in tglTransaction. We found that SQL Server 2012 stopped using an index which killed performance. We ended up adding a hint to use index(XIE1tglTransaction). If your…

  • Error 13 from 7.2 to 7.6

    Hello, I am experiencing Error 13 after upgrading our MAS 500 from 7.2.20 to 7.60.6. Strangely, error 13 didn't present itself during testing. The error appears when users are processing invoices for payment after clicking the proceed button. The messages…

  • Partial Payments/Decimal Quantities for Serialized Items

    We have a serialized item in our inventory (a cooling tower) that is currently the only line item on an open PO and has a quantity of 1.00. We have setup progress payments with the vendor, received the first invoice, and need to make the first payment…

  • Accounts Payable Processing Software

    Which Accounts Payable Processing Software would work well with Sage 500?

  • Financial Reports

    I have a couple of small things, that annoys me. 1. when generating a Financial Report, the Fiscal Year - Period keep a defualt of 2012 and we are in 2015, how can i change this> 2. when process AP or AR, whatever posting date i sent does not carry…

  • Invoice for Purchase Order before Receipt of Goods

    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…

  • Sync Sage 500 to Webcart 2.0 Question

    A year ago we went live with Sage 500. I am happy with the functionality, especially the contract pricing charts for individual customers. This is a powerful tool for eliminating the need for sales reps to make external notes, where customer service used…

*Community Hub is the new name for Sage City