• How to deal with Vendor Credits on Prepaid Purchase Orders

    We regularly import products from overseas and prepay 100% of those purchase orders. Sometimes we end up changing items, leaving us with a credit with that vendor. They typically apply it as a credit on future purchase orders. What is the best practice…
  • SQL Query for Vendor and Customer Account Balances

    We are in the process of upgrading to Sage 100 Premium. Can anyone help me re-write these SQL Queries from our old version of MAS200? The table names and fields have changed and some of the fields are no longer in the master tables. Any help is appreciated…