• Clear open negative balance in A/R

    We have a customer account with an open PY (overpayment of an invoice) where the funds will not be refunded to the customer. We want to clear and close the account but the AR receipt batch will not allow us to adjust off the open credit amount via a zero…
  • Correcting a Billing dated in future period

    I have an entry that won't post due to an error in the billing date. How do I correct the date so it will post in the correct period?
  • Qty committed to sale

    Hi Support, We have a client who used to use VM Service manager. which was linked to inventory and order entry. they have identified some items that have Qty committed to sale because of VM service manager. the items are old and need to be written…
  • Cost decrease adjustment is not reflecting in Location details.

    We adjusted one of the item cost (cost decrease), but it is not affecting in location details. Inventory movement and Stock transaction report is showing correct figures. How an i solve this issue. In ICILOC table i saw Qtyonhand is 11 and Qtyshnocst…
  • Quantity on S/O but no Sales Order in system for specific item

    Our client is working on Sage 300 2014 PU3. When doing the Physical Inventory Reconciliation it gave an error that states "There is insufficient quantity available to adjust item XXX at location XXX". When checking the specific item via Item Location…
  • Clear unapplied receipt payments from system

    Hi everyone, There has been some instances were receipts were made and applied to invoices in the AR, but some of the balance has remained unapplied. These are on the trial balance as a PY document, and I am unsure how to clear them. Any help is much…
  • po receipt entry

    Dear all I have a customer who has received 16 goods intstead of 32 and inserted the invoice number.. after running the day and processing, he realizes that he was supposed to receive all 32 quantities... what do i do please help
  • In AR module, I can't figure out how to change the date of a posted transaction. The amount will stay the same.

    In AR module, I can't figure out how to change the date of a posted transaction. The amount will stay the same. There is a few that the incorrect dates were applied and I would like to just go in and change the date. Is there an easy way to do this? …
  • Unapplied Receipt in AR Subleger

    I have an unapplied receipt showing as -ve receivable in my AR Sub Léger, how can I go about correcting this? The AR ledger looks okay. Thanks
  • Cost adjustment causing user to lose all entered data

    Have a client that tries to enter adjustments in Inventory. Sometimes when there's insufficient quantity for the adjustment it gives this error message, they fix their error and continue on: Other times, they get this error and it causes them to…
  • Returning items to inventory

    Hello, I have a few items that were capitalized some time ago that need to be returned to inventory. I am unsure how to do this. How can I move them back to inventory and have the original cost associated with each item? And how can I adjust the accumulated…
  • Credit Card Payment made with Sage Payment Solutions in Sage 300 to Wrong invoice

    A credit card payment was entered, posted to the correct customer, but to the wrong invoice. Is there a way to fix this. We attempted to reverse the entry, but since it was made with Sage Payment Solutions this was not allowed.
  • Receiving Slip Entry Error

    Hello, While posting a receiving slip, the wrong item quantity was entered (2 instead of 1) and posted. I can re-post the receiving slip, but the inventory quantity for this item remains overstated. How can I correct this? Thank you!
  • Sage 300 5.5 inventory with negative average cost

    I have a couple of items with negative average cost. What's the best way to fix this in Sage 300 5.5? TIA, Peter Heinicke
  • AR aging report and GL trial balance doesn't tie

    Hello, When I entered receipt, I input the wrong receipt date and posting date as 01/12/2014 while it should be 01/16/2015 to match my batch deposit date. Then, I cleared it in the bank for the month of 1/31/2015's reconciliation. Later, when I reviewed…
  • Edit AR Invoice Date

    Hello, I recently posted about 10 invoices from BL with the invoice date of 1/20/2014. Is there an easy way to change or edit this date in AR, without having to void the invoices and regenerate all 10 from BL? When I go to adjust the invoice in AR, the…