• AR debit note

    Hi, Just noticed that in AR debit note, the document date and due date is picking as the same date even if the customer has a credit term of 30days. Is there any reason for this and how can this be changed? Sage 300 ERP 6.0 Priti Kumar
  • AR Interest invoices - Sage 300 2017.2

    Hi, Does anyone know of a way (add-on? or Crystal modified?) to print an AR invoice with the original amount and interest due, when appropriate? Thanks,
  • AR Subledger Balance by Month

    How can I get the balance of the AR Subledger by month for an entire year or date range? The only way I know is to create an AR Aged Trial Balance Report manually for each month... but I just need the balance.
  • AR Receipt - Special / invalid characters in AR check / receipt field causing Bank Reconciliation issue

    A user entered a '[' within text in the AR Receipt Check/Receipt No. field which then caused an issue in the Bank Reconciliation. We are on version 2014 (300 Premium ERP) (Build 1) (Product Update 1). A posting by Connie H. in Sage Ideas database titled…
  • How to undo AR Receipt Entry

    Hi, We have an AR receipt Entry batch with 2 entries my first entry is ok but I want to undo the 2nd entry in order to put back the document number in the first entry.
  • Invoice number table

    Hi there, Is there a document for Sage 300 2016 to direct the user as to which tables should be edited in order to change an invoice number in the AR module. thanks
  • Unapplied amount AR receipt Entry

    Hi there, In accounts receivable invoice was entered for customer “ABC” in the amount of $50,000 another Invoice was entered for customer “XXX” in the amount of $500. That was all ok the problem happened when the receipt entry was made. There was…
  • Sage 300 ERP - A/R Invoice Summary

    Hi All How can i run something (and download to excel) that shows all invoiced A/R customers and the amount billed to them for a specific period of time (lets say 2016). something that looks like: Thanks! Vendor A $50,000 Vendor B $100,000 …
  • duplicate receipt

    Is there any option in AR to warn for duplicate receipt numbers in Sage 6.0?
  • Importing tax wrong amount

    I have a single CSV file that I am importing invoices into Sage 300 2014 A/R. I receive no error on import but when I analyze the sage invoice compared to the csv file there is a difference in the tax1 amount. Eg the line total is 990.47 and the csv…
  • Is there a way to disallow new order entry or shipment entry for a customer that has gone past 30 days? or their allotted days of credit extended?

    We extend 30 days of credit to some customers who we need to stay on top of. At 30 days, we need ACCPAC to disallow anyone from entering a new order or shipment. Is this possible out-of-the-box or with an add-on?
  • Is there a way to edit OE invoices in AR?

    We use OE module to create invoices selling stock and non-stock inventory items from IC module. Sometimes there are errors on the OE invoices that need to be changed such as wrong taxes charged, unit prices don't match customer PO, etc. Sometimes the…
  • Importing in AR Receipts using single line items

    I know how to import into AR Receipts in Sage 300. Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…
  • Auto Apply Documents "Doc Number"

    Hi there We are making a report in which we have to consider Applied documents. How can we trace whether a document is applied or not through database or front end on the doc? Regards
  • Applying Accounts Payable to Accounts Receivable Open Invoices

    We have some companies that we work with. They are vendors and customers in our Sage 300. There are times when they owe us money in AR and we owe them money in AP. Is there a way to offset the balances? For example, in AP we owe them $100. In AR, they…