| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-238727 - Batch Posting|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-238727]
+ *Steps:* +
Batch post invoices through sales > batch posting.
*Steps to Replicate:*
1. From TM > Consumption Site, select and open a site.
2. Set Fill Method = Julian Delivery. Create a custom Julian Calendar and named it as Every 20 days as description. Enter 20 value for the month of October and the rest should have a 0 value. Save.
3. From Sales, create a Tank Delivery Invoice. Set Invoice/Post Date for the month of Nov. Ex. Nov. 26, 2019. Note: Clock Reading for the specific date should also exist.
4. Select the values linked to consumption site with Julian Calendar setup such as Customer, item and site #. Save the invoice.
5. Open Sales > Batch Posting screen. Filter the created invoice. Click Post. Message will be encountered.
!pastedImage_d127075_0.png|height=228,width=694!
+ *Results:* +
Error "adding a value to a datetime column caused an overflow.” See comment.
Invoice can be posted in invoice screen.
I tried to upgrade their backup to the latest software version 19.1.1120.494 but same result.
|