Journal Tab

[sandymra]

Hello!
I am trying to make a form in access to display data from actinic website.So far i found in tables where i can find the data, but i can't find where the journal tab info is being held. When in actinic, one double click on the order, and there is journal tab where you can write comments about order. Does anybody has any idea where in the system that data is being held. I have found just one column in table orders "sjournal" but it has just date and time of last change but no comment itself.
Any help would be appreciated!

[Jan]

Journal information is held in order.sJournal.

Regards,

[sandymra]

Thank you for your response. I already looked there, but probably i didn't see it good. Are you sure there is not some other place as well?

By some chance, how could i get documentation of access database to know the use of every field? Is it possible?

[Duncan Rounding]

sJournal does hold the journal data as well as the date/time and user, but to see the data/journal comment you must expand the line down in Access as there is a line feed after the user name.

[sandymra]

Thank you. It worked!

[sandymra]

Does anybody maybe know where i can find documentation of actiniccatalog.mdb data structure?

[Mike Hughes]

If you contact actinic support they should be able to supply you with the database documentation.

Mike

[sandymra]

May i ask one more question here and not to open new subject.
How is the invoice number generated. Where are the fields in tables that says about invoice number that appears in invoice.rpt.
I found value in orders.sinvoicenumber. But it's text value and it appears only when order is completed. Can somebody tell me how is order number generated?

[Duncan Rounding]

The invoice number is generated by Actinic when you complete the sale - essentailly when you print the invoice.

The order number is allocated online at the time of the order placement and is as such is generated by the perl scripts.

[sandymra]

I know i am boring with questions,but i don't have other place to ask. When the order is completed in actinic catalog program, what fields in database are changed.
I figured out so far, and i change:
order.nInvoiceStatus=1
order.Status=F
order.nPaymentMethod=10 (full payment received)
order.Total Lines Shipped = i put same number as lines ordered
order.date order finished = i put time and date
order.nTotalItemShipped = lines ordered

orderdetails.Status = F
orderdetails.QuantityShipped=1

And for one minute it works well, it moves order to completed in actinic, but after some time it changes value of payment to "pending" and gets it back to pending.Probably i am missing something.Any idea?

[Mike Hughes]

I'm not an expert on the database but I suspect the problem you're having is that it appears you're not adding any details to the payment fields.

Unless there's a payment in the payment fields (look at the payments tab in Actinic) then Actinic is likely to reset the payment status to 'pending' the next time the order is viewed.

Mike