Importing data from excel to sage 50 in "General journey"

SOLVED

Hi!

I appreciate all your help 

I have a Excel Database that contains all the transactions of the General Journal.

To import it, I exported a Sage 50 database, to know the format and variables. I have all the variables to fill the Sage 50 format with the exception of "Number of distribution".

So I downloaded a format without using that variabl.  I import the database (CSV), but I get an error in the variable "Number of distribution". Looking for information, I have learned that it is a mandatory variable to import.

Can you help me to know what should I put in this variable?

What does the variable "number of distribution" mean?

I appreciate all the help you can give me.

  • +1
    verified answer

    "Number of distributions" is the number of lines in your file that belong to that transaction. For general journal entries it is simple because it is just the total number of debits and credits in a single journal entry.

    Number Of Distributions is a required field.

  • 0 in reply to StephenC

    hello.

    I have another question.

    I am trying to enter payroll data by importing payroll data from a CVS file.
    (emplyeeID,Reqular hours, Overtime Hours, Payroll End date.)
    The exported data already has a field created by calculating the payroll.

    I want to import the payroll input data of several employees.

    It seems that one record per person is correct, but there are several records per employee in the exported data.

    May I ask how can I do it?

    Thank you.