• Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • Change payment terms for vendors

    Hi all, I would like to enquire how can I change the payment terms for a vendor if my invoice for the vendor is already posted? I realised my invoices for some vendors have wrong payment terms and now my aging report is wrong.. So, is it possible…
  • A/R Invoice Posting Errors

    Hi, Have this error message in A/R Invoice Posting Errors: Invalid Input. Document currency (EUR) does not match customer currency (USD) Any idea? thanks for your help.