malaia
Active Member
List,
Requirement: We have a SO with non-stock lines. System will bypass A/R and use 4245 to write to GL. We want the GL date to be same as ship date.
Challenge: If I use 2 in invoice date and 2 in GL date (to use ship confirm), system is giving an error and the error is - In a batch all the GL dates must me same. Reason for this error is all the stock lines have ADDJ populated (ship date) and the non-stock line doesn't have ADDJ.
We cannot use system date, because this will screw up month end sales update. We cannot use 1 (invoice date), because we don't print invoice for these orders.
We also tried ship confirming the non-stock lines - this will work, but the challenge we have is freight lines will be entered after ship confirm and before sales update - so these lines will not have ship date.
We don't want to do sales update one at a time. We want this in sleeper.
Any suggestions or recommendations?
Thanks as always,
Malai Annamalai
Deloitte & Touche
San Francisco
OneWorld Xe, Update 6, SP20
Requirement: We have a SO with non-stock lines. System will bypass A/R and use 4245 to write to GL. We want the GL date to be same as ship date.
Challenge: If I use 2 in invoice date and 2 in GL date (to use ship confirm), system is giving an error and the error is - In a batch all the GL dates must me same. Reason for this error is all the stock lines have ADDJ populated (ship date) and the non-stock line doesn't have ADDJ.
We cannot use system date, because this will screw up month end sales update. We cannot use 1 (invoice date), because we don't print invoice for these orders.
We also tried ship confirming the non-stock lines - this will work, but the challenge we have is freight lines will be entered after ship confirm and before sales update - so these lines will not have ship date.
We don't want to do sales update one at a time. We want this in sleeper.
Any suggestions or recommendations?
Thanks as always,
Malai Annamalai
Deloitte & Touche
San Francisco
OneWorld Xe, Update 6, SP20