Hi Dynamics User Group -
I have found it challenging with Ecommerce operations and working with 3rd Party Logistics integrations to get all of our invoices in the proper period. (I want to get to 100% of all shipments invoiced within the same accounting period.)
The invoicing is occurring during batch processing which means that there will always be some kind of delay, even if it is only a matter of minutes. I’ve asked Microsoft whether there was an option to have the invoice and associated GL entry be posted with the Shipment Date and not the date that the invoice job was run and was told there is no such configuration.
Kind Regards,
Dave
The way to do that is to not process the shipment in the last x time period of the period but have the batch routine run in that period to ensure they match. Have you looked at direct invoicing which then creates the shipment, i.e. post the order and then the shipment is created, of course that means you always need to have shipped what is on the order.
A lot depends upon your business, frequency, volume, timings etc. In addition you would have to challenge why you want 100% of shipments to be in the same accounting period as the generated invoice.
It sounds like you’re having trouble getting all of your invoices in the proper accounting period due to delays in the batch processing and invoicing that occurs during that process. While there may not be a way to configure the system to post the invoice and GL entry with the shipment date instead of the invoice job run date, there are some other strategies you could consider.
One option could be to adjust your batch processing schedule to ensure that it runs closer to the end of the accounting period, so that any delays are minimized and there’s a better chance that all invoices will be processed in the correct period. You could also consider setting up alerts or notifications to monitor your invoicing progress throughout the period, so that you can take action if any invoices are at risk of being posted in the wrong period.
Another option could be to work with your 3rd party logistics provider to see if there are any changes you can make to your processes that would help to streamline the invoicing process and minimize delays. This might involve things like setting up more efficient data exchange mechanisms or adjusting your shipping processes to reduce the time it takes to create and process invoices.
Ultimately, the key to success in this area is likely to be a combination of process improvements, proactive monitoring, and ongoing communication with your logistics partners to ensure that everyone is aligned around the goal of invoicing all shipments in the correct accounting period.