Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Changing Default Date for an Invoice created from Sales ordr

Sage 50 general help forum - Free help and support for all general issues
Post Reply
sjohnson
User
User
Posts: 1
Joined: 04 Nov 2012, 14:47
Sage Version: v2012 18 UK/Europe/Africa

Changing Default Date for an Invoice created from Sales ordr

Post by sjohnson » 04 Nov 2012, 14:55

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Changing Default Date for an Invoice created from Sales

Post by brucedenney » 05 Nov 2012, 10:12

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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

dgilfillan
User
User
Posts: 1
Joined: 05 Apr 2014, 14:41
Sage Version: v2013 19 UK/Europe/Africa

Re: Changing Default Date for an Invoice created from Sales

Post by dgilfillan » 05 Apr 2014, 14:46

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.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Changing Default Date for an Invoice created from Sales

Post by brucedenney » 07 Apr 2014, 15:28

No, sorry, not possible.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests