• exporting invoice detail lines

    is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…
  • AR Invoice History file size limits or performance hits

    Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…
  • Add On the Fly Ship to in SO Entry in V2022

    We just upgraded from Sage 100C V2019 in that version and all the others before we have been able to add on the fly ship to addresses. In 2022 it looks like someone thought it would be a great idea to remove that permission able item, either that or they…
  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
  • How to record a wire transfer in AR

    How do you record a wire transfer from a customer in AR? In AP there is the selection drop down for Wire Transfer, but not in AR. I read if we use ACH/Credit Card, it doesn't post to BR. So do we use Cash and if so, how/where do we enter the long 15 digits…
  • AR Pre-payment

    Hi. Okay..... A prepayment was applied to the wromg customer in Sage and has been reconciled since December 2021. I was told to issue a debit memo for the amount that was misapplied. My big question is.... is it possible to apply prepayments to…
  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
  • Moving an overpayment from one customer to another

    I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…
  • Setup Paperless AR Statement Delivery SOP

    Is there an SOP available to set up Paperless AR Statement Delivery only for specific customers?
  • BIE- How to calculate GP Margin w/ credits

    This may be better accomplished by a crystal report, but I don't have access to create those. I'm looking to calculate the final GP Margin on a job including credits which are often $0 to the customer with negative costs of goods so they greatly improve…
  • Aging Categories not being updated before invoice printing (random occurrences)

    We are having an issue where the latest payment of a customer is not being reflected in a printed invoice. This issue only happens on very rare occasions, and we do not receive any errors or notifications before it happens. Below are a few observations…