Browse By Tags

  • 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…
  • CSV TS importing or other Service - Ask along

    Hi All, I have been using TimeSlips CSV importing for years now. I have have some knowledge of various functions in TS if you need help or need a person to do importing/export time and expense entries via TS import (CSV file) just le me know. Also…
  • Importing invoices data from Chargebee in Sage 50 CA

    We are using Chargebee to generate our invoices for all recurring customers and we want to import the invoices’ data from Chargebee into Sage 50CA. Any suggestion on how to execute this basic accounting process? Thanks in advance
  • Re-opening a closed fiscal year

    I need to reopen a closed fiscal year, but I can't find any instructions on how to accomplish this.
  • INVOICING PROGRESSIVE BILLING

    Is there a way to keep track of materials used and labour for a project on excel and export it into sage as a sales invoice? I have been weeks trying to figure out the easiest way to keep track. I could use time slips to keep track of labour but it doesn…
  • 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
  • Data inconsistency in A/R Listing

    I have 3 issues; not sure if they're related. It is a foreign currency set-up, and I'm aware of the Knowledgebase article saying that one should call Sage support for database repair -- but I'm not sure I'm at that point -- would prefer to explore ideas…
  • 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…
  • Clearing a problem invoice in A/R

    I was trying to change a customer number, but when I went to Utilities and tried to use Delete/Change, I got the message that I was unable to proceed with unposted data in A/R Invoice Entry. When I looked at the A/R invoices, I was unable to select…