• Sage 300 2017 PU6 Import AR Invoice line comments without line breaks issue

    Hi All, May I know is this the limitation in Sage 300 2017 PU6 whereby user unable to import AR Invoice line comments with line break? One of our clients encountered this issue recently. At first, this client was in Sage 300 2017 PU3. Hence, we…
  • Filling up the GL-JE Import template in Excel

    Hi All, Trying to fill up an import template in Excel - As you can see in the screenshot, there are 4 transaction per journal entry but in some cases there are 5 - 6 transactions as well. I know that excel follows a 20-40-60-80 patter in the TRANSNBR…
  • A/P Importing Error - G/L account cannot be blank

    I am trying to import an A/P batch into Sage, I'm using the template downloaded from an already existing batch. The issue is when I select the file (Excel 200 format) and click OK an error window pops up with the G/L account cannot be blank message. …
  • The values of "Category" in timecard import sheets

    Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR
  • 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…