[Lori Holmes]

We are AX 2012 RTM users and have begun using the batch invoicing features.

We’ve scheduled our batch job to invoice (every 15 minutes) any packing slips that are waiting to be invoiced.  It executes a query based on a specific set of criteria.  For the most part, everything works as expected.  However, we occasionally see a problem whereby the batch job continuously throws an error and stops invoicing.  The only remedy that we are aware of is to delete the batch job and recreate it. 

Our batch job also prints or emails each invoice after it’s billed.  When we review the log for a given job run, we can see that some packing slips show an error stating Shipping charges have not been retrieved, but they get billed on subsequent job runs.

We believe the error is the result of timing between the shipper and when the job executes.  This means the appropriate tables had not been populated when the batch job ran.  We also believe that in some cases the error is the result of our users setting up the order as the freight being the responsibility of a third party instead of collect from the recipient.  Nevertheless, we clear the error from the errors file (SalesParmSubLine) which then allows the batch job to continue.

However, as stated above, we occasionally get the following error Cannot insert multiple records in Sales order header – updating table (SalesParmSubTable). Sales order: SO-123456, Company Name Inc.  The record already exists. One packing slip is shown as the culprit and nothing else gets billed unless we recreate the batch job.  For your information, we are able to manually bill the “stuck” packing slip with no issues. 

Also for your information, we have many sales orders that have many shipments.  It’s not unusual for a sales order to be shipped partially 15 or 20 times.  We’ve tried playing around with the thread in the AR setup to no avail.  Any ideas you may have would be appreciated.

——————————
Lori Holmes
Hamamatsu Corporation
Bridgewater, NJ
LHOLMES@hamamatsu.com
——————————

[Ludwig Reinhard]

?Hi,
Is it right that you send out invoices and email notifications every 15 min?
Is that really necessary and can you possibly change it to 1x or 2x a day e.g. at night?
Probably batch runs that run at night or during non-peak hours might perform better and help you avoiding this issue.
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Lori Holmes]

Hi Ludwig…

We agree…it is likely more often then most other companies schedules.  Our processes require that certain shipments be invoiced as quickly as possible.

We’ve reduced the schedule today to see if it helps…stay tuned.  

Also…if others have ideas from experience as well, we’d like to hear them too!

——————————
Lori Holmes
Hamamatsu Corporation
Bridgewater, NJ
LHOLMES@hamamatsu.com
——————————
——————————————-