We are still struggling with dates on the invoicing process, and I am trying to understand how the system is meant to work.
There are two date fields, described as follows in SuiteAnswers:
In the Next Bill On Or Before field, enter a date to filter the list by the billing date on the orders.
In the Date field, enter the billing date for the transactions. The current date is entered by default.
My first question is 'what is the billing date' - I can't find this field anywhere in the system?
It is my understanding (from the testing and issues we've seen so far) that a Sales Order will not be billed until it is Shipped (which is correct). However, I think the dates it uses is based on the Sales Order date rather than the date of Fulfilment.
What we are trying to achieve is to invoice 2-3 days in areas (to allow time for any delivery issues to be resolved), but we ran the Bill Sales Orders process today with 31st July in both boxes, and it has invoiced an order that was raised and fulfilled today (2nd August) - but posted this with an Invoice dated 31st July (which is clearly ludicrous).
I want to issue invoices for any Sales Orders that were fulfilled up to a date 2-3 days ago (i.e. 31st July), and have them dated for that date (31st July). But it shouldn't include items delivered yesterday or today (even if the Sales Order was dated before 31st July).
How do we achieve this?