We were finally able to get by all of the errors but upon (what we thought was a successful completion),we could not locate the transactions. This is the format I was able to get the furthest with: Its in Excel below but saved as CSV Date Reference Number of Distributions Currency Exchange Rate G/L Account Description Amount Transaction Number Recur Number Recur Frequency 10/17/2018 10/17/18 Cash for De 3 1020-0300 Tender $0.02 1 0 0 10/17/2018 10/17/18 Sales PLANT 3 4022-0300 Department (Sales) -$0.01 1 0 0 10/17/2018 10/17/18 Sales DRIED 3 4023-0300 Department (Sales) -$0.01 1 0 0

Hi there I am trying to help someone import journal transactions from a POS systems in a CSV format and I cannot find a record layout anywhere.

Posted By Sheri M over 5 years ago

We were finally able to get by all of the errors but upon (what we thought was a successful completion),we could not locate the transactions. This is the format I was able to get the furthest with: Its in Excel below but saved as CSV

Date	Reference	Number of Distributions	Currency	Exchange Rate	G/L Account	Description	Amount	Transaction Number	Recur Number	Recur Frequency
10/17/2018	10/17/18 Cash for De	3			1020-0300	Tender	$0.02	1	0	0
10/17/2018	10/17/18 Sales PLANT	3			4022-0300	Department (Sales)	-$0.01	1	0	0
10/17/2018	10/17/18 Sales DRIED	3			4023-0300	Department (Sales)	-$0.01	1	0	0

Parents

0 DeneshS over 5 years ago

Hi Sheri M

You must format the text file a certain way. See KB 10186

Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 DeneshS over 5 years ago

Hi Sheri M

You must format the text file a certain way. See KB 10186

Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Sheri M over 5 years ago in reply to DeneshS

It did help. Thank you so much. I had to demoralize the layout to include a date and header for each record. Do you know if there is any way to include an account reference is in the layout? It seems very specific with no mapping tools.

We are also receiving supplier invoices for multiple retail stores summarized by account-dep to post to AP. Do you have a layout for this? I our actual iitem level inv management is performed in different software.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DeneshS over 5 years ago in reply to Sheri M

The method for generating Purchase Invoices and Sales invoice are very different, more so because these are linked accounts in Sage 50 (AP and AR)

If you generate an .IMP file using KB 91392 and open it in notepad, you can have a look at the format. That article indicates that if you email a sales invoice, it will fire out a purchase invoice IMP. If you want more detailed mapping info on the text format, have a look at KB 41370. As an alternative, if you weren't concerned about getting too technical, you can have a look at our partners at http://sagepss.com/Solutions.aspx?p=6. Some on here have created their own solutions for importing AP and AR.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Canada

Hi there I am trying to help someone import journal transactions from a POS systems in a CSV format and I cannot find a record layout anywhere.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING