Support: A few things [Issue:Closed]

Must say I really appreciate this software. I do however have a few issues I need to have cleared up, hope someone can help with these

- If I create an invoice and it's #35, and then I delete invoice 35, the next invoice created is #36, is there a way to use #35 again?

**No because the invoice number is generated with the "identity" seed for the record. When you delete a record this number is related to other records in the other tables in the db.

- When I create a consulting style invoice and save it, the order in which I put things has changed. I put the date and description of work done in the description field, so after I've saved it the dates are all out of order.

**Can you elaborate on this a little further?

Thanks, hopefully there are solutions!

Flyans

I will check this out and see if I can reproduce it. I will post back with my findings.

-D-

No problem Dimante, I look forward to your findings and the next release!

Flyans

Here are before and after screenshots

Removing the SI directory and reinstalling fixed the invoice ordering issue. As far as the invoice numbering issue I think that is an auto incrementing field. I don't think that you can get that number back.

-D-

Dimante, the problem is back, all my data is out of order again.

Flyans

Dimante, I'm using Version: 20080511 stable it's a fresh install from last time we talked.

Here are the steps I take to create the invoices.

Click on Consulting Style Invoice
Enter the quantity in the quantity field of the first line
Choose the product "hourly labour" from the drop down list
Then I type the date in the description field and under that I type the description of the work done.

I do this for as many days as I need and then click Save at the bottom

After that SI says it's processing the invoice and I'll be directed to the quick view of the invoice and that's when I notice the data is out of order.

Flyans

new: http://simpleinvoices.org/forum/discussion/536/
old: http://simpleinvoices.org/usebb/topic-545.html

cheers

justin

OK, so an update to this issue...

When I create a consulting style invoice and then save it, it goes into quick view of the invoice, my data is out of order. I then hit the back button and save the invoice again. Again in quick view of the invoice the data is out of order, hit the back button again and save again, the data is back in order...this has happened twice now...

????????

Flyans

Hey Flyans,

just did a consulting invoices

using the same product for all entries and just doing 1,2,3,4 in the description so test the order

on save the items were still in the correct order - no need to click Back and save again

refer below
#############################
Invoice Summary: Show detailsHide details
Invoice No.: 9
Invoice date: 2008-06-25

Biller: Fawlty Towers Show detailsHide details
Street address: 13 Seaside Drive
Street address 2:
City: Torquay Ph.: 089 6985 4569
State, Zip code: Brixton on Avon, 65894 Mob.: 0425 5477 8789
Country: United Kingdom Fax: 089 6985 4568
Email: penny@fawltytowers.co.uk
Custom field 1:
Tax ID:
Custom field 3:
Custom field 4:

Customer: Kath and Kim Pty Ltd Show details Hide details
Attn.: Kath Day-Knight,
Street address: 82 Fountain Drive
Street address 2:
City: Fountain Lakes Ph: 03 9658 7456
State, ZIP: VIC, 3567 Fax: 03 9658 7457
Country: Australia Mobile:
Email: kath@kathandkim.com.au
Custom field 1:
Custom field 2:
Custom field 3:
Custom field 4:

Show detailsHide details
Qty Item Unit Price Gross Tax TOTAL
1.00 Accomodation $125.00 $125.00 $12.50 $137.50
Custom field 1: Custom field 2:
Custom field 3: Custom field 4:
Description:
1
1.00 Accomodation $125.00 $125.00 $12.50 $137.50
Custom field 1: Custom field 2:
Custom field 3: Custom field 4:
Description:
2
1.00 Accomodation $125.00 $125.00 $12.50 $137.50
Custom field 1: Custom field 2:
Custom field 3: Custom field 4:
Description:
3
1.00 Accomodation $125.00 $125.00 $12.50 $137.50
Custom field 1: Custom field 2:
Custom field 3: Custom field 4:
Description:
4

Total Tax included $50.00

Invoice Amount $550.00
#####################

also i did a test on the demo install ( http://simpleinvoices.org/demo/index.php?module=invoices&view=quick_view&invoice=19&type=3# )and the ordering was fine

can you test on the demo install and let me know what happens we you do it?

also how many line items do you have in the invoice?

Cheers

Justin

hmmm.. if it worked on the demo site then it should work on your system

you might want to try another fresh install ( into a new directory )

have you made any changes to the db etc.. that you can think of that may upset invoice items order?

Cheers

Justin