Page 1 of 1

Changing Default Date for an Invoice created from Sales ordr

Posted: 04 Nov 2012, 14:55
by sjohnson
Hi

I'm running Sage 50 Professional and importing Sales Orders for items we sell. These are set up with the date that the sale is made. When we then Allocate stock to each order, and mark the Sales Order as Dispatched, a sales Invoice is created. The problem is that this has a date which is set to the system date of when I mark the Sales Order as Dispatched. I need to to inherit the Sales Order date. This is causing a problem with the VAT return as we do this activity at month end, so all the Invoices are showing with a date in advance, rather than the date that has been set on the Sales Order.

Is there a way that the Invoice created from the Sales Order can have the same date as the Sales Order?

Thanks

Simon

Re: Changing Default Date for an Invoice created from Sales

Posted: 05 Nov 2012, 10:12
by brucedenney
You can not do that.

Why are you importing as Sales orders if these are Invoices? Seems like you are making more work for yourselves than you need to.

Re: Changing Default Date for an Invoice created from Sales

Posted: 05 Apr 2014, 14:46
by dgilfillan
Like me sjohnson might be importing sales orders to manage stock (which I'm not sure but I'm pretty sure cannot be done by importing directly as invoices?)

Anyway, I too am facing the same problem...

Having just imported 600+ orders (all correctly dated), allocated stock and despatched, all the invoices are created using the current program date! - Which as sjohnson says messes up VAT...!

Is there no setting which simply ensures the invoice takes the order date? Or perhaps some other way/add on tool to correct?

All help appreciated.

Re: Changing Default Date for an Invoice created from Sales

Posted: 07 Apr 2014, 15:28
by brucedenney
No, sorry, not possible.