Hi everyone,
I'm trying to create a mailing list from our customer data in SAP Business One. The list will include a lot of the information stored in the OCRD table but I also need to pull the primary billing and shipping addresses for each customer. Those values seemed to be stored in the CRD1 table but I can't find a way to determine which addresses are primary. I can link the OCRD and CRD1 tables based on CardCode but that just pulls every address which doens't really help.
Does anyone know how SAP BO determines the primary billing and shipping addresses in the SQL Database?
Thanks in advance,
Tyler Condon