ISTech Support Forum http://www.istechforum.com/YaBB.pl Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> Customer Due date getting stepped on http://www.istechforum.com/YaBB.pl?num=1122578396 Message started by rmh148 on 07/28/05 at 11:19:56

Title: Customer Due date getting stepped on Post by rmh148 on 07/28/05 at 11:19:56 The problem as I see it. Is that, when you create a sales order the customer due date is being stored in BKARINVL.BKAR_INVL_ASD which allows you to track the real customer due date.   The problem occurs when you invoice and post.  It creates BKARHINV and BKARHIVL records. The BKARHINV has the invoice date, order date, ship date, but the BKARHIVL.BKAR_INVL_ASD now contains the actual shipdate.  You now have lost the original customer due date and can not tell if you met the customers date or not.   If you have not purged closed sales orders you still have the customer due date in BKARINVL.BKAR_INVL_ASD, but you can not relate it to the HIVL because you have no invoice number in INVL. If you have purged closed sales orders, you have lost the customers required date completely. In my mind the BKARHIVL.BKAR_INVL_ASD should retain the original customer due date because the actual ship date is recorded and stored in BKARHINV which is linked to BKARHIVL.

Title: Re: Customer Due date getting stepped on Post by Lynn Pantic on 07/28/05 at 14:41:19 There are a number of other reports and programs that expect the BKAR.INVL.ASD in BKARHIVL to be the actual Ship Date, we just "stole" the field for the Due Date in the BKARINVL file.  However, the date is not lost if the On Time Delivery tracking is turned on in SD-Q because it is stored in the BKARHCHG file when the invoice is posted.

Title: Re: Customer Due date getting stepped on Post by rmh148 on 07/29/05 at 11:58:41 I'll give it a look.  Thanks,

Title: Re: Customer Due date getting stepped on Post by rmh148 on 08/03/05 at 05:06:42 Lynn, I have "Track On Time Shipping (Reports)" turned on in the sales defaults.  But, the file BKARHCHG.B that you indicated changes were stored in does not exist.  There is ISARHCHG, however I can not see this files when I use maintain database.  Please advise

Title: Re: Customer Due date getting stepped on Post by Lynn Pantic on 08/04/05 at 08:04:28 You are right, it is ISARHCHG and you need to run UT-J and rebuild the DDF to get to it in Maintain DB.

ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved.