QIF Invoice Example

[Neil Williams]

On Thursday 16 December 2004 7:01 pm, David Bottomley wrote:
> >>>> Does anyone have an example of the qif for importing an invoice?
> >>>> I've seen the qif definition but I'm doing something wrong.
> >>>
> >>> There is no such example because you can't do it.
> >>
> >> Can't import an invoice in any form?
> >> Or can't import as a QIF?
> >
> > Both.  Eventually the former problem will be solved by Neil Williams
> > and his QSF code.  The latter will (most likely) never be supported.
>
> What about a "Sales Order"? 

Same type of thing. As Derek said, it's a pending task and work is ongoing - 
it's not as simple as it seems on the surface.

> I was trying to import an invoice because it 
> looks like Sales Orders (SO) are not supported in gnucash -- true?
> Perhaps I'm going about this all wrong -- can someone suggest another
> approach to what I'm attempting(?):
>  1) I'd like gnucash to recognize that I have some work that will generate
> revenue at some time in the future, like a SO does.

If you are charging this as a debit to a customer, it's an invoice, isn't it? 
Or a Bill, same GnuCash objects, different usage. At present, you'll need to 
enter the invoice/bill by hand. I know, it's a pain, that's why I'm writing 
the alternative!

I've got some help now too, so things are looking up.

>  2) At that time in the future, I'd like to move value from the SO to an
> asset account.

Receive payment.

>  3) I'd also like to import, or connect to, the source that generates these
> SO-like things and the transactions that move SO value into a different
> account -- I planned to use qif imports for this.


No. You will probably have to wait for QSF - an XML format that makes all 
GnuCash objects accessible to any supporting application as well as from 
hand-edited XML files. What QIF can handle is not within our control.

I do have examples here:

http://code.williamsleesmill.me.uk/qsf.html

Invoices are the particular emphasis during testing but all QOF objects in 
GnuCash are to be supported along with most if not all pilot-link databases 
via QOF. (Some databases like photos would not, initially, appear to be 
useful but things can change - there's already been some talk on these lists 
about linking images to transactions.)

-- 

Neil Williams
=============
http://www.dclug.org.uk/
http://www.nosoftwarepatents.com/
http://sourceforge.net/projects/isbnsearch/
http://www.williamsleesmill.me.uk/
http://www.biglumber.com/x/web?qs=0x8801094A28BCB3E3

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20041216/ba896907/attachment.bin