Resolving “too many unique dates” issue when invoicing
Table of Contents
Issue
When emailing an invoice to a Customer you are met with the error message ‘Error! There are 126 unique dates on this invoice while the maximum supported by the invoice summary is 126’.
Why the issue occurred
CartonCloud limits the maximum number of dates on an invoice to 126. A date may be a storage period start and end date, date of picking an order, or delivering a consignment. This limit of 126 dates is imposed to prevent issues with invoice summary generation which can arise from having too many date columns in the resulting file.
This issue generally arises if an invoice is created which contains a large amount of old, uninvoiced data, such as storage periods, manifests, or even warehouse and transport jobs which had not been invoiced yet for some reason. Often the cause of this is a settings change which begins invoicing a customer automatically for the first time, or alters the invoicing behaviour such that things which were not previously invoiced, are now invoiced for the first time.
How to resolve the issue
CartonCloud is designed to automatically invoice everything which has not yet been invoiced, therefore, to resolve the issue we recommend you:
-
Remove any records from the problematic invoice that you don't wish to charge for.
-
Add the removed records to a New Invoice and set the status of this invoice to Void - this treats those old records as “invoiced” so they will not be picked up by future invoicing runs. See How to void Storage Periods for steps on voiding charges (note, the article only mentions Storage Periods, however, this can be applied for all types of charges).
-
Add a new invoice which contains only those records that you do wish to charge for.