Description |
*Steps to replicate:*
# Restore the stroh database.
# Import customer, after importing customer. The below error will display:
# !pastedImage_d84493_0.png!
# Run this script to delete the discrepancy:
# select cus_no from (
select distinct
cus_no = RTRIM(LTRIM(agivc_bill_to_cus ))
from agivcmst
where agivc_bill_to_cus not in ( select agcus_key from agcusmst )
) missing_table
delete from agivcmst where agivc_bill_to_cus not in ( select agcus_key from agcusmst )
# After running the above script. this error will be displayed:
# !pastedImage_d84493_1.png!
# Run this script:
# select * from agivcmst where agivc_slsmn_no not in ( select agsls_slsmn_id from agslsmst)
# This will be displayed:
# !pastedImage_d84493_2.png!
# Run this: select * from agivcmst where agivc_slsmn_no not in ( select agsls_slsmn_id from agslsmst)
# Delete all records then the below will image will be displayed:
# !pastedImage_d84493_3.png!
# Run this: select * from tblARCompanyPreference
# Then delete 1 and 3 record id.
*Issue:*
The below columns are missing,
Further checking reveals that the agstm_tax_key only exists in ptstmmst but with a name of
ptstm_tax_key, and not in agstmmst
and the maximum column of agstm_lc*_amt is up to 6 column,
!pastedImage_d84493_4.png!
*Acceted:*
Should be able to import invoice using AG database
|