sage help please

waynedance

I use at work a garage invoice system (oynx) which is great as it keeps track of whats been done to the customers cars etc.

i would like to keep using oynx but be able to export the invoices to sage line 50 v10. I am looking to use sage for all supplier invoices and do the banking and VAT.

i have got as far as exporting from Oynx some files of .csv but when i inport to Sage all i get is the customers details no invoices.

Someone did say at the end of each month input the total sales figure from Onyx into sage as a single invoice, but this will not work as some of the invoice like MOT's have no VAT.

Does anyone have an idea of what i need to do? i guess i need some 3rd party software or something.

Thank you.

colin2002

Hi
have you looked at the CSV file? does the export contain invoice data or does it just contain customer details

colin

waynedance

thank you for your help.

opened up the csv files in excel and all the info is there ie invoice amounts.

i have looked in the help file of onyx and it reads like this.

"Sage accounts export"
This is still a new feature that is being extended. It currently only allows you to export invoice transaction records into Sage (it will generate three files – customers, invoices and refund transactions – which you can then import into Sage). Please bear in mind that these transactions will not show up in Sage’s invoice module, but they will update the internal ledgers and show against the customer’s activity. A quick internet search will highlight numerous third party utilities that can load these files directly into Sage’s invoice module if you would prefer.

Any ideas, really want to sort this out, if i look at a customer in sage that was exported from Oynx there is no invoices for them in the activity tab.

colin2002

Hi
What you need to do I think is
from the file menu in sage goto import select audit trail transactions
click on the import file details button and check your csv file has the same format as sage is expecting. (you may need to shuffle your column order to match sage, you can do this in excel)The column in your csv file which will be imported into the vaildation field needs to be set to SI (Sales invoice) if the columns don't match what sage is expecting the import will fail.

hope this helps

waynedance

tried that, but sage crashes.

how do i know what order to put the colums in within excel (sorry a noob here)

i understand what all the info is in excel.

this is the current order.

SIDRPAINTB4000120/06/20071D R Paint starting balance715.16 TO1.50

waynedance

i have got an error report from sage and it seems the import fails because there are minus figures for some invoices.
these invoices were rasied as credit notes and have not been payed off.
what is the correct procedure to raise credits? if we send an invoice to some one by mistake or wrong amount, and that invoice has been used for vat returns so can not be cancelled?



hope someone with good accounting skills can help.

waynedance

bump, anyone

inmypocketnottheirs

Call the sage helpline. I no longer have the number (not using sage any more) , but they are usually very helpful on matters such as this.

colin2002

Hi
the first thing I notice is that the line you have just posted is not a line from a csv file as it has no comma's in it. the format for audit trail import is outlined below


yours would have to be something like

SI,DRPAINT,B4,0,0,01,20/06/2007,1D, R, Paint starting balance,715.16, TO1,.50,,,

you have to have as many columns as sage is expecting. Each comma represents a column

Field (Split Data)

Type

Size

Validation

Precision

Import Type

Transaction Type

Char

2

BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR

Standard / Extended

Sales / Purchase / Bank Account Ref

Char

8

Lookup

Standard / Extended

Nominal Code

Char

8

Lookup

Standard / Extended

Department Number

Int

3

1 - 999

Standard / Extended

Transaction Date

Date

10

Date

Standard / Extended

Transaction (Invoice) Reference

Char

8

Standard / Extended

Transaction Details

Char

60

Standard / Extended

Net Amount

Double

11

8 digits + 2 d.p.

Standard / Extended

Tax Code

Int

3

T0 – T99

Standard / Extended

Tax Amount

Double

11

8 digits + 2 d.p.

Standard / Extended

Extra Reference

Char

8

Extended

User Name

Char

32

Extended

colin