Browse By Tags

  • several prepayments for a purchase order with one product and quantity of one

    I need to apply an initial prepayment of 30%, a 2nd prepayment of 40% and final prepayment before shipment of 30% but I only have one product, quantity of one and if I apply the first 30% and create an invoice for the second and third payment it cannot…
  • General Ledger AR out of balance with Aged Receivables

    HELP!! Why is this happening? Please see attached screen shots. Thank you /resized-image/__size/0x0/__key/communityserver-discussions-components-files/132/SCREEN-SHOT-BUSINESS-STATUS-SCREEN.png
  • Setting up a financing loan and posting payments for the loan

    the Peach Tree software we are using is pretty dated I believe 2011. We receive statements monthly from the bank for a large equipment financed loan. The accounts used in setting up the loan were Note payable to the bank; Interest Expense, and the other…
  • Can an invoice be processed with current date if Pick/Pack has future date?

    I have a pick/pack that was done with a 8/7/19 future date in error. I don’t believe that the pick/pack can be deleted or the date changed on it but need to know if I change the date on the invoice how it will affect the information processed. How does…
  • 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.