• 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. …
  • 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…
  • Tax Class invalid input

    Hi, I try to import a spreadsheet from IC item list and when I proceed the following error show up: -Invalid input. Purchase tax class does not exist -Warning the next lot number does not contain an incrementable segment.You will not able to add…
  • Creating Price Lists

    Hi - I'm new to the forum and to this part of the software, so please bear with me. I've been asked to maintain price lists for 40 customer accounts which have 200-3000 skus each. Is there someplace on this site that explains efficient procedures to change…