Sage 50 Accounting - U.S. Edition

[sampaules]

"memo" below should say "credit memo"

[sampaules]

Rick,

After struggling for 3-1/2 hours with invoice import error messages that made no sense, I came across your post that the memo field was required.  As you probably know, the Peachtree help screen for sales journal import (at least for Peachtree "Quantum 2010) says it is not required.   Was no problem after that.

Thanks for your help,

Sam Paules 

[Cricket4]

We are importing invoices from another program and have found the following to be true:

        Although you do not need to import the date due OR the display terms fields, the program (we are using Premium) does NOT apply the default term code and does not calculate the date due.  Therefore, we had problems with our aged receivables report and our statements did not show a due date.

       Now we export our data into a csv file and open it in a spreadsheet where we calculate the date due from the terms information we have exported.  Now that we are importing the display terms and date due fields our aging and statements are looking much better.

          Cricket

[rance]

Regarding the Transaction Number ...

1.  Is there a maximum number of characters for this field?

2.  What happens if a Transaction Number in an import file already exists in Peachtree?

Thank you!

[pguru · Accepted solution]

You do not need the following fields. Recur Number, Recur Frequeny or Date Due.

[rance]

Thank you Rick.

I reviewed an exported Purchase Journal file and think that we will need to include the following fields for our imports:  Vendor ID, Invoice/CM #, Credit Memo, Date, Date Due, Accounts Payable Account, Number of Distributions, G/L Account, Amount, Transaction Number, Recur Number and Recur Frequency.  Are any other fields required?

[pguru]

The best answer to your questions will be found by entering a TEST Invoice, populating only the fields that you determine necessary for your purposes.  Export this one Invoice, while selecting the OPTIONS -"Include Headers".  Note on the Export Options Tab the ability to define the export file name and location.  Open the CSV export file and note your data as it pertains to the template. 

Note when importing Invoices, you MUST include the column "Credit Memo" in order to prevent duplicates and related error messages.  You do not need to include Serial Number Column unless you are using Inventory - Serialized Items.  You will find that you can remove many other fields from your template. Remember to match your file template with the Peachtree Import Template , column for column and the column order numbers.  You will then be able to save your proven import template for repeated future use - see the OPTIONS Tab for the SAVE Icon. 

[rance]

I am trying to determine the minimum number of fields required for an Invoice Import, using an exported file from a third party application.  I have reviewed the Purchase Journal Fields documentation and have a couple of questions:

- The Serial Number field is required for an import but the Item ID is not.  Why is the SN required?  Should the Serial Number field be included and left blank in the import file?  We will not use the Item ID.

- The Transaction Number field is listed as not available for import.  However, in the Import/Export Tips document under the Working with Journals heading, it states that the Transaction Number field is required for transactions created in another program.  Is the latter correct for our situation?