Welcome, Guest. Please Login.
05/09/25 at 16:02:31
News:
Home Help Search Login


Pages: 1
Send Topic Print
Customer Due date getting stepped on (Read 594 times)
rmh148
Member
**




Posts: 84
Customer Due date getting stepped 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.
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Customer Due date getting stepped on
Reply #1 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
rmh148
Member
**




Posts: 84
Re: Customer Due date getting stepped on
Reply #2 - 07/29/05 at 11:58:41
 
I'll give it a look.  Thanks,
Back to top
 
 
  IP Logged
rmh148
Member
**




Posts: 84
Re: Customer Due date getting stepped on
Reply #3 - 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
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Customer Due date getting stepped on
Reply #4 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print