Most of our sales reporting reads from the ILE. Unfortunately, there is sometimes a gap between the date that the items are posted and the date they are invoiced. This usually indicates additional warehouse processing, or pre-processing an order prior to a customer's requested ship date. Invoicing occurs on or after the ship date and once the order has been manifested.
However, because there can be a time difference between invoicing and posting (sometimes weeks), our sales reporting can be thrown off, since the ILE recognizes the date of the posting, but not the date of the invoice.
How can this be reconciled? Is it possible to add an "invoice date" field to the ILE that is updated at the time of invoicing and change our reporting to look for those dates? Or do we need to match posting dates with invoicing dates? There was a fear that GAAP requires posting dates to match invoicing dates as well - is there any legitimacy to that?
*This post is locked for comments
I have the same question (0)
