Pro Forma Invoicing

iMix

Has anyone else had an issue with producing Pro Forma invoices in Navision (v3.6)? Whilst I could create a simple report to produce the actual document, that is not where my problem lies.

I notice that in the past it has been suggested that an Invoice is created against the G/L rather than an Item to get around the problem of the Invoice & Sales Order both showing a requirement.

However I'm worried that to take this approach may mean when it comes to Posting the Sales Order that the customer will be accidentally invoiced twice becuase there is no link between the Invoice and the Sales Order, therefore nothing to flag the fact that the Invoicing has been done this way.

Has anyone any experience of this issue, or indeed any work-arounds for it? Or am I doing Navision an injustice and this functionality already exists?

Savatage

I guess you have taken the "Sales Quote" path and it doesn't fulfill your needs?

iMix

I had thought that would be a way to achieve it, however the problem occurs when it comes to shipping the item. I am concerned that a shipment will be posted along with an invoice, as the person posting the shipment has no way of knowing if this item has had a pro forma raised against it. So we'd end up double invoicing the customer, which could cause problems especially if they paid twice. Possibly problems the accounts department would like though!!

I guess the Customer Card would show a credit on Navision so that might flag something, but even so it wouldn'd be immediately obvious which Sale had been already invoiced.

Savatage

iMix wrote:

becuase there is no link between the Invoice and the Sales Order, therefore nothing to flag the fact that the Invoicing has been done this way.

The link would be the original Order No. is saved in the Sales Invoice Header table.

I'm not reaaly sure what you're going for here.

Do you want to maybe add a boolean field to the sales order called "Pro-Forma" and it can be checked off if it is. and then have that field show on shipments or invoices so everyone knows it was a pro-forma order?

would that be an answer?

iMix

I think that is exactly what I'll do - thanks for your input.

Savatage

it's real easy if you use the same ID Field# for the Pro-Forma Boolean on each of the Sales Order Header - Sales Invoice header & Sales Shipment Header tables!

like 50099 or something.