Proper way of importing sales invoices ?

SOLVED

Hello community,

It is been a week me trying to figure out the proper format of a .txt file that would be accepted by Sage 50 CA edition to import invoices. The error that I always get is : "The number of detail lines does not match the actual number of lines."  here is a content of a  file I'm trying to import: 

<Version>
"12001","1"
</Version>
<salinvoice>
"Universal Construction", , , , , , , , , , , ,
1, , "INV-9", "10-04-2023", "0", , "0.00", "0.00"
"4200", "14.0", "0.00", "0.00", "GST", "0", "1", "5.00", "0.00"
<salinvoice>

and I'm really struggling with this as even example that sage has in manuals doesnt work. Any advice would be much appreciated. Thanks 

Mike 

Top Replies